Open Navigation

Google Sheets

Send and retrieve data from Google Sheets

Overview

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

Authentication

Note: Before authenticating any Google connector, you will need to whitelist the Tray.io 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:

add-auth

Set up your Google Sheet to work with Tray.io

To use your Google Sheet with Tray.io, 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 Tray.io
  • 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?
Yes
No