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