About this query
Triggers, queries, and actions are the building blocks of Applets. Triggers tell an Applet to start, queries ask a question, and actions are its end result.
Developer info
- Description
- This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
- 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