{"id":3044,"date":"2021-03-21T00:30:23","date_gmt":"2021-03-21T00:30:23","guid":{"rendered":"https:\/\/pickyassist.com\/blog\/?p=3044"},"modified":"2026-03-18T07:51:10","modified_gmt":"2026-03-18T07:51:10","slug":"whatsapp-integration-with-google-sheets","status":"publish","type":"post","link":"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-sheets\/","title":{"rendered":"WhatsApp Integration with Google Sheets"},"content":{"rendered":"\n<p>This article demonstrates how to integrate Google Sheets and WhatsApp using the Picky Assist Connector without third-party automation platforms. Integrate Google Sheets and WhatsApp to automatically send messages, manage contacts, and trigger workflows directly from spreadsheet updates.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Pre &#8211; Requisite\u00a0<\/strong>to integrate Google Sheets and WhatsApp<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>WhatsApp Channel Activated In your Picky Assist Account<\/li>\n\n\n\n<li>A Picky Assist Plan which has access to Connector Feature&nbsp;<\/li>\n\n\n\n<li>Google Sheet (You should be the owner of the Sheet)<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">Google Sheet<\/h2>\n\n\n\n<p>In this guide let&#8217;s discuss how to send WhatsApp messages directly from Google Sheets using Picky Assist Connector.<\/p>\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=512&#038;feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">What You Can Do?<\/h2>\n\n\n\n<p>You can trigger Picky Assist actions whenever a specified Google Sheets column is edited or a new row is added. See this example!<\/p>\n\n\n\n<p>A Small Restaurant accept orders through a Simple Google Form and use the Google Sheet to manage the order. The Google Sheet is shared with the employees for easy collaboration.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a class=\"gridlove-popup-img\" href=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheets.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"436\" height=\"1024\" src=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheets-436x1024.jpg\" alt=\"\" class=\"wp-image-3045\" srcset=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheets-436x1024.jpg 436w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheets-128x300.jpg 128w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheets-768x1806.jpg 768w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheets-370x870.jpg 370w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheets-270x635.jpg 270w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheets-570x1340.jpg 570w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheets-740x1740.jpg 740w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheets.jpg 854w\" sizes=\"auto, (max-width: 436px) 100vw, 436px\" \/><\/a><\/figure><\/div>\n\n\n<p>Now the Restaurant want to do the following actions&nbsp;whenever their employees make changes to the Google Sheet. It is  always specified Column Status as shown in the below image:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><mark class=\"annotation-text annotation-text-yoast\" id=\"annotation-text-2034471f-67bf-4ec4-886d-dbdd4c0e1b64\"><strong>Order Accepted -&gt; <\/strong>Send A WhatsApp Message to the Rider &amp; Customer<\/mark><\/li>\n\n\n\n<li><strong>Order is Ready -&gt; <\/strong>Send A WhatsApp Message to the Customer&nbsp;and Inform the Rider<\/li>\n\n\n\n<li><strong>Order Dispatched -&gt;<\/strong> Send A WhatsApp Message to the Customer<\/li>\n\n\n\n<li><strong>Order Delivered -&gt;<\/strong> Send A WhatsApp Message to the Customer&nbsp;<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">How it Works?<\/h2>\n\n\n\n<p>Now let\u2019s consider the above usecase and the order status is saved in Column F as shown below;<br><\/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-sheet-scaled.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"433\" src=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-1024x433.jpg\" alt=\"\" class=\"wp-image-3046\" srcset=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-1024x433.jpg 1024w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-300x127.jpg 300w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-768x325.jpg 768w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-1536x650.jpg 1536w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-2048x867.jpg 2048w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-370x157.jpg 370w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-270x114.jpg 270w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-570x241.jpg 570w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-740x313.jpg 740w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>Now we want to perform an action of sending a message whenever <strong>Column F<\/strong> is edited. So, whenever <strong>Column F is edited<\/strong> Google Sheet will send a request to the Picky Assist. This is along with complete data in the specific row which got edited.&nbsp;<\/p>\n\n\n\n<p>Then using the connector you will able to map these row data and create different steps to send different messages. So in this case we need to send 5 messages based on the order update status in Column F. So in order to do this we have to create 5 steps in the connector along with the Filter &amp; Actions.&nbsp;<\/p>\n\n\n\n<div style=\"height:61px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\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 Connector URL. Make sure the Connector is in Online Mode to start accepting requests from Google Sheet whenever the specified column is edited.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"blob:https:\/\/pickyassist.com\/224ad1e8-231f-48ad-8005-5c64e1d4bd19\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"510\" src=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/Connector-URL-2nd-Step-1-1024x510.png\" alt=\"\" class=\"wp-image-3048\" srcset=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/Connector-URL-2nd-Step-1-1024x510.png 1024w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/Connector-URL-2nd-Step-1-300x149.png 300w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/Connector-URL-2nd-Step-1-768x383.png 768w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/Connector-URL-2nd-Step-1-370x184.png 370w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/Connector-URL-2nd-Step-1-270x134.png 270w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/Connector-URL-2nd-Step-1-570x284.png 570w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/Connector-URL-2nd-Step-1-740x369.png 740w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/Connector-URL-2nd-Step-1.png 1331w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Open Google Sheet&nbsp;<\/strong><\/p>\n\n\n\n<p><strong>Then navigate to the Tools -&gt; Script Editor<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"921\" src=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/open-script-editor-1024x921.jpg\" alt=\"\" class=\"wp-image-3049\" srcset=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/open-script-editor-1024x921.jpg 1024w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/open-script-editor-300x270.jpg 300w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/open-script-editor-768x691.jpg 768w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/open-script-editor-370x333.jpg 370w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/open-script-editor-270x243.jpg 270w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/open-script-editor-335x300.jpg 335w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/open-script-editor-570x513.jpg 570w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/open-script-editor-740x666.jpg 740w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/open-script-editor.jpg 1116w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/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 TargetColumn = 'F';\nfunction columnToLetter(column) {\n  var temp, letter = '';\n  while (column &gt; 0) {\n    temp = (column - 1) % 26;\n    letter = String.fromCharCode(temp + 65) + letter;\n    column = (column - temp - 1) \/ 26;\n  }\n  return letter;\n}\nfunction onEdit(e){\n\n  var range = e.range; \n\n  var StartRow  = range.getLastRow() - range.getNumRows() + 1;\n  var LastRow = range.getLastRow();\n\n  if( columnToLetter(range.getLastColumn()) != TargetColumn)\n    return false;\nvar ss = SpreadsheetApp.getActiveSpreadsheet();\nvar sheet = ss.getSheetByName(range.getSheet().getName());\n\n\nfor ( var crow = StartRow; crow&lt;= LastRow; crow++){\n\n  var formData = {\n      'CELL_UPDATED': range.getA1Notation(),\n      'NEW_VALUE': range.getValue(),\n      'SHEET':range.getSheet().getName(),\n  };\n\n  var range1 = sheet.getRange(crow, 1, 1, sheet.getLastColumn());\n  var values = range1.getDisplayValues(); \/\/getValues();\n\n  for (var i = 0; i &lt; sheet.getLastColumn(); i++){\n    formData&#91;columnToLetter(i+1)] = values&#91;0]&#91;i];\n\n  }\n\n  var options = {\n      'method' : 'post',\n      'payload' : formData\n    };\n\n  UrlFetchApp.fetch('https:\/\/pickyassist.com\/beta\/url\/470b5a2689e86f575f9bbcf4060f6b3c7913035', options);\n  delete formData;\n}\n}\n<\/code><\/pre>\n\n\n\n<p><strong>Now we need to update the 1st line code &amp; 45th line of the code as explained below&nbsp;<\/strong><\/p>\n\n\n\n<p class=\"has-gridlove-bg-color has-gridlove-meta-background-color has-text-color has-background\">The 1st line i.e <strong>var TargetColumn = &#8216;F&#8217;;<\/strong> is where we map the column, any change in the specified column data will trigger the details to the Picky Assist Connector along with the data in the specified row which got updated, you can specify any column for this as per your requirements<\/p>\n\n\n\n<p>In our example we want to send different messages whenever the value in Column F gets edited, so specify as \u201cF\u201d exactly as shown in the image 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-sheet-editor-column-name.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"512\" src=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-editor-column-name-1024x512.jpg\" alt=\"WhatsApp Integration with Google Sheets\" class=\"wp-image-3050\" srcset=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-editor-column-name-1024x512.jpg 1024w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-editor-column-name-300x150.jpg 300w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-editor-column-name-768x384.jpg 768w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-editor-column-name-370x185.jpg 370w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-editor-column-name-270x135.jpg 270w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-editor-column-name-570x285.jpg 570w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-editor-column-name-740x370.jpg 740w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-editor-column-name.jpg 1440w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p><strong>Now we need to update the Connector URL<\/strong>. <strong>Just go to line number 45 and paste the Connector URL 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\/updating-connector-url-google-sheets.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"471\" src=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/updating-connector-url-google-sheets-1024x471.jpg\" alt=\"WhatsApp Integration with Google Sheets2\" class=\"wp-image-3051\" srcset=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/updating-connector-url-google-sheets-1024x471.jpg 1024w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/updating-connector-url-google-sheets-300x138.jpg 300w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/updating-connector-url-google-sheets-768x354.jpg 768w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/updating-connector-url-google-sheets-370x170.jpg 370w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/updating-connector-url-google-sheets-270x124.jpg 270w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/updating-connector-url-google-sheets-570x262.jpg 570w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/updating-connector-url-google-sheets-740x341.jpg 740w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/updating-connector-url-google-sheets.jpg 1440w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p class=\"has-text-color\" style=\"color:#ed080c\">Make sure you have pasted it correctly inside the double quotes&nbsp;<\/p>\n\n\n\n<p>Now Click on the <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<div style=\"height:76px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\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 Sheet so that every time google will trigger the code when column get edited.&nbsp; To do this select the trigger menu from the left side menu bar and then click on<strong> \u201cAdd Trigger\u201d <\/strong>then configure it as seen in the below screenshot;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"512\" src=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-triggers-1024x512.jpg\" alt=\"WhatsApp Integration with Google Sheets3\" class=\"wp-image-3053\" srcset=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-triggers-1024x512.jpg 1024w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-triggers-300x150.jpg 300w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-triggers-768x384.jpg 768w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-triggers-370x185.jpg 370w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-triggers-270x135.jpg 270w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-triggers-570x285.jpg 570w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-triggers-740x370.jpg 740w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-triggers.jpg 1440w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>After that click on \u201cSave\u201d button and that\u2019s it&nbsp;<\/strong><\/p>\n\n\n\n<div style=\"height:51px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Testing the Integration&nbsp;<\/h2>\n\n\n\n<p>Set up the integration by mapping Google Sheets data with Picky Assist Connector to trigger conditions and actions from updates.<\/p>\n\n\n\n<p>Open Google Sheet &amp; Just make any update to Column F so that we get the sample data to the Connector&nbsp;<\/p>\n\n\n\n<p>Go to Picky Assist Connector, open the created connector, and check logs to confirm Google Sheets updates were received.<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Mapping the JSON Data Structure <\/h2>\n\n\n\n<p>In order to map the JSON data structure go to &#8220;Field Mapping&#8221; then click on JSON Code from the popup you will able to see something shown as below;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"512\" src=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/json-code-1024x512.jpg\" alt=\"WhatsApp Integration with Google Sheets4\" class=\"wp-image-3054\" srcset=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/json-code-1024x512.jpg 1024w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/json-code-300x150.jpg 300w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/json-code-768x384.jpg 768w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/json-code-370x185.jpg 370w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/json-code-270x135.jpg 270w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/json-code-570x285.jpg 570w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/json-code-740x370.jpg 740w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/json-code.jpg 1440w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>If you are not seeing this option then please click on the <strong>&#8220;Code&#8221; <\/strong>tab then Click on <strong>&#8220;Map&#8221;<\/strong> button as shown below <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"471\" src=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/code-mapping-1024x471.jpg\" alt=\"WhatsApp Integration with Google Sheets5\" class=\"wp-image-3055\" srcset=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/code-mapping-1024x471.jpg 1024w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/code-mapping-300x138.jpg 300w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/code-mapping-768x354.jpg 768w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/code-mapping-370x170.jpg 370w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/code-mapping-270x124.jpg 270w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/code-mapping-570x262.jpg 570w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/code-mapping-740x341.jpg 740w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/code-mapping.jpg 1440w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:46px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Creating Steps<\/h2>\n\n\n\n<p>Now we need to create 6 steps which take different action based on the value in <strong>Column F<\/strong>, in order to do this first let&#8217;s create one step with all necessary filter and action then duplicate the steps for ease the process,<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"512\" src=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-ftiler-actions-1024x512.jpg\" alt=\"WhatsApp Integration with Google Sheets6\" class=\"wp-image-3057\" srcset=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-ftiler-actions-1024x512.jpg 1024w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-ftiler-actions-300x150.jpg 300w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-ftiler-actions-768x384.jpg 768w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-ftiler-actions-1536x768.jpg 1536w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-ftiler-actions-370x185.jpg 370w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-ftiler-actions-270x135.jpg 270w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-ftiler-actions-570x285.jpg 570w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-ftiler-actions-740x370.jpg 740w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/google-sheet-ftiler-actions.jpg 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Once a step is configured, we can simply take duplicates of the steps and change the filter condition value and message contents, the final settings will look like this<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"512\" src=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/5-steps-1024x512.jpg\" alt=\"WhatsApp Integration with Google Sheets7\" class=\"wp-image-3058\" srcset=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/5-steps-1024x512.jpg 1024w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/5-steps-300x150.jpg 300w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/5-steps-768x384.jpg 768w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/5-steps-1536x768.jpg 1536w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/5-steps-370x185.jpg 370w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/5-steps-270x135.jpg 270w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/5-steps-570x285.jpg 570w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/5-steps-740x370.jpg 740w, https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/5-steps.jpg 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Now this automation does the following actions when the order status column i.e Column F here changes <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Send a WhatsApp Message to the Customer when the google sheet status column changes to <strong>&#8220;Accepted&#8221;<\/strong><\/li>\n\n\n\n<li>Send a WhatsApp Message to the Customer when the google sheet status column changes to <strong>&#8220;Ready&#8221; <\/strong><\/li>\n\n\n\n<li>Send a WhatsApp message to the rider informing that there is an order which is ready for delivery when the google sheet status column changes to <strong>&#8220;Ready&#8221;<\/strong><\/li>\n\n\n\n<li>Send a WhatsApp Message to the Customer when the google sheet status column changes to <strong>&#8220;Dispatched&#8221; <\/strong><\/li>\n\n\n\n<li>Send a WhatsApp Message to the Customer when the google sheet status column changes to<strong> &#8220;Delivered&#8221; <\/strong><\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">Important Notes<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>If you add new columns to your Google Sheet then always make sure you have updated your JSON Code structure and steps accordingly so that you can able to make use of newly available fields in your connector.<\/li>\n\n\n\n<li>Kindly keep in mind that the target column edit action will trigger for all sheets in a spreadsheet<strong>, <\/strong>so if your spreadsheet has more than one sheets then always filter the condition based on the<strong> Sheet Name<\/strong> in the Connector in order to avoid wrong trigger \/ action <\/li>\n\n\n\n<li>Once a trigger from Google Sheet to Picky Assist happens there is no way to recall it so please be careful while writing conditions and actions in the Connector.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">Known Limitations to integrate Google Sheets and WhatsApp<\/h2>\n\n\n\n<p>Below are the known limitations of this automation so please keep this in mind while doing the automation;<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>There will be no trigger if new rows are added to the sheet<\/li>\n\n\n\n<li>There will be no trigger if a new row  or cell data is added by copy and paste <\/li>\n\n\n\n<li>There will be no trigger if a new row is created using any other 3rd party platforms (Refer to the solution below)<\/li>\n\n\n\n<li>There will be no trigger if a data change happens automatically in the background through A custom function, formula, or updates from 3rd party apps (Refer to the solution below)<\/li>\n<\/ol>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Workaround &amp; Tips <\/h2>\n\n\n\n<p>Below are the possible workarounds for various use cases.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Data Updating from 3rd Party Sites like Zapier <\/h3>\n\n\n\n<p>If the data is updating to the google sheet from any 3rd party sources like Zapier, API then this given method will not work as this works only based on the events which are performed by a user manually, for automated events you need to configure the polling i.e in every certain interval you need to lookup for certain data and if matches send the event to the Picky Assist Connector, you may refer the code and <a href=\"https:\/\/pickyassist.com\/blog\/google-sheet-value-update-script\/\" target=\"_blank\" rel=\"noreferrer noopener\">instructions here<\/a>. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Sending Mass Messages from Google Sheet<\/h3>\n\n\n\n<p>The current integration doesn&#8217;t natively provide an option to send mass messages however you can try the following workarounds to achieve this;<\/p>\n\n\n\n<p>The recommended method is to export the worksheet as csv and use the Picky Assist broadcaster feature to send personalised messages <\/p>\n\n\n\n<p>If you can&#8217;t do this process then you can create any keyword like &#8220;SendMsg&#8221; in the column then create a filter and action for the keyword in the Connector, you can setup the Send Message action which enables you to send a specific message when the keyword is updated in the Column.<\/p>\n\n\n\n<p>You can drag and drop the values from one cell to another to send bulk messages (this method is recommended only if you have less than 100 messages at a time) using this method for more rows will lead to missing messages due to the throttle limit of 5 triggers per second.<\/p>\n\n\n\n<p class=\"has-text-align-left has-gridlove-bg-color has-gridlove-meta-background-color has-text-color has-background has-link-color has-large-font-size wp-elements-6f46f7a88e36bcea9aa81af54caccd67\">Start now to integrate Google Sheets and WhatsApp and automate your business workflows instantly! <a href=\"https:\/\/meet.pickyassist.com\/team\/sales\" target=\"_blank\" rel=\"noreferrer noopener\">Book a Demo with Picky Assist<\/a> now!<\/p>\n\n\n\n<p><br><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This article demonstrates how to integrate Google Sheets and WhatsApp using the Picky Assist Connector without third-party automation platforms. Integrate Google Sheets and WhatsApp to automatically send messages, manage contacts, and trigger workflows directly from spreadsheet updates. Pre &#8211; Requisite\u00a0to integrate Google Sheets and WhatsApp Google Sheet In this guide let&#8217;s discuss how to send [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3061,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[131],"tags":[135,136],"class_list":["post-3044","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-integrations","tag-google-sheet-whatsapp-integration","tag-send-whatsapp-message-from-google-sheets"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Integrate Google Sheets and WhatsApp for Automation<\/title>\n<meta name=\"description\" content=\"Integrate Google Sheets and WhatsApp to automate updates, send alerts, and streamline workflows with real-time data syncing.\" \/>\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-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Integrate Google Sheets and WhatsApp for Automation\" \/>\n<meta property=\"og:description\" content=\"Integrate Google Sheets and WhatsApp to automate updates, send alerts, and streamline workflows with real-time data syncing.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Picky Assist Official Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-03-21T00:30:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-18T07:51:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/GoogleSheet.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=\"9 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-sheets\/\",\"url\":\"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-sheets\/\",\"name\":\"Integrate Google Sheets and WhatsApp for Automation\",\"isPartOf\":{\"@id\":\"https:\/\/pickyassist.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-sheets\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-sheets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/GoogleSheet.jpg\",\"datePublished\":\"2021-03-21T00:30:23+00:00\",\"dateModified\":\"2026-03-18T07:51:10+00:00\",\"author\":{\"@id\":\"https:\/\/pickyassist.com\/blog\/#\/schema\/person\/f7e9e7ef306abb4d9a1b00210e2c86e1\"},\"description\":\"Integrate Google Sheets and WhatsApp to automate updates, send alerts, and streamline workflows with real-time data syncing.\",\"breadcrumb\":{\"@id\":\"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-sheets\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-sheets\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-sheets\/#primaryimage\",\"url\":\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/GoogleSheet.jpg\",\"contentUrl\":\"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/GoogleSheet.jpg\",\"width\":600,\"height\":327,\"caption\":\"Send WhatsApp Message From Google Sheets\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/pickyassist.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"WhatsApp Integration with Google Sheets\"}]},{\"@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":"Integrate Google Sheets and WhatsApp for Automation","description":"Integrate Google Sheets and WhatsApp to automate updates, send alerts, and streamline workflows with real-time data syncing.","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-sheets\/","og_locale":"en_US","og_type":"article","og_title":"Integrate Google Sheets and WhatsApp for Automation","og_description":"Integrate Google Sheets and WhatsApp to automate updates, send alerts, and streamline workflows with real-time data syncing.","og_url":"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-sheets\/","og_site_name":"Picky Assist Official Blog","article_published_time":"2021-03-21T00:30:23+00:00","article_modified_time":"2026-03-18T07:51:10+00:00","og_image":[{"width":600,"height":327,"url":"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/GoogleSheet.jpg","type":"image\/jpeg"}],"author":"Danny","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Danny","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-sheets\/","url":"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-sheets\/","name":"Integrate Google Sheets and WhatsApp for Automation","isPartOf":{"@id":"https:\/\/pickyassist.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-sheets\/#primaryimage"},"image":{"@id":"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/GoogleSheet.jpg","datePublished":"2021-03-21T00:30:23+00:00","dateModified":"2026-03-18T07:51:10+00:00","author":{"@id":"https:\/\/pickyassist.com\/blog\/#\/schema\/person\/f7e9e7ef306abb4d9a1b00210e2c86e1"},"description":"Integrate Google Sheets and WhatsApp to automate updates, send alerts, and streamline workflows with real-time data syncing.","breadcrumb":{"@id":"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-sheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-sheets\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-sheets\/#primaryimage","url":"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/GoogleSheet.jpg","contentUrl":"https:\/\/pickyassist.com\/blog\/wp-content\/uploads\/2021\/03\/GoogleSheet.jpg","width":600,"height":327,"caption":"Send WhatsApp Message From Google Sheets"},{"@type":"BreadcrumbList","@id":"https:\/\/pickyassist.com\/blog\/whatsapp-integration-with-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pickyassist.com\/blog\/"},{"@type":"ListItem","position":2,"name":"WhatsApp Integration with Google Sheets"}]},{"@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\/3044","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=3044"}],"version-history":[{"count":20,"href":"https:\/\/pickyassist.com\/blog\/wp-json\/wp\/v2\/posts\/3044\/revisions"}],"predecessor-version":[{"id":7655,"href":"https:\/\/pickyassist.com\/blog\/wp-json\/wp\/v2\/posts\/3044\/revisions\/7655"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pickyassist.com\/blog\/wp-json\/wp\/v2\/media\/3061"}],"wp:attachment":[{"href":"https:\/\/pickyassist.com\/blog\/wp-json\/wp\/v2\/media?parent=3044"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pickyassist.com\/blog\/wp-json\/wp\/v2\/categories?post=3044"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pickyassist.com\/blog\/wp-json\/wp\/v2\/tags?post=3044"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}