{"id":18008,"date":"2026-11-18T23:44:36","date_gmt":"2026-11-18T18:14:36","guid":{"rendered":"https:\/\/www.fast2sms.com\/help\/google-sheets-send-sms-apps-script\/"},"modified":"2026-11-19T02:03:15","modified_gmt":"2026-11-18T20:33:15","slug":"google-sheets-send-sms-apps-script","status":"publish","type":"post","link":"https:\/\/www.fast2sms.com\/help\/google-sheets-send-sms-apps-script\/","title":{"rendered":"Send SMS from Google Sheets with Apps Script and the Fast2SMS API"},"content":{"rendered":"<p>You can send SMS from Google Sheets with the Fast2SMS API and a short Apps Script. Each row in your sheet (name, mobile, order number and so on) becomes a DLT SMS from your own sender ID, and the script writes the request ID and the delivery status back into the sheet. This guide is for shop owners, schools and small teams who keep their lists in Google Sheets and are comfortable pasting a script. No server is needed.<\/p>\n<aside class=\"f2s-cta\" aria-label=\"Get started with Fast2SMS\"><div class=\"f2s-cta__copy\"><strong class=\"f2s-cta__title\">Send SMS from your Google Sheet<\/strong><p>Add your DLT template in Fast2SMS, paste the script and send personalised SMS from your rows.<\/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<div class=\"f2s-note\">Prefer no code at all? The Fast2SMS add-on for Google Sheets lets you send from the sidebar (see Related guides). Use the script in this guide when you want full control: your own columns, a menu button, scheduled sends and delivery status in the sheet.<\/div>\n<h2>Before you start<\/h2>\n<ul>\n<li><strong>A Google account<\/strong> and a Google Sheet with your contacts.<\/li>\n<li><strong>API key<\/strong> from <strong>API Key<\/strong> under UTILITY, with <strong>API Access<\/strong> on.<\/li>\n<li><strong>An approved DLT template<\/strong> added in <strong>DLT Manager<\/strong>, with its <strong>Message ID<\/strong> and <strong>Sender ID<\/strong>.<\/li>\n<li><strong>Wallet balance<\/strong> for the number of SMS you plan to send.<\/li>\n<li><strong>Share the sheet carefully.<\/strong> Anyone who can edit the sheet can edit the script. The key is stored in Script Properties, not in a cell, but editors can still run the script.<\/li>\n<\/ul>\n<h2>Get your key and template IDs<\/h2>\n<ol class=\"f2s-steps\">\n<li>\n<h3>Copy the API key<\/h3>\n<p>In Fast2SMS open <strong>Account Setting<\/strong>, <strong>API Key<\/strong>. Click <strong>View<\/strong>, enter the OTP sent to your account mobile and copy the <strong>Authorization Key<\/strong>.<\/p>\n<figure class=\"f2s-shot\"><img src=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/11\/api-key-hd-8-scaled.webp\" width=\"1440\" height=\"900\" loading=\"lazy\" decoding=\"async\" alt=\"API Key page with masked Authorization Key, View and Reset buttons and the API Access switch turned on\"><figcaption>You will paste this into Script Properties, not into the sheet.<\/figcaption><\/figure>\n<\/li>\n<li>\n<h3>Copy the Message ID and Sender ID<\/h3>\n<p>Open <strong>DLT Manager<\/strong>, <strong>Content Template<\/strong>. On the approved template card, copy the <strong>Message ID<\/strong> and the <strong>Sender ID<\/strong>. Count the <code>{#var#}<\/code> places in the text; you need one sheet column for each.<\/p>\n<figure class=\"f2s-shot\"><img src=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/11\/sms-dlt-template-list-hd-11-scaled.webp\" width=\"1440\" height=\"900\" loading=\"lazy\" decoding=\"async\" alt=\"Approved DLT template cards with the template text, Message ID, Sender ID, Template ID and Entity\"><figcaption>The variables in the template become columns in your sheet.<\/figcaption><\/figure>\n<\/li>\n<li>\n<h3>Optional: download the API Excel<\/h3>\n<p>Under <strong>API Excel<\/strong>, the <strong>SMS<\/strong> tab has <strong>Download Excel<\/strong>. The file lists your approved DLT templates with sender IDs and sample API URLs, which is handy to check the Message IDs.<\/p>\n<figure class=\"f2s-shot\"><img src=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/11\/api-excel-sms-hd-2-scaled.webp\" width=\"1440\" height=\"900\" loading=\"lazy\" decoding=\"async\" alt=\"API Excel page with channel tabs SMS, WhatsApp, RCS, Smart OTP and Voice and the SMS DLT API Excel card with a Download Excel button\"><figcaption>The sample URLs in this file carry your key, so keep the file private.<\/figcaption><\/figure>\n<\/li>\n<\/ol>\n<h2>Prepare the sheet<\/h2>\n<p>Name the tab <strong>SMS<\/strong> and use these columns in row 1. The example template is Message ID 10001 on sender DEMOTR: &#8220;Dear {#var#}, your order {#var#} of Rs.{#var#} is confirmed and will be delivered by {#var#}. &#8211; Demo Traders&#8221;.<\/p>\n<div class=\"f2s-facts\">\n<table>\n<thead>\n<tr>\n<th>A<\/th>\n<th>B<\/th>\n<th>C<\/th>\n<th>D<\/th>\n<th>E<\/th>\n<th>F<\/th>\n<th>G<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Name<\/td>\n<td>Mobile<\/td>\n<td>Order<\/td>\n<td>Amount<\/td>\n<td>Delivery date<\/td>\n<td><a href=\"\/help\/sms-request-id-find-message\/\">Request ID<\/a><\/td>\n<td>Status<\/td>\n<\/tr>\n<tr>\n<td>Rahul<\/td>\n<td>9999999999<\/td>\n<td>DT10458<\/td>\n<td>1240<\/td>\n<td>21 Nov<\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>Columns A and C to E fill the four variables in order. The script fills F and G. Format column B as plain text so Sheets does not change long numbers.<\/p>\n<h2>Add the script<\/h2>\n<ol>\n<li>In the sheet, open <strong>Extensions<\/strong>, then <strong>Apps Script<\/strong>.<\/li>\n<li>Open <strong>Project Settings<\/strong> (gear icon), scroll to <strong>Script Properties<\/strong> and add a property named <code>FAST2SMS_API_KEY<\/code> with your key as the value.<\/li>\n<li>Back in the editor, replace the code in <code>Code.gs<\/code> with the full script below and click Save.<\/li>\n<li>Reload the sheet. A <strong>Fast2SMS<\/strong> menu appears. The first run asks you to allow the script to use the sheet and connect to an external service.<\/li>\n<\/ol>\n<h2>Full copy-paste script: Code.gs<\/h2>\n<pre><code class=\"language-javascript\">\/\/ Fast2SMS: send DLT SMS from Google Sheets and read delivery status\nconst SHEET_NAME = 'SMS';\nconst SENDER_ID = 'DEMOTR';       \/\/ your approved sender ID, exact case\nconst MESSAGE_ID = '10001';       \/\/ Message ID from DLT Manager\nconst VAR_COLUMNS = [1, 3, 4, 5]; \/\/ columns (1 = A) that fill {#var#} in order\nconst MOBILE_COL = 2;             \/\/ B\nconst REQ_COL = 6;                \/\/ F\nconst STATUS_COL = 7;             \/\/ G\n\nfunction onOpen() {\n  SpreadsheetApp.getUi().createMenu('Fast2SMS')\n    .addItem('Send to rows without a Request ID', 'sendPending')\n    .addItem('Update delivery status', 'updateStatus')\n    .addToUi();\n}\n\nfunction apiKey_() {\n  const key = PropertiesService.getScriptProperties().getProperty('FAST2SMS_API_KEY');\n  if (&#33;key) throw new Error('Add FAST2SMS_API_KEY in Project Settings &gt; Script Properties');\n  return key;\n}\n\nfunction call_(method, path, body) {\n  const options = {\n    method: method,\n    headers: { authorization: apiKey_() },\n    muteHttpExceptions: true,\n  };\n  if (body) {\n    options.contentType = 'application\/json';\n    options.payload = JSON.stringify(body);\n  }\n  const res = UrlFetchApp.fetch('https:\/\/www.fast2sms.com' + path, options);\n  let data = {};\n  try { data = JSON.parse(res.getContentText()); } catch (e) { data = { message: 'Non-JSON response' }; }\n  return { http: res.getResponseCode(), data: data };\n}\n\nfunction cleanMobile_(value) {\n  let d = String(value).replace(\/\\D\/g, '');\n  if (d.length &gt; 10 &amp;&amp; d.startsWith('91')) d = d.slice(2);\n  return \/^[6-9]\\d{9}$\/.test(d) ? d : '';\n}\n\nfunction sendPending() {\n  const sheet = SpreadsheetApp.getActive().getSheetByName(SHEET_NAME);\n  const rows = sheet.getDataRange().getValues();\n  let sent = 0, failed = 0;\n\n  for (let i = 1; i &lt; rows.length; i++) {          \/\/ skip the header row\n    const row = rows[i];\n    if (row[REQ_COL - 1]) continue;                 \/\/ already sent\n    const mobile = cleanMobile_(row[MOBILE_COL - 1]);\n    if (&#33;mobile) {\n      sheet.getRange(i + 1, STATUS_COL).setValue('Invalid number');\n      failed++;\n      continue;\n    }\n    const vars = VAR_COLUMNS.map(c =&gt; String(row[c - 1]).replace(\/\\|\/g, ' ').slice(0, 40));\n    const r = call_('post', '\/dev\/bulkV2', {\n      route: 'dlt',\n      sender_id: SENDER_ID,\n      message: MESSAGE_ID,\n      variables_values: vars.join('|'),\n      numbers: mobile,\n      udf1: 'sheet-row-' + (i + 1),\n    });\n\n    if (r.data.return === true) {\n      sheet.getRange(i + 1, REQ_COL).setValue(r.data.request_id);\n      sheet.getRange(i + 1, STATUS_COL).setValue('Queued');\n      sent++;\n    } else {\n      const msg = Array.isArray(r.data.message) ? r.data.message.join(' ') : r.data.message;\n      sheet.getRange(i + 1, STATUS_COL).setValue('Error ' + (r.data.status_code || r.http) + ': ' + msg);\n      failed++;\n      \/\/ Stop on account-level errors so every row does not fail the same way\n      if ([412, 413, 414, 416].includes(Number(r.data.status_code))) break;\n    }\n  }\n  SpreadsheetApp.getActive().toast('Queued: ' + sent + ', not sent: ' + failed, 'Fast2SMS');\n}\n\nfunction updateStatus() {\n  const sheet = SpreadsheetApp.getActive().getSheetByName(SHEET_NAME);\n  const rows = sheet.getDataRange().getValues();\n\n  for (let i = 1; i &lt; rows.length; i++) {\n    const requestId = rows[i][REQ_COL - 1];\n    const status = String(rows[i][STATUS_COL - 1]);\n    if (&#33;requestId || status === 'Delivered' || status === 'Failed') continue;\n\n    const r = call_('get', '\/dev\/dlr\/' + encodeURIComponent(requestId));\n    if (r.data.success &amp;&amp; r.data.data &amp;&amp; r.data.data[0]) {\n      const d = r.data.data[0].delivery_status[0];\n      sheet.getRange(i + 1, STATUS_COL).setValue(d.status);   \/\/ Delivered, Failed or Sent\n    }\n  }\n}<\/code><\/pre>\n<h2>Send and check the results<\/h2>\n<ol>\n<li>Add a test row with your own mobile number and click <strong>Fast2SMS<\/strong>, <strong>Send to rows without a Request ID<\/strong>.<\/li>\n<li>Column F gets a request ID that starts with S, and column G says Queued. Queued means Fast2SMS accepted the SMS, not that it reached the phone.<\/li>\n<li>After a few minutes, click <strong>Update delivery status<\/strong>. Column G changes to Delivered, Failed or Sent (operator report still pending). The delivery report API looks back 7 days.<\/li>\n<li>Rows that already have a request ID are skipped, so you can add new rows and run the menu again without sending twice.<\/li>\n<\/ol>\n<aside class=\"f2s-cta\" aria-label=\"Get started with Fast2SMS\"><div class=\"f2s-cta__copy\"><strong class=\"f2s-cta__title\">Turn your sheet into an SMS tool<\/strong><p>Use your approved DLT templates and send order updates, fee reminders or alerts straight from 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>Run it automatically<\/h2>\n<p>In the Apps Script editor, open <strong>Triggers<\/strong> (clock icon) and add a time-driven trigger:<\/p>\n<ul>\n<li><code>sendPending<\/code> every hour or every day, if other people or forms add rows to the sheet.<\/li>\n<li><code>updateStatus<\/code> every hour to keep the Status column fresh.<\/li>\n<\/ul>\n<p>A Google Form that writes to this sheet plus an hourly trigger gives you an automatic &#8220;thank you&#8221; or confirmation SMS, using an approved template.<\/p>\n<h2>Things to know<\/h2>\n<ul>\n<li><strong>Variables:<\/strong> each value is cut to 40 characters, and the script replaces any <code>|<\/code> in a cell with a space because <code>|<\/code> separates variables.<\/li>\n<li><strong>Charges:<\/strong> each SMS is charged at your plan rate times the SMS parts. Failed DLT SMS are not refunded automatically. See the current rates on the <a href=\"https:\/\/www.fast2sms.com\/bulk-sms-pricing\">bulk SMS pricing page<\/a>.<\/li>\n<li><strong>Promotional templates:<\/strong> if the template is promotional or the sender is numeric, SMS sent late in the evening or at night are held until the next morning.<\/li>\n<li><strong>Large lists:<\/strong> Apps Script has a time limit per run and daily quotas for URL fetches (see Google&#8217;s Apps Script quotas page). For thousands of rows, run the menu again (sent rows are skipped), or send the same text to many numbers in one call by joining them with commas in <code>numbers<\/code>.<\/li>\n<li><strong>Webhooks:<\/strong> for a sheet, the <strong>Update delivery status<\/strong> button is simpler than a webhook. Do not use both for the same messages, because reading the report by API can stop the webhook for those rows.<\/li>\n<\/ul>\n<h2>Can I send or verify OTP from Google Sheets?<\/h2>\n<p>Sheets is the wrong place for login OTPs, because OTP is part of your app&#8217;s sign-in flow. If you build a small form as an Apps Script web app, the same <code>call_<\/code> function works for <a href=\"\/help\/smart-otp-setup-guide-fast2sms\/\">Smart OTP<\/a>:<\/p>\n<pre><code class=\"language-javascript\">function sendOtp(mobile) {\n  return call_('post', '\/dev\/otp\/send', { mobile: cleanMobile_(mobile), otp_id: 'YOUR_OTP_ID', otp_expiry: 5 });\n}\n\nfunction verifyOtp(mobile, otp) {\n  const r = call_('post', '\/dev\/otp\/verify', { mobile: cleanMobile_(mobile), otp: String(otp).trim() });\n  return r.data.return === true;   \/\/ false: Invalid OTP, OTP expired, ...\n}<\/code><\/pre>\n<p>Verify checks the latest unverified OTP for that mobile; no OTP ID is needed. Keep these functions on the server side of the web app (<code>google.script.run<\/code>), never in the HTML page.<\/p>\n<h2>Errors you may see in the Status column<\/h2>\n<div class=\"f2s-facts\">\n<table>\n<thead>\n<tr>\n<th>Status text<\/th>\n<th>Fix<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><a href=\"\/help\/error-412-invalid-authentication\/\">Error 412<\/a>: Invalid Authentication, Check Authorization Key<\/td>\n<td>The key in Script Properties is wrong or was reset. Paste the current key.<\/td>\n<\/tr>\n<tr>\n<td><a href=\"\/help\/error-413-key-disabled\/\">Error 413<\/a>: Authorization Key Disabled<\/td>\n<td>Turn <strong>API Access<\/strong> on.<\/td>\n<\/tr>\n<tr>\n<td><a href=\"\/help\/error-414-ip-blacklisted\/\">Error 414<\/a>: IP is blacklisted from Dev API section<\/td>\n<td>API Security is on. Google&#8217;s servers use many changing IPs, so turn API Security off for this use, or send from your own server instead.<\/td>\n<\/tr>\n<tr>\n<td><a href=\"\/help\/error-406-invalid-sender-id\/\">Error 406<\/a>: Invalid Sender ID<\/td>\n<td>Fix <code>SENDER_ID<\/code>; it must match <a href=\"\/help\/dlt-manager-entity-sender-template-guide\/\">DLT Manager<\/a> exactly, including case.<\/td>\n<\/tr>\n<tr>\n<td><a href=\"\/help\/error-424-invalid-message-id\/\">Error 424<\/a>: Invalid Message ID<\/td>\n<td>Use the Message ID (not the 19-digit Template ID) linked to that sender.<\/td>\n<\/tr>\n<tr>\n<td><a href=\"\/help\/error-416-insufficient-balance\/\">Error 416<\/a>: You don&#8217;t have sufficient wallet balance<\/td>\n<td>Recharge and run the menu again.<\/td>\n<\/tr>\n<tr>\n<td><a href=\"\/help\/error-411-invalid-numbers\/\">Error 411<\/a>: Invalid Numbers<\/td>\n<td>The mobile is not a 10-digit Indian number starting with 6 to 9.<\/td>\n<\/tr>\n<tr>\n<td>Invalid number<\/td>\n<td>The script skipped the row before calling the API. Fix the number.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<h2>Common problems and fixes<\/h2>\n<ul>\n<li><strong>No Fast2SMS menu:<\/strong> reload the sheet. Check that the function is named exactly <code>onOpen<\/code>.<\/li>\n<li><strong>&#8220;Add FAST2SMS_API_KEY&#8230;&#8221; error:<\/strong> the Script Property is missing or misspelled.<\/li>\n<li><strong>Numbers show as 9.99E+09:<\/strong> format the Mobile column as plain text before pasting numbers.<\/li>\n<li><strong>Same person got two SMS:<\/strong> the Request ID cell was cleared, or the row was copied with an empty Request ID. Do not clear column F after sending.<\/li>\n<li><strong>Status stays Sent:<\/strong> the operator has not reported yet. Run <strong>Update delivery status<\/strong> again later.<\/li>\n<\/ul>\n<section class=\"f2s-faq\">\n<h2>Frequently asked questions<\/h2>\n<h3>Is it free to send SMS from Google Sheets?<\/h3>\n<p>The script is free. Each SMS is charged from your Fast2SMS wallet at your plan rate.<\/p>\n<h3>Do I need DLT to send from Sheets?<\/h3>\n<p>Yes, for SMS from your own sender ID in India. The script uses your approved DLT template through its Message ID.<\/p>\n<h3>Can I use the API URL in a cell formula instead?<\/h3>\n<p>Not recommended. A URL with <code>authorization=<\/code> in it exposes your key to everyone who can see the sheet, and formulas can recalculate and send again. Use the script with Script Properties.<\/p>\n<h3>Can I send different templates from one sheet?<\/h3>\n<p>Yes. Add a Message ID column and read it per row instead of the fixed <code>MESSAGE_ID<\/code>. All templates must be linked to the sender you use.<\/p>\n<h3>Can I send WhatsApp messages from Google Sheets?<\/h3>\n<p>Yes, with the Fast2SMS add-on for Google Sheets, or with the WhatsApp API and an approved WhatsApp template.<\/p>\n<h3>Will Hindi templates work?<\/h3>\n<p>Yes. Apps Script sends UTF-8, and the language is detected from your approved template.<\/p>\n<\/section>\n<aside class=\"f2s-cta\" aria-label=\"Get started with Fast2SMS\"><div class=\"f2s-cta__copy\"><strong class=\"f2s-cta__title\">Start sending from Google Sheets<\/strong><p>Sign up, add your DLT template and paste the script to send SMS from your rows.<\/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=\"https:\/\/www.fast2sms.com\/help\/fast2sms-integration-for-google-sheets\/\">Fast2SMS add-on for Google Sheets<\/a><\/li>\n<li><a href=\"\/help\/dlt-sms-api-guide\/\">Fast2SMS DLT SMS API: send SMS with your DLT template<\/a><\/li>\n<li><a href=\"\/help\/dlt-sms-variables-values\/\">How to pass variables_values in the DLT SMS API<\/a><\/li>\n<li><a href=\"\/help\/send-bulk-sms-from-excel-fast2sms\/\">Send bulk SMS from an Excel file in Fast2SMS<\/a><\/li>\n<li><a href=\"\/help\/sms-delivery-report-status-meaning\/\">SMS delivery report in Fast2SMS: every status explained<\/a><\/li>\n<li><a href=\"https:\/\/www.fast2sms.com\/bulk-sms\">Fast2SMS Bulk SMS<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>You can send SMS from Google Sheets with the Fast2SMS API and a short Apps Script. Each row in your sheet (name, mobile, order number and so on) becomes a DLT SMS from your own sender ID, and the script writes the request ID and the delivery status back into the sheet. This guide is [&hellip;]<\/p>\n","protected":false},"featured_media":17999,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,13,25],"tags":[],"class_list":["post-18008","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-api","category-bulk-sms","category-integrations"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Send SMS from Google Sheets with Apps Script | Fast2SMS<\/title>\n<meta name=\"description\" content=\"Send personalised DLT SMS from Google Sheets with a copy-paste Apps Script and the Fast2SMS API. Menu button, request IDs, delivery status and errors.\" \/>\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\/google-sheets-send-sms-apps-script\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Send SMS from Google Sheets with Apps Script | Fast2SMS\" \/>\n<meta property=\"og:description\" content=\"Send personalised DLT SMS from Google Sheets with a copy-paste Apps Script and the Fast2SMS API. Menu button, request IDs, delivery status and errors.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fast2sms.com\/help\/google-sheets-send-sms-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:14:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-11-18T20:33:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/11\/api-key-hd-8-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\\\/google-sheets-send-sms-apps-script\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/google-sheets-send-sms-apps-script\\\/\"},\"author\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/#organization\"},\"headline\":\"Send SMS from Google Sheets with Apps Script and the Fast2SMS API\",\"datePublished\":\"2026-11-18T18:14:36+00:00\",\"dateModified\":\"2026-11-18T20:33:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/google-sheets-send-sms-apps-script\\\/\"},\"wordCount\":1490,\"publisher\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/google-sheets-send-sms-apps-script\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/api-key-hd-8-scaled.webp\",\"articleSection\":[\"API\",\"Bulk SMS\",\"Integrations\"],\"inLanguage\":\"en-IN\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/google-sheets-send-sms-apps-script\\\/\",\"url\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/google-sheets-send-sms-apps-script\\\/\",\"name\":\"Send SMS from Google Sheets with Apps Script | Fast2SMS\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/google-sheets-send-sms-apps-script\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/google-sheets-send-sms-apps-script\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/api-key-hd-8-scaled.webp\",\"datePublished\":\"2026-11-18T18:14:36+00:00\",\"dateModified\":\"2026-11-18T20:33:15+00:00\",\"description\":\"Send personalised DLT SMS from Google Sheets with a copy-paste Apps Script and the Fast2SMS API. Menu button, request IDs, delivery status and errors.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/google-sheets-send-sms-apps-script\\\/#breadcrumb\"},\"inLanguage\":\"en-IN\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/google-sheets-send-sms-apps-script\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-IN\",\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/google-sheets-send-sms-apps-script\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/api-key-hd-8-scaled.webp\",\"contentUrl\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/api-key-hd-8-scaled.webp\",\"width\":2560,\"height\":1600,\"caption\":\"API Key page with masked Authorization Key, View and Reset buttons and the API Access switch turned on\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/google-sheets-send-sms-apps-script\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"API\",\"item\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/api\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Send SMS from Google Sheets with Apps Script and the Fast2SMS API\"}]},{\"@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":"Send SMS from Google Sheets with Apps Script | Fast2SMS","description":"Send personalised DLT SMS from Google Sheets with a copy-paste Apps Script and the Fast2SMS API. Menu button, request IDs, delivery status and errors.","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\/google-sheets-send-sms-apps-script\/","og_locale":"en_US","og_type":"article","og_title":"Send SMS from Google Sheets with Apps Script | Fast2SMS","og_description":"Send personalised DLT SMS from Google Sheets with a copy-paste Apps Script and the Fast2SMS API. Menu button, request IDs, delivery status and errors.","og_url":"https:\/\/www.fast2sms.com\/help\/google-sheets-send-sms-apps-script\/","og_site_name":"Fast2SMS","article_publisher":"https:\/\/www.facebook.com\/Fast2SMS\/","article_published_time":"2026-11-18T18:14:36+00:00","article_modified_time":"2026-11-18T20:33:15+00:00","og_image":[{"width":2560,"height":1600,"url":"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/11\/api-key-hd-8-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\/google-sheets-send-sms-apps-script\/#article","isPartOf":{"@id":"https:\/\/www.fast2sms.com\/help\/google-sheets-send-sms-apps-script\/"},"author":{"@id":"https:\/\/www.fast2sms.com\/#organization"},"headline":"Send SMS from Google Sheets with Apps Script and the Fast2SMS API","datePublished":"2026-11-18T18:14:36+00:00","dateModified":"2026-11-18T20:33:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fast2sms.com\/help\/google-sheets-send-sms-apps-script\/"},"wordCount":1490,"publisher":{"@id":"https:\/\/www.fast2sms.com\/#organization"},"image":{"@id":"https:\/\/www.fast2sms.com\/help\/google-sheets-send-sms-apps-script\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/11\/api-key-hd-8-scaled.webp","articleSection":["API","Bulk SMS","Integrations"],"inLanguage":"en-IN"},{"@type":"WebPage","@id":"https:\/\/www.fast2sms.com\/help\/google-sheets-send-sms-apps-script\/","url":"https:\/\/www.fast2sms.com\/help\/google-sheets-send-sms-apps-script\/","name":"Send SMS from Google Sheets with Apps Script | Fast2SMS","isPartOf":{"@id":"https:\/\/www.fast2sms.com\/help\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fast2sms.com\/help\/google-sheets-send-sms-apps-script\/#primaryimage"},"image":{"@id":"https:\/\/www.fast2sms.com\/help\/google-sheets-send-sms-apps-script\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/11\/api-key-hd-8-scaled.webp","datePublished":"2026-11-18T18:14:36+00:00","dateModified":"2026-11-18T20:33:15+00:00","description":"Send personalised DLT SMS from Google Sheets with a copy-paste Apps Script and the Fast2SMS API. Menu button, request IDs, delivery status and errors.","breadcrumb":{"@id":"https:\/\/www.fast2sms.com\/help\/google-sheets-send-sms-apps-script\/#breadcrumb"},"inLanguage":"en-IN","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fast2sms.com\/help\/google-sheets-send-sms-apps-script\/"]}]},{"@type":"ImageObject","inLanguage":"en-IN","@id":"https:\/\/www.fast2sms.com\/help\/google-sheets-send-sms-apps-script\/#primaryimage","url":"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/11\/api-key-hd-8-scaled.webp","contentUrl":"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/11\/api-key-hd-8-scaled.webp","width":2560,"height":1600,"caption":"API Key page with masked Authorization Key, View and Reset buttons and the API Access switch turned on"},{"@type":"BreadcrumbList","@id":"https:\/\/www.fast2sms.com\/help\/google-sheets-send-sms-apps-script\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fast2sms.com\/help\/"},{"@type":"ListItem","position":2,"name":"API","item":"https:\/\/www.fast2sms.com\/help\/api\/"},{"@type":"ListItem","position":3,"name":"Send SMS from Google Sheets with Apps Script and the Fast2SMS API"}]},{"@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\/18008","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=18008"}],"version-history":[{"count":2,"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/posts\/18008\/revisions"}],"predecessor-version":[{"id":20010,"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/posts\/18008\/revisions\/20010"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/media\/17999"}],"wp:attachment":[{"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/media?parent=18008"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/categories?post=18008"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/tags?post=18008"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}