To set up a bot that triggers a process when a data change happens in Google Sheets, you'll need to perform the following steps:

  1. Configure AppSheet Events on Google Sheets to allow a data change event to be sent to your app.

  2. Create the data change events in your AppSheet app that are triggered by Google Sheets.

Troubleshooting provides tips on resolving issues.

Video Demonstration

The following video demonstrates how to set up external eventing with Google Sheets, as described in this section.

Configure AppSheet Events on Google Sheets

To configure AppSheet Events on Google Sheets to allow a data change event to be sent to your app from the sheets:

  1. Install the AppSheet Events Add-On from the Add-On marketplace.

  2. Open a spreadsheet and select Add-ons> AppSheet Events > Enable for Document to enable the add-on.

  3. Enable Add-ons> AppSheet Events > Turn events on/off > sheet for each sheet from which you want to send events.

    In addition, you can enable the add-on for response sheets from Google Forms:

Create the data change events in your AppSheet app

To create the data change events in your AppSheet app to be triggered by Google Sheets:

  1. Create or open an app.

  2. Select Data > Table and add tables for the Google Sheets that you enabled to send events in the previous section.

  3. Select Automation > Events and create an event that triggers on Data Change.
    You can configure the event for adds or deletions only, as required.

    For example, the following event triggers when content is added to the employees table.

    Screen+Shot+2021-04-12+at+5.25.15+PM.png (910×876)
  4. Create a bot that uses that event.

  5. When you modify the sheet in Google Sheet, you should see the event trigger after a few seconds. For Google Forms, new rows added to the response sheet via direct interaction with the Google Form can also trigger events.

    Note: Third-party (like IFTTT) or scripted interactions will not trigger events.

To learn more about events, see Events: The Essentials and Configuring an event.

Troubleshooting

If the event hasn't triggered the bot after a few seconds, check that the event was received in the Automation Monitor by selecting Manage > Monitor > Automation Monitor > Launch automation monitor from the AppSheet editor.

If the event doesn't show up, verify your table selection in Google Sheets and that you are logged into a Google account that has access to both the Google Spreadsheet and the AppSheet app (from the Users tab).

If the event did show up but did not run, check that your Table, Condition, and data change type are all correct in the event configuration in AppSheet.

Did this answer your question?