Google SheetsAbout this query
Triggers, queries, and actions are the building blocks of Applets. Triggers tell an Applet to start, queries ask a question, and actions are its end result.
Developer info
- Description
- This query returns the current value of a single cell in your spreadsheet.
- API endpoint slug
- google_sheets.cell_value
- Runtime method
- performQuery("google_sheets.cell_value")
Query fields
Cell Text input > Other
- Label
- Which cell?
- Helper text
- E.g. C25, Sheet2!B5, or 'Monthly budget'!B12 (must be a valid single cell)
- Slug
- cell
- Required
- true
- Can have default value
- true
Spreadsheet URL Text input
- Label
- Copy and paste the spreadsheet URL
- Helper text
- Must be a valid Google Sheets spreadsheet URL
- Slug
- spreadsheet_url
- Required
- true
- Can have default value
- true
Ingredients
ValueThe current value of the cell.
- Slug
- value
- Filter code
- GoogleSheets.cellValue.Value
- Type
- String
- Example
- $120.00
CellThe address of the cell.
- Slug
- cell
- Filter code
- GoogleSheets.cellValue.Cell
- Type
- String
- Example
- A20
Spreadsheet nameThe title of the spreadsheet.
- Slug
- spreadsheet_name
- Filter code
- GoogleSheets.cellValue.SpreadsheetName
- Type
- String
- Example
- Monthly family budget
Spreadsheet URLThe URL of the spreadsheet.
- Slug
- spreadsheet_url
- Filter code
- GoogleSheets.cellValue.SpreadsheetUrl
- Type
- String
- Example
- https://docs.google.com/spreadsheets/d/XXXXXXXXX/edit#gid=0
Checked atThe timestamp when the value of the cell was fetched.
- Slug
- checked_at
- Filter code
- GoogleSheets.cellValue.CheckedAt
- Type
- Date with time (ISO8601)
- Example
- 2020-07-08T04:17:06.000+05:00