{"id":10263,"date":"2023-01-29T07:00:00","date_gmt":"2023-01-29T01:30:00","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=10263"},"modified":"2024-03-11T18:06:49","modified_gmt":"2024-03-11T12:36:49","slug":"submit-html-form-to-google-sheet","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/submit-html-form-to-google-sheet\/","title":{"rendered":"Submit a HTML Form to Google Sheet using Apps Script"},"content":{"rendered":"\n<p>HTML Form to Google Sheet, Save Web Page Data to Google Sheet, Connect your HTML Form to Google Spreadsheet, Google Apps Script Web App Deployment<\/p>\n\n\n\n<p>\u091c\u092c \u092d\u0940 \u0906\u092a \u0915\u094b\u0908 \u092d\u0940 Web App \u092c\u0928\u093e\u0924\u0947 \u0939\u0948\u0902 \u0914\u0930 \u0909\u0938\u0915\u0947 Data \u0915\u094b Store \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0906\u092a\u0915\u094b \u090f\u0915 Web Server \u0915\u0940 \u0906\u0935\u0936\u094d\u092f\u0915\u0924\u093e \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0964 Web Server \u092a\u0930 \u092f\u0926\u093f HTML \u0930\u0916\u0928\u093e \u0939\u094b \u0924\u094b \u0939\u092e \u0915\u094b\u0908 \u092d\u0940 Free \u0935\u093e\u0932\u0947 Blogging Platform \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 \u0932\u0947\u0915\u093f\u0928 \u092f\u0926\u093f \u092c\u093e\u0926 Data Store \u0915\u0930\u0928\u0947 \u0915\u0940 \u0906\u090f \u0924\u094b Google Sheet \u090f\u0915 \u0905\u091a\u094d\u091b\u093e Option \u0939\u094b \u0938\u0915\u0924\u093e \u0939\u0948\u0902\u0964 \u0907\u0938\u0915\u0947 \u0932\u093f\u090f \u0906\u092a\u0915\u094b \u0905\u0932\u0917 \u0938\u0947 \u0915\u094b\u0908 Tool \u092d\u0940 Purchase \u0928\u0939\u0940\u0902 \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0964  <\/p>\n\n\n\n<p><strong>Submit a HTML Form to Google Sheet only in 5 Steps<\/strong><\/p>\n\n\n\n<div class=\"wp-block-rank-math-toc-block\" id=\"rank-math-toc\"><h2>Table of Contents<\/h2><nav><ul><li><a href=\"#step-1-create-a-html-form\">Step 1 : Create a HTML Form <\/a><\/li><li><a href=\"#step-2-create-a-google-sheet-add-apps-script\">Step 2 : Create a Google Sheet add Apps Script <\/a><\/li><li><a href=\"#step-3-deploy-apps-script\">Step 3 : Deploy Apps Script <\/a><\/li><li><a href=\"#step-4-connect-apps-script-link-to-form-action\">Step 4 : Connect Apps Script Link to Form Action <\/a><\/li><li><a href=\"#step-5-submit-form-testing\">Step 5 : Submit Form (Testing) <\/a><\/li><li><a href=\"#\u0939\u092e\u093e\u0930\u0947-\u0905\u0928\u094d\u092f-\u0906\u0930\u094d\u091f\u093f\u0915\u0932\">\u0939\u092e\u093e\u0930\u0947 \u0905\u0928\u094d\u092f \u0906\u0930\u094d\u091f\u093f\u0915\u0932<\/a><\/li><\/ul><\/nav><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-1-create-a-html-form\">Step 1 : Create a HTML Form <\/h2>\n\n\n\n<p>\u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0947 \u0906\u092a\u0915\u094b \u090f\u0915 HTML Form \u092c\u0928\u093e\u0928\u093e \u0939\u094b\u0917\u093e  \u092f\u093e \u091c\u093f\u0938 \u092d\u0940 Page \u0915\u093e Data \u0906\u092a Google Sheet \u092a\u0930 \u0938\u094d\u091f\u094b\u0930 \u0915\u0930\u0928\u093e \u0939\u094b \u0909\u0938\u0915\u093e \u0906\u092a\u0915\u094b \u090f\u0915 Form \u092c\u0928\u093e\u0928\u093e \u0939\u094b\u0917\u093e, \u0928\u093f\u092e\u094d\u0928 Blog \u092e\u0947 \u0939\u092e\u0928\u0947 \u090f\u0915 Invoice \u092c\u0928\u093e\u0908 \u0939\u0948\u0902 \u0914\u0930 \u0909\u0938\u0940 \u0915\u0947 Data \u0915\u094b Google sheet \u092a\u0930 Upload \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<p>\u0939\u092e\u093e\u0930\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u0909\u092a\u092f\u094b\u0917 \u092e\u0947 \u0932\u093f\u092f\u093e \u0917\u092f\u093e Form \u0928\u093f\u092e\u094d\u0928 \u0932\u093f\u0902\u0915 \u0938\u0947 \u092c\u0928\u093e\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0902 \u0906\u092a\u0915\u094b \u092e\u0947 \u090f\u0915 \u0936\u0949\u0930\u094d\u091f Form \u0915\u0947\u0935\u0932 reference \u0915\u0947 \u0932\u093f\u090f \u0926\u0947 \u0930\u0939\u093e  \u0939\u0941 \u092f\u0926\u093f \u0906\u092a As it \u092c\u0928\u093e\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u0928\u093f\u092e\u094d\u0928 \u0932\u093f\u0902\u0915 \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0947 \u0964 <\/p>\n\n\n\n<p><a href=\"https:\/\/selfimagination.in\/tips\/complete-invoice-with-calculation\/\">Related Article : HTML Bootstrap Invoice with Add, Delete, Print option<\/a><\/p>\n\n\n\n<p>\u0928\u093f\u092e\u094d\u0928 HTML \u092c\u093f\u0932\u094d\u0915\u0941\u0932 Plain HTML \u0939\u0948\u0902 \u0964 \u0907\u0938\u092e\u0947 \u0915\u094b\u0908 \u092d\u0940 Bootstrap \u0914\u0930 CSS \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0928\u0939\u0940\u0902 \u0915\u093f\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0902 \u092f\u0939 \u0915\u0947\u0935\u0932 \u0938\u092e\u091d\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u092c\u0928\u093e\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0902 , \u092f\u0926\u093f \u0906\u092a Image \u092e\u0947 \u0926\u093f\u0916\u093e\u090f \u0917\u090f look \u091c\u0948\u0938\u0940 Invoice \u092c\u0928\u093e\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u0906\u092a\u0915\u094b \u0909\u092a\u0930\u094b\u0915\u094d\u0924 \u0932\u093f\u0902\u0915 \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u093e \u0964 <\/p>\n\n\n\n<pre title=\"Invoice.html \" class=\"wp-block-code\"><code lang=\"markup\" class=\"language-markup\">&lt;!doctype html&gt;\n&lt;html lang=\"en\"&gt;\n    &lt;head&gt;\n        &lt;meta charset=\"utf-8\"&gt;\n        &lt;meta name=\"viewport\" content=\"width=device-width, initial-scale=1\"&gt;\n        &lt;title&gt;Imagination Invoice Example&lt;\/title&gt;\n    &lt;\/head&gt;\n    &lt;body&gt;\n        &lt;h4&gt;INVOICE&lt;\/h4&gt;\n       &lt;!-- Change action --&gt;\n        &lt;form method=\"POST\" action=\"https:\/\/script.google.com\/macros\/s\/....\/exec\"&gt;\n\n            Inv. No :   &lt;input type=\"text\" name=\"inv_no\"  value=\"1001\"&gt; &lt;\/br&gt;\n            Inv. Date : &lt;input type=\"date\" name=\"inv_dt\"  value=\"2023-01-26\"&gt; &lt;\/br&gt;\n            Customer :  &lt;input type=\"text\" name=\"cust_nm\" value=\"Imagination\"&gt; &lt;\/br&gt;\n            Address :   &lt;input type=\"text\" name=\"addr\"    value=\"Address Here\"&gt; &lt;\/br&gt;\n            City :      &lt;input type=\"text\" name=\"city\"    value=\"City Here\"&gt; &lt;\/br&gt;\n                            \n            &lt;table &gt;\n                &lt;thead &gt;\n                    &lt;tr&gt;\n                        &lt;th &gt;#&lt;\/th&gt;\n                        &lt;th &gt;Particular&lt;\/th&gt;\n                        &lt;th &gt;Qty&lt;\/th&gt;\n                        &lt;th &gt;Rate&lt;\/th&gt;\n                        &lt;th &gt;Amount&lt;\/th&gt;\n                    &lt;\/tr&gt;\n                &lt;\/thead&gt;\n                &lt;tbody &gt;\n                    &lt;tr &gt;\n                        &lt;th &gt;1&lt;\/th&gt;\n                        &lt;td&gt;&lt;input type=\"text\"    name=\"item_nm\" value=\"Item 1\"&gt;&lt;\/td&gt;\n                        &lt;td&gt;&lt;input type=\"number\"  name=\"qty\"     value=\"10\"&gt;&lt;\/td&gt;\n                        &lt;td&gt;&lt;input type=\"number\"  name=\"rate\"    value=\"1200\"&gt;&lt;\/td&gt;\n                        &lt;td&gt;&lt;input type=\"number\"  name=\"amt\"     value=\"12000\"&gt;&lt;\/td&gt;\n                    &lt;\/tr&gt;\n                    &lt;tr &gt;\n                        &lt;th &gt;1&lt;\/th&gt;\n                        &lt;td&gt;&lt;input type=\"text\"    name=\"item_nm\" value=\"Item 2\"&gt;&lt;\/td&gt;\n                        &lt;td&gt;&lt;input type=\"number\"  name=\"qty\"     value=\"20\"&gt;&lt;\/td&gt;\n                        &lt;td&gt;&lt;input type=\"number\"  name=\"rate\"    value=\"1300\"&gt;&lt;\/td&gt;\n                        &lt;td&gt;&lt;input type=\"number\"  name=\"amt\"     value=\"26000\"&gt;&lt;\/td&gt;\n                    &lt;\/tr&gt;\n                &lt;\/tbody&gt;\n            &lt;\/table&gt;\n\n            &lt;button type=\"submit\" class=\"btn btn-primary\" &gt;submit&lt;\/button&gt;\n        &lt;\/form&gt;       \n    &lt;\/body&gt;\n&lt;\/html&gt;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-2-create-a-google-sheet-add-apps-script\">Step 2 : Create a Google Sheet add Apps Script <\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0907\u0938\u0915\u0947 \u092c\u093e\u0926 \u0906\u092a\u0915\u094b \u090f\u0915 Google Sheet \u092c\u0928\u093e\u0928\u093e \u0939\u094b\u0917\u0940 , \u0909\u0938\u092e\u0947 \u0906\u092a \u091a\u093e\u0939\u0947 \u0939\u094b Columns \u0915\u0947 \u0928\u093e\u092e \u092a\u0939\u0932\u0947 \u0938\u0947 \u0932\u093f\u0916 \u0932\u0947 \u0964 <\/li>\n\n\n\n<li>Address Bar \u092a\u0930 Google Sheet \u0915\u0947 URL \u0915\u094b Copy \u0915\u0930\u0947\u0964 <\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"412\" height=\"245\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-22.png?resize=412%2C245&#038;ssl=1\" alt=\"Google Sheet Link\" class=\"wp-image-10312\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-22.png?w=412&amp;ssl=1 412w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-22.png?resize=300%2C178&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-22.png?resize=150%2C89&amp;ssl=1 150w\" sizes=\"auto, (max-width: 412px) 100vw, 412px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Extension Menu \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947\u0964 <\/li>\n\n\n\n<li>Apps Script Select \u0915\u0930\u0947\u0964 <\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"325\" height=\"187\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-10.png?resize=325%2C187&#038;ssl=1\" alt=\"Extensions Apps Script\" class=\"wp-image-10270\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-10.png?w=325&amp;ssl=1 325w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-10.png?resize=300%2C173&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-10.png?resize=150%2C86&amp;ssl=1 150w\" sizes=\"auto, (max-width: 325px) 100vw, 325px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Apps Script \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0928\u0947 \u092a\u0930 \u0915\u0941\u091b \u0928\u093f\u092e\u094d\u0928 \u092a\u094d\u0930\u0915\u093e\u0930 \u0938\u0947 Screen \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0917\u0940 \u0964 <\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"625\" height=\"283\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-20.png?resize=625%2C283&#038;ssl=1\" alt=\"Apps Script Rename Project\" class=\"wp-image-10302\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-20.png?w=625&amp;ssl=1 625w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-20.png?resize=300%2C136&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-20.png?resize=150%2C68&amp;ssl=1 150w\" sizes=\"auto, (max-width: 625px) 100vw, 625px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Untitled project \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947 <\/li>\n\n\n\n<li>Project title \u092a\u0930 \u091c\u093e \u0915\u0930 \u091c\u094b \u092d\u0940 \u0906\u092a \u0928\u093e\u092e \u0930\u0916\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0935\u0939 \u0928\u093e\u092e Enter \u0915\u0930\u0947\u0964 <\/li>\n\n\n\n<li>\u0909\u0938\u0915\u0947 \u092c\u093e\u0926 Rename \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947 \u0964 <\/li>\n\n\n\n<li>\u0905\u092c \u0906\u092a\u0915\u094b \u0928\u093f\u092e\u094d\u0928 function screen \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0917\u0940 \u0907\u0938\u092e\u0947 \u0906\u092a \u0915\u094b Code \u0932\u093f\u0916\u0928\u093e \u0939\u094b\u0917\u093e\u0964 <\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"327\" height=\"113\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-21.png?resize=327%2C113&#038;ssl=1\" alt=\"\" class=\"wp-image-10308\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-21.png?w=327&amp;ssl=1 327w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-21.png?resize=300%2C104&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-21.png?resize=150%2C52&amp;ssl=1 150w\" sizes=\"auto, (max-width: 327px) 100vw, 327px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>\u0909\u092a\u0930\u094b\u0915\u094d\u0924 Window \u092e\u0947 \u0928\u093f\u092e\u094d\u0928 Code \u0915\u094b Copy \u0915\u0930\u0947 \u0964 <\/li>\n\n\n\n<li>&#8220;Your Google Sheet URL&#8221; \u0915\u0947 \u0938\u094d\u0925\u093e\u0928 \u092a\u0930 \u0906\u092a\u0928\u0947 \u091c\u094b Google Sheet URL Copy \u0915\u093f\u092f\u093e \u0925\u093e \u0909\u0938\u0947 Paste \u0915\u0930\u0947\u0964 <\/li>\n\n\n\n<li>Sheet1 \u0915\u0947 \u0938\u094d\u0925\u093e\u0928 \u092a\u0930 \u091c\u094b \u092d\u0940 Sheet \u0915\u093e \u0928\u093e\u092e \u0939\u094b \u0909\u0938\u0947 \u0932\u093f\u0916\u0947 \u092f\u0926\u093f \u0906\u092a\u0928\u0947 Sheet \u0928\u093e\u092e Change \u0928\u0939\u0940\u0902 \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0924\u094b \u092b\u093f\u0930 Sheet 1 \u0939\u0940 \u0930\u0939\u0928\u0947 \u0926\u0947\u0935\u0947\u0964 <\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"243\" height=\"89\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-23.png?resize=243%2C89&#038;ssl=1\" alt=\"\" class=\"wp-image-10316\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-23.png?w=243&amp;ssl=1 243w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-23.png?resize=150%2C55&amp;ssl=1 150w\" sizes=\"auto, (max-width: 243px) 100vw, 243px\" \/><\/figure>\n<\/div>\n\n\n<p>HTML Form to Google Sheet Apps Script <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"javascript\" class=\"language-javascript\">let MySheets = SpreadsheetApp.openByUrl(\"Your Google Sheet URL\");  \/\/01\nlet InvSheet = MySheets.getSheetByName(\"Inv\");                  \/\/02 \n\nfunction doPost(e)          \/\/03 \n{\n    let Inv = e.parameters; \/\/04\n    let Qtys = Inv.qty;     \/\/05 \n     \n     InvSheet.appendRow([Inv.inv_no[0], Inv.inv_dt[0], Inv.cust_nm[0], Inv.addr[0], Inv.city[0]]) ;    \/\/06\n    let i = 0;\n    Qtys.forEach(function(value, index)                       \/\/07\n    {\n      if (i > 0) {\n        InvSheet.appendRow([\"\", \"\", \"\", \"\", \"\", Inv.item_nm[index], value, Inv.rate[index], Inv.amt[index]]) ;  \/\/08\n     }\n     i++;\n\n\n    });\n\n    return ContentService.createTextOutput(\"Data Submitted\"); \/\/09\n}\n\n<\/code><\/pre>\n\n\n\n<p>\u0906\u0907\u090f \u0906\u092a \u0906\u092a\u0915\u094b Google Apps Script \u0915\u0947 Syntax \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947 \u092c\u0924\u093e\u0924\u0947 \u0939\u0948\u0902\u0964 <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>01: \u0907\u0938 Line \u092e\u0947 \u0939\u092e\u0928\u0947 MySheets Variable \u092e\u0947 URL \u0938\u0947 Google Sheet \u0915\u094b Declare \u0915\u093f\u092f\u093e \u0939\u0948\u0902\u0964 <\/li>\n\n\n\n<li>02: \u0907\u0938 \u0932\u093e\u0907\u0928 \u092e\u0947 \u0939\u092e\u0928\u0947 MySheet \u092e\u0947 \u0938\u0947 \u090f\u0915 \u092a\u0939\u0932\u0940 Sheet \u0915\u094b Point \u0915\u093f\u092f\u093e \u0939\u0948\u0902\u0964 <\/li>\n\n\n\n<li>03: doPost(e) \u0907\u0938 Method \u0915\u093e \u0909\u092a\u092f\u094b\u0917 Web Apps \u092e\u0947 \u091c\u092c \u0939\u092e Data Form \u0938\u0947 Post Method \u0938\u0947 send \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0924\u092c Apps Script dwara doPost Function Call \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902\u0964 <\/li>\n\n\n\n<li>04: \u0939\u092e\u0928\u0947 Multiple Columns \u0915\u0940 value Send \u0915\u0908 \u0939\u0948 \u091c\u093f\u0938\u092e\u0947 \u0915\u0947 \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 value \u0939\u0948\u0902 \u092f\u093e\u0928\u093f \u0915\u0908 Qty, Rate \u0914\u0930 Amt Array \u0939\u0948\u0902 \u0907\u0938\u0932\u093f\u090f \u0939\u092e\u0928\u0947 e.parameters \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u0939\u0948\u0902\u0964 \u0910\u0938\u093e \u0915\u0930\u0928\u0947 \u0938\u0947 \u091c\u094b \u092d\u0940 data \u092d\u0947\u091c\u093e \u0917\u092f\u093e \u0939\u0948\u0902 \u0909\u0938\u0947 Inv Variable \u092e\u0947 Receive \u0915\u093f\u092f\u093e \u091c\u093e\u090f\u0917\u093e\u0964 <\/li>\n\n\n\n<li>05: Array \u0935\u093e\u0932\u0940 value \u0939\u094b \u0939\u092e\u0928\u0947 Qtys \u0935\u093e\u0932\u0947 Variable \u092e\u0947 Receive \u0915\u093f\u092f\u093e \u0939\u0948\u0902\u0964 <\/li>\n\n\n\n<li>06: \u091c\u094b \u092d\u0940 Data \u0939\u092e\u0928\u0947 Variable \u092e\u0947 \u0932\u093f\u092f\u093e \u0939\u0948\u0902 \u0909\u0938\u0947 InvSheet.appendRow \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 Sheet \u092a\u0930 Store \u0915\u0930\u0935\u093e \u0926\u093f\u092f\u093e \u0939\u0948\u0902  \u0964 \u091c\u0940\u0924\u0928\u0947 \u092d\u0940 Columns \u0939\u0948\u0902 \u0909\u0928\u0915\u0940 Value \u0915\u094b \u0906\u092a Comma (,) \u0938\u0947 Separate \u0915\u0930 Type \u0915\u0930 \u0938\u0915\u0924 \u0939\u0948\u0902\u0964 <\/li>\n\n\n\n<li>07: \u0907\u0938 \u0932\u093e\u0907\u0928 \u092e\u0947 \u0939\u092e\u0928\u0947 Qtys \u0935\u093e\u0932\u0947 array \u092e\u0947 \u0938\u0947 value \u0915\u094b get \u0915\u093f\u092f\u093e \u0939\u0948 , \u0914\u0930 index \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0905\u0928\u094d\u092f Array \u092e\u0947 \u0938\u0947 \u092d\u0940 value \u0915\u094b get \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li>08: \u0907\u0938 Line \u092e\u0947 \u0939\u092e\u0928\u0947 Array \u0935\u093e\u0932\u0940 Value \u0915\u094b \u0906\u0917\u0947 \u0938\u0947 \u0915\u0941\u091b Columns \u0915\u094b Blank \u091b\u094b\u095c\u0915\u0930 Qty, Rate, Amt \u0915\u0940 Value set \u0915\u0930 \u0926\u0940 \u0939\u0948\u0902\u0964 <\/li>\n\n\n\n<li>09: \u091c\u0939\u093e \u0938\u0947 request \u0906\u0908 \u0939\u0948\u0902 \u0909\u0938\u0915\u094b \u0907\u0938 Line \u0938\u0947 Replay \u0915\u093f\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0902 , \u092f\u0939 \u0938\u0947 \u0926\u093f\u092f\u093e \u0917\u092f\u093e Message \u0906\u092a\u0915\u0947 Form \u092a\u0930 display \u0939\u094b \u091c\u093e\u090f\u0917\u093e \u0964<\/li>\n<\/ul>\n\n\n\n<p>\u0907\u0924\u0928\u093e \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0906\u092a Script \u0915\u094b Save \u0915\u0930\u0947\u0902\u0917\u0947\u0964 <\/p>\n\n\n\n<p><a href=\"https:\/\/www.youtube.com\/watch?v=lKeFN4JxRB8\" target=\"_blank\" rel=\"noopener\">Related Video : How to Submit a HTML Form to Google Sheet<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-3-deploy-apps-script\">Step 3 : Deploy Apps Script <\/h2>\n\n\n\n<p>\u0906\u092a \u0906\u092a\u0915\u094b Project \u0915\u094b Deploy \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u093e\u0964 Deploy \u0915\u0947 \u0932\u093f\u090f \u0906\u092a\u0915\u094b Deploy Button \u092a\u0930 Click \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u093e\u0964 \u0909\u0938\u0915\u0947 \u092c\u093e\u0926 New deployment \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u093e\u0964 <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"207\" height=\"210\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-24.png?resize=207%2C210&#038;ssl=1\" alt=\"Deploy New Deployment\" class=\"wp-image-10349\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-24.png?w=207&amp;ssl=1 207w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-24.png?resize=96%2C96&amp;ssl=1 96w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-24.png?resize=150%2C152&amp;ssl=1 150w\" sizes=\"auto, (max-width: 207px) 100vw, 207px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>\u0910\u0938\u093e \u0915\u0930\u0928\u0947 \u092a\u0930 \u0928\u093f\u092e\u094d\u0928 Window open \u0939\u094b\u0917\u0940 \u0964 <\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"353\" height=\"255\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-12.png?resize=353%2C255&#038;ssl=1\" alt=\"Setting Web App\" class=\"wp-image-10275\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-12.png?w=353&amp;ssl=1 353w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-12.png?resize=300%2C217&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-12.png?resize=150%2C108&amp;ssl=1 150w\" sizes=\"auto, (max-width: 353px) 100vw, 353px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>\u0909\u092a\u0930\u094b\u0915\u094d\u0924 \u0938\u094d\u0915\u094d\u0930\u0940\u0928 \u092a\u0930 \u0906\u092a\u0915\u094b Setting \u0935\u093e\u0932\u0947 Icon \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u093e\u0964 <\/li>\n\n\n\n<li>\u0909\u0938\u092e\u0947 \u0938\u0947 \u0939\u092e\u0947 Web App \u0915\u094b \u0938\u093f\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u093e\u0964 <\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"508\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-13.png?resize=640%2C508&#038;ssl=1\" alt=\"New Deployment Configuration\" class=\"wp-image-10277\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-13.png?w=771&amp;ssl=1 771w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-13.png?resize=300%2C238&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-13.png?resize=768%2C610&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-13.png?resize=150%2C119&amp;ssl=1 150w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>New Description :<\/strong> \u092f\u0939\u093e \u092a\u0930 \u0906\u092a\u0915\u094b Deployment \u0915\u093e \u0928\u093e\u092e \u0926\u0947\u0928\u093e \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li><strong>Web App Execute as :<\/strong>  \u092e\u0947 \u0906\u092a\u0915\u0940 Gmail ID \u0938\u093f\u0932\u0947\u0915\u094d\u091f \u0939\u094b \u0915\u0930 \u0906\u090f\u0917\u0940\u0964 <\/li>\n\n\n\n<li><strong>Who has access : <\/strong>\u092e\u0947 \u0906\u092a \u091c\u093f\u0928\u094d\u0939\u0947 \u092d\u0940 Execution \u0915\u0940 Permission \u0926\u0947\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0935\u0939 \u0938\u093f\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902\u0964 \u0905\u092d\u0940 \u0915\u0947 \u0932\u093f\u090f \u0906\u092a \u092f\u0939\u093e \u092a\u0930 Anyone \u0938\u093f\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0947 \u0964 <\/li>\n\n\n\n<li><strong>Deploy :<\/strong> \u0907\u0924\u0928\u093e \u0915\u0930 \u0906\u092a Deploy Button \u092a\u0930 Click \u0915\u0930\u0947\u0964 <\/li>\n<\/ul>\n\n\n\n<p>Deploy \u0915\u0930\u0928\u0947 \u092a\u0930 \u0928\u093f\u092e\u094d\u0928 Screen \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0917\u0940 \u0964 <\/p>\n\n\n\n<p>\u0907\u0938\u092e\u0947 \u0906\u092a Authorize Access \u0915\u0940 Permission \u0926\u0947\u0928\u093e \u0939\u094b\u0917\u0940\u0964 \u092f\u093e\u0928\u093f \u0915\u0908 Authorize Access Button \u092a\u0930 Click \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u093e\u0964 <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"221\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-14.png?resize=640%2C221&#038;ssl=1\" alt=\"New Deployment Authorize access\" class=\"wp-image-10280\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-14.png?w=773&amp;ssl=1 773w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-14.png?resize=300%2C104&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-14.png?resize=768%2C265&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-14.png?resize=150%2C52&amp;ssl=1 150w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n<\/div>\n\n\n<p>\u0907\u0938\u0915\u0947 \u092c\u093e\u0926 \u0906\u092a\u0915\u094b \u0905\u092a\u0928\u0947 Gmail Account \u0915\u094b \u0938\u093f\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u093e \u091c\u093f\u0938\u0938\u0947 \u0906\u092a Permission \u0926\u0947\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902\u0964 <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"463\" height=\"372\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-15.png?resize=463%2C372&#038;ssl=1\" alt=\"\" class=\"wp-image-10281\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-15.png?w=463&amp;ssl=1 463w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-15.png?resize=300%2C241&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-15.png?resize=150%2C121&amp;ssl=1 150w\" sizes=\"auto, (max-width: 463px) 100vw, 463px\" \/><\/figure>\n<\/div>\n\n\n<p>\u0907\u0938 \u0924\u0930\u0939 \u0938\u0947 Script \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0928\u093e Safe \u0928\u0939\u0940\u0902 \u0939\u094b\u0924\u093e \u0939\u0948\u0902 Security Issue \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 , \u0907\u0938\u0932\u093f\u090f \u092f\u0939\u093e \u092a\u0930 Google \u0906\u092a\u0915\u094b Warning \u0926\u0947 \u0915\u0930 \u0906\u092a\u0915\u094b Information \u0926\u0947\u0924\u093e \u0939\u0948\u0902 \u0915\u0940 \u0906\u092a \u091c\u094b \u092d\u0940 \u0915\u0930 \u0930\u0939\u0947 \u0939\u0948\u0902 \u092f\u0939 Unsafe \u0939\u0948\u0902 \u092b\u093f\u0930 \u092d\u0940 \u092f\u0926\u093f \u0906\u092a Authorized \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b (unsafe) \u0935\u093e\u0932\u0947 option \u0915\u094b select \u0915\u0930\u0947\u0964  <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"459\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-16.png?resize=624%2C459&#038;ssl=1\" alt=\"\" class=\"wp-image-10283\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-16.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-16.png?resize=300%2C221&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-16.png?resize=150%2C110&amp;ssl=1 150w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/figure>\n<\/div>\n\n\n<p>\u0907\u0924\u0928\u093e \u0915\u0930\u0928\u0947 \u092a\u0930 \u0906\u092a\u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u092c\u0928\u093e\u092f\u093e \u0917\u092f\u093e Apps Script Project \u0906\u092a\u0915\u094b Google Sheet \u0915\u094b \u0926\u0947\u0916\u0928\u0947, \u092c\u0928\u093e\u0928\u0947 \u0914\u0930 Delete \u0915\u0930\u0928\u0947 \u0915\u0940 Permission \u092e\u093e\u0901\u0917\u0924\u093e \u0939\u0948\u0902 \u092f\u0939\u093e \u0938\u0947 Allow \u0915\u0930\u0928\u0947 \u092a\u0930 \u0906\u092a\u0915\u094b \u090f\u0915 Link \u0926\u0940 \u091c\u093e\u0924\u0940 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"459\" height=\"631\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-17.png?resize=459%2C631&#038;ssl=1\" alt=\"\" class=\"wp-image-10284\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-17.png?w=459&amp;ssl=1 459w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-17.png?resize=218%2C300&amp;ssl=1 218w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-17.png?resize=150%2C206&amp;ssl=1 150w\" sizes=\"auto, (max-width: 459px) 100vw, 459px\" \/><\/figure>\n<\/div>\n\n\n<p>\u0938\u092d\u0940 Permission \u0926\u0947\u0928\u093e \u0915\u0947 \u092c\u093e\u0926 \u0905\u0902\u0924 \u092e\u0947 \u0906\u092a\u0915\u094b \u090f\u0915 Web app URL provide \u0915\u0940 \u091c\u093e\u0924\u0940 \u0939\u0948\u0902  \u0964 \u0906\u092a\u0915\u094b \u0907\u0938 link \u0915\u094b copy \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902\u0964 <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"506\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-18.png?resize=640%2C506&#038;ssl=1\" alt=\"\" class=\"wp-image-10286\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-18.png?w=770&amp;ssl=1 770w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-18.png?resize=300%2C237&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-18.png?resize=768%2C607&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-18.png?resize=150%2C119&amp;ssl=1 150w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n<\/div>\n\n\n<p>\u0914\u0930 \u0905\u092c Apps Script \u0915\u093e \u0915\u093e\u0930\u094d\u092f \u0938\u092e\u093e\u092a\u094d\u0924 \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0964 \u0905\u092c \u0906\u092a\u0915\u094b \u091c\u094b \u0906\u092a\u0928\u0947 \u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0947 HTML Form \u092c\u0928\u093e\u092f\u093e \u0909\u0938 \u092a\u0930 \u091c\u093e\u0928\u093e \u0939\u094b\u0917\u093e\u0964 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-4-connect-apps-script-link-to-form-action\">Step 4 : Connect Apps Script Link to Form Action <\/h2>\n\n\n\n<p>\u0906\u092a\u0928\u0947 \u091c\u094b \u092d\u0940 HTML Form \u092c\u0928\u093e\u092f\u093e \u0939\u0948\u0902 \u0909\u0938 \u0915\u0947 Action Attribute \u092a\u0930 \u0906\u092a\u0915\u094b Web App Link \u0926\u0947\u0928\u093e \u0939\u094b\u0917\u0940 \u0964 <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"53\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-19.png?resize=640%2C53&#038;ssl=1\" alt=\"\" class=\"wp-image-10287\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-19.png?w=1015&amp;ssl=1 1015w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-19.png?resize=300%2C25&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-19.png?resize=768%2C64&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-19.png?resize=150%2C12&amp;ssl=1 150w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<p>\u0932\u093f\u0902\u0915 \u0926\u0947\u0928\u0947 \u0938\u0947 \u0906\u092a\u0915\u093e Form \u0905\u092c Apps Script \u0938\u0947 Connect \u0939\u094b \u0917\u092f\u093e \u0939\u0948\u0964 \u0905\u092c \u0906\u092a\u0915\u093e Form Data \u092d\u0947\u091c\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f Ready \u0939\u0948\u0902\u0964 \u0905\u092c HTML Form to Google Sheet Connection Complete \u0939\u094b \u0917\u092f\u093e \u0939\u0948\u0902\u0964 <\/p>\n\n\n\n<p><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-5-submit-form-testing\">Step 5 : Submit Form (Testing) <\/h2>\n\n\n\n<p>\u0905\u092c \u0939\u092e\u0928\u0947 \u091c\u094b HTML Form \u092c\u0928\u093e\u092f\u093e \u0939\u0948\u0902 \u0909\u0938\u0947 Browser \u092a\u0930 run \u0915\u0930\u0947\u0902\u0917\u0947 \u0914\u0930 Data Enter \u0915\u0930\u0947\u0902\u0917\u0947 \u0964  <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"339\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-25.png?resize=640%2C339&#038;ssl=1\" alt=\"\" class=\"wp-image-10378\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-25.png?resize=1024%2C542&amp;ssl=1 1024w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-25.png?resize=300%2C159&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-25.png?resize=768%2C406&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-25.png?resize=220%2C115&amp;ssl=1 220w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-25.png?resize=140%2C73&amp;ssl=1 140w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-25.png?resize=60%2C31&amp;ssl=1 60w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-25.png?resize=150%2C79&amp;ssl=1 150w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-25.png?w=1130&amp;ssl=1 1130w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Data Enter \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0906\u092a\u0915\u094b Submit Button \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u093e\u0964 <\/li>\n\n\n\n<li>\u091c\u092c \u092d\u0940 Form Submit \u0939\u094b\u0917\u093e \u0924\u092c \u0906\u092a\u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u091c\u094b Action \u092a\u0930 Web App \u0915\u0940 link \u0926\u0940 \u0939\u0948\u0902 \u0909\u0938 \u092a\u0930 Request \u092d\u0947\u091c\u0940 \u091c\u093e\u090f\u0917\u0940 \u0914\u0930 form \u0915\u0908 Method POST \u0939\u0948\u0902 \u0907\u0938\u0932\u093f\u090f doPost() method \u0915\u094b call \u0915\u093f\u092f\u093e \u091c\u093e\u090f\u0917\u093e\u0964 <\/li>\n\n\n\n<li>doPost \u0915\u0947 call \u0939\u094b\u0928\u0947 \u092a\u0930 \u0906\u092a\u0928\u0947 \u091c\u094b \u092d\u0940 Google Sheet \u0913\u0930 Data Insert \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f logic \u0932\u093f\u0916\u093e \u0939\u0948\u0902 \u0935\u0939 Execute \u0939\u094b \u091c\u093e\u090f\u0917\u093e\u0964 <\/li>\n\n\n\n<li>\u0914\u0930 \u0906\u092a\u0915\u094b \u0928\u093f\u092e\u094d\u0928 Message Display \u0939\u094b\u0917\u093e\u0964 <\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"333\" height=\"88\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-27.png?resize=333%2C88&#038;ssl=1\" alt=\"\" class=\"wp-image-10411\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-27.png?w=333&amp;ssl=1 333w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-27.png?resize=300%2C79&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-27.png?resize=150%2C40&amp;ssl=1 150w\" sizes=\"auto, (max-width: 333px) 100vw, 333px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>\u0907\u0938\u0915\u0947 \u092c\u093e\u0926 \u091c\u092c \u0906\u092a Google sheet \u0915\u094b \u0926\u0947\u0916\u0947\u0902\u0917\u0947 \u0924\u094b \u0909\u0938\u0915\u0947 \u0906\u092a\u0915\u094b Data \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0917\u093e\u0964 \u091c\u094b \u0915\u094b \u0915\u0941\u091b \u0907\u0938 \u0924\u0930\u0939 \u0939\u094b\u0917\u093e\u0964 <\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"198\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-26.png?resize=640%2C198&#038;ssl=1\" alt=\"\" class=\"wp-image-10385\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-26.png?w=970&amp;ssl=1 970w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-26.png?resize=300%2C93&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-26.png?resize=768%2C238&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-26.png?resize=150%2C46&amp;ssl=1 150w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n<\/div>\n\n\n<p>\u0905\u092c \u0906\u092a\u0915\u093e HTML Form to Google Sheet Connection \u0915\u0947 \u0938\u092d\u0940 Process Complete \u0939\u0941\u0935\u0947\u0964 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\u092f\u0939 Article HTML Form to Google Sheet \u0915\u0948\u0938\u093e \u0932\u0917\u093e \u092c\u0924\u093e\u0928\u093e \u0928 \u092d\u0942\u0932\u0947 \u092e\u093f\u0932\u0924\u0947 \u0939\u0948\u0902 Next Article \u092e\u0947 Thanks for Reading \u0964<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"\u0939\u092e\u093e\u0930\u0947-\u0905\u0928\u094d\u092f-\u0906\u0930\u094d\u091f\u093f\u0915\u0932\"><strong>\u0939\u092e\u093e\u0930\u0947 \u0905\u0928\u094d\u092f \u0906\u0930\u094d\u091f\u093f\u0915\u0932<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-function\/\">MySQL Function<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-stored-procedure\/\">MySQL Stored Procedure<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/get-post-method\/\">PHP Get \/Post Method \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/php-math-function\/\">PHP Math Function \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/learn-cpp-from-c\/\">C \u0938\u0947 C ++ \u0938\u0940\u0916\u0947 \u0938\u0930\u0932 \u0936\u092c\u094d\u0926\u094b\u0902 \u092e\u0947\u0902<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/php-variables\/\">PHP Variable \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/arduino-control-structure\/\">Arduino Control Structure<\/a>&nbsp;<\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/c-union\/\">Union in C<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/c-pointer\/\">Declaration of Pointer in C<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/search-jquery\/\">jQuery Search Filter<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-table-create-alter-drop\/\">MySQL Create Table | Alter Table | Drop Table<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/api-using-node-react-express-mysql\/\">API Using NODE REACT EXPRESS MYSQL SEQUELIZE (For Backend OR Server Side)<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/cpanel\/\">CPANEL In Hindi<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>HTML Form to Google Sheet<\/p>\n","protected":false},"author":1,"featured_media":10468,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[28],"tags":[],"class_list":["post-10263","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-apps-script"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/submit-form-to-google-sheet.jpg?fit=1280%2C720&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/10263","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/comments?post=10263"}],"version-history":[{"count":135,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/10263\/revisions"}],"predecessor-version":[{"id":12356,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/10263\/revisions\/12356"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/10468"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=10263"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=10263"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=10263"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}