Explore Plans
Mobile menu Close menu
Google Sheets

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