{"id":3024,"date":"2021-03-20T01:04:42","date_gmt":"2021-03-20T01:04:42","guid":{"rendered":"https:\/\/pickyassist.com\/blog\/?p=3024"},"modified":"2022-08-08T21:06:19","modified_gmt":"2022-08-08T21:06:19","slug":"whatsapp-integration-with-google-form","status":"publish","type":"post","link":"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-form\/","title":{"rendered":"WhatsApp Integration with Google Form"},"content":{"rendered":"\n<p>In this guide, we are going to learn how to Integrate Google Form &amp; WhatsApp using Picky Assist Connector without Using Zapier or any other 3rd Party Automation Platforms.<br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Pre &#8211; Requisite&nbsp;<\/strong><\/h2>\n\n\n\n<ol class=\"wp-block-list\"><li>WhatsApp Channel Activated In your Picky Assist Account<\/li><li>A Picky Assist Plan which has access to Connector Module&nbsp;<\/li><li>Google Form&nbsp;(You should be the owner of the Google Form)<\/li><\/ol>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Usecases<\/strong><\/h2>\n\n\n\n<p>Google forms are widely used to collect data from users which can be used for a variety of use cases, few are mentioned below;<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Call Back&nbsp;<\/li><li>Contact&nbsp;<\/li><li>Product Request&nbsp;<\/li><li>Feedback&nbsp;<\/li><li>Interview Form&nbsp;<\/li><li>E-Commerce Orders<\/li><li>Surveys<\/li><\/ol>\n\n\n\n<p><strong>Once you connected Google Form &amp; Picky Assist Connecter you will able to perform a wide range of actions whenever a Google Form is Submitted, few usecases are listed below;<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Send A Thankyou WhatsApp message to the User who fills the form<\/li><li>Inform your Sales Team via WhatsApp \/ Email about new form submission<\/li><li>Create an Advanced Filter and Send WhatsApp Message based on the Filter Condition.<\/li><li>Add the Google Form entries as PIcky Assist Contact <\/li><li>Add Tags &amp; Categories for user segmentation and later using the Broadcaster feature.<\/li><li>Add User into a Sequence (WhatsApp Drip Campaign) <\/li><li>Assign a Chat to a Team Member \/ Department using Teambox<\/li><\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">Watch Step by Step Video Setup  <\/h2>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"WhatsApp Integration into Google Sheets, Google Forms, Google  Ads &amp; Gmail - Webinar Recording\" width=\"770\" height=\"433\" src=\"https:\/\/www.youtube.com\/embed\/3SLjFrkbFZc?start=957&#038;feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Getting Started&nbsp;<\/strong><\/h2>\n\n\n\n<p>The first step is to go to Picky Assist and create a <strong>Connector URL<\/strong>, just make sure the Connector is in Online Mode to start accepting requests from Google Server whenever a new form submits.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a class=\"gridlove-popup-img\" href=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/Connector-URL-2nd-Step.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"510\" src=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/Connector-URL-2nd-Step-1024x510.png\" alt=\"\" class=\"wp-image-3025\" srcset=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/Connector-URL-2nd-Step-1024x510.png 1024w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/Connector-URL-2nd-Step-300x149.png 300w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/Connector-URL-2nd-Step-768x383.png 768w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/Connector-URL-2nd-Step-370x184.png 370w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/Connector-URL-2nd-Step-270x134.png 270w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/Connector-URL-2nd-Step-570x284.png 570w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/Connector-URL-2nd-Step-740x369.png 740w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/Connector-URL-2nd-Step.png 1331w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<div style=\"height:29px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><strong>Open Google Form&nbsp;<\/strong><\/p>\n\n\n\n<p>Then navigate to the Right Side 3 dotted menu and select the <strong>\u201cScript Editor\u201d <\/strong>and you will see something like as shown below;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a class=\"gridlove-popup-img\" href=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-form-opening-script.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"554\" src=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-form-opening-script-1024x554.png\" alt=\"\" class=\"wp-image-3026\" srcset=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-form-opening-script-1024x554.png 1024w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-form-opening-script-300x162.png 300w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-form-opening-script-768x415.png 768w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-form-opening-script-370x200.png 370w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-form-opening-script-270x146.png 270w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-form-opening-script-570x308.png 570w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-form-opening-script-740x400.png 740w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-form-opening-script.png 1331w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a class=\"gridlove-popup-img\" href=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/script-editor-intro.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"510\" src=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/script-editor-intro-1024x510.png\" alt=\"\" class=\"wp-image-3032\" srcset=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/script-editor-intro-1024x510.png 1024w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/script-editor-intro-300x149.png 300w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/script-editor-intro-768x383.png 768w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/script-editor-intro-370x184.png 370w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/script-editor-intro-270x134.png 270w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/script-editor-intro-570x284.png 570w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/script-editor-intro-740x369.png 740w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/script-editor-intro.png 1331w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p><strong>In the Code.js file just copy the below code and paste it<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>var POST_URL = \"https:\/\/pickyassist.com\/beta\/url\/a3f1d43f95ecd4ac26b534e4bb2cce6c58dab\";\nfunction onSubmit(e) {\n    var form = FormApp.getActiveForm();\n    var allResponses = form.getResponses();\n    var latestResponse = allResponses&#91;allResponses.length - 1];\n    var response = latestResponse.getItemResponses();\n    var payload = {};\n    for (var i = 0; i &lt; response.length; i++) {\n        var question = response&#91;i].getItem().getTitle();\n        var answer = response&#91;i].getResponse();\n        payload&#91;question] = answer;\n    }\n  \n    var options = {\n        \"method\": \"post\",\n        \"contentType\": \"application\/json\",\n        \"payload\": JSON.stringify(payload)\n    };\nUrlFetchApp.fetch(POST_URL, options);\n};<\/code><\/pre>\n\n\n\n<p><strong>Now we need to update the 1st line code, your need to replace the connector url with your own here as shown below;<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a class=\"gridlove-popup-img\" href=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/code-editor-updating.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"554\" src=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/code-editor-updating-1024x554.png\" alt=\"\" class=\"wp-image-3027\" srcset=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/code-editor-updating-1024x554.png 1024w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/code-editor-updating-300x162.png 300w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/code-editor-updating-768x415.png 768w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/code-editor-updating-370x200.png 370w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/code-editor-updating-270x146.png 270w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/code-editor-updating-570x308.png 570w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/code-editor-updating-740x400.png 740w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/code-editor-updating.png 1331w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p class=\"has-text-color\" style=\"color:#f70b49\">Make sure you have pasted the Connector URL correctly inside the double quotes&nbsp;<\/p>\n\n\n\n<p>Now Click on <strong>\u201cSave\u201d <\/strong>Icon to Save the Project, you can give any relevant name to the Project to identify it later&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Setup Trigger in Google Form<\/strong><\/h2>\n\n\n\n<p>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,&nbsp; select the trigger menu from the left side menu bar as shown below;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a class=\"gridlove-popup-img\" href=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/script-adding-triger.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"554\" src=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/script-adding-triger-1024x554.png\" alt=\"\" class=\"wp-image-3028\" srcset=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/script-adding-triger-1024x554.png 1024w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/script-adding-triger-300x162.png 300w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/script-adding-triger-768x415.png 768w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/script-adding-triger-370x200.png 370w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/script-adding-triger-270x146.png 270w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/script-adding-triger-570x308.png 570w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/script-adding-triger-740x400.png 740w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/script-adding-triger.png 1331w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p><strong>Then Click on \u201cAdd Trigger\u201d then configure it as seen in the below screenshot<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a class=\"gridlove-popup-img\" href=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/saving-trigger.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"554\" src=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/saving-trigger-1024x554.png\" alt=\"\" class=\"wp-image-3029\" srcset=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/saving-trigger-1024x554.png 1024w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/saving-trigger-300x162.png 300w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/saving-trigger-768x415.png 768w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/saving-trigger-370x200.png 370w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/saving-trigger-270x146.png 270w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/saving-trigger-570x308.png 570w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/saving-trigger-740x400.png 740w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/saving-trigger.png 1331w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p><strong>After that click on the \u201cSave\u201d button and that\u2019s it, please make sure you have selected the settings exactly the same as shown in the above image.<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Testing the Integration&nbsp;<\/strong><\/h2>\n\n\n\n<p>Now open the Google form and fill in the data then submit the form.<\/p>\n\n\n\n<p>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;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a class=\"gridlove-popup-img\" href=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/json-mapping.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"510\" src=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/json-mapping-1024x510.png\" alt=\"\" class=\"wp-image-3030\" srcset=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/json-mapping-1024x510.png 1024w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/json-mapping-300x149.png 300w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/json-mapping-768x383.png 768w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/json-mapping-370x184.png 370w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/json-mapping-270x134.png 270w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/json-mapping-570x284.png 570w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/json-mapping-740x369.png 740w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/json-mapping.png 1331w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Let\u2019s Map the Form with Picky Assist<\/strong><\/h3>\n\n\n\n<p>Now it\u2019s time to map the Google form structure with Picky Assist so that it can perform various conditions and actions as per your business requirements.<\/p>\n\n\n\n<p><strong>Go to Field Mapping&nbsp;<\/strong><\/p>\n\n\n\n<p>Click on <strong>JSON Code <\/strong>and from the popup click on <strong>Map<\/strong> after that, you will able to see the form question and answer sample in the Picky Assist&nbsp;as shown below;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a class=\"gridlove-popup-img\" href=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/sample-form-mapping.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"510\" src=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/sample-form-mapping-1024x510.png\" alt=\"\" class=\"wp-image-3031\" srcset=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/sample-form-mapping-1024x510.png 1024w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/sample-form-mapping-300x149.png 300w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/sample-form-mapping-768x383.png 768w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/sample-form-mapping-370x184.png 370w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/sample-form-mapping-270x134.png 270w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/sample-form-mapping-570x284.png 570w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/sample-form-mapping-740x369.png 740w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/sample-form-mapping.png 1331w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Adding as Contact&nbsp;\/ Contact Subscriber <\/strong><\/h2>\n\n\n\n<p>If you wish to add the Google form details as a contact in the Picky Assist then you need to start mapping the fields, <strong>please note this step is required only if you need to save the contacts into Picky Assist Account<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a class=\"gridlove-popup-img\" href=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/field-mapping.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"471\" src=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/field-mapping-1024x471.png\" alt=\"\" class=\"wp-image-3035\" srcset=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/field-mapping-1024x471.png 1024w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/field-mapping-300x138.png 300w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/field-mapping-768x354.png 768w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/field-mapping-370x170.png 370w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/field-mapping-270x124.png 270w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/field-mapping-570x262.png 570w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/field-mapping-740x341.png 740w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/field-mapping.png 1440w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p class=\"has-text-color\" style=\"color:#3b0aff\">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.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Sending WhatsApp Message<\/strong><\/h2>\n\n\n\n<p>To send a WhatsApp Message you need to create a Step and inside the Step Create an Action <strong>\u201cSend Message\u201d<\/strong> after that you can draft the message as shown below;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a class=\"gridlove-popup-img\" href=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/sending-message-connector.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"512\" src=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/sending-message-connector-1024x512.png\" alt=\"\" class=\"wp-image-3034\" srcset=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/sending-message-connector-1024x512.png 1024w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/sending-message-connector-300x150.png 300w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/sending-message-connector-768x384.png 768w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/sending-message-connector-370x185.png 370w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/sending-message-connector-270x135.png 270w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/sending-message-connector-570x285.png 570w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/sending-message-connector-740x370.png 740w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/sending-message-connector.png 1440w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p><strong>You can personalize the message using the Google Form fields or Picky Assist Subscriber fields using the Attributes.<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Creating Filters<\/h2>\n\n\n\n<p>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.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a class=\"gridlove-popup-img\" href=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/condition.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"471\" src=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/condition-1024x471.png\" alt=\"\" class=\"wp-image-3036\" srcset=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/condition-1024x471.png 1024w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/condition-300x138.png 300w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/condition-768x354.png 768w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/condition-370x170.png 370w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/condition-270x124.png 270w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/condition-570x262.png 570w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/condition-740x341.png 740w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/condition.png 1440w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p class=\"has-gridlove-bg-color has-gridlove-meta-background-color has-text-color has-background\">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.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Advanced Features&nbsp;<\/strong><\/h2>\n\n\n\n<p>Using the Connector Multi Step, Filter &amp; Actions features you can achieve more advanced features as listed below&nbsp;;<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>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.<br><\/li><li>Adding User into a Sequence (WhatsApp Drip Campaign) to send a series of messages which are related to the customer enquiry, using the filters it\u2019s possible to enroll users into specific drip campaigns automatically based on the Google form value.<br><\/li><li>Segmenting users automatically into Category &amp; Tags that help to identify the user later or send personalized mass messages using Broadcaster&nbsp;<br><\/li><li>Assign to an agent for instant engagements through WhatsApp using Teambox, using the filter it\u2019s possible to assign a chat to the right department or agent as per the user form values.&nbsp;<\/li><\/ol>\n\n\n\n<div style=\"height:46px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-text-align-center has-gridlove-bg-color has-gridlove-meta-background-color has-text-color has-background has-large-font-size\">Picky Assist Connector is capable of integrating WhatsApp into any Online Forms &amp; Softwares.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Important Notes<\/strong><\/h2>\n\n\n\n<ol class=\"wp-block-list\"><li>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&nbsp; 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&nbsp;and paste into the JSON Code section then click on Map to update the Structure.<br><\/li><li>Always make sure you are adjusting the filter conditions and attribute values if the form field names are getting an update.<br><\/li><li>If your form allows users to upload files then the uploaded file will not be available with Picky Assist due to Google Drive restrictions, the uploaded file will be visible only to the form owner.&nbsp;<br><\/li><li>Always ask users to fill in the mobile number along with the country code to avoid failed messages.&nbsp;<\/li><\/ol>\n","protected":false},"excerpt":{"rendered":"<p>In this guide, we are going to learn how to Integrate Google Form &amp; WhatsApp using Picky Assist Connector without Using Zapier or any other 3rd Party Automation Platforms. Pre &#8211; Requisite&nbsp; WhatsApp Channel Activated In your Picky Assist Account A Picky Assist Plan which has access to Connector Module&nbsp; Google Form&nbsp;(You should be the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3041,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[131],"tags":[133,132,134],"class_list":["post-3024","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-integrations","tag-google-form","tag-google-form-whatsapp-integration","tag-whatsapp"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>WhatsApp Integration with Google Form - Picky Assist Official Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-form\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"WhatsApp Integration with Google Form - Picky Assist Official Blog\" \/>\n<meta property=\"og:description\" content=\"In this guide, we are going to learn how to Integrate Google Form &amp; WhatsApp using Picky Assist Connector without Using Zapier or any other 3rd Party Automation Platforms. Pre &#8211; Requisite&nbsp; WhatsApp Channel Activated In your Picky Assist Account A Picky Assist Plan which has access to Connector Module&nbsp; Google Form&nbsp;(You should be the [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-form\/\" \/>\n<meta property=\"og:site_name\" content=\"Picky Assist Official Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-03-20T01:04:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-08T21:06:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/Googleforms.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"327\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Danny\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Danny\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-form\/\",\"url\":\"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-form\/\",\"name\":\"WhatsApp Integration with Google Form - Picky Assist Official Blog\",\"isPartOf\":{\"@id\":\"https:\/\/pickyassist.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-form\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-form\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/Googleforms.jpg\",\"datePublished\":\"2021-03-20T01:04:42+00:00\",\"dateModified\":\"2022-08-08T21:06:19+00:00\",\"author\":{\"@id\":\"https:\/\/pickyassist.com\/blog\/#\/schema\/person\/f7e9e7ef306abb4d9a1b00210e2c86e1\"},\"breadcrumb\":{\"@id\":\"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-form\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-form\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-form\/#primaryimage\",\"url\":\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/Googleforms.jpg\",\"contentUrl\":\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/Googleforms.jpg\",\"width\":600,\"height\":327,\"caption\":\"Google Form to WhatsApp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-form\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/pickyassist.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"WhatsApp Integration with Google Form\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/pickyassist.com\/blog\/#website\",\"url\":\"https:\/\/pickyassist.com\/blog\/\",\"name\":\"Picky Assist Official Blog\",\"description\":\"Picky Assist Official Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/pickyassist.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/pickyassist.com\/blog\/#\/schema\/person\/f7e9e7ef306abb4d9a1b00210e2c86e1\",\"name\":\"Danny\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/pickyassist.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/83c616c1e62e9b2f2177e7b029b7270bea92cfe313402e298ee4c0fa0e05a951?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/83c616c1e62e9b2f2177e7b029b7270bea92cfe313402e298ee4c0fa0e05a951?s=96&d=mm&r=g\",\"caption\":\"Danny\"},\"url\":\"https:\/\/pickyassist.com\/blog\/author\/adminreji_blog\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"WhatsApp Integration with Google Form - Picky Assist Official Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-form\/","og_locale":"en_US","og_type":"article","og_title":"WhatsApp Integration with Google Form - Picky Assist Official Blog","og_description":"In this guide, we are going to learn how to Integrate Google Form &amp; WhatsApp using Picky Assist Connector without Using Zapier or any other 3rd Party Automation Platforms. Pre &#8211; Requisite&nbsp; WhatsApp Channel Activated In your Picky Assist Account A Picky Assist Plan which has access to Connector Module&nbsp; Google Form&nbsp;(You should be the [&hellip;]","og_url":"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-form\/","og_site_name":"Picky Assist Official Blog","article_published_time":"2021-03-20T01:04:42+00:00","article_modified_time":"2022-08-08T21:06:19+00:00","og_image":[{"width":600,"height":327,"url":"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/Googleforms.jpg","type":"image\/jpeg"}],"author":"Danny","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Danny","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-form\/","url":"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-form\/","name":"WhatsApp Integration with Google Form - Picky Assist Official Blog","isPartOf":{"@id":"https:\/\/pickyassist.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-form\/#primaryimage"},"image":{"@id":"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-form\/#primaryimage"},"thumbnailUrl":"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/Googleforms.jpg","datePublished":"2021-03-20T01:04:42+00:00","dateModified":"2022-08-08T21:06:19+00:00","author":{"@id":"https:\/\/pickyassist.com\/blog\/#\/schema\/person\/f7e9e7ef306abb4d9a1b00210e2c86e1"},"breadcrumb":{"@id":"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-form\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-form\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-form\/#primaryimage","url":"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/Googleforms.jpg","contentUrl":"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/Googleforms.jpg","width":600,"height":327,"caption":"Google Form to WhatsApp"},{"@type":"BreadcrumbList","@id":"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-form\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pickyassist.com\/blog\/"},{"@type":"ListItem","position":2,"name":"WhatsApp Integration with Google Form"}]},{"@type":"WebSite","@id":"https:\/\/pickyassist.com\/blog\/#website","url":"https:\/\/pickyassist.com\/blog\/","name":"Picky Assist Official Blog","description":"Picky Assist Official Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pickyassist.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/pickyassist.com\/blog\/#\/schema\/person\/f7e9e7ef306abb4d9a1b00210e2c86e1","name":"Danny","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pickyassist.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/83c616c1e62e9b2f2177e7b029b7270bea92cfe313402e298ee4c0fa0e05a951?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/83c616c1e62e9b2f2177e7b029b7270bea92cfe313402e298ee4c0fa0e05a951?s=96&d=mm&r=g","caption":"Danny"},"url":"https:\/\/pickyassist.com\/blog\/author\/adminreji_blog\/"}]}},"_links":{"self":[{"href":"https:\/\/pickyassist.com\/blog\/wp-json\/wp\/v2\/posts\/3024","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pickyassist.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pickyassist.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pickyassist.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pickyassist.com\/blog\/wp-json\/wp\/v2\/comments?post=3024"}],"version-history":[{"count":7,"href":"https:\/\/pickyassist.com\/blog\/wp-json\/wp\/v2\/posts\/3024\/revisions"}],"predecessor-version":[{"id":3951,"href":"https:\/\/pickyassist.com\/blog\/wp-json\/wp\/v2\/posts\/3024\/revisions\/3951"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pickyassist.com\/blog\/wp-json\/wp\/v2\/media\/3041"}],"wp:attachment":[{"href":"https:\/\/pickyassist.com\/blog\/wp-json\/wp\/v2\/media?parent=3024"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pickyassist.com\/blog\/wp-json\/wp\/v2\/categories?post=3024"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pickyassist.com\/blog\/wp-json\/wp\/v2\/tags?post=3024"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}