Explore Plans
Mobile menu Close menu
Google Sheets

Current values of a row

This query returns the current values in a given row. Values from columns A-Z are available as ingredients.

Developer info

API endpoint slug
google_sheets.cell_values_in_row
Runtime method
performQuery("google_sheets.cell_values_in_row"}

Query fields

Row index Text input > Other

Label
Which row?
Helper text
E.g. 25, Sheet2!5, or 'Monthly budget'!12 (must be a valid single row)
Slug
row_index
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

Column a The value of a cell in column A at this row

Slug
column_a
Filter code
GoogleSheets.cellValuesInRow.ColumnA
Type
String
Example
$120.00

Column b The value of a cell in column B at this row

Slug
column_b
Filter code
GoogleSheets.cellValuesInRow.ColumnB
Type
String
Example
$120.00

Column c The value of a cell in column C at this row

Slug
column_c
Filter code
GoogleSheets.cellValuesInRow.ColumnC
Type
String
Example
$120.00

Column d The value of a cell in column D at this row

Slug
column_d
Filter code
GoogleSheets.cellValuesInRow.ColumnD
Type
String
Example
$120.00

Column e The value of a cell in column E at this row

Slug
column_e
Filter code
GoogleSheets.cellValuesInRow.ColumnE
Type
String
Example
$120.00

Column f The value of a cell in column F at this row

Slug
column_f
Filter code
GoogleSheets.cellValuesInRow.ColumnF
Type
String
Example
$120.00

Column g The value of a cell in column G at this row

Slug
column_g
Filter code
GoogleSheets.cellValuesInRow.ColumnG
Type
String
Example
$120.00

Column h The value of a cell in column H at this row

Slug
column_h
Filter code
GoogleSheets.cellValuesInRow.ColumnH
Type
String
Example
$120.00

Column i The value of a cell in column I at this row

Slug
column_i
Filter code
GoogleSheets.cellValuesInRow.ColumnI
Type
String
Example
$120.00

Column j The value of a cell in column J at this row

Slug
column_j
Filter code
GoogleSheets.cellValuesInRow.ColumnJ
Type
String
Example
$120.00

Column k The value of a cell in column K at this row

Slug
column_k
Filter code
GoogleSheets.cellValuesInRow.ColumnK
Type
String
Example
$120.00

Column l The value of a cell in column L at this row

Slug
column_l
Filter code
GoogleSheets.cellValuesInRow.ColumnL
Type
String
Example
$120.00

Column m The value of a cell in column M at this row

Slug
column_m
Filter code
GoogleSheets.cellValuesInRow.ColumnM
Type
String
Example
$120.00

Column n The value of a cell in column N at this row

Slug
column_n
Filter code
GoogleSheets.cellValuesInRow.ColumnN
Type
String
Example
$120.00

Column o The value of a cell in column O at this row

Slug
column_o
Filter code
GoogleSheets.cellValuesInRow.ColumnO
Type
String
Example
$120.00

Column p The value of a cell in column P at this row

Slug
column_p
Filter code
GoogleSheets.cellValuesInRow.ColumnP
Type
String
Example
$120.00

Column q The value of a cell in column Q at this row

Slug
column_q
Filter code
GoogleSheets.cellValuesInRow.ColumnQ
Type
String
Example
$120.00

Column r The value of a cell in column R at this row

Slug
column_r
Filter code
GoogleSheets.cellValuesInRow.ColumnR
Type
String
Example
$120.00

Column s The value of a cell in column S at this row

Slug
column_s
Filter code
GoogleSheets.cellValuesInRow.ColumnS
Type
String
Example
$120.00

Column t The value of a cell in column T at this row

Slug
column_t
Filter code
GoogleSheets.cellValuesInRow.ColumnT
Type
String
Example
$120.00

Column u The value of a cell in column U at this row

Slug
column_u
Filter code
GoogleSheets.cellValuesInRow.ColumnU
Type
String
Example
$120.00

Column v The value of a cell in column V at this row

Slug
column_v
Filter code
GoogleSheets.cellValuesInRow.ColumnV
Type
String
Example
$120.00

Column w The value of a cell in column W at this row

Slug
column_w
Filter code
GoogleSheets.cellValuesInRow.ColumnW
Type
String
Example
$120.00

Column x The value of a cell in column X at this row

Slug
column_x
Filter code
GoogleSheets.cellValuesInRow.ColumnX
Type
String
Example
$120.00

Column y The value of a cell in column Y at this row

Slug
column_y
Filter code
GoogleSheets.cellValuesInRow.ColumnY
Type
String
Example
$120.00

Column z The value of a cell in column Z at this row

Slug
column_z
Filter code
GoogleSheets.cellValuesInRow.ColumnZ
Type
String
Example
$120.00

Row index Row number

Slug
row_index
Filter code
GoogleSheets.cellValuesInRow.RowIndex
Type
String
Example
20

Spreadsheet name The title of the spreadsheet.

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

Spreadsheet url The URL of the spreadsheet.

Slug
spreadsheet_url
Filter code
GoogleSheets.cellValuesInRow.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.cellValuesInRow.CheckedAt
Type
Date with time (ISO8601)
Example
2020-07-08T04:17:06+05:00