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

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