Open Navigation

Google Sheets

Send and retrieve data from Google Sheets


The Google Sheets connector allows you to send & retrieve data from any of the Google Sheets in your account.


Note: Before authenticating any Google connector, you will need to whitelist the Google authentication app. Please follow the instructions here before continuing with the authentication process.

Once this is done, you can click on the New Authentication button:


Set up your Google Sheet to work with

To use your Google Sheet with, you'll need to set up your Sheet to work in a specific way:

  • The first row must have column headers for each of the columns you'd like to use in
  • There can be no completely blank rows in your spreadsheet (you'll need to delete any blank rows, as Google creates sheets with default 1,000 rows)
  • The row values in your sheet should be in rows 2, 3, 4.... etc
Was this article helpful?