Our platform enables you to quickly and easily connect your data sources to data from a Google Spreadsheet.
This enables a one-way synchronisation to occur – where any changes in the Google Spreadsheet are downloaded into your data source on a regular basis.
Your data source will be automatically updated in this way until you remove the connector or an error occurs (such as losing authorisation to access the Spreadsheet).
Google Spreadsheet currently have 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.
Note: You need to have configured a Connection to your Google account before adding a Connector.
- Adding a Google Spreadsheet Data Source Connector
- Configuring a Google Spreadsheet Data Source Connector
Adding a Google Spreadsheet Data Source Connector
Navigate to the Settings page of the data source you’d like to import rows into.
- Connected Data>Data Sources
- In the list of available data sources, hover your mouse over the listing of the data source you wish to connect.
A set of options will show, click on the Settings link. -
On the Settings page, after Basic and Advanced Options is the Connector option, click the Add Connector link.
- A new window with connectors to choose from will appear, click the Google Spreadsheet option.
The page should refresh with your newly added connector to be configured.
Configuring a Google Spreadsheet Data Source Connector
Next, configure the following:
- Spreadsheet Name
The exact name and location of the Google spreadsheet that you wish to pull data from. If the spreadsheet is in a subfolder of your Google Drive, then use the following format: ‘FolderName/Folder2/Sheetname’.
“My Drive” need not be included for the connection to be made successfully. - Refresh Frequency
The frequency that data is pulled by this connector. - Master Sheet
If enabled, this will allow the import of Master Google Sheets. A Master Sheet references and is filled with data from other Google Sheet(s). - Shared/Team Drive ID
If your target file location is within a Shared or Team Drive, you must specify the unique identifier for this Drive.
To retrieve the ID, go to your Google Drive in a web browser and navigate to the root of the target Drive.
Next, check the address bar of your web browser and copy the characters which follow the “/folders/” part of the URL.
e.g. if the URL is https://drive.google.com/drive/folders/1234567890ABCDEFGHI, then the drive ID of 1234567890ABCDEFGHI.
When you SAVE your changes, the connector will be fired for the first time and after that will run at the interval you specified in the connector settings.
Wait a minute or so and then check the Rows page of your data source.
If rows are not downloaded, then there may be an error with the Spreadsheet’s data or in accessing the spreadsheet.
You can check this by clicking on the View Logs link shown next to your connector on the Settings page.