Query Rows
Last updated
Was this helpful?
Last updated
Was this helpful?
The Query Rows action retrieves rows from your Google Spreadsheet. To get started, and select an existing Spreadsheet and Sheet. Then click the Retrieve Fields button to retrieve the columns from your spreadsheet. These columns will be available as variables in future steps in your workflow.
You can choose to fetch all of the rows in your spreadsheet, or you can filter the rows returned by specific values. For basic filters, use the Filter rows by column value option pictured above. The Column value will pre-populate with the columns from your spreadsheet, and you can select columns that equal, do not equal, or contain a specific value.
MESA will use the header values detected when you last clicked the Retrieve Fields button in the builder.
Tip: Depending on your plan, the Loop step generally will time out after about 200 records. If your spreadsheet has more than 200 rows, we suggest filtering your rows in the Google Sheets Query Rows step.
Because the result of a query doesn't always match your header row, MESA will use the A, B, C, ... column representation as keys for your response.
This will return a single row (Row 2).
This will return three rows (Row 2 and 3).
This will return a single record with one value, the total of C2 + any other row where Oakland was the City.
To filter by multiple column values, specify a specific subset of columns that should be returned, or to run advanced queries that calculate the sum or average value of columns, use the Advanced query option and enter a query in the input.
Here are a few basic examples of Query Language queries based on the spreadsheet below. Additional examples can be found in the .
