Google Sheets 8.1
Send and retrieve data from Google Sheets.
OverviewCopy
The Google Sheets connector allows you to send & retrieve data from any of the Google Sheets available within your account.
API InformationCopy
The Google Sheets connector has the following Base URL: https://sheets.googleapis.com/v4. More information can be found on their main API documentation (v4) site. Details regarding their API limitations can be found here.
Google Sheets TemplatesCopy
Export leads from a Google Sheet to Salesforce
Capture leads from a Google Sheet, then create and update contacts in Salesforce
Create a Google Sheet from JSON array
Generates a Google Sheet from a JSON array and (optionally) share the sheet with a list of user emails
Upload list of employees to Bamboo
Adds new employees from a Google Sheet to BambooHR
Export Salesforce query to new Google Sheet
Executes a query for specific records, then compiles them into a new Google Sheet
Export Salesforce query to existing Google Sheet
Executes a query for specific records, then compiles them into an existing Google Sheet
Export SuiteQL response to Google Sheets
Executes a SuiteQL query in Netsuite, then sends the response to a Google Sheet
Check for new data in Google Sheets
Runs on a constant schedule to check for new content in a google sheet
Migrate Google Sheets contacts to Mailchimp
Migrate contacts stored in Google Sheets to a Mailchimp list
Migrate Mailchimp contacts to Google Sheets
Migrate contacts from a Mailchimp list to a Google Worksheet
Export leads from a Google Sheet to Zoho
Intake leads from a Google Sheet, standardize them, and record in Zoho CRM
Add Typeform survey responses to Google Sheets
Every time a Typeform survey is completed, store the result in a new row in Google Sheets
Sync Typeform responses to Google Sheets (Embedded quickstart tutorial)
Every time a Typeform survey is submitted the answers are stored in a Google Sheet
Export leads from a Google Sheet to HubSpot
Intake leads from a Google Sheet, standardize them, and record in HubSpot
Export leads from a Google Sheet to Pardot
Intake leads from a Google Sheet, standardize them, and record in Pardot
Export leads from a Google Sheet to Iterable
Intake leads from a Google Sheet, standardize them, and record in Iterable
Export leads from a Google Sheet to Pipedrive
Intake leads from a Google Sheet, standardize them, and record in Pipedrive
Export leads from a Google Sheet to Freshsales
Capture leads from a Google Sheet, then create and update contacts in Freshsales
Export leads from a Google Sheet to Marketo
Capture leads from a Google Sheet, then create and update contacts in Marketo
AuthenticationCopy
When using the Google sheets connector for the first time, you need to create a new authentication.
Name your authentication and specify the type ('Personal' or 'Organizational').
The next page asks you for your 'Service Permissions'. Set as appropriate for your project scopes and click Create authentication.
On the new dialog box, click Allow if you wish to permit Tray.io to access your Google Account.
Go back to your settings authentication field (within the workflow builder properties panel), and select the recently added authentication from the available dropdown options .
Your connector authentication setup is now complete.