Webhook

Google Forms + Webhook Integration

Make HTTP GET, POST, PUT, PATCH and DELETE requests on Google Form submission.

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.