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 effect 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?

Need more help?

Try these next steps:

Search
Clear search
Close search
Google apps
Main menu
17242831075755480128
true
Search Help Center
true
true
true
false
false