Current value of a cell

This query returns the current value of a single cell in your spreadsheet.

Developer info

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

Value The current value of the cell.

Slug: value
Filter code: GoogleSheets.cellValue.Value
Type: String
Example: $120.00

Cell The address of the cell.

Slug: cell
Filter code: GoogleSheets.cellValue.Cell
Type: String
Example: A20

Spreadsheet name The title of the spreadsheet.

Slug: spreadsheet_name
Filter code: GoogleSheets.cellValue.SpreadsheetName
Type: String
Example: Monthly family budget

Spreadsheet url The 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 at The 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+05:00