Google Sheets Connector Setup Guide
This article describes how to set up the Google Sheets connector.
This connector may be used for low volume testing (up to 100 requests per day). Exceeding this limit or sending a large volume at once may throttle the connector and cause data loss on the spreadsheet.
Requirements
- Google Account
- Google Spreadsheet - Must be in your Google Drive and already have column names in the first (header) row.
Supported Actions
Action Name | AudienceStream | EventStream |
---|---|---|
Add or Update Row | ✓ | ✓ |
Configure Settings
Go to the Connector Marketplace and add a new connector. Read the Connector Overview article for general instructions on how to add a connector.
Action Settings - Parameters and Options
Click Next or go to the Actions tab. This is where you configure connector actions.
This section describes how to set up parameters and options for each action.
Action - Add or Update Row
Parameters
Parameter | Description |
---|---|
Row Operation |
|
Spreadsheet Name |
|
Worksheet Name |
|
Row Data |
|
Lookup (Optional) |
|
FAQs
How do I find my Spreadsheet ID to enable Lookup?
Use the following steps to find your Google Sheets Spreadsheet ID and enable Lookup:
- Click the Enable Lookup button on the upper-left.
- In the Spreadsheet ID field, enter your spreadsheet ID.
You can locate the ID in your spreadsheet URL. For example, in the following URL, the Spreadsheet ID is 12345:https://docs.google.com/spreadsheets/d/**12345**/edit#gid=0
- Click Enable Lookup on the bottom right to return to the previous screen.
Lookups must be enabled once per spreadsheet using the individual Spreadsheet ID.
Tracking is not available to show which Google Sheets are enabled for Lookup
There is no tracking available to show which Google sheets are enabled for lookup. Once lookup is enabled, there is no method to determine that Lookup enabled for a particular sheet if you log into the account another time.
Action Dynamic Drop-Down lists do not display in real-time
Updates to the action dynamic drop-down lists are not live and do not display in real time. For example, if you are adding a new column in Google Sheets, modifications to the sheet do not automatically inherit the changes and reflect in the drop-down list.
To view the most recent data, you can click the Refresh icon on the connectors page or deselect the spreadsheet and select it again. Using either of these methods refreshes the drop-down lists to reflect your most recent updates.
Vendor Documentation
This page was last updated: June 23, 2022