Google Forms + Webhook Integration
Make HTTP GET, POST, PUT, PATCH and DELETE requests on Google Form submission.
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.
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.
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.
Choose Webhook from the list of apps.
Name your service.
Choose Post under services.
Please enter the url in which you need to send post request
Configure the headers that need to be send along with the POST request
Configure Query Parameters that need to be send along with the Webhook URL
Content type can be of three types
JSON
Form
Raw
Please type in the JSON format in the text box
You can insert Form Field into JSON
Please Specify the Form Content
You have any number of Form content
If you need data needs to be sent to the application in raw format use Raw.
You can do a basic Authentication by providing user name and password
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
Steps for mapping from field with Webhook app fields
Click on setup mapping
Choose the form field
choose the app field
click save
Save service
You are all set to make a post request to the webhook URL on your Google Form submission
Submit the Google Form
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}
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.