WhatsApp Integration with Google Form

In this guide, we are going to learn how to Integrate Google Form & WhatsApp using Picky Assist Connector without Using Zapier or any other 3rd Party Automation Platforms.

Pre — Requisite

  1. WhatsApp Channel Activated In your Picky Assist Account

Usecases

Google forms are widely used to collect data from users which can be used for a variety of use cases, few are mentioned below;

  1. Call Back

Once you connected Google Form & Picky Assist Connecter you will able to perform a wide range of actions whenever a Google Form is Submitted, few usecases are listed below;

  1. Send A Thankyou WhatsApp message to the User who fills the form

Getting Started

The first step is to go to Picky Assist and create a Connector URL, just make sure the Connector is in Online Mode to start accepting requests from Google Server whenever a new form submits.

Open Google Form

Then navigate to the Right Side 3 dotted menu and select the “Script Editor” and you will see something like as shown below;

In the Code.js file just copy the below code and paste it

var POST_URL = "https://pickyassist.com/beta/url/a3f1d43f95ecd4ac26b534e4bb2cce6c58dab";
function onSubmit(e) {
var form = FormApp.getActiveForm();
var allResponses = form.getResponses();
var latestResponse = allResponses[allResponses.length - 1];
var response = latestResponse.getItemResponses();
var payload = {};
for (var i = 0; i < response.length; i++) {
var question = response[i].getItem().getTitle();
var answer = response[i].getResponse();
payload[question] = answer;
}

var options = {
"method": "post",
"contentType": "application/json",
"payload": JSON.stringify(payload)
};
UrlFetchApp.fetch(POST_URL, options);
};

Now we need to update the 1st line code, your need to replace the connector url with your own here as shown below;

Make sure you have pasted the Connector URL correctly inside the double quotes

Now Click on “Save” Icon to Save the Project, you can give any relevant name to the Project to identify it later

Setup Trigger in Google Form

The next step is to Configure the Trigger in the Google Form so that every time google triggers the code when a new form is submitted, select the trigger menu from the left side menu bar as shown below;

Then Click on “Add Trigger” then configure it as seen in the below screenshot

After that click on the “Save” button and that’s it, please make sure you have selected the settings exactly the same as shown in the above image.

Testing the Integration

Now open the Google form and fill in the data then submit the form.

Go to your Picky Assist Account then navigate to Connector, select the connector which was created for this Google Form then in the left sidebar you will able to see logs, this means the Google notified the Picky Assist for the new form submission as shown below;

Let’s Map the Form with Picky Assist

Now it’s time to map the Google form structure with Picky Assist so that it can perform various conditions and actions as per your business requirements.

Go to Field Mapping

Click on JSON Code and from the popup click on Map after that, you will able to see the form question and answer sample in the Picky Assist as shown below;

Adding as Contact / Contact Subscriber

If you wish to add the Google form details as a contact in the Picky Assist then you need to start mapping the fields, please note this step is required only if you need to save the contacts into Picky Assist Account

Please note Mobile number with a country code is mandatory for sending WhatsApp messages from the Picky Assist Platform, so always ensure you are collecting the WhatsApp Number along with Country Code.

Sending WhatsApp Message

To send a WhatsApp Message you need to create a Step and inside the Step Create an Action “Send Message” after that you can draft the message as shown below;

You can personalize the message using the Google Form fields or Picky Assist Subscriber fields using the Attributes.

Creating Filters

Filters are useful if you wish to check certain conditions in the form and then perform the actions based on the condition for example if you offer 3 services and when the user selects Service 1 you want to alert a sales rep who handles the Service 1 and move the user into the specific category.

Please note if the filter condition is false then it will skip the action configured in the step and moves into the next step in the order, so if you want to perform separate action for both filter conditions i.e true and false then please create another step with the false condition just below the true condition step.

Advanced Features

Using the Connector Multi Step, Filter & Actions features you can achieve more advanced features as listed below ;

  1. Sending different messages to different Mobile Numbers, like alerting your sales team about new form submission, sending a thankyou message to the user who filled the form.

Picky Assist Connector is capable of integrating WhatsApp into any Online Forms & Softwares.

Important Notes

  1. After the initial setup if you are editing the form then please make sure that you update the latest Form Structure in the JSON Code under field mapping To do this after making the changes in the form, fill and submit a sample entry then go to the Picky Assist and from the right side logs click on the last log received time and from the popup copy the Request Body Code and paste into the JSON Code section then click on Map to update the Structure.

WhatsApp Integration to 3000+ Apps & Chatbots