Google SheetsSend 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.
Click on the New Authentication button:
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?