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 aThe value of a cell in column A at this row

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

Column bThe value of a cell in column B at this row

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

Column cThe value of a cell in column C at this row

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

Column dThe value of a cell in column D at this row

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

Column eThe value of a cell in column E at this row

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

Column fThe value of a cell in column F at this row

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

Column gThe value of a cell in column G at this row

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

Column hThe value of a cell in column H at this row

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

Column iThe value of a cell in column I at this row

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

Column jThe value of a cell in column J at this row

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

Column kThe value of a cell in column K at this row

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

Column lThe value of a cell in column L at this row

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

Column mThe value of a cell in column M at this row

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

Column nThe value of a cell in column N at this row

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

Column oThe value of a cell in column O at this row

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

Column pThe value of a cell in column P at this row

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

Column qThe value of a cell in column Q at this row

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

Column rThe value of a cell in column R at this row

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

Column sThe value of a cell in column S at this row

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

Column tThe value of a cell in column T at this row

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

Column uThe value of a cell in column U at this row

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

Column vThe value of a cell in column V at this row

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

Column wThe value of a cell in column W at this row

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

Column xThe value of a cell in column X at this row

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

Column yThe value of a cell in column Y at this row

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

Column zThe value of a cell in column Z at this row

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

Row indexRow number

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

Spreadsheet nameThe title of the spreadsheet.

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

Spreadsheet URLThe 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 atThe 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.000+05:00