Row Updated (Advanced)
Last updated
Was this helpful?
Last updated
Was this helpful?
The Row Updated trigger requires additional configuration within your Google Sheet to work properly. Let's go through each step:
Begin by creating a new workflow in MESA and adding a Row Updated trigger. Under Step configuration, copy the App Script code:
Go to your Google Sheet. Click on the “Extensions” menu option and select “Apps Script”.
You should end up here:
Paste the code from step 1, replacing the contents of the App Script file. It should look like this:
The last thing we have to do is to setup a trigger. In order to do that we need to click on the clock icon on the left hand side (in the Google Script editor).
Click the “Add Trigger” button on the bottom right.
The only thing we need to edit in the window that pops up is under “Select Event Type”, set that to “On change” and Save.
You will be asked to approve this trigger via the standard Google authorization flow. Choose the correct Google account and grant access.
Your Row Updated trigger has now been configured. Enable your workflow in MESA and edit your spreadsheet. Confirm that your workflow is getting triggered successfully in the Activity tab.
The Row Updated step will not have any variables available until you have set up the App Script in Google Sheets and run at least one test. To update the variables available after updating column headers, simply make another update in your spreadsheet and refresh the builder. MESA will automatically make the columns from your latest test available in the Variable Selector.
