{"id":19681,"date":"2026-11-19T01:29:18","date_gmt":"2026-11-18T19:59:18","guid":{"rendered":"https:\/\/www.fast2sms.com\/help\/otp-widget-google-sheets-form-fast2sms\/"},"modified":"2026-11-19T01:29:18","modified_gmt":"2026-11-18T19:59:18","slug":"otp-widget-google-sheets-form-fast2sms","status":"publish","type":"post","link":"https:\/\/www.fast2sms.com\/help\/otp-widget-google-sheets-form-fast2sms\/","title":{"rendered":"OTP-verified form that saves to Google Sheets, no website needed (Fast2SMS)"},"content":{"rendered":"<p>Need a lead or enquiry form where every phone number is real, but have no website or server? This kit builds a form on Google Apps Script that verifies the visitor&#8217;s mobile number with an OTP (SMS or WhatsApp) and saves each entry to a Google Sheet. Google hosts the page and the code. You share the link, or embed the form in any site with an iframe.<\/p>\n<aside class=\"f2s-cta\" aria-label=\"Get started with Fast2SMS\"><div class=\"f2s-cta__copy\"><strong class=\"f2s-cta__title\">Collect verified phone numbers in Google Sheets<\/strong><p>Create a Smart OTP template, paste the script into your Sheet and share the form link.<\/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<p class=\"f2s-kit-wrap\"><a class=\"f2s-kit\" href=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/11\/fast2sms-otp-widget-google-apps-script.zip\" download><svg class=\"f2s-kit__icon\" width=\"28\" height=\"28\" viewBox=\"0 0 24 24\" aria-hidden=\"true\"><path fill=\"#7F56D9\" d=\"M6 2h8l6 6v12a2 2 0 0 1-2 2H6a2 2 0 0 1-2-2V4a2 2 0 0 1 2-2z\"\/><path fill=\"#FFFFFF\" d=\"M14 2v6h6\"\/><path fill=\"#FFFFFF\" d=\"M9 6h2v2H9zm2 2h2v2h-2zM9 10h2v2H9zm2 2h2v2h-2zm-2 2h4v4H9z\"\/><rect x=\"10\" y=\"15.4\" width=\"2\" height=\"1.6\" fill=\"#7F56D9\"\/><\/svg><span class=\"f2s-kit__text\"><strong>Download the Google Sheets form OTP widget kit (zip)<\/strong><span class=\"f2s-kit__meta\">fast2sms-otp-widget-google-apps-script.zip &middot; 26 KB<\/span><\/span><span class=\"f2s-kit__btn\">Download .zip<\/span><\/a><\/p>\n<div class=\"f2s-note f2s-note--warn\"><strong>Partly tested.<\/strong> We ran <code>Code.gs<\/code> and the form page in Node.js with stand-ins for the Apps Script services, against a mock copy of the Fast2SMS API, and drove the page in Chrome: 17 of 17 checks passed. It has not been run on Google&#8217;s servers yet, so real quotas and permission prompts were not tested. Test it with your own number before you share it.<\/div>\n<h2>What you get<\/h2>\n<ul>\n<li>A form page (by default: name, email, message and mobile number) with the OTP widget built in.<\/li>\n<li>A new row in your Sheet for each submission: the time, the <strong>verified<\/strong> mobile number and the form fields.<\/li>\n<li>Your Fast2SMS API key in Script Properties, which visitors cannot see.<\/li>\n<\/ul>\n<h2>Before you start<\/h2>\n<ul>\n<li>A Fast2SMS account with wallet balance, and an approved DLT OTP template (SMS) or WhatsApp Authentication\/Utility template.<\/li>\n<li>A Google account.<\/li>\n<\/ul>\n<h2>Set up the OTP form in Google Sheets<\/h2>\n<ol class=\"f2s-steps\">\n<li>\n<h3>Create a Smart OTP template and copy its OTP ID<\/h3>\n<p>In the panel, open <strong>Smart OTP<\/strong> &gt; <strong>OTP Template List<\/strong> and click <strong>Add OTP Template<\/strong>. On the <strong>SMS Channel<\/strong> tab, pick your DLT entity, sender and approved OTP template, then click the variable that should carry the code. For WhatsApp, use the <strong>WhatsApp Channel<\/strong> tab with an approved Authentication or Utility template. Tick <strong>SET FALLBACK TEMPLATE<\/strong> if you want the other channel as a backup, then click <strong>Assign OTP Template<\/strong>.<\/p>\n<p>Copy the 10-character <strong>OTP ID<\/strong> from the new card. It decides the channel, the template and the fallback for every code the widget sends. Before you build the form, use <strong>Test OTP<\/strong> on the card to check that the template reaches your phone.<\/p>\n<figure class=\"f2s-shot\"><img src=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/11\/smart-otp-template-list-hd-31-scaled.webp\" width=\"1440\" height=\"900\" loading=\"lazy\" decoding=\"async\" alt=\"Smart OTP Template list with SMS and WhatsApp template cards, each showing its OTP ID with a copy icon\"><figcaption>Each template card shows its 10-character OTP ID with a copy icon.<\/figcaption><\/figure>\n<\/li>\n<li>\n<h3>Copy your API key<\/h3>\n<p>Under <strong>Utility<\/strong> in the left menu, click <strong>API Key<\/strong>. Click <strong>View<\/strong> (the panel first asks for an OTP sent to your registered mobile) and copy the <strong>Authorization Key<\/strong>. Check that <strong>API Access<\/strong> is switched on. This key will live only in your backend&#8217;s settings, never in a page or an app.<\/p>\n<figure class=\"f2s-shot\"><img src=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/11\/api-key-hd-33-scaled.webp\" width=\"1440\" height=\"900\" loading=\"lazy\" decoding=\"async\" alt=\"API Key page with the masked Authorization Key, View and Reset buttons and the API Access switch turned on\"><figcaption>Copy the Authorization Key. API Access must be on.<\/figcaption><\/figure>\n<\/li>\n<li>\n<h3>Paste the code into a Sheet<\/h3>\n<p>Create a Google Sheet, then open <strong>Extensions<\/strong> &gt; <strong>Apps Script<\/strong>.<\/p>\n<ul>\n<li>Replace the contents of <code>Code.gs<\/code> with the kit&#8217;s <code>Code.gs<\/code>.<\/li>\n<li>Add two HTML files (<strong>+<\/strong> &gt; <strong>HTML<\/strong>) named <code>Index<\/code> and <code>Widget<\/code>, and paste in <code>Index.html<\/code> and <code>Widget.html<\/code>.<\/li>\n<li>In <strong>Project Settings<\/strong>, tick <strong>Show &#8220;appsscript.json&#8221; manifest file in editor<\/strong>, then paste the kit&#8217;s <code>appsscript.json<\/code>.<\/li>\n<\/ul>\n<\/li>\n<li>\n<h3>Make a secret and fill in Script Properties<\/h3>\n<p>Select the function <code>makeSecret<\/code> and click <strong>Run<\/strong> once. Copy the value it prints in the execution log.<\/p>\n<p>In <strong>Project Settings<\/strong> &gt; <strong>Script Properties<\/strong>, add:<\/p>\n<ul>\n<li><code>FAST2SMS_API_KEY<\/code>: your API key<\/li>\n<li><code>F2S_OTP_ID<\/code>: your OTP ID<\/li>\n<li><code>F2S_TOKEN_SECRET<\/code>: the value from <code>makeSecret<\/code><\/li>\n<li>optional: <code>FORM_TITLE<\/code> (default &#8220;Contact us&#8221;) and <code>SHEET_NAME<\/code> (default &#8220;Responses&#8221;)<\/li>\n<\/ul>\n<p>Do not type the key into the code. Script Properties stay with the script and are not shown to visitors.<\/p>\n<\/li>\n<li>\n<h3>Deploy as a web app<\/h3>\n<p>Click <strong>Deploy<\/strong> &gt; <strong>New deployment<\/strong> &gt; <strong>Web app<\/strong>. Set <strong>Execute as: Me<\/strong> and <strong>Who has access: Anyone<\/strong>. Google asks you to allow two permissions: connecting to an external service (Fast2SMS) and editing your spreadsheet.<\/p>\n<\/li>\n<li>\n<h3>Share or embed the form<\/h3>\n<p>Copy the web app link that ends in <code>\/exec<\/code> and share it, or embed it in any site:<\/p>\n<pre><code class=\"language-html\">&lt;iframe src=\"https:\/\/script.google.com\/macros\/s\/YOUR_DEPLOYMENT_ID\/exec\"\n        style=\"width:100%;max-width:520px;height:720px;border:0\"&gt;&lt;\/iframe&gt;<\/code><\/pre>\n<\/li>\n<\/ol>\n<figure class=\"f2s-shot\"><img src=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/11\/smart-otp-test-modal-hd-2-scaled.webp\" width=\"1440\" height=\"900\" loading=\"lazy\" decoding=\"async\" alt=\"Test OTP window with the OTP ID filled in and a 10-digit mobile number, and the Send Test OTP button\"><figcaption>Test OTP sends a real, charged OTP to the number you type.<\/figcaption><\/figure>\n<aside class=\"f2s-cta\" aria-label=\"Get started with Fast2SMS\"><div class=\"f2s-cta__copy\"><strong class=\"f2s-cta__title\">Get your OTP ID<\/strong><p>Set up a Smart OTP template on SMS or WhatsApp, with fallback, and add it to Script Properties.<\/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>Change the form fields<\/h2>\n<p>Edit the fields in <code>Index.html<\/code>, and add each new field&#8217;s <code>name<\/code> to <code>FORM_FIELDS<\/code> in <code>Code.gs<\/code>. For example, to add a city:<\/p>\n<pre><code class=\"language-html\">&lt;label class=\"field\"&gt;City &lt;input name=\"city\" maxlength=\"100\"&gt;&lt;\/label&gt;<\/code><\/pre>\n<pre><code class=\"language-javascript\">\/\/ at the top of Code.gs: the form fields saved to the sheet, besides the verified mobile\nvar FORM_FIELDS = ['name', 'email', 'message', 'city'];<\/code><\/pre>\n<p>The header row (<code>Time<\/code>, <code>Mobile (verified)<\/code> and your field names) is written when the sheet is empty. After a change, create a new deployment version so visitors get the new form.<\/p>\n<h2>How it stays safe<\/h2>\n<ul>\n<li><strong>The mobile number comes from the token, not from the form.<\/strong> <code>submitForm()<\/code> saves a row only with a fresh, unused token from a correct OTP.<\/li>\n<li><strong>No public URL endpoint.<\/strong> The widget calls the script through <code>google.script.run<\/code>, so only this script&#8217;s own page can ask for an OTP.<\/li>\n<li><strong>Limits:<\/strong> Apps Script cannot see a visitor&#8217;s IP address, so instead of a per-IP limit there is a cap for the whole form, <code>F2S_LIMIT_GLOBAL<\/code> (200 sends per hour by default), next to the per-number limit (5 per hour) and the 30-second resend wait.<\/li>\n<li><strong>Spreadsheet safety:<\/strong> a value that starts with <code>=<\/code>, <code>+<\/code>, <code>-<\/code> or <code>@<\/code> is saved as text, so nobody can plant a formula in your sheet.<\/li>\n<li><strong>Logs<\/strong> in the Apps Script <strong>Executions<\/strong> page show masked numbers only, never the OTP or the key.<\/li>\n<\/ul>\n<div class=\"f2s-note\">Apps Script has daily quotas (for example on URL fetches and run time). A busy form may outgrow them; then move to a backend kit such as PHP or a Cloudflare Worker. Google&#8217;s calls also do not come from one fixed IP address, so IP whitelisting in <strong>API Security<\/strong> does not suit this kit.<\/div>\n<h2>Sending, resending and cost<\/h2>\n<p>A new code for a number cancels the older one. &#8220;Code sent&#8221; means Fast2SMS accepted it; delivery shows in <strong>Smart OTP<\/strong> &gt; <strong>Delivery Report<\/strong>.<\/p>\n<p><strong>Resend<\/strong> sends the same code again, it does not make a new one. Fast2SMS allows it within 10 minutes of the first send, and up to 5 sends to one number in that time, counting the first.<\/p>\n<p>Every send and every resend is charged at your Smart OTP rate, and a fallback message on the second channel is charged too. Verify is free. The <strong>Test OTP<\/strong> button on a template card is also a real, charged send. See the current rates on the <a href=\"https:\/\/www.fast2sms.com\/otp-sms\">OTP SMS page<\/a>.<\/p>\n<div class=\"f2s-note f2s-volume\"><p><strong>Sending in bulk?<\/strong> For high OTP volumes our team offers discounted rates. <a href=\"https:\/\/www.fast2sms.com\/meet\/\" target=\"_blank\" rel=\"noopener\">Talk to our team<\/a> or see <a href=\"https:\/\/www.fast2sms.com\/bulk-sms-pricing\">OTP pricing<\/a>.<\/p><\/div>\n<h2>Common problems and fixes<\/h2>\n<div class=\"f2s-facts\">\n<table>\n<thead>\n<tr>\n<th>What you see<\/th>\n<th>Why<\/th>\n<th>Fix<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>The form page shows an error instead of the form<\/td>\n<td>A Script Property is missing or wrong<\/td>\n<td>Check <code>FAST2SMS_API_KEY<\/code>, <code>F2S_OTP_ID<\/code> (10 characters) and <code>F2S_TOKEN_SECRET<\/code> (32 or more), then reload.<\/td>\n<\/tr>\n<tr>\n<td>Google says the app is not verified, or asks for permissions<\/td>\n<td>First run of a script under your account<\/td>\n<td>Review the two permissions (external requests and the spreadsheet) and allow them.<\/td>\n<\/tr>\n<tr>\n<td>&#8220;We could not send the code right now.&#8221;<\/td>\n<td>An account or setup problem<\/td>\n<td>Open <strong>Executions<\/strong> in Apps Script for the real reason, for example a wrong OTP ID or low balance.<\/td>\n<\/tr>\n<tr>\n<td>&#8220;Too many requests&#8221;<\/td>\n<td>The per-number limit or the whole-form cap was hit<\/td>\n<td>Wait an hour, or raise <code>F2S_LIMIT_PER_NUMBER<\/code> \/ <code>F2S_LIMIT_GLOBAL<\/code> in Script Properties.<\/td>\n<\/tr>\n<tr>\n<td>New fields are not saved<\/td>\n<td>The field is missing from <code>FORM_FIELDS<\/code>, or the deployment was not updated<\/td>\n<td>Add the field name to <code>FORM_FIELDS<\/code> and deploy a new version.<\/td>\n<\/tr>\n<tr>\n<td>The code never arrives<\/td>\n<td>Sent is not the same as delivered<\/td>\n<td>Check <strong>Smart OTP<\/strong> &gt; <strong>Delivery Report<\/strong>, and use <strong>Test OTP<\/strong> on the template card.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<section class=\"f2s-faq\">\n<h2>Frequently asked questions<\/h2>\n<h3>Can I verify phone numbers in a Google Form?<\/h3>\n<p>Google Forms cannot run an OTP step. This kit gives you a similar form page, hosted by Google Apps Script, that verifies the number with an OTP and writes each entry to your Google Sheet.<\/p>\n<h3>Do I need a website or hosting?<\/h3>\n<p>No. Google hosts the page and the script. You can share the <code>\/exec<\/code> link on its own, or embed it in a site with an iframe.<\/p>\n<h3>Can visitors see my API key?<\/h3>\n<p>No. The key is in Script Properties and is used only on Google&#8217;s side. The page never receives it.<\/p>\n<h3>Is there a limit on how many people can fill the form?<\/h3>\n<p>The kit caps OTP sends at 200 per hour for the whole form by default (<code>F2S_LIMIT_GLOBAL<\/code>), and Google has its own daily Apps Script quotas.<\/p>\n<h3>Can I send an SMS from the sheet too?<\/h3>\n<p>Yes, with a separate script. See <a href=\"\/help\/google-sheets-send-sms-apps-script\/\">Send SMS from Google Sheets with Apps Script<\/a>.<\/p>\n<h3>Is verify charged?<\/h3>\n<p>No. Each send and each resend is charged; verify is free.<\/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 with Fast2SMS Smart OTP<\/strong><p>Sign up and build a phone-verified form in Google Sheets today.<\/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\/google-sheets-send-sms-apps-script\/\">Send SMS from Google Sheets with Apps Script and the Fast2SMS API<\/a><\/li>\n<li><a href=\"\/help\/smart-otp-setup-guide-fast2sms\/\">Smart OTP in Fast2SMS: set up OTP on SMS and WhatsApp<\/a><\/li>\n<li><a href=\"\/help\/otp-verification-signup-form\/\">OTP verification for signup forms<\/a><\/li>\n<li><a href=\"\/help\/send-sms-from-website-form\/\">Send an SMS when someone fills your website form<\/a><\/li>\n<li><a href=\"\/help\/otp-not-received-checklist\/\">OTP not received? A checklist to find the cause<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Need a lead or enquiry form where every phone number is real, but have no website or server? This kit builds a form on Google Apps Script that verifies the visitor&#8217;s mobile number with an OTP (SMS or WhatsApp) and saves each entry to a Google Sheet. Google hosts the page and the code. You [&hellip;]<\/p>\n","protected":false},"featured_media":19646,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,25,5],"tags":[],"class_list":["post-19681","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-api","category-integrations","category-otp"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>OTP Verified Form That Saves to Google Sheets | Fast2SMS<\/title>\n<meta name=\"description\" content=\"Build a phone-verified form with Google Apps Script: visitors confirm their number by OTP and every entry lands in your Google Sheet. No server needed.\" \/>\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\/otp-widget-google-sheets-form-fast2sms\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"OTP Verified Form That Saves to Google Sheets | Fast2SMS\" \/>\n<meta property=\"og:description\" content=\"Build a phone-verified form with Google Apps Script: visitors confirm their number by OTP and every entry lands in your Google Sheet. No server needed.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fast2sms.com\/help\/otp-widget-google-sheets-form-fast2sms\/\" \/>\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-18T19:59:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/11\/smart-otp-template-list-hd-31-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\\\/otp-widget-google-sheets-form-fast2sms\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/otp-widget-google-sheets-form-fast2sms\\\/\"},\"author\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/#organization\"},\"headline\":\"OTP-verified form that saves to Google Sheets, no website needed (Fast2SMS)\",\"datePublished\":\"2026-11-18T19:59:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/otp-widget-google-sheets-form-fast2sms\\\/\"},\"wordCount\":1455,\"publisher\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/otp-widget-google-sheets-form-fast2sms\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/smart-otp-template-list-hd-31-scaled.webp\",\"articleSection\":[\"API\",\"Integrations\",\"OTP\"],\"inLanguage\":\"en-IN\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/otp-widget-google-sheets-form-fast2sms\\\/\",\"url\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/otp-widget-google-sheets-form-fast2sms\\\/\",\"name\":\"OTP Verified Form That Saves to Google Sheets | Fast2SMS\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/otp-widget-google-sheets-form-fast2sms\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/otp-widget-google-sheets-form-fast2sms\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/smart-otp-template-list-hd-31-scaled.webp\",\"datePublished\":\"2026-11-18T19:59:18+00:00\",\"description\":\"Build a phone-verified form with Google Apps Script: visitors confirm their number by OTP and every entry lands in your Google Sheet. No server needed.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/otp-widget-google-sheets-form-fast2sms\\\/#breadcrumb\"},\"inLanguage\":\"en-IN\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/otp-widget-google-sheets-form-fast2sms\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-IN\",\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/otp-widget-google-sheets-form-fast2sms\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/smart-otp-template-list-hd-31-scaled.webp\",\"contentUrl\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/smart-otp-template-list-hd-31-scaled.webp\",\"width\":2560,\"height\":1600,\"caption\":\"Smart OTP Template page with WhatsApp and SMS OTP template cards, each showing its OTP ID, sender or number, template ID and fallback\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/otp-widget-google-sheets-form-fast2sms\\\/#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\":\"OTP-verified form that saves to Google Sheets, no website needed (Fast2SMS)\"}]},{\"@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":"OTP Verified Form That Saves to Google Sheets | Fast2SMS","description":"Build a phone-verified form with Google Apps Script: visitors confirm their number by OTP and every entry lands in your Google Sheet. No server needed.","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\/otp-widget-google-sheets-form-fast2sms\/","og_locale":"en_US","og_type":"article","og_title":"OTP Verified Form That Saves to Google Sheets | Fast2SMS","og_description":"Build a phone-verified form with Google Apps Script: visitors confirm their number by OTP and every entry lands in your Google Sheet. No server needed.","og_url":"https:\/\/www.fast2sms.com\/help\/otp-widget-google-sheets-form-fast2sms\/","og_site_name":"Fast2SMS","article_publisher":"https:\/\/www.facebook.com\/Fast2SMS\/","article_published_time":"2026-11-18T19:59:18+00:00","og_image":[{"width":2560,"height":1600,"url":"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/11\/smart-otp-template-list-hd-31-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\/otp-widget-google-sheets-form-fast2sms\/#article","isPartOf":{"@id":"https:\/\/www.fast2sms.com\/help\/otp-widget-google-sheets-form-fast2sms\/"},"author":{"@id":"https:\/\/www.fast2sms.com\/#organization"},"headline":"OTP-verified form that saves to Google Sheets, no website needed (Fast2SMS)","datePublished":"2026-11-18T19:59:18+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fast2sms.com\/help\/otp-widget-google-sheets-form-fast2sms\/"},"wordCount":1455,"publisher":{"@id":"https:\/\/www.fast2sms.com\/#organization"},"image":{"@id":"https:\/\/www.fast2sms.com\/help\/otp-widget-google-sheets-form-fast2sms\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/11\/smart-otp-template-list-hd-31-scaled.webp","articleSection":["API","Integrations","OTP"],"inLanguage":"en-IN"},{"@type":"WebPage","@id":"https:\/\/www.fast2sms.com\/help\/otp-widget-google-sheets-form-fast2sms\/","url":"https:\/\/www.fast2sms.com\/help\/otp-widget-google-sheets-form-fast2sms\/","name":"OTP Verified Form That Saves to Google Sheets | Fast2SMS","isPartOf":{"@id":"https:\/\/www.fast2sms.com\/help\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fast2sms.com\/help\/otp-widget-google-sheets-form-fast2sms\/#primaryimage"},"image":{"@id":"https:\/\/www.fast2sms.com\/help\/otp-widget-google-sheets-form-fast2sms\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/11\/smart-otp-template-list-hd-31-scaled.webp","datePublished":"2026-11-18T19:59:18+00:00","description":"Build a phone-verified form with Google Apps Script: visitors confirm their number by OTP and every entry lands in your Google Sheet. No server needed.","breadcrumb":{"@id":"https:\/\/www.fast2sms.com\/help\/otp-widget-google-sheets-form-fast2sms\/#breadcrumb"},"inLanguage":"en-IN","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fast2sms.com\/help\/otp-widget-google-sheets-form-fast2sms\/"]}]},{"@type":"ImageObject","inLanguage":"en-IN","@id":"https:\/\/www.fast2sms.com\/help\/otp-widget-google-sheets-form-fast2sms\/#primaryimage","url":"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/11\/smart-otp-template-list-hd-31-scaled.webp","contentUrl":"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/11\/smart-otp-template-list-hd-31-scaled.webp","width":2560,"height":1600,"caption":"Smart OTP Template page with WhatsApp and SMS OTP template cards, each showing its OTP ID, sender or number, template ID and fallback"},{"@type":"BreadcrumbList","@id":"https:\/\/www.fast2sms.com\/help\/otp-widget-google-sheets-form-fast2sms\/#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":"OTP-verified form that saves to Google Sheets, no website needed (Fast2SMS)"}]},{"@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\/19681","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=19681"}],"version-history":[{"count":0,"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/posts\/19681\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/media\/19646"}],"wp:attachment":[{"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/media?parent=19681"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/categories?post=19681"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/tags?post=19681"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}