Sending a Webhook for each Google Forms Submission
If you have ever tried to use a Google Form as your medium of lead generation, you know that it is possible to save these submissions to a Google Sheet automatically.
That’s all fine and dandy however, for business automation professionals like myself who need to integrate this data with 3rd party applications such as CRM, Mailing lists etc.. The only way this data could be pulled out of Google Sheets is to use a workflow/business automation platform such as Integromat or Zapier.
The problem is that it is not possible to get a form submission in real time, you would need to poll Google Sheets and check for new entries. This process costs operations/tasks and wastes the “data plan” of whichever automation platform you are using.
The Solution is quite simple (that is if you have basic JavaScript skills) and involves a Google Apps script and setting up a trigger, here are the required steps:
- Using an existing or new Google form, click on the 3 vertical dots in the top right corner and select “Script Editor”.
2. Copy this script:
3. Replace this script with your copied script from the previous step:
4. Notice that at line #1 of the script there is a variable called POST_URL, we need to replace the placeholder text “enter your webhook URL” with a real webhook url you can get off Integromat, Zapier or even your custom endpoint.
5. In order for the form to actually submit the data we need to setup a trigger. To do that we need to click on edit and select “Current Project’s Triggers”
6. Create a new trigger by clicking on the Add Trigger button on the bottom right hand side:
Once you click on “Add Trigger” this window shows up:
The only thing you need to do is make sure “Select event type” is set as “On form submit”. Click save and approve.
6. Once thats done once you submit a form you will get the data in nicely formatted JSON string:
In my example I used Requestcatcher as an endpoint.
That’s all folks, your Google Forms is set up to submit data to any webhook URL immediately after a form submission has been made.
