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

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