Google Sheets

Overview

This doc outlines how to use the Google Sheets connector to manage your engagement campaigns and import data for unified analysis and workflow creation.

Setup

Create connector
From the settings panel or from the node catalog, search for the Google Sheets integration and navigate to the 'Create connector' view.

Configure the connector
Click on the authenticate button and log in with your Google OAuth credentials to grant Cargo access to your Google Sheets.

Setup step 1

Create data loader

  • From the data module on the left panel, add a model using + next to the Google Sheets connector to begin configuring a data model using a Google Sheets object.

  • Load data from Google Sheets into Cargo by pasting the entire Google Sheet URL (including the GID) and selecting the spreadsheet and worksheet, and defining the necessary fields and filters.

Actions

Write - Create a new record in Google Sheets
Add the spreadsheet ID and worksheet, and add the content of the new record to the mappings. Choose from an existing column or define a new column in your Google Sheet using the connector.

Write - Upsert record in Google Sheets
Use an expression to define the matching value for a record to identify an existing row against a matching property name. Choose from an existing column or define a new column in your Google Sheet using the connector.

FAQ

Which rate limits should I set for this connector?
The advised rate limit for the Google Sheets connector is below 10 requests per minute.

Does a sheet need to have shared permissions to be loaded as a data loader?
The OAuth connection with Google Sheets means the shared permissions of a Google Sheet don't impact its loading into a Cargo data model.