Kloudio's Google Sheets integration allows users to easily create reports from Google Sheets file data.

The following article will help you get started:

Step 1 : Go to Kloudio Dataflows and Click on Add a Flow button to create a New Data Flow.

Step 2: Select the appropriate Data Warehouse and Click on Next button.

Note: On selecting Use Kloudio's Data warehouse check box, Kloudio’s Default Data Warehouse gets selected.

Step 3: Select Google Sheets from the Data Sources List.

Step 4: On Selecting the Data Source, Corresponding Popup window is displayed, Enter the following details:

  • Connection Name : Enter the appropriate name of the Connection

  • Schema Name : Enter the Desired Schema Name (Schema Name can only contain lowercase letters, numbers and underscores, and cannot begin with a number)

  • Table Name: Enter the appropriate Table Name

  • Frequency : Select the desired frequency for the sync to be initiated and Click on Continue button.

Step 5: On Selecting the Continue button, it takes you to Privacy Policy Page,

Click on the I Understand button to navigate to the authorization page.

Step 6: On Redirecting to Google Sheets Dashboard Screen, Select the Authentication Mode, Enter the Sheet URL and Click on FIND SHEET and later SAVE & TEST button

Step 7 : Once all the connection tests are passed, You will be redirected to the Data Flow List Screen, where Sync Job status “Success” gets displayed on successful sync.

Did this answer your question?