{"id":2255,"date":"2022-10-17T12:32:09","date_gmt":"2022-10-17T12:32:09","guid":{"rendered":"https:\/\/support.spoki.com\/docs\/uncategorized\/integrate-whatsapp-with-google-sheets\/"},"modified":"2023-11-07T11:17:49","modified_gmt":"2023-11-07T11:17:49","password":"","slug":"integrate-whatsapp-with-google-sheets","status":"publish","type":"docs","link":"https:\/\/support.spoki.com\/en\/docs\/integrations\/integrate-whatsapp-with-google-sheets\/","title":{"rendered":"Integrate WhatsApp with Google Sheets"},"content":{"rendered":"\n<p>You can send a WhatsApp message automatically when you edit or fill in <strong>a specific cell in the Google Sheets sheet<\/strong>.  <\/p>\n\n<p>Assume, for example, that you want to <strong>send confirmation of an appointment<\/strong> you just made. As soon as you go to <strong>change the content of the GoogleSheets cell<\/strong>, <strong>Spoki, via Zapier, will record that change and send the message to the client<\/strong> in question without you doing anything more.<\/p>\n\n<p>Let us now see how to integrate <strong>WhatsApp with Google Sheets<\/strong> via Spoki.<\/p>\n\n<ul class=\"wp-block-list\">\n<li>First, go to <strong>Zapier<\/strong><\/li>\n\n\n\n<li>Select Google Sheets as <strong>Trigger<\/strong> <\/li>\n<\/ul>\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1014\" height=\"418\" src=\"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-23.png\" alt=\"\" class=\"wp-image-283\" srcset=\"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-23.png 1014w, https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-23-300x124.png 300w, https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-23-768x317.png 768w\" sizes=\"(max-width: 1014px) 100vw, 1014px\" \/><\/figure>\n\n<ul class=\"wp-block-list\">\n<li>Select the Trigger of the event, which in this case will be New or Updated Spreadsheet Row (Team Drive)<\/li>\n\n\n\n<li>Select the Google account you wish to use and go on to select the Google Sheets sheet you intend to use<\/li>\n\n\n\n<li>As a Trigger Column you can choose the column that will serve as our trigger (in the example below it will be Date Appointment)<\/li>\n<\/ul>\n\n<blockquote class=\"wp-block-quote has-background is-layout-flow wp-block-quote-is-layout-flow\" style=\"background-color:#ebebeb\">\n<p>N.B. The name given to the column must be identical to the dynamic field created in the Spoki platform.<\/p>\n<\/blockquote>\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"675\" src=\"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-24-1024x675.png\" alt=\"\" class=\"wp-image-284\" srcset=\"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-24-1024x675.png 1024w, https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-24-300x198.png 300w, https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-24-768x506.png 768w, https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-24.png 1300w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n<ul class=\"wp-block-list\">\n<li>Test that everything is working properly with the test trigger.<\/li>\n\n\n\n<li>Select the tool that is to be triggered when the Google sheet records a change or a new value in the cell, namely Spoki.<\/li>\n<\/ul>\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"935\" height=\"673\" src=\"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-25.png\" alt=\"\" class=\"wp-image-285\" srcset=\"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-25.png 935w, https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-25-300x216.png 300w, https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-25-768x553.png 768w\" sizes=\"(max-width: 935px) 100vw, 935px\" \/><\/figure>\n\n<ul class=\"wp-block-list\">\n<li>Choose the action that should start as a result of the trigger. Select the<em>&#8220;Start Automation<\/em>&#8221; item (with <strong>StartAutomation<\/strong> you can start a message that is intended to trigger a conversation with the user, thus involving automation) and continue by choosing the Spoki account to use.<\/li>\n<\/ul>\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"920\" height=\"507\" src=\"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-26.png\" alt=\"\" class=\"wp-image-286\" srcset=\"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-26.png 920w, https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-26-300x165.png 300w, https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-26-768x423.png 768w\" sizes=\"(max-width: 920px) 100vw, 920px\" \/><\/figure>\n\n<ul class=\"wp-block-list\">\n<li>Open the Spoki platform.<\/li>\n\n\n\n<li>Create a new automation or select the automation you want to link to Google Sheet and select as Start Step: <em>Zapier<\/em>.  <\/li>\n\n\n\n<li>Automatically, the system will generate an automation identification code called <strong>Automation ID<\/strong>. Copy the code and close the window.  <\/li>\n<\/ul>\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"624\" src=\"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-27-1024x624.png\" alt=\"\" class=\"wp-image-287\" srcset=\"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-27-1024x624.png 1024w, https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-27-300x183.png 300w, https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-27-768x468.png 768w, https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-27.png 1111w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n<ul class=\"wp-block-list\">\n<li>Select the template you want to send to the user by entering the dynamic field (in our example, the dynamic field will be <strong>Date Appointment<\/strong>)<\/li>\n\n\n\n<li>Go back to Zapier and paste the code you saved inside the <em>ID Standard Message<\/em> entry.<\/li>\n<\/ul>\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"385\" src=\"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-28.png\" alt=\"\" class=\"wp-image-288\" srcset=\"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-28.png 900w, https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-28-300x128.png 300w, https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-28-768x329.png 768w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><\/figure>\n\n<ul class=\"wp-block-list\">\n<li>Match the data you want to take from the Google sheet and send it to Spoki.<\/li>\n<\/ul>\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"588\" src=\"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-29-1024x588.png\" alt=\"\" class=\"wp-image-289\" srcset=\"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-29-1024x588.png 1024w, https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-29-300x172.png 300w, https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-29-768x441.png 768w, https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-29.png 1300w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n<ul class=\"wp-block-list\">\n<li>Check that everything is properly set up and activate zap.<\/li>\n<\/ul>\n\n<p>From now on, <strong>every time you go to edit a Google Sheets cell in the chosen column the user who is the subject of the change will automatically receive a WhatsApp message<\/strong>. In our example you will receive an appointment confirmation message.<\/p>\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"278\" src=\"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-30-1024x278.png\" alt=\"\" class=\"wp-image-290\" srcset=\"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-30-1024x278.png 1024w, https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-30-300x82.png 300w, https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-30-768x209.png 768w, https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-30.png 1104w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n<h2 class=\"wp-block-heading\">Related articles<\/h2>\n\n<p><a href=\"https:\/\/support.spoki.com\/docs\/how-to\/come-avviare-un-messaggio-di-reminder-in-automatico-da-spoki\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to send an automatic reminder message<\/a><\/p>\n\n<p><a href=\"https:\/\/support.spoki.com\/docs\/integrazioni\/integrare-whatsapp-con-ifttp\/\">Integrating WhatsApp with IFTTT<\/a><\/p>\n\n<p><a href=\"https:\/\/support.spoki.com\/docs\/integrazioni\/integrare-whatsapp-con-zapier\/\" target=\"_blank\" rel=\"noreferrer noopener\">Integrating WhatsApp with Zapier<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>You can send a WhatsApp message automatically when you edit or fill in a specific cell in the Google Sheets [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_category":[47],"doc_tag":[],"class_list":["post-2255","docs","type-docs","status-publish","hentry","doc_category-integrations"],"year_month":"2026-04","word_count":426,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"romantic-torvalds","author_nicename":"romantic-torvalds","author_url":"https:\/\/support.spoki.com\/en\/author\/romantic-torvalds\/"},"doc_category_info":[{"term_name":"Integrations","term_url":"https:\/\/support.spoki.com\/en\/docs-category\/integrations\/"}],"doc_tag_info":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Integrate WhatsApp with Google Sheets - Supporto Spoki<\/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:\/\/support.spoki.com\/docs\/integrazioni\/integrare-whatsapp-con-google-fogli\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Integrate WhatsApp with Google Sheets - Supporto Spoki\" \/>\n<meta property=\"og:description\" content=\"You can send a WhatsApp message automatically when you edit or fill in a specific cell in the Google Sheets [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/support.spoki.com\/docs\/integrazioni\/integrare-whatsapp-con-google-fogli\/\" \/>\n<meta property=\"og:site_name\" content=\"Supporto Spoki\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-07T11:17:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-23.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/support.spoki.com\/docs\/integrazioni\/integrare-whatsapp-con-google-fogli\/\",\"url\":\"https:\/\/support.spoki.com\/docs\/integrazioni\/integrare-whatsapp-con-google-fogli\/\",\"name\":\"Integrate WhatsApp with Google Sheets - Supporto Spoki\",\"isPartOf\":{\"@id\":\"https:\/\/support.spoki.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/support.spoki.com\/docs\/integrazioni\/integrare-whatsapp-con-google-fogli\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/support.spoki.com\/docs\/integrazioni\/integrare-whatsapp-con-google-fogli\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-23.png\",\"datePublished\":\"2022-10-17T12:32:09+00:00\",\"dateModified\":\"2023-11-07T11:17:49+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/support.spoki.com\/docs\/integrazioni\/integrare-whatsapp-con-google-fogli\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/support.spoki.com\/docs\/integrazioni\/integrare-whatsapp-con-google-fogli\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/support.spoki.com\/docs\/integrazioni\/integrare-whatsapp-con-google-fogli\/#primaryimage\",\"url\":\"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-23.png\",\"contentUrl\":\"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-23.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/support.spoki.com\/docs\/integrazioni\/integrare-whatsapp-con-google-fogli\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/support.spoki.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Docs\",\"item\":\"https:\/\/support.spoki.com\/docs\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Integrate WhatsApp with Google Sheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/support.spoki.com\/#website\",\"url\":\"https:\/\/support.spoki.com\/\",\"name\":\"Supporto Spoki\",\"description\":\"Documentation for Spoki use\",\"publisher\":{\"@id\":\"https:\/\/support.spoki.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/support.spoki.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/support.spoki.com\/#organization\",\"name\":\"Supporto Spoki\",\"url\":\"https:\/\/support.spoki.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/support.spoki.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/11\/Logo_Spoki-Primary_Black-01-scaled.jpg\",\"contentUrl\":\"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/11\/Logo_Spoki-Primary_Black-01-scaled.jpg\",\"width\":2560,\"height\":761,\"caption\":\"Supporto Spoki\"},\"image\":{\"@id\":\"https:\/\/support.spoki.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/spokiapp\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Integrate WhatsApp with Google Sheets - Supporto Spoki","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:\/\/support.spoki.com\/docs\/integrazioni\/integrare-whatsapp-con-google-fogli\/","og_locale":"en_US","og_type":"article","og_title":"Integrate WhatsApp with Google Sheets - Supporto Spoki","og_description":"You can send a WhatsApp message automatically when you edit or fill in a specific cell in the Google Sheets [&hellip;]","og_url":"https:\/\/support.spoki.com\/docs\/integrazioni\/integrare-whatsapp-con-google-fogli\/","og_site_name":"Supporto Spoki","article_modified_time":"2023-11-07T11:17:49+00:00","og_image":[{"url":"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-23.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/support.spoki.com\/docs\/integrazioni\/integrare-whatsapp-con-google-fogli\/","url":"https:\/\/support.spoki.com\/docs\/integrazioni\/integrare-whatsapp-con-google-fogli\/","name":"Integrate WhatsApp with Google Sheets - Supporto Spoki","isPartOf":{"@id":"https:\/\/support.spoki.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/support.spoki.com\/docs\/integrazioni\/integrare-whatsapp-con-google-fogli\/#primaryimage"},"image":{"@id":"https:\/\/support.spoki.com\/docs\/integrazioni\/integrare-whatsapp-con-google-fogli\/#primaryimage"},"thumbnailUrl":"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-23.png","datePublished":"2022-10-17T12:32:09+00:00","dateModified":"2023-11-07T11:17:49+00:00","breadcrumb":{"@id":"https:\/\/support.spoki.com\/docs\/integrazioni\/integrare-whatsapp-con-google-fogli\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/support.spoki.com\/docs\/integrazioni\/integrare-whatsapp-con-google-fogli\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/support.spoki.com\/docs\/integrazioni\/integrare-whatsapp-con-google-fogli\/#primaryimage","url":"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-23.png","contentUrl":"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/10\/image-23.png"},{"@type":"BreadcrumbList","@id":"https:\/\/support.spoki.com\/docs\/integrazioni\/integrare-whatsapp-con-google-fogli\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/support.spoki.com\/en\/"},{"@type":"ListItem","position":2,"name":"Docs","item":"https:\/\/support.spoki.com\/docs\/"},{"@type":"ListItem","position":3,"name":"Integrate WhatsApp with Google Sheets"}]},{"@type":"WebSite","@id":"https:\/\/support.spoki.com\/#website","url":"https:\/\/support.spoki.com\/","name":"Supporto Spoki","description":"Documentation for Spoki use","publisher":{"@id":"https:\/\/support.spoki.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/support.spoki.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/support.spoki.com\/#organization","name":"Supporto Spoki","url":"https:\/\/support.spoki.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/support.spoki.com\/#\/schema\/logo\/image\/","url":"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/11\/Logo_Spoki-Primary_Black-01-scaled.jpg","contentUrl":"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/11\/Logo_Spoki-Primary_Black-01-scaled.jpg","width":2560,"height":761,"caption":"Supporto Spoki"},"image":{"@id":"https:\/\/support.spoki.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/spokiapp\/"]}]}},"_links":{"self":[{"href":"https:\/\/support.spoki.com\/en\/wp-json\/wp\/v2\/docs\/2255","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.spoki.com\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/support.spoki.com\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/support.spoki.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/support.spoki.com\/en\/wp-json\/wp\/v2\/comments?post=2255"}],"version-history":[{"count":1,"href":"https:\/\/support.spoki.com\/en\/wp-json\/wp\/v2\/docs\/2255\/revisions"}],"predecessor-version":[{"id":2263,"href":"https:\/\/support.spoki.com\/en\/wp-json\/wp\/v2\/docs\/2255\/revisions\/2263"}],"wp:attachment":[{"href":"https:\/\/support.spoki.com\/en\/wp-json\/wp\/v2\/media?parent=2255"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/support.spoki.com\/en\/wp-json\/wp\/v2\/doc_category?post=2255"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/support.spoki.com\/en\/wp-json\/wp\/v2\/doc_tag?post=2255"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}