Spreadsheet
Store a Google Sheets spreadsheet id tied to a Google connection.
Type
google.sheets.spreadsheetListed only when a matching connected service is enabled.
Spreadsheet stores a Google Sheets spreadsheet id. It appears in the column picker only when a Google connection has Google Sheets enabled.
Name, key, hidden, and permissions are the same for every column — see Tables.
There is no per-row “sheet row id” field. Google has no stable row primary key. Keep the spreadsheet id here and use ranges in Get Values.
Configure
| Setting | Description |
|---|---|
| Connected service | Google connection with Sheets |
| Default range (optional) | A1 range used when reading values from this cell, e.g. Sheet1!A:Z |
Open the cell to search spreadsheets and pick one. The title comes from Get Spreadsheet.
Use case
- Keep a tracker workbook on a deal or intake row.
- Pair with Spreadsheet Changed or List Spreadsheets to write the id onto the row.