Webhook
Google Forms + Webhook Integration
Make HTTP GET, POST, PUT, PATCH and DELETE requests on Google Form submission.
How to integrate your Google Form with Webhook?
You can integrate Google Forms with Webhook using Form Director. Form Director enables you to connect Google Forms with Webhook, allowing you to make HTTP GET, POST, PUT, PATCH and DELETE requests based on form responses.
What is Form Director?
Form Director is a Google Workspace add-on that directs data submitted from Google Forms to applications like Google Docs, Forms, Sheets, Contacts, Calendar, Tasks, Email, Trello, Slack, QuickBooks etc.
Installation:
It is available in the Google workspace Marketplace.
Please check installation instructions to install the add-on.
What is Webhook?
A webhook (also called a web callback or HTTP push API) is a way for an app to provide other applications with real-time information.
A webhook delivers data to other applications as it happens, meaning you get data immediately.
Google Forms to Webhook: Use Case(s)
> Make "GET, POST, PUT, PATCH and DELETE" to a webhook url on Google Form Submission.
Google Forms
Make GET, POST, PUT, PATCH, and DELETE requests on Form Submit.
Form Director
Webhook
Create POST request
Choose Webhook from the list of apps.
Name your service.
Choose Post under services.
Configuring Webhook
Provide Webhook URL
Please enter the url in which you need to send post request
Create Headers
Configure the headers that need to be send along with the POST request
Create Query Params
Configure Query Parameters that need to be send along with the Webhook URL
Content Type
Content type can be of three types
JSON
Form
Raw
JSON
Please type in the JSON format in the text box
You can insert Form Field into JSON
Form
Please Specify the Form Content
You have any number of Form content
Raw
If you need data needs to be sent to the application in raw format use Raw.
Authentication
You can do a basic Authentication by providing user name and password
Loading App Fields
Click on Load App fields to load dynamic fields that you have entered in the headers, query params and content
you can map these app fields with Form fields or Templated Fields or Calculated Fields
Mapping
Steps for mapping from field with Webhook app fields
Click on setup mapping
Choose the form field
choose the app field
click save
Finish setting up
Save service
You are all set to make a post request to the webhook URL on your Google Form submission
Submit the Form
Submit the Google Form
See new contact created by Webhook in Active Campaign
Service results
Users can select the result of a webhook service and map it to a service.
Form Director provides REQUEST and RESPONSE of webhook service output to use in other services.
Users can map these webhook service results either using Service Result or Templated mapping.
Service Result type mapping provides the whole object whether it is REQUEST or RESPONSE.
In Template mapping, users can use the dot(.) operator to access values nested in the REQUEST and RESPONSE of a service result.
Example: ${_Result.SERVICE_1675072285786.RESPONSE.result.uuid}
Service Results via Templated mapping
Choose Templated mapping.
Click on the three dots icon(pick up fields from form).
Choose Webhook results either REQUEST or RESPONSE.
Now use the dot(.) operator to access nested values.
REQUEST contains 'url' and options key. options key contains the 'method', 'content-type', 'headers', and 'payload'.
RESPONSE contains 'code', 'result' etc. the 'result' key has the actual response.
Note: check the below image for reference.