Google Form Response Capture To n8n Webhook

Steps to add google form response capture with n8n

Step 1: Setup the n8n webhook

Step 2: Setup the App Script

Create the google form and click on "App Script" from 3 dots on top right corner

Google Form Response Capture Script

Paste the snippet in code block

Change the POST_URL to your n8n webhook

Step 3. Deploy the the script - Web App

After deployed, click on "Authorize .." and select you gmail account to authorize with, if a warning is shown proceed unsafe and complete the authorization. After its completed click "done".

Step 4. Now we need to configure the trigger.

1. Click on "Triggers" from the left sidebar
2. Click on "Add new Trigger" button
3. From the form, at the bottom for select event type field, change "On Open" to "On Submit"

Everything is now configured, now the form submissions will be captured by the n8n webhook