MESA Docs
MESA Homepage
  • Welcome to MESA
    • Installing MESA
    • Dashboard
    • Core Concepts
    • Getting Help
  • Templates
    • Template Library
    • Installing & Editing
  • Workflow Builder
    • Triggers
    • Actions
    • Fields
      • Variables
      • Formatting Variables
      • Liquid Templating
    • Testing
  • Workflow Activity
    • Tasks
      • Troubleshooting
      • Replay
    • Logs
    • Time Travel
  • Best Practices
    • Set Titles & Descriptions
    • Track Time Saved
    • Enable Failure Notifications
    • Avoid Infinite Loops
  • Going Further
    • Plans & Billing
    • Notifications
    • Credentials
    • Understanding the Queue
    • Export & Import Workflows
    • Platform Thresholds & Limits
  • Built-in Tools
    • Activity Log
    • AI
    • API
    • Approval
    • MCP
    • Custom Code
      • Libraries
        • MESA SDK
        • Filter
        • Loop
        • Transform
        • oAuth
        • Shopify
        • ShopifyGraphql
      • FAQ
    • Data
    • Delay
    • Email
    • Filter
    • Form
      • Configure
      • Going Further
      • Technical Notes
    • FTP
    • Image
    • Loop
    • Package Tracking
    • Paths
    • Schedule
    • Scraper
    • SMS
    • Transform
    • Virtual Output
    • Weather
    • Web Request
    • Webhook
  • Apps
    • Airtable
    • Amazon S3
    • Asana
    • Blog Studio
    • ChannelApe
    • Claude
    • ChatGPT
    • Dall-E 2
    • Delighted
    • Digital Humani
    • Discord
    • DocuSign
    • Dropbox
    • Etsy
    • Facebook
    • Fera.ai
    • Gatsby
    • Gmail
      • Send Email
    • Google Analytics 4
    • Google Analytics UA
    • Google Calendar
    • Google Drive
    • Google Forms
    • Google Sheets
      • Add Row
      • Query Rows
      • Update Row
      • Row Created
      • Row Updated (Advanced)
      • Creating New Spreadsheets
      • Technical Notes
    • Gorgias
    • Govalo
    • Help Scout
    • Hubspot
    • Infinite Options
    • Intercom
    • IPDetective
    • Judge.me
    • Katana
    • Klaviyo
      • API Deprecation
    • Loop Returns
    • Loyalty Lion
    • Mailchimp
    • Mailgun
    • Mandrill
    • Mantle
    • Notion
    • Odoo
    • Omnisend
    • Page Studio
    • Pinterest
    • Printful
    • PrintNode
    • QuickBooks
    • Rebuy
    • Recharge
    • Remove.bg
    • Returnly
    • Rivo
    • Salesforce
    • Segment
    • Sendlane
    • Shippo
    • ShipStation
    • Shopify
      • Technical Notes
        • Configuring Your Payload
        • Modifying and Filtering Get Lists
        • Parameters
        • Error Codes
        • Accuracy of orders_count Variable
        • Accuracy of Count Products Action
        • Using the Gift Cards API
        • How to Find a Specific Record in the Testing Interface
        • Order, Customer, and Product Updated Trigger Frequency
    • Shopify Flow
    • Shopify Partner
    • Shopify Plus
    • Shopify Retail POS
    • Skio Subscriptions
    • Slack
    • Smartrr
    • Smile.io
    • Square
      • Updating Inventory
      • Frequently Asked Questions
    • Stamped.io
    • Stripe
    • Thanks.io
    • TikTok
    • Tracktor
    • Twilio
    • Uploadery
    • Wonderment
    • Xero
    • Yotpo
    • Yotpo Loyalty
  • For developers
    • Admin API
    • Command Line Interface
    • Embedding templates
  • Frequently asked questions
    • Why isn't the log search returning logs with the search I entered?
    • Is it possible to handle errors or retry steps?
    • How do I handle a failed task?
    • Does MESA auto-save workflows?
    • Can I Use Apps That Don't Have a MESA Connector?
    • Why is my workflow action adding the same data each time it occurs?
    • How do I cancel automations that are already in progress?
    • How do I cancel my MESA subscription or 7-day trial?
    • Can you import code from npm in custom code?
    • Do you have a Slack Community?
Powered by GitBook
On this page
  • Basic filtering
  • Advanced filtering
  • Query examples

Was this helpful?

  1. Apps
  2. Google Sheets

Query Rows

PreviousAdd RowNextUpdate Row

Last updated 1 month ago

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.

Basic filtering

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.

Advanced filtering

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.

Query examples

Return records that match multiple filter criteria (and):

select * where B="Oakland" and C>100

This will return a single row (Row 2).

Return records with multiple options (or)

select * where B="Oakland" or B="San Francisco"

This will return three rows (Row 2 and 3).

Calculate the total value of a column

select sum(C) where B="Oakland"

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 .

Google Sheets Query Language
Query Language docs
Authenticate