Google Sheets

Automatic Data Synchronization

The Dataddo Google Sheets Connector gives you the ability to sync your data automatically in hourly, daily, weekly, or monthly increments.

API Call Limitations

All limitations for API calls are described here.

BEFORE YOU START! 

Before you connect your Google Sheet and send the data to a destination, make sure the particular table is formated correctly as the configuration of Attributes depends on it. The first row of the table should contain the names for the values in each column,  like this:

Google Sheets - first row example

How to create a Google Sheets Data Source

   
Number 1

Sign in to your Dataddo account and click on Sources at the top of the page. Home Page - Data Source

Number 2

Click on Create Source in the top right corner.Data Sources - Create Source

Number 3 From the list of sources, choose Google Sheets. You can type the name of the connector into the search bar to find it faster.
Google Sheets - step 3
Number 4 From the drop-down menu, choose your Google Sheets Account connected to Dataddo, and then select the Spreadsheet and the Sheet. Click on Next to continue with the setup. Google Sheets - step 4
a) Add new account
If you want to connect a new Google Sheet Account that is not on the list, click on Add Account. You will be redirected to the Google Sign-In page to confirm the right account. Once you confirm, you will be redirected back to the Dataddo app.
Google Sheets - step 4 add new account
Google Ads - step 4b
b) Authorize Google Account
If you have not authorized your Google Sheet Account with Dataddo, click on Authorize and you will be redirected to your account to log in.
Google Sheets - step 4a
After you log in and give Dataddo the necessary permissions to access your data, you will be redirected back to the connector.
Number 5

Choose a Name for your Data Source and select Attributes. To continue to the next page, click Next.

NOTE: The attributes depend on the sheet you select and are created from the first row of the table.

Google Sheets - step 5

Number 6

On the Storage selection page, you can set up the destination configuration. To help you with the snapshot mapping, we make it easier for you to create a connection to the destination based on your preference.

  • A) Click on the option Dashboarding App if you want your data to connect to applications such as Google Data Studio, Power BI, or Tableau.
  • B) Click on the option Data Warehouse, if you want your data to be sent to warehouse storage, e.g., MySQL, Big Query, or PostgreSQL.
Google Sheets - step 6
Number 7

Configure your snapshotting preferences by choosing your Data range*, Sync type, Sync frequency, Time, and Timezone. Confirm your setup by clicking on Next.

NOTE: *If the Data range is available to select, you can load historical data. Read more about it in our guide.

Google Sheets - step 7

Number 8 In the last step you can preview your data. Click on Save and your new Data Source is ready.
Google Sheets - step 8 preview
* Broken view / Error message
If you cannot see a preview of your data, go back a few steps and check your setup. The most common causes are:
  • Date range - we recommend a smaller date range. If you need to load historical data, check our guide.
  • Invalid metrics, attributes or breakdowns, or their combination - you may not have any values for them.
Google Sheets - step 8 broken preview

Congratulations, your new Data Source is ready!


Need assistance?

Feel free to contact us or create a ticket and we will help you set up the Data Source.