# Google Forms – Pabbly - Gallabox

If you use Google Sheets to manage your data and want to make it work smoothly with Gallabox through Pabbly Connect, you're in for a real treat. 

This connection simplifies the process of gathering data from your forms and sending it to Gallabox, making your work easier and your communication more effective. It's all about streamlining your tasks so you can engage with your audience. 

Using step-by-step approach, we'll show you how you can achieve this. 

### Workflow creation in Pabbly Connect

To create a new workflow, click the ‘**Create Workflow**’ button in Pabbly Connect. Name your workflow and click on '**Create**'. 

<figure><img src="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2FLrtxPiLe0T3TijYHCrJe%2FWorkflow%20creation%20in%20Pabbly%20Connect.gif?alt=media&#x26;token=b80544c6-124b-4aa6-aa50-34ab259131d6" alt=""><figcaption></figcaption></figure>

### Choose Your First Application : Trigger (Google Forms)

In the App, search for **Google Forms** and select. For the Trigger event select New response Received. A Webhook URL will be generated and you have to follow the steps as listed below it.&#x20;

<figure><img src="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2FhXLp1Rvc2BwLSTaaqYs1%2FChoose%20Your%20First%20Application%20%20Trigger%20-%20Google%20Forms.gif?alt=media&#x26;token=d7488310-225a-44e8-a2f3-998e5409ec59" alt=""><figcaption></figcaption></figure>

#### Configuring Google Form Trigger

Go to the Google Form on which you want to take submission and make the last question as required for the trigger.

<figure><img src="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2FFSw1saR4x8xkSKZIEsQ8%2FConfiguring%20Google%20Form%20Trigger.gif?alt=media&#x26;token=1f337ae2-0297-476e-b4e3-3f1d02ebaa08" alt=""><figcaption></figcaption></figure>

#### Link Google Form Responses to Sheet

Navigate to the "Response Tab" and click on the "Create Spreadsheet" icon to generate a new sheet for storing form responses.

<figure><img src="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2FdDHgL5UONvD3w2Bbzb3X%2FLinking%20Google%20Form%20Responses%20to%20Sheet.gif?alt=media&#x26;token=108b141c-1447-499f-818f-cc9e7cf99047" alt=""><figcaption></figcaption></figure>

#### Installing Pabbly Connect Webhooks for Google Forms

Install the "**Pabbly Connect Webhooks**" add-on from the "**G-Suite App Marketplace.**&#x20;

<figure><img src="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2Fcx1BoRiWwI6cTJT9SlDZ%2FInstalling%20Pabbly%20Connect%20Webhooks%20for%20Google%20Forms.gif?alt=media&#x26;token=b17326d9-0c92-450c-9f1d-47bb6d953401" alt=""><figcaption></figcaption></figure>

#### Setting Up Pabbly Connect Webhooks

Under the "**Pabbly Connect Webhooks**" dropdown under "**Extensions**," select "**Initial setup**." Copy the provided webhook URL and paste it into the "**Webhook URL**" field, and specify the trigger column name (the last required column in the Google Form).

<figure><img src="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2FzsrL29z3NaLZG44xDnxn%2FSetting%20Up%20Pabbly%20Connect%20Webhooks.gif?alt=media&#x26;token=a164b1ad-3583-41a4-9a22-99aa1f5ba83c" alt=""><figcaption></figcaption></figure>

#### Webhook Configuration for Google Forms

Now move to the "**Pabbly Connect Webhook**" from the Google sheet menu under the "**Extensions**" tab and choose the event when it should send data.

<figure><img src="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2FrkzpXKDwjv21iV2cp0Jg%2FWebhook%20Configuration%20for%20Google%20Forms.gif?alt=media&#x26;token=36c214ed-af58-4962-80ed-f7608364bbca" alt=""><figcaption></figcaption></figure>

#### Verifying Webhook Setup for Google Forms

Click on "**Capture Webhook Response**" and submit a test form to ensure the new response is captured correctly.

<figure><img src="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2FtsYByyQNRclISW3wFBGl%2FCapture%20Webhook%20Response%20Google%20Sheet.gif?alt=media&#x26;token=8081d4c7-0103-4e6e-bcd5-a8ed60169166" alt=""><figcaption></figcaption></figure>

If you are facing an errors related to google sheet [click here](https://www.pabbly.com/common-problems-with-google-sheets-integration-in-pabbly-connect/).

### Choose the Next Application : Action (Gallabox)

Our objective is to send WhatsApp messages after every response received on the Google Form. Hence, we will be using ‘**Gallabox**’ as the Action App, select ‘***Send WhatsApp Template Message***’ as the Action Event, and click on ‘**Connect’**.

<figure><img src="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2FDHwj3CLZiGbjdTCmdgkv%2FChoose%20the%20Next%20Application%20%20Action%20(Gallabox).gif?alt=media&#x26;token=c5830483-1ed5-4d5d-aaf3-933b1d69103e" alt=""><figcaption></figcaption></figure>

#### Connecting Gallabox to Pabbly Account

To connect your Gallabox account with your Pabbly account click on Connect and a pop-up will be there to ask you for your Gallabox Account Id and API Key & Secret.

<figure><img src="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2FHPtRV5y4CJVhaJDaqHRl%2FConnecting%20Gallabox%20to%20Pabbly%20Account.gif?alt=media&#x26;token=2064c637-577a-40f7-b17d-243185792a99" alt=""><figcaption></figcaption></figure>

#### Obtaining Gallabox Account ID, API Key & Secret

To get your Account Id, API Key & Secret go to the below links to know in detail.&#x20;

{% content-ref url="broken-reference" %}
[Broken link](https://docs.gallabox.com/~/changes/A8xmww5XU9i8x7QbfPLe/integration/other-integrations/pabbly/broken-reference)
{% endcontent-ref %}

<figure><img src="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2FxcU24h5G6VKyjbyF4DYG%2FObtaining%20Gallabox%20Account%20ID%2C%20API%20Key%20%26%20Secret.gif?alt=media&#x26;token=5e3925d0-b12c-4dca-8275-f48a58beb5ea" alt=""><figcaption></figcaption></figure>

#### Selecting Channel ID, Template, and Bot ID

* Select the Template you would like to share with the submitters.&#x20;

<figure><img src="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2FPNScOyU0hE8J2Wq8aE3B%2FTemplate%20in%20Pabbly.gif?alt=media&#x26;token=9aec8ca6-1081-4f11-9b3f-d3458a90e6d0" alt=""><figcaption></figcaption></figure>

* To get the Channel Id, click on Settings, then WhatsApp Channel, and copy paste the Channel Id.&#x20;

<figure><img src="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2FhUjrxiVRPMLfSOaNZXFP%2FChannel%20Id%20in%20Pabbly.gif?alt=media&#x26;token=f0da7b63-ecc3-4280-b0d4-34b36e82536c" alt=""><figcaption></figcaption></figure>

* To capture the Name, Phone, and Contact Name of the submitter who submitted the feedback form, insert the data from the Google form itself.&#x20;

<figure><img src="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2Fu9UBrEXV19WfcT1vbfTG%2FName%2C%20Phone%2C%20and%20Contact%20Name%20sample.gif?alt=media&#x26;token=f7454544-9a39-4f0c-8707-2cdb62873d44" alt=""><figcaption></figcaption></figure>

Click on '**Save and Send Test message**' to verify the workflow. Click on Save to save the data.

<figure><img src="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2F27GPYU6h63l56HLO5ULz%2FSave%20and%20send%20test%20message.gif?alt=media&#x26;token=69e89f24-07a9-489a-b79b-415c508214fe" alt=""><figcaption></figcaption></figure>

You are now all set for efficient, automated communication.