Google Sheets

  • Connecting Google Sheets with Mesa
  • Configuring
  • Triggers
  • Actions
  • Connecting Google Sheets with Mesa

    When you're setting up your first workflow with Google Sheets, you'll need to create a credential through Mesa's Google App or your own custom Google App. Click on Authenticate with Google to finish the process. 

    Afterwards, your credential will be selected.

    Configuring

    Google Sheets Triggers and Actions both require a Spreadsheet and Sheet to be configured. Add your Credential and then use the Typeahead to select a Spreadsheet and a Sheet within that spreadsheet from the docs in the Google account associated with your Credential.  Once you have values, we can automatically detect the the columns in your Google Sheet and add them to Mesa:

    By default, we will pull field labels from the first row in your Sheet.  If you would rather use the letter column labels (A, B, C, D ... AA), update the  Column Headers select list option and the click the button again. If no fields or tokens appear, or if fields are missing, make sure you have at least one row in your Sheet with a value in each column.

    Triggers

    The Row Created Trigger runs on a polling system.  Mesa makes a request to Google Sheets every hour to look for new records and triggers the necessary Workflows. During testing, Mesa will look for new records every time the workflow is saved. After each poll, Mesa records the last row that was read. For example, if there are nine rows in your spreadsheet and you add a two rows, Mesa will trigger an workflow for the 10th and 11th rows. Because of this, making the following changes to your spreadsheet while the workflow is active could cause rows to be duplicated or skipped:

    • Deleting existing rows.
    • Adding rows anywhere other than to the bottom of your sheet.
    • Resorting the sheet.
    • Filtering the sheet.
    If you need to make any of those changes to your Google Sheet, disable the Mesa Workflow, and make your changes. Then click the Update Field Values button and then enable and save your workflow. You should also click the  Update Field Values button after making any of these changes to your sheet's structure:
    • Renaming the sheet.
    • Renaming/adding/rearranging columns.
    • Deleting existing columns.

    Actions

    Click the  Retrieve Column Field Values button after making any of these changes to your sheet's structure:
    • Renaming the sheet.
    • Renaming/adding/rearranging columns.
    • Deleting existing columns.
    Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.