{"id":19069,"date":"2026-11-19T00:20:41","date_gmt":"2026-11-18T18:50:41","guid":{"rendered":"https:\/\/www.fast2sms.com\/help\/whatsapp-webhook-google-sheets-apps-script\/"},"modified":"2026-11-19T00:20:41","modified_gmt":"2026-11-18T18:50:41","slug":"whatsapp-webhook-google-sheets-apps-script","status":"publish","type":"post","link":"https:\/\/www.fast2sms.com\/help\/whatsapp-webhook-google-sheets-apps-script\/","title":{"rendered":"Save WhatsApp replies and delivery reports to Google Sheets"},"content":{"rendered":"<p>You can save every WhatsApp reply from customers, and the delivery status of messages you send through the API, straight into a Google Sheet. No server is needed: a short Google Apps Script receives the Fast2SMS webhook and adds one row per event. This guide gives you the script, the settings and the checks to send a WhatsApp webhook to Google Sheets.<\/p>\n<aside class=\"f2s-cta\" aria-label=\"Get started with Fast2SMS\"><div class=\"f2s-cta__copy\"><strong class=\"f2s-cta__title\">Get WhatsApp data into your sheet<\/strong><p>Connect your number to Fast2SMS and push replies and delivery reports to Google Sheets.<\/p><\/div><div class=\"f2s-cta__actions\"><a class=\"f2s-cta__btn f2s-cta__btn--primary\" href=\"https:\/\/www.fast2sms.com\/\"><span>Sign up free<\/span> <span class=\"f2sh-btn__arrow\" aria-hidden=\"true\">&rarr;<\/span><\/a><a class=\"f2s-cta__btn f2s-cta__btn--ghost\" href=\"https:\/\/www.fast2sms.com\/meet\/\" target=\"_blank\" rel=\"noopener\">Book a free meeting<\/a><\/div><\/aside>\n<h2>Before you start<\/h2>\n<ul>\n<li>A Google account and a new Google Sheet.<\/li>\n<li>A WhatsApp number connected to Fast2SMS.<\/li>\n<li>Know what the webhook sends. Customer replies (Incoming Messages) are sent for every message a customer writes to your number. Status updates (sent, delivered, read, failed) are sent only for messages you send through the API, not for campaigns sent from the panel. For panel campaigns, use the <a href=\"\/help\/send-bulk-whatsapp-messages-fast2sms\/\">delivery report and its export<\/a>.<\/li>\n<\/ul>\n<h2>How to send WhatsApp webhooks to Google Sheets<\/h2>\n<ol class=\"f2s-steps\">\n<li>\n<h3>Prepare the sheet<\/h3>\n<p>Create a Google Sheet and name the first tab <strong>Sheet1<\/strong> (or change the name in the script below). In row 1, add the headings: Time, Type, Mobile, From, Status, Message type, Text, Media URL, Request ID, Reason.<\/p>\n<\/li>\n<li>\n<h3>Add the Apps Script<\/h3>\n<p>In the sheet, open <strong>Extensions<\/strong> &gt; <strong>Apps Script<\/strong>. Delete the sample code and paste this:<\/p>\n<pre><code class=\"language-javascript\">function doPost(e) {\n  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1');\n  var d = {};\n  try {\n    d = JSON.parse(e.postData.contents);   \/\/ JSON body from Fast2SMS\n  } catch (err) {\n    d = e.parameter;                         \/\/ form-encoded body\n  }\n  sheet.appendRow([\n    new Date(),\n    d.webhook_type || '',\n    d.mobile || '',\n    d.from || '',\n    d.status || '',\n    d.message_type || '',\n    d.body || '',\n    d.media_url || '',\n    d.request_id || '',\n    d.failure_reason || ''\n  ]);\n  return ContentService.createTextOutput('ok');\n}<\/code><\/pre>\n<p>Click the save icon. The script runs each time Fast2SMS sends a POST request and adds one row to the sheet.<\/p>\n<\/li>\n<li>\n<h3>Deploy it as a web app<\/h3>\n<p>Click <strong>Deploy<\/strong> &gt; <strong>New deployment<\/strong>. Next to &#8220;Select type&#8221;, choose <strong>Web app<\/strong>. Set it to run as you, and allow access to anyone, because Fast2SMS calls it without a Google login. Click <strong>Deploy<\/strong>, allow the permissions Google asks for, and copy the <strong>Web app URL<\/strong>. It ends in <code>\/exec<\/code>.<\/p>\n<div class=\"f2s-note\">\n<p>Anyone with this URL can add rows to your sheet. Keep it private. For extra safety, add your own secret header in the webhook (step 4) and a check for it in the script.<\/p>\n<\/div>\n<\/li>\n<li>\n<h3>Create the WhatsApp webhook in Fast2SMS<\/h3>\n<p>Go to <strong>Webhook<\/strong> &gt; <strong>WhatsApp<\/strong> and click <strong>Add Webhook<\/strong>. Fill in:<\/p>\n<ul>\n<li><strong>Webhook Name<\/strong>: for example &#8220;Google Sheet log&#8221;.<\/li>\n<li><strong>Select Format<\/strong>: Standard Webhook.<\/li>\n<li><strong>Select Event<\/strong>: Incoming Messages for customer replies, or Default All Events for replies plus status updates.<\/li>\n<li>The number: your WhatsApp number, or Default All.<\/li>\n<li><strong>Method<\/strong>: POST. <strong>URL<\/strong>: the web app URL you copied. <strong>Content-Type<\/strong>: JSON.<\/li>\n<\/ul>\n<figure class=\"f2s-shot\"><img src=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/11\/webhook-create-event-menu-hd-4-scaled.webp\" width=\"1440\" height=\"900\" loading=\"lazy\" decoding=\"async\" alt=\"Select Event list for a WhatsApp webhook with Default All Events, On Sent, On Delivered, On Read, On Failed and Incoming Messages\"><figcaption>Pick Incoming Messages to log customer replies.<\/figcaption><\/figure>\n<\/li>\n<li>\n<h3>Set the body to match the script<\/h3>\n<p>In the <strong>Body<\/strong> tab, keep only the fields the script reads. Type <code>{{<\/code> to insert a field. A body that matches the script:<\/p>\n<pre><code class=\"language-json\">{\n  \"webhook_type\": \"{{webhook_type}}\",\n  \"mobile\": \"{{mobile}}\",\n  \"from\": \"{{from}}\",\n  \"status\": \"{{status}}\",\n  \"message_type\": \"{{message_type}}\",\n  \"body\": \"{{body}}\",\n  \"media_url\": \"{{media_url}}\",\n  \"request_id\": \"{{request_id}}\",\n  \"failure_reason\": \"{{failure_reason}}\"\n}<\/code><\/pre>\n<p>Keep <strong>Webhook Status<\/strong> on and click <strong>CREATE<\/strong>. The new webhook shows in the list as Active.<\/p>\n<figure class=\"f2s-shot\"><img src=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/11\/whatsapp-webhook-hd-1-scaled.webp\" width=\"1440\" height=\"900\" loading=\"lazy\" decoding=\"async\" alt=\"WhatsApp Webhook list with three webhooks showing URL, event, WhatsApp number, method and Active or Inactive status\"><figcaption>Your webhook appears in the WhatsApp Webhook list.<\/figcaption><\/figure>\n<\/li>\n<li>\n<h3>Test and check the logs<\/h3>\n<p>From the webhook&#8217;s three-dot menu, choose <strong>Test Webhook<\/strong>. Fast2SMS sends sample data and shows the result. Then send a WhatsApp message to your business number from your phone and check that a row appears in the sheet.<\/p>\n<p>Open <strong>Webhook Logs<\/strong> to see each call with its HTTP code and time taken. Logs are kept for 7 days, and each event can be resent once.<\/p>\n<figure class=\"f2s-shot\"><img src=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/11\/webhook-logs-hd-3-scaled.webp\" width=\"1440\" height=\"900\" loading=\"lazy\" decoding=\"async\" alt=\"Webhook Logs with SMS and WhatsApp events, URL, response time, HTTP code and Success or Failed status\"><figcaption>Webhook Logs show every call and the HTTP code your URL returned.<\/figcaption><\/figure>\n<div class=\"f2s-note f2s-note--warn\">\n<p>Google answers web app requests with a redirect to a one-time address. Fast2SMS counts only HTTP 2xx answers as success. If a log shows a 3xx code but the row is in your sheet, the data did arrive. Do not use Resend in that case, or you will get the row twice.<\/p>\n<\/div>\n<\/li>\n<\/ol>\n<aside class=\"f2s-cta\" aria-label=\"Get started with Fast2SMS\"><div class=\"f2s-cta__copy\"><strong class=\"f2s-cta__title\">Track WhatsApp replies in a sheet<\/strong><p>Log in to Fast2SMS, add a WhatsApp webhook and paste your Apps Script URL.<\/p><\/div><div class=\"f2s-cta__actions\"><a class=\"f2s-cta__btn f2s-cta__btn--primary\" href=\"https:\/\/www.fast2sms.com\/\"><span>Sign up free<\/span> <span class=\"f2sh-btn__arrow\" aria-hidden=\"true\">&rarr;<\/span><\/a><a class=\"f2s-cta__btn f2s-cta__btn--ghost\" href=\"https:\/\/www.fast2sms.com\/meet\/\" target=\"_blank\" rel=\"noopener\">Book a free meeting<\/a><\/div><\/aside>\n<h2>What the columns mean<\/h2>\n<div class=\"f2s-facts\">\n<table>\n<thead>\n<tr>\n<th>Field<\/th>\n<th>What it holds<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>webhook_type<\/td>\n<td><code>incoming_message<\/code> for a customer message, <code>status_update<\/code> for a delivery status<\/td>\n<\/tr>\n<tr>\n<td>mobile \/ from<\/td>\n<td>The customer&#8217;s number<\/td>\n<\/tr>\n<tr>\n<td>status<\/td>\n<td>sent, delivered, read, failed or received<\/td>\n<\/tr>\n<tr>\n<td>message_type, body<\/td>\n<td>The type of incoming message and its text<\/td>\n<\/tr>\n<tr>\n<td>media_url<\/td>\n<td>Link to a photo, video, audio or document the customer sent<\/td>\n<\/tr>\n<tr>\n<td>request_id<\/td>\n<td>The W\u2026 request ID from your API send, to match the status with your message<\/td>\n<\/tr>\n<tr>\n<td>failure_reason<\/td>\n<td>Why a message failed, when it did<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>You can add more fields, such as <code>caption<\/code>, <code>mime_type<\/code>, <code>display_phone_number<\/code> or <code>udf1<\/code>, by adding them to both the webhook body and the <code>appendRow<\/code> list in the script.<\/p>\n<h2>Common problems and fixes<\/h2>\n<div class=\"f2s-facts\">\n<table>\n<thead>\n<tr>\n<th>Problem<\/th>\n<th>Fix<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>No rows appear<\/td>\n<td>Check the webhook is Active and the event matches. Check the URL ends in \/exec, not \/dev. Check the tab is named Sheet1.<\/td>\n<\/tr>\n<tr>\n<td>Rows appear for replies but not for delivery status<\/td>\n<td>Status webhooks are sent only for messages sent through the API, not panel campaigns.<\/td>\n<\/tr>\n<tr>\n<td>Changes to the script do nothing<\/td>\n<td>After editing, deploy again: Deploy &gt; Manage deployments, edit the deployment and choose a new version. The URL stays the same.<\/td>\n<\/tr>\n<tr>\n<td>Test Webhook fails and no rows appear<\/td>\n<td>Check the web app access allows anyone, not only you. Change it and deploy again.<\/td>\n<\/tr>\n<tr>\n<td>Empty cells<\/td>\n<td>The key names in the webhook body must match the names the script reads (d.body, d.status and so on).<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<section class=\"f2s-faq\">\n<h2>Frequently asked questions<\/h2>\n<h3>Is this free?<\/h3>\n<p>Webhooks cost nothing in Fast2SMS, and Google Apps Script is free within Google&#8217;s usage limits. You pay only for the messages you send.<\/p>\n<h3>Can I log SMS delivery reports the same way?<\/h3>\n<p>Yes. Create the webhook under Webhook &gt; SMS instead and use the SMS fields, such as request_id, mobile, status and failure_reason. SMS webhooks are also sent only for API sends.<\/p>\n<h3>Will this work for thousands of messages a day?<\/h3>\n<p>Google Sheets is fine for small and medium volumes. For heavy traffic, receive the webhook on your own server or database.<\/p>\n<h3>Can I send messages from Google Sheets too?<\/h3>\n<p>Yes. The Fast2SMS add-on for Google Sheets sends SMS from a sheet. See <a href=\"\/help\/fast2sms-integration-for-google-sheets\/\">Fast2SMS integration for Google Sheets<\/a>.<\/p>\n<h3>How do I stop the logging?<\/h3>\n<p>Switch the webhook to Inactive or delete it in Webhook &gt; WhatsApp.<\/p>\n<\/section>\n<aside class=\"f2s-cta\" aria-label=\"Get started with Fast2SMS\"><div class=\"f2s-cta__copy\"><strong class=\"f2s-cta__title\">Connect WhatsApp to your tools<\/strong><p>Sign up for Fast2SMS and send replies and delivery reports to your sheet or server.<\/p><\/div><div class=\"f2s-cta__actions\"><a class=\"f2s-cta__btn f2s-cta__btn--primary\" href=\"https:\/\/www.fast2sms.com\/\"><span>Sign up free<\/span> <span class=\"f2sh-btn__arrow\" aria-hidden=\"true\">&rarr;<\/span><\/a><a class=\"f2s-cta__btn f2s-cta__btn--ghost\" href=\"https:\/\/www.fast2sms.com\/meet\/\" target=\"_blank\" rel=\"noopener\">Book a free meeting<\/a><\/div><\/aside>\n<h2>Related guides<\/h2>\n<ul>\n<li><a href=\"\/help\/fast2sms-webhooks-setup-delivery-reports\/\">Set up webhooks in Fast2SMS<\/a><\/li>\n<li><a href=\"\/help\/how-webhooks-work\/\">How webhooks work: real-time delivery reports<\/a><\/li>\n<li><a href=\"\/help\/fast2sms-integration-for-google-sheets\/\">Fast2SMS integration for Google Sheets<\/a><\/li>\n<li><a href=\"\/help\/whatsapp-live-chat-inbox-fast2sms\/\">WhatsApp Live Chat in Fast2SMS<\/a><\/li>\n<li><a href=\"https:\/\/www.fast2sms.com\/whatsapp-api\">WhatsApp Business API<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>You can save every WhatsApp reply from customers, and the delivery status of messages you send through the API, straight into a Google Sheet. No server is needed: a short Google Apps Script receives the Fast2SMS webhook and adds one row per event. This guide gives you the script, the settings and the checks to [&hellip;]<\/p>\n","protected":false},"featured_media":19065,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25,31,24],"tags":[],"class_list":["post-19069","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-integrations","category-webhooks","category-whatsapp"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>WhatsApp Webhook to Google Sheets (Apps Script) | Fast2SMS<\/title>\n<meta name=\"description\" content=\"Log WhatsApp replies and API delivery reports in Google Sheets with a Fast2SMS webhook and a short Apps Script web app. Script, setup steps and fixes.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.fast2sms.com\/help\/whatsapp-webhook-google-sheets-apps-script\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"WhatsApp Webhook to Google Sheets (Apps Script) | Fast2SMS\" \/>\n<meta property=\"og:description\" content=\"Log WhatsApp replies and API delivery reports in Google Sheets with a Fast2SMS webhook and a short Apps Script web app. Script, setup steps and fixes.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fast2sms.com\/help\/whatsapp-webhook-google-sheets-apps-script\/\" \/>\n<meta property=\"og:site_name\" content=\"Fast2SMS\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Fast2SMS\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-11-18T18:50:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/11\/webhook-create-event-menu-hd-4-scaled.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@fast2sms\" \/>\n<meta name=\"twitter:site\" content=\"@fast2sms\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/whatsapp-webhook-google-sheets-apps-script\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/whatsapp-webhook-google-sheets-apps-script\\\/\"},\"author\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/#organization\"},\"headline\":\"Save WhatsApp replies and delivery reports to Google Sheets\",\"datePublished\":\"2026-11-18T18:50:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/whatsapp-webhook-google-sheets-apps-script\\\/\"},\"wordCount\":1063,\"publisher\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/whatsapp-webhook-google-sheets-apps-script\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/webhook-create-event-menu-hd-4-scaled.webp\",\"articleSection\":[\"Integrations\",\"Webhooks\",\"WhatsApp\"],\"inLanguage\":\"en-IN\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/whatsapp-webhook-google-sheets-apps-script\\\/\",\"url\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/whatsapp-webhook-google-sheets-apps-script\\\/\",\"name\":\"WhatsApp Webhook to Google Sheets (Apps Script) | Fast2SMS\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/whatsapp-webhook-google-sheets-apps-script\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/whatsapp-webhook-google-sheets-apps-script\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/webhook-create-event-menu-hd-4-scaled.webp\",\"datePublished\":\"2026-11-18T18:50:41+00:00\",\"description\":\"Log WhatsApp replies and API delivery reports in Google Sheets with a Fast2SMS webhook and a short Apps Script web app. Script, setup steps and fixes.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/whatsapp-webhook-google-sheets-apps-script\\\/#breadcrumb\"},\"inLanguage\":\"en-IN\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/whatsapp-webhook-google-sheets-apps-script\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-IN\",\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/whatsapp-webhook-google-sheets-apps-script\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/webhook-create-event-menu-hd-4-scaled.webp\",\"contentUrl\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/webhook-create-event-menu-hd-4-scaled.webp\",\"width\":2560,\"height\":1600,\"caption\":\"Select Event list for a WhatsApp webhook with Default All Events, On Sent, On Delivered, On Read, On Failed and Incoming Messages\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/whatsapp-webhook-google-sheets-apps-script\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Integrations\",\"item\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/integrations\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Save WhatsApp replies and delivery reports to Google Sheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/#website\",\"url\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/\",\"name\":\"Fast2SMS\",\"description\":\"Help\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/#organization\"},\"inLanguage\":\"en-IN\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/#organization\",\"name\":\"Fast2SMS\",\"url\":\"https:\\\/\\\/www.fast2sms.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/#logo\",\"url\":\"https:\\\/\\\/www.fast2sms.com\\\/Fast2SMS.png\",\"contentUrl\":\"https:\\\/\\\/www.fast2sms.com\\\/Fast2SMS.png\",\"caption\":\"Fast2SMS\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/#logo\"},\"email\":\"support@fast2sms.com\",\"telephone\":\"+91-6262778822\",\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/Fast2SMS\",\"https:\\\/\\\/www.instagram.com\\\/fast2sms\",\"https:\\\/\\\/x.com\\\/fast2sms\",\"https:\\\/\\\/www.youtube.com\\\/Fast2SMSofficial\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/fast2sms\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"WhatsApp Webhook to Google Sheets (Apps Script) | Fast2SMS","description":"Log WhatsApp replies and API delivery reports in Google Sheets with a Fast2SMS webhook and a short Apps Script web app. Script, setup steps and fixes.","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:\/\/www.fast2sms.com\/help\/whatsapp-webhook-google-sheets-apps-script\/","og_locale":"en_US","og_type":"article","og_title":"WhatsApp Webhook to Google Sheets (Apps Script) | Fast2SMS","og_description":"Log WhatsApp replies and API delivery reports in Google Sheets with a Fast2SMS webhook and a short Apps Script web app. Script, setup steps and fixes.","og_url":"https:\/\/www.fast2sms.com\/help\/whatsapp-webhook-google-sheets-apps-script\/","og_site_name":"Fast2SMS","article_publisher":"https:\/\/www.facebook.com\/Fast2SMS\/","article_published_time":"2026-11-18T18:50:41+00:00","og_image":[{"width":2560,"height":1600,"url":"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/11\/webhook-create-event-menu-hd-4-scaled.webp","type":"image\/webp"}],"twitter_card":"summary_large_image","twitter_creator":"@fast2sms","twitter_site":"@fast2sms","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fast2sms.com\/help\/whatsapp-webhook-google-sheets-apps-script\/#article","isPartOf":{"@id":"https:\/\/www.fast2sms.com\/help\/whatsapp-webhook-google-sheets-apps-script\/"},"author":{"@id":"https:\/\/www.fast2sms.com\/#organization"},"headline":"Save WhatsApp replies and delivery reports to Google Sheets","datePublished":"2026-11-18T18:50:41+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fast2sms.com\/help\/whatsapp-webhook-google-sheets-apps-script\/"},"wordCount":1063,"publisher":{"@id":"https:\/\/www.fast2sms.com\/#organization"},"image":{"@id":"https:\/\/www.fast2sms.com\/help\/whatsapp-webhook-google-sheets-apps-script\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/11\/webhook-create-event-menu-hd-4-scaled.webp","articleSection":["Integrations","Webhooks","WhatsApp"],"inLanguage":"en-IN"},{"@type":"WebPage","@id":"https:\/\/www.fast2sms.com\/help\/whatsapp-webhook-google-sheets-apps-script\/","url":"https:\/\/www.fast2sms.com\/help\/whatsapp-webhook-google-sheets-apps-script\/","name":"WhatsApp Webhook to Google Sheets (Apps Script) | Fast2SMS","isPartOf":{"@id":"https:\/\/www.fast2sms.com\/help\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fast2sms.com\/help\/whatsapp-webhook-google-sheets-apps-script\/#primaryimage"},"image":{"@id":"https:\/\/www.fast2sms.com\/help\/whatsapp-webhook-google-sheets-apps-script\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/11\/webhook-create-event-menu-hd-4-scaled.webp","datePublished":"2026-11-18T18:50:41+00:00","description":"Log WhatsApp replies and API delivery reports in Google Sheets with a Fast2SMS webhook and a short Apps Script web app. Script, setup steps and fixes.","breadcrumb":{"@id":"https:\/\/www.fast2sms.com\/help\/whatsapp-webhook-google-sheets-apps-script\/#breadcrumb"},"inLanguage":"en-IN","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fast2sms.com\/help\/whatsapp-webhook-google-sheets-apps-script\/"]}]},{"@type":"ImageObject","inLanguage":"en-IN","@id":"https:\/\/www.fast2sms.com\/help\/whatsapp-webhook-google-sheets-apps-script\/#primaryimage","url":"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/11\/webhook-create-event-menu-hd-4-scaled.webp","contentUrl":"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/11\/webhook-create-event-menu-hd-4-scaled.webp","width":2560,"height":1600,"caption":"Select Event list for a WhatsApp webhook with Default All Events, On Sent, On Delivered, On Read, On Failed and Incoming Messages"},{"@type":"BreadcrumbList","@id":"https:\/\/www.fast2sms.com\/help\/whatsapp-webhook-google-sheets-apps-script\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fast2sms.com\/help\/"},{"@type":"ListItem","position":2,"name":"Integrations","item":"https:\/\/www.fast2sms.com\/help\/integrations\/"},{"@type":"ListItem","position":3,"name":"Save WhatsApp replies and delivery reports to Google Sheets"}]},{"@type":"WebSite","@id":"https:\/\/www.fast2sms.com\/help\/#website","url":"https:\/\/www.fast2sms.com\/help\/","name":"Fast2SMS","description":"Help","publisher":{"@id":"https:\/\/www.fast2sms.com\/#organization"},"inLanguage":"en-IN"},{"@type":"Organization","@id":"https:\/\/www.fast2sms.com\/#organization","name":"Fast2SMS","url":"https:\/\/www.fast2sms.com\/","logo":{"@type":"ImageObject","@id":"https:\/\/www.fast2sms.com\/#logo","url":"https:\/\/www.fast2sms.com\/Fast2SMS.png","contentUrl":"https:\/\/www.fast2sms.com\/Fast2SMS.png","caption":"Fast2SMS"},"image":{"@id":"https:\/\/www.fast2sms.com\/#logo"},"email":"support@fast2sms.com","telephone":"+91-6262778822","sameAs":["https:\/\/www.facebook.com\/Fast2SMS","https:\/\/www.instagram.com\/fast2sms","https:\/\/x.com\/fast2sms","https:\/\/www.youtube.com\/Fast2SMSofficial","https:\/\/www.linkedin.com\/company\/fast2sms"]}]}},"_links":{"self":[{"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/posts\/19069","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/comments?post=19069"}],"version-history":[{"count":0,"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/posts\/19069\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/media\/19065"}],"wp:attachment":[{"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/media?parent=19069"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/categories?post=19069"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/tags?post=19069"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}