You must be a Google Workspace user to build AppSheet automations with Google Forms. See Add AppSheet to Google Workspace.
If you are using your Google Workspace account, the Google Workspace Terms of Service govern your use of Google Forms. Otherwise, refer to the Google Terms of Service.
Build an automation using Google Forms to trigger events based on a form response, as described in the following sections:
Get started
To get started building automations with Google Forms, see Quick start: Build your first app and automation using Google Forms.
Steps to build automations using Google Forms
Build automations using Google Forms to trigger events based on a form submission by performing the following steps.
# | Step | Description |
1 |
Create a form using Google Forms |
Before you can build an automation, you must create a form using Google Forms. See How to use Google Forms. Notes:
|
2 | Add the form to your app |
Do one of the following:
In each case, select Google Forms as the data source and then navigate to the form. See also How AppSheet stores responses from Google Forms. To create an app from the form, do the following:
|
3 |
Use the form responses to trigger an automation |
Build an automation and add a Google Forms event. |
How AppSheet stores responses from Google Forms
When you add a form from Google Forms to your app, AppSheet adds a read-only table to store the responses collected by the form. For example, the following shows the Table settings for the read-only table that is used to store data collected by the Travel Request form.