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.
In this Quick start, you'll build your first app using Google Forms that is based on a travel request approval workflow. You'll create an app using a form from Google Forms and build a new automation flow that sends an email notification when a form response is received requesting approval for business travel.
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 anautomation 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 toAppSheet.
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 Approvaland 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 Requestform 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 toclose it.
- In the app editor, clickDatain the left navigation bar.
When you create an app using a form from Google Forms,AppSheet adds aread-onlytable, 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 toAutomation .
- 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.
- SelectMore > 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 Settingspane opens in the right side of the app editor.
You could also selectA new form resonse is submitted to Travel Request in the list ofsuggestions 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 sourcedrop-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 sourcedrop-down, select Forms.
- In thebot 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 thetask 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 includesdata values from the requester's response (the added row).
- ClickSave 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 yourselfand 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.
Was this helpful?
How can we improve it?