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.
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:
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