Build automations using AppSheet databases

Build an automation using AppSheet databases to trigger events when there are changes made to one or more columns, as described in the following sections:

See also Automation limits.

Get started

To get started building automations using AppSheet databases, see Quick start: Build your first automation using an AppSheet database.

Steps to build automations using AppSheet databases

Build automations using Google Forms to trigger events when there are changes made to one or more columns by performing the following steps.

# Step Description
1

Create an AppSheet database

Before you can build an automation, you must create an AppSheet database. See Create and copy databases.
2 Add the AppSheet database to your app

Do one of the following:

In each case, select AppSheet databases as the data source, then navigate to the database and click Select.

3

Use adds, updates, or deletes in the AppSheet database to trigger an event

Build an automation and configure an AppSheet database event.

App concepts or table settings defined in the app editor (such as making a column non-editable or required) won't affect how the bot gets triggered for event sources that are external to the app. For example, even if a column is marked as non-editable for apps, it can still be selected in the Column to watch for setting in the event.

Copy apps with AppSheet database events

To copy an app with AppSheet database events, follow the steps described in Copy apps and select AppSheet database in the Save app to field. Otherwise, the AppSheet database event will no longer work.

Was this helpful?

How can we improve it?