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.
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 in for each of the columns you'd like to use in Tray
- 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?