Data Source Connector – Google Spreadsheet

Data Source Connector – Google Spreadsheet

Our platform enables you to quickly and easily connect your data sources to data from a Google Spreadsheet.

This enables a one-way synchronization, where any changes in the Google Spreadsheet are downloaded into your data source regularly.

Your data source will be automatically updated in this way until you remove the connector or an error occurs (such as losing authorization to access the Spreadsheet).

Google Spreadsheet currently has a limit of 5,000,000 cells per spreadsheet, and our platform currently supports a maximum of 50 columns and 50,000 rows.

If your data source is beyond this limit, you will need to consider an alternative connector approach.

You need to have configured a Connection to your Google account before adding a Connector.

Adding a Google Spreadsheet Data Source Connector

Data Source Settings

  • Navigate the side menu to Data Hub > Data Sources
  • Hover over a data source and click the “Settings” icon link ()
  • In Settings, hit the “Add Connector” button
  • Select the relevant option to add the connector

This will refresh the page with the newly added connector ready for configuration.

Nothing has been saved at this stage, so save your connector after making any changes to enable or update it.

Alternatively, if you’re viewing the rows of a data source, you can navigate to the Settings page using the option under the page’s title.

Configuring a Google Spreadsheet Data Source Connector

Next, configure the following:

Refresh Frequency

The time interval during which data is pulled and refreshed by this connector.

Using Connection

If your account has multiple Google connections configured, this option allows you to choose which connection to use.

Choose Spreadsheet

Select the Google spreadsheet from which you wish to pull data.

Master Sheet

If enabled, this will allow the import of Master Google Sheets.

A Master Sheet references and is filled with data from another Google Sheet.

When you SAVE your changes, the connector will be fired for the first time, and after that, it will run at the refresh frequency you specified in the connector settings.

Wait a minute or so, or click the three-dot menu ( ) and access the RUN NOW to manually trigger the connector and check the Rows in your data source.

If the rows were not downloaded, there may be an error with the file’s data or permissions to access it. To identify and resolve the issue, you can review the logs by clicking the three-dot menu ( ) and selecting VIEW LOGS.

Once resolved, you can run the connector again and confirm that the rows have been successfully downloaded.

    • Related Articles

    • Google Spreadsheet - Data Source Connector

      A Google Drive data source connector synchronizes a data source with a Google Drive spreadsheet. Any changes made to the Google Spreadsheet will be updated on the data source on the platform. Synchronization can occur in as little as 15 minutes. Your ...

    • Google Drive

      A Google Drive data source connector will sync a data source with a spreadsheet or CSV file hosted on Google Drive. Any changes made to the data source on Google Drive will be reflected on the data source. Synchronization can occur up to every 15 ...

    • Connecting to Google Drive & Spreadsheets

      Adding and authenticating a Connection to your Google Drive and Spreadsheets allows data to be pushed and pulled between the two platforms. Form Connectors can then be added to send files to your Google account or add rows to a spreadsheet when a ...

    • Form Connector – Google Spreadsheet

      Google Spreadsheets is a popular, free platform for creating and maintaining spreadsheets. Its popularity has also resulted in Google Spreadsheets becoming a commonly accepted means of sharing data between systems. One of the easiest ways to automate ...

    • Data Source Connector – Google BigQuery

      Our platform enables you to quickly and easily connect a data source to a Google BigQuery table. This enables a one-way synchronization to occur, where any changes in the Google BigQuery table are downloaded into your data source on a regular basis. ...