- Get started
- Steps to build automations using AppSheet databases
- Copy apps with AppSheet database events
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.