Google Sheet is basically a spreadsheet program. This allows users to create and edit files online while collaborating with other users in real-time. These edits are tracked by the user with a revision history presenting changes.
Sprinkle supports a wide range of data sources. On clicking the “+sign”, a list of data sources pops up. In this case, Google Sheet is selected. A new Google Sheet data source is named and created.
To create a connection, the user needs to click on the “Connect to GOOGLE” button which pops up a Google login page.
Post login, users will be prompted to allow permissions required for sprinkle to read data further. Once a user does consent by clicking on ‘Allow’, the connection can be created from Sprinkle.
In the Datasets tab, the user needs to select the Spreadsheet ID and then the tab from the particular sheet he intends to ingest. Please note that users can ingest only one tab at a time. On selecting the tab, a default table name is created. However, users can rename the table as per their requirements. Next, the user can click on “Create”.
In the Ingestion Jobs tab, the concurrency (number of tables that can run in parallel, a maximum of 7) can be set preferentially before running the job. The status of the job will be updated in the tab below once it’s complete. The jobs can also be set to run automatically by enabling autorun. By default, the frequency is set to every night. Frequency can be changed by clicking on More --> Autorun-->Change Frequency.