Top Google Sheets automations
Explore Plans
Mobile menu Close menu
Google SheetsGoogle 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.

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