This is a beta release of creating apps and building automations using Google Forms. See Track and manage feature releases. Beta offerings are intended for use in test environments only. This feature is not recommended for use in production apps. For questions or assistance with this feature, contact AppSheet Support.
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.
The following sections provide tips for troubleshooting issues when using AppSheet with Google Forms.
If the following error is logged:
Request had invalid authentication
- The app owner still has access to the form. See "How to check access to the form" (below).
- The form is connected to the app.
- Check that the application is deployed. An application that isn't deployed can only send email to the application owner. See Deploy: The Essentials.
- Check the validity of the email address or expression used for the To field for the email task in the bot.
See also: Troubleshoot email
There are two issues that can result in the Data table <name> is not accessible
error in an application view.
Use the code and message included in the error to determine the issue, as follows:
- Code:
404
, Message:File not found
The application owner no longer has editor access to the form. See "How to check access to the form" (below). - Code:
401
, Message:Request had invalid authentication credentials
Authentication has expired or is revoked. Sign out of AppSheet and sign back in to refresh authentication.
To check access to the form, do the following:
- Go to Data .
- Select the form-based table in the left Data pane.
- Click View data source.
- Make sure that the app owner has editor access to the form, as described in Share your form with collaborators.