How to setup Google Sheets Integration

This integration will allow you to connect with Google Sheets. It is a matter of minutes to send your Google Sheets data to feed your BI, your data warehouse, or your custom analytics stack. With your Google Sheets data into one place like Google BigQueryPostgreSQLAmazon Redshift or Microsoft SQL Server, it is much easier to have all your disparate files and data up to date without moving or downloading csv files and make that scripts of yours even more valuable.

  1. Connecting Google Sheets
  2. Set the Replication Frequency
  3. Load your Google Sheets data into your data warehouse

Getting Started – Setup Google Sheets integration at Blendo

1. To add this integration, go to Blendo dashboard. Click Add a Source and click on Google Sheets.

Connect Google Sheets as data source

 

2. In the next screen, select your spreadsheet file from Spreadsheet and the worksheet to load from Worksheet.

Connect Google Sheets as data source

 

3. Then we need to setup the Header row. This is the row that contains this sheet’s headers and field names. By default, Blendo uses the first row of the sheet.

Connect Google Sheets as data source

 

4. Then we need to setup the First data row. This is the row that the sheet’s data begin. By default, Blendo uses the row that follows the header.

Connect Google Sheets as data source

5. Click Validate & Save.

Connect Google Sheets as data source6. Then you will return back to the home dashboard. Click on your new Google Sheet data source.

Set the Replication Frequency

7. If you want to change the replication schedule go to the Schedule section and click on Reschedule.

 

8. In the next pop-up select one of the options available and click Apply.

Load your Google Sheets data into your data warehouse

Here is how to start loading your Google Sheets data into your data warehouse:

Import your Google Sheets data into your data warehouse - Blendo.co

Questions? Contact us!

in Connecting SaaS Data Sources