External eventing with Google Sheets

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.

See Troubleshoot for tips on resolving issues.

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

AppSheet Automation: External eventing with Google Sheets

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-Onfrom the Add-On marketplace.
  2. Open a spreadsheet and select Extensions > 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.

    Shows Extensions> AppSheet Events > Turn events on/off > Sheet1 in the Sheets Extensions drop-down.

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.

    Data change event triggered with an add to the employees table.
  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 through 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.

Troubleshoot

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. See Monitor automation for more information.

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.

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false