Google Forms Webhook
Google Forms Webhook starts a flow every time someone fills in and submits a Google Forms form. The flow receives the answers with the text of each question, ready to store them, analyse them or reply to the person who wrote.
NappAI checks the form about once a minute and, if there are new responses, runs the flow with them. You don’t have to set anything up in Google: the credential and subscribing the flow are enough.
When to use it
- Every event registration should be stored in a spreadsheet and get a confirmation email.
- You want an AI agent to read every survey response and alert you if someone is unhappy.
- Quote requests come in through a form and you want to add them to your CRM straight away.
- You want to notify your team on a messaging app every time an incident report arrives.
Configuration
You need a Google Forms credential, which connects by signing in with your Google account. See Credentials.
| Field | What it does |
|---|---|
| Credential (required) | The Google Forms credential of the account that owns the form. |
| Form | The form being watched. Choose it with the Drive picker. It is needed to subscribe. |
| Data | Test field. It lets you try the flow with a sample response without waiting for someone to fill in the form. Leave it empty in normal use. |
Turn on the subscription
The flow only receives responses when it is subscribed:
- Save the flow and publish a version. You need a published version of the flow to subscribe. See Versions and publishing.
- In the node’s settings panel, click Subscribe.
- In the panel that opens, click Subscribe. The status changes to Synced.
Only responses submitted after you subscribe come through. If you later change the form, the status shows Out of sync: subscribe again to apply the change. From the same panel you can Unsubscribe when you no longer want to receive responses.
Output
The Data output contains one item per new response, with its ID (responseId), the submission dates, the form title (formTitle) and the answers (answers), each next to the text of its question. If a question allows several options, all the ticked ones come through. If several responses arrive at once, they all come out together.
Connect it to Sheet Cells to store the answers, to an AI agent to analyse them, or to an email component to reply.
Example
An association collects registrations for its annual conference with a form.
- Add Google Forms Webhook, choose the association’s Google Forms credential and the registration form in Form.
- Connect the Data output to Sheet Cells with the
Add Rowoperation to record each attendee. - Also connect the output to Gmail Message to send a confirmation email.
- Publish the flow and click Subscribe.
Good practices
- To be able to reply to the person who fills in the form, include a question asking for their email address.
- Test the flow by submitting a response to the form yourself after subscribing.
Related components
- Forms: create forms and read their answers whenever you need.
- Sheet Cells: store the answers in a spreadsheet.