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.
To create your first automation using Google Forms, perform the following steps:
- Create a form using Google Forms.
- Create an app using the form.
- Build an automation using the form.
- Test the automation.
Create a form using Google Forms
Create a simple form using Google Forms. See How to use Google Forms.
For example, in this quick start we use the following Travel Request form. But you don't have to match this exactly.
In the next step, you'll create an app using the form you just created.
Create an app using the form
To create an app using the Travel Request form:
- Sign in to AppSheet.
The My Apps page is displayed. - Select Create > App > Start with existing data.
The Create a new app dialog is displayed. - For App name, enter Travel Approval and click Choose your data.
The Select data source dialog is displayed. - Click Google Forms.
The Select a file dialog is displayed. - Navigate to the Travel Request form and click Select.
Your new Travel Approval app is created and opened in the AppSheet app editor. The Learning Center is displayed, by default.
If the Try it out! dialog is displayed, click Customize with AppSheet to close it. - In the app editor, click Data in the left navigation bar.
When you create an app using a form from Google Forms, AppSheet adds a read-only table, in this case Travel Request, to store the responses collected by the form, as shown:
Your table content might vary; the table columns are based on your form's fields.
In the next step, you'll build an automation using the Travel Request form from Google Forms.
Build an automation using the form
In this step, you'll build an automation using the form that triggers the travel request approval flow. Specifically, you'll learn how to create a bot that sends an email to the approver.
To build an automation using the Travel Request form:
- In the app editor, go to Automation .
- Click + in the top header of the Bots pane.
- In the Add a new bot dialog, click Create a new bot.
A new empty bot is created and displayed in the center pane of the app editor. - Edit the name of the bot.
- Position your cursor over the New Bot in the left navigation pane.
- Select More > Rename.
- Rename the bot to Travel request approval and press Enter.
- In the new bot flow in the center pane, click Configure event.
- For Event name, enter Travel request form submitted and click Create a custom event.
The Settings pane opens in the right side of the app editor.
You could also select A new form resonse is submitted to Travel Request in the list of suggestions to automatically configure a portion of the event. But for the purposes of this tutorial you'll learn how to configure the event manually. For more information, see Suggestions in the app editor. - Configure the event as follows:
- In the Event source drop-down, select Forms.
New response is selected automatically. - For Form, select Travel Request in the drop-down (it should already be selected).
- In the Event source drop-down, select Forms.
- In the bot flow in the center pane, click + Add a step.
- For Step name, enter Email approver and click Create a custom step.
The Email approver task is added and the configuration settings are displayed in the right pane. - Edit the task configuration settings in the right pane, as follows:
- Leave the task type set to Send an email.
- For Email Type, click Custom template.
- Note, the Table is set to Travel Request.
- In the To field, click Add and enter your email address (for testing).
- In the Email Subject field, enter: Travel request to <<[Destination]>> by <<[Name]>>
The<<[Destination]>>
and<<[Name]>>
are variables that refer to column data stored in the table from the requester's response. - Leave the Email Body field set to the default content.
By default, the Email Body includes data values from the requester's response (the added row).
- Click Save to save the app.
The following warning message is displayed:
You can ignore this message for now. All test messages will be sent to you as the app owner, so you don't need to deploy the app in order to test the automation.
Next, you'll test your automation.
Test the automation
To test the automation:
- Send the Travel Request form to yourself and submit a response.
- Check your email for a message titled Travel request to destination by name, where destination matches the destination and name matches the name specified in the submitted form.
Congratulations! You have built your first app and automation using Google Forms.
What's next? You can access more quick starts to learn about other AppSheet features.