{"id":12359,"date":"2024-03-30T22:24:33","date_gmt":"2024-03-30T16:54:33","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=12359"},"modified":"2024-10-03T18:28:31","modified_gmt":"2024-10-03T12:58:31","slug":"google-apps-script-tutorial-in-hindi","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/google-apps-script-tutorial-in-hindi\/","title":{"rendered":"Google Apps Script Tutorial in Hindi"},"content":{"rendered":"\n<p>Google Apps Script Tutorial : Learn how to utilize Google Apps Script through this comprehensive English tutorial. With live searching option included, you&#8217;ll receive a step-by-step guide to help you automate your projects. Dive in now and streamline your workflows!<\/p>\n\n\n\n<p>Google Apps Script \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0948\u0938\u0947 \u0915\u0930\u0947\u0902 \u0938\u0940\u0916\u0947\u0902 \u092f\u0939 \u090f\u0915 \u0938\u0930\u0932 \u0939\u093f\u0902\u0926\u0940 \u091f\u094d\u092f\u0942\u091f\u094b\u0930\u093f\u092f\u0932 \u0915\u0947 \u092e\u093e\u0927\u094d\u092f\u092e \u0938\u0947 \u0939\u0948\u0964 \u0907\u0938\u092e\u0947\u0902 \u0932\u093e\u0907\u0935 \u0938\u0930\u094d\u091a\u093f\u0902\u0917 \u0915\u093e \u0911\u092a\u094d\u0936\u0928 \u092d\u0940 \u0939\u0948 \u0914\u0930 \u0906\u092a\u0915\u094b \u0938\u094d\u091f\u0947\u092a-\u092c\u093e\u092f-\u0938\u094d\u091f\u0947\u092a \u0917\u093e\u0907\u0921 \u092e\u093f\u0932\u0947\u0917\u0940\u0964 \u0905\u092d\u0940 \u092a\u0922\u093c\u0947\u0902 \u0914\u0930 \u0905\u092a\u0928\u0947 \u092a\u094d\u0930\u094b\u091c\u0947\u0915\u094d\u091f\u094d\u0938 \u0915\u094b \u0911\u091f\u094b\u092e\u0947\u091f \u0915\u0930\u0947\u0902<\/p>\n\n\n\n<p><strong>Google Apps Script Search : \u0906\u092a \u0928\u093f\u092e\u094d\u0928 bar \u0938\u0947 Code Search \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 <\/strong><\/p>\n\n\n\n<style>\nfieldset {\n    float: left;\n    position: relative;\n    width: 100%;\n    border: none;\n    padding: 0;\n    margin: 0;\nmargin-bottom: 15px;\n}\n\n#myInput {\n\nwidth: 100%;\n    border: 1px solid #E2E2E2;\n    float: left;\n    padding: 7px 0;\n    height: 38px;\n    text-indent: 10px;\n    opacity: 1;\n    font-size: 18px;\n    color: #6d6868;\n    border-radius: 0;\n    transition: all 0.25s linear;\n    background: #F5F5F5;\n    position: relative;\n    z-index: 1;\n    box-sizing: border-box;\n\n}\n#MyTable{\ndisplay:contents;\n\n}\n\n.YTImg {\n    background-image: url(\"https:\/\/selfimagination.in\/tips\/wp-content\/uploads\/2024\/03\/yt.png\");\n    background-repeat: no-repeat;\n    width: 50px;\n    height: 40px;\n    margin: 0;\n    padding: 0;\ncolor:red;\n}\n.myTD\n{\n  padding:0px !important;\n}\n\n<\/style>\n<fieldset>\n\t\t<input type=\"text\" name=\"myInput\" id=\"myInput\" value=\"Search\" onblur=\"if (this.value == '') {this.value = 'Search';}\" onfocus=\"if (this.value == 'Search') {this.value = '';}\" placeholder=\"Search\">\n\t\t<button id=\"search-image\" class=\"sbutton\" type=\"button\" value=\"\">\n\t\t\t<i class=\"point-icon icon-search\"><\/i>\n\t\t<\/button>\n\t<\/fieldset>\n<script>\n jQuery(document).ready(function(){\n  jQuery(\"#MyTable\").find(\"table\").addClass(\"fbox MyRow\");\n  jQuery(\"#MyTable\").find(\"tr\").addClass(\"mbox\");\n\n        jQuery(\"#myInput\").val('');\n        jQuery(\"#myInput\").on(\"keyup\", function() {\n          var value = jQuery(this).val().toLowerCase();\n          jQuery(\".fbox .mbox\").filter(function() {\n            jQuery(this).toggle(jQuery(this).text().toLowerCase().indexOf(value) > -1)\n          });\n        });\n\njQuery(\".mbox\").each(function( index ) {\n  let Obj = jQuery( this ).children()[2];\n  let Link = Obj.innerHTML.trim();\nif (Link.length > 10)\n{\n    jQuery(Obj).addClass(\"myTD\");\n    Obj.innerHTML = '<a href=\"'+Link +'\" target=\"_blank\" ><div class=\"YTImg\">.<\/div><\/a>';\n}\n  \n});\n\n\n      });\n<\/script>\n\n\n\n<figure id=\"MyTable\" class=\"wp-block-table\"><table><thead><tr><th>Methods<\/th><th>Description<\/th><th><\/th><\/tr><\/thead><tbody><tr><td><a href=\"#onOpen\">onOpen<\/a><\/td><td>jab bhi hame Sheet open hone par koi script execute karna ho tab<\/td><td>https:\/\/youtu.be\/Pkzl_vhvUBM\/&amp;t=36<\/td><\/tr><tr><td><a href=\"#onSelectionChange\">onSelectionChange<\/a> <\/td><td>jab Sheet ke kisi cell par Selection (Cursor) Move karne par Script Execute<\/td><td>https:\/\/youtu.be\/Pkzl_vhvUBM\/&amp;t=133<\/td><\/tr><tr><td><a href=\"#onEdit\">onEdit<\/a><\/td><td>jab Sheet ke kisi cell par value change karne par Script Execute karna ho tab<\/td><td>https:\/\/youtu.be\/Pkzl_vhvUBM\/&amp;t=236<\/td><\/tr><tr><td><a href=\"#Alert\">Alert<\/a><\/td><td>User ko Message Display karne ke liye<\/td><td>https:\/\/youtu.be\/q2zhykKaWvA<\/td><\/tr><tr><td><a href=\"#Prompt\">Prompt<\/a><\/td><td>User se Input lene ke liye <\/td><td>https:\/\/youtu.be\/ZLlAFuE6Zrc<\/td><\/tr><tr><td><a href=\"#Toast\">Toast<\/a><\/td><td>Botton Right Corner par Message Display kar automatic use hide karne liye<\/td><td>https:\/\/youtu.be\/my7ddCQCEbk<\/td><\/tr><tr><td>ShowModalDialog<\/td><td>External Dialog Box Open karne ke liye<\/td><td>https:\/\/youtu.be\/yOEClwgpSRc<\/td><\/tr><tr><td>ShowModelessDialog<\/td><td>isme Dialog open bhi rahta hain or aap Sheet par working bhi kar sakte hain<\/td><td>https:\/\/youtu.be\/uc1dXDapM6A<\/td><\/tr><tr><td>showSidebar<\/td><td>Sidebar &#8211; Left side me box dikhane ke liye <\/td><td>https:\/\/youtu.be\/ifhTbXfVPwI<\/td><\/tr><tr><td>createMenu<\/td><td>Custom Menu, SubMenu banane ke lilye<\/td><td>https:\/\/youtu.be\/J3u_Uvx6OkA<\/td><\/tr><tr><td>HTMLService<\/td><td>HTML Content Kaise dikhaye<\/td><td>https:\/\/youtu.be\/38nFyIV58l0<\/td><\/tr><tr><td>Clickable Image<\/td><td>Image Button<\/td><td>https:\/\/youtu.be\/Pjkq8BTIhv4<\/td><\/tr><tr><td>Image Display<\/td><td>Google Drive to Google Sheet <\/td><td>https:\/\/youtu.be\/havAFnr3sUI<\/td><\/tr><tr><td>Product Gallery<\/td><td>Display your Product Detail with Image, Name, Description, MRP, Price <\/td><td>https:\/\/youtu.be\/LXJSKe8fpTs<\/td><\/tr><tr><td>Google Sheet Search<\/td><td>Search Sheet with name using Sidebar<\/td><td>https:\/\/youtu.be\/xQ11Wn0IuQs<\/td><\/tr><tr><td><a href=\"https:\/\/selfimagination.in\/tips\/submit-html-form-to-google-sheet\/\">HTML to Sheet<\/a><\/td><td>HTML Form (Localhost) Submit to Google Sheet <\/td><td>https:\/\/youtu.be\/lKeFN4JxRB8<\/td><\/tr><tr><td><a href=\"https:\/\/selfimagination.in\/tips\/google-sheet-to-html-table-using-apps-script\/\">Sheet to HTML Table<\/a><\/td><td>Pull Data From Sheet To HTML Table (Localhost)<\/td><td>https:\/\/youtu.be\/dc1z2QcPmDo<\/td><\/tr><tr><td><a href=\"https:\/\/selfimagination.in\/tips\/google-sheets-api-apps-script\/\">Sheet to HTML (Web)<\/a><\/td><td>Google Sheet to HTML Table (Web)<\/td><td>https:\/\/youtu.be\/N9kgbSgRAPE<\/td><\/tr><tr><td><a href=\"https:\/\/selfimagination.in\/tips\/dynamic-html-dropdown-from-google-sheet\/\">Dynamic Select<\/a><\/td><td>Dynamic HTML Dropdown from Sheet<\/td><td>https:\/\/youtu.be\/mPn7sGxbfOA<\/td><\/tr><tr><td><a href=\"https:\/\/selfimagination.in\/tips\/complete-invoice-with-calculation\/\">Get Next Number<\/a><\/td><td>Next Invoice Number<\/td><td>https:\/\/youtu.be\/rLLGdnTyj44<\/td><\/tr><tr><td><a href=\"https:\/\/selfimagination.in\/tips\/search-html-invoice-google-sheet-apps-script\/\">Search Invoice<\/a><\/td><td>HTML Invoice Search From Google Sheet<\/td><td>https:\/\/youtu.be\/BunOO__Ftk0<\/td><\/tr><tr><td><a href=\"https:\/\/selfimagination.in\/tips\/modify-google-sheet-from-html\/\">Update Sheet<\/a><\/td><td>Modify Google Sheet from Html<\/td><td>https:\/\/youtu.be\/ErdUfo4YxIo<\/td><\/tr><tr><td><a href=\"https:\/\/selfimagination.in\/tips\/display-google-sheets-data-in-a-table\/\">Display &amp; Open<\/a><\/td><td>How to Display Google Sheets Data in a Table and Show Details on an HTML Page<\/td><td>https:\/\/youtu.be\/RjTZiMRUy2A<\/td><\/tr><tr><td><a href=\"https:\/\/selfimagination.in\/tips\/upload-image-to-google-drive-sheet-apps-script\/\">Upload Image to Drive<\/a><\/td><td>How to Upload Images from Local Host or Server to Google Drive<\/td><td>https:\/\/youtu.be\/Q5TKeqxcpCU<\/td><\/tr><tr><td><a href=\"https:\/\/selfimagination.in\/tips\/upload-image-to-google-drive-sheet-apps-script\/\">Upload Image to Sheet<\/a><\/td><td>How to Upload Images from Local Host or Server to Google Sheet <\/td><td>https:\/\/youtu.be\/RJYDb__wLCI<\/td><\/tr><tr><td><a href=\"https:\/\/selfimagination.in\/tips\/change-date-format-html-form-to-sheets\/\">Date Format<\/a><\/td><td>Sending HTML Form Data to Google Sheets (DD-MM-YYYY Format) <\/td><td>https:\/\/youtu.be\/xJJHA345BNg<\/td><\/tr><tr><td><a href=\"https:\/\/selfimagination.in\/tips\/customizing-apps-script-output\">createHtmlOutput<\/a><\/td><td>Customizing Apps Script Output<\/td><td>https:\/\/youtu.be\/J3abjSdPaj4<\/td><\/tr><tr><td><a href=\"https:\/\/selfimagination.in\/tips\/fetch-item-rates-from-google-sheets\/\">Get Item Rate<\/a><\/td><td>Fetch Item Rates from Google Sheets<\/td><td>https:\/\/youtu.be\/kswAIttEdcM<\/td><\/tr><tr><td><a href=\"https:\/\/selfimagination.in\/tips\/creating-a-simple-login-apps-script\/\">Simple Login<\/a><\/td><td>Simple Login System<\/td><td>https:\/\/youtu.be\/Ls1JR8QUrbA<\/td><\/tr><tr><td><a href=\"https:\/\/selfimagination.in\/tips\/user-registration-system-apps-script\/\">User Registration<\/a><\/td><td>User Registration System<\/td><td>https:\/\/youtu.be\/hG87WrXkDSk<\/td><\/tr><tr><td><a href=\"https:\/\/selfimagination.in\/tips\/secure-login-logout-user-registration-session\/\">Secure Login<\/a><\/td><td>Secure Login, Logout, and User Registration with Session<\/td><td>https:\/\/youtu.be\/90SQmafC1HU<\/td><\/tr><tr><td><a href=\"https:\/\/selfimagination.in\/tips\/user-registration-with-otp-mail\/\">Email OTP<\/a><\/td><td>Email OTP While User Registration in Google<\/td><td>https:\/\/youtu.be\/ZfTGavM9D7w<\/td><\/tr><tr><td><a href=\"https:\/\/selfimagination.in\/tips\/forgot-password-mail-using-apps-script\/\">Forgot Password<\/a><\/td><td>How to e-mail password when forgot password<\/td><td>https:\/\/youtu.be\/3EXteOuX_Js<\/td><\/tr><tr><td><a href=\"https:\/\/selfimagination.in\/tips\/multiple-pages-in-google-apps-script-web-app\/\">Navigation<\/a><\/td><td>Dynamic Web App Navigation &amp; Multiple Pages Tutorial<\/td><td>https:\/\/youtu.be\/jtHULVi0Ed4<\/td><\/tr><tr><td><a href=\"https:\/\/selfimagination.in\/tips\/how-to-set-title-in-html\/\">Set Title<\/a><\/td><td>Set Title on HTML Page<\/td><td>https:\/\/youtu.be\/qiQeDxcNg6E<\/td><\/tr><tr><td><a href=\"https:\/\/selfimagination.in\/tips\/secure-login-logout-user-registration-session\/\">User Info<\/a><\/td><td>Display User Information on the Home Page<\/td><td>https:\/\/youtu.be\/i0J_xpruB1o<\/td><\/tr><tr><td><a href=\"https:\/\/selfimagination.in\/tips\/unique-data-dropdown-apps-script\/\">Unique Dropdown<\/a><\/td><td>Unique Data Dropdown | Eliminate Duplicates<\/td><td>https:\/\/youtu.be\/kq5-jPZUMN8<\/td><\/tr><tr><td><a href=\"https:\/\/selfimagination.in\/tips\/dependent-dropdowns-with-apps-script\/\">Dependent Dropdown<\/a><\/td><td>Google Sheets Dependent Dropdowns<\/td><td>https:\/\/youtu.be\/wyAnzXmBGG8<\/td><\/tr><tr><td><a href=\"https:\/\/selfimagination.in\/tips\/create-dynamic-html-forms-apps-script-crud\/\">Create Dynamic HTML<\/a><\/td><td>Create Dynamic HTML Forms Using Google Apps Script &#8211; CRUD<\/td><td>https:\/\/youtu.be\/eyn15ND58OQ<\/td><\/tr><tr><td><a href=\"https:\/\/selfimagination.in\/tips\/read-dynamic-google-sheet-data-to-html\/\">Read Dynamic Sheet<\/a><\/td><td>Dynamic Google Sheet Data to HTML Table  &#8211; CRUD<\/td><td>https:\/\/youtu.be\/qKnM0CAfyuU<\/td><\/tr><tr><td><a href=\"https:\/\/selfimagination.in\/tips\/update-google-sheet-from-html-table-crud\/\">Update Dynamic Form<\/a><\/td><td>Update &#8211; Google Sheet Data to HTML Table | Interactive Form  &#8211; CRUD<\/td><td>https:\/\/youtu.be\/DD-VvIMYhOg<\/td><\/tr><tr><td><a href=\"https:\/\/selfimagination.in\/tips\/delete-sheet-row-using-apps-script-web-api\/\">Delete Dynamic App<\/a><\/td><td>Delete Button Web API &#8211; CRUD<\/td><td>https:\/\/youtu.be\/NlLwrvGsp-Y<\/td><\/tr><tr><td>Pagination<\/td><td>Pagination: Infinite Scroll<\/td><td>https:\/\/youtu.be\/5KoJBAZOUGo<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"onOpen\">onOpen<\/h2>\n\n\n\n<p>\u091c\u092c \u092d\u0940 \u0939\u092e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0915\u0940 Sheet open \u0939\u094b\u0924\u0947  \u0939\u0940 Code Execute \u0939\u094b \u0924\u092c \u0939\u092e onOpen Event \u092f\u093e Method \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">function onOpen(e) {\n    let ui  = SpreadsheetApp.getUi();\n    ui.alert(\"onOpen\");\n}<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"onSelectionChange\">onSelectionChange <\/h2>\n\n\n\n<p>\u091c\u092c \u092d\u0940 \u0906\u092a\u0915\u0940 \u0915\u093f\u0938\u0940 \u092d\u0940 Cell \u092a\u0930 \u0938\u0947 Cursor \u0915\u094b \u0939\u091f\u093e \u0915\u0930 \u0905\u0928\u094d\u092f \u0915\u093f\u0938\u0940 Cell \u092a\u0930 \u0932\u0947 \u091c\u093e\u0924\u0947 \u0939\u0948\u0902 \u0924\u092c \u092f\u0939 Event \/ Trigger Execute \u0939\u094b\u0924\u093e \u0939\u0948\u0902\u0964  \u0907\u0938\u092e\u0947 \u092e\u0947 \u0906\u092a\u0915\u094b Range parameter \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0939\u094b\u0924\u093e \u0939\u0948 \u091c\u093f\u0938 cell \u092f\u093e Range (\u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 Cell) \u092a\u0930 \u0938\u0947 \u0906\u092a\u0928\u0947 cursor \u0939\u091f\u093e\u092f\u093e \u0939\u0948\u0902 \u0935\u0939 Range \u0907\u0938\u092e\u0947 Parameter \u092e\u0947 \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0939\u094b\u0924\u0940 \u0939\u0948\u0902  \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">function onSelectionChange(e) {\n  let ui  = SpreadsheetApp.getUi();\n  const range = e.range;\n  range.setBackground('lightblue');\n}<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"onEdit\">onEdit <\/h2>\n\n\n\n<p>\u091c\u092c \u092d\u0940 \u0906\u092a Sheet \u092a\u0930 \u0915\u0941\u091b Change \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0924\u092c \u092f\u0939 Event Execute \u0915\u0930\u0924\u0947 \u0939\u0948\u0902\u0964 \u0907\u0938\u092e\u0947 Parameter \u092e\u0947 Cell \u0914\u0930 Range (\u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 cells) \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">function onEdit(e) {\n  let ui  = SpreadsheetApp.getUi();\n  const range = e.range;\n  range.setBackground('lightgreen');  \n}<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"Alert\">Alert<\/h2>\n\n\n\n<p>\u091c\u092c \u092d\u0940 \u0906\u092a\u0915\u094b \u0915\u094b\u0908 Message Box (Alert) \u0926\u093f\u0916\u093e\u0928\u093e \u0939\u094b \u0924\u094b \u0906\u092a Alert \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"javascript\" class=\"language-javascript\">function myOpen() \n{\n  \n  let ui  = SpreadsheetApp.getUi();\n\n  \/\/1. Simple Alert\n  ui.alert(\"Welcome\");\n\n  \/\/2. With Button Set\n  ui.alert(\"Hello\", ui.ButtonSet.YES_NO_CANCEL);\n\n  \/\/3. With Title &amp; Button Set\n  ui.alert(\"Delete\", \"Want to Delete?\", ui.ButtonSet.YES_NO);\n\n\n  \/\/4. Response Handle\n  let res = ui.alert(\"Delete\", \"Want to Delete?\", ui.ButtonSet.YES_NO)\n\n  if (res == ui.Button.YES) {\n      ui.alert(\"Yes\");\n  }\n  else if (res == ui.Button.NO) {\n      ui.alert(\"No\");\n  }\n\n  \n}\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"Prompt\">Prompt<\/h2>\n\n\n\n<p>\u091c\u092c \u0939\u092e\u0928\u0947 Message Box \u092e\u0947 User \u0938\u0947 \u0915\u0941\u091b Input \u0932\u0947\u0928\u093e \u0939\u094b \u0924\u092c \u0939\u092e prompt \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902\u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"javascript\" class=\"language-javascript\">function onOpen() {\n  let ui  = SpreadsheetApp.getUi();\n\n  \/\/1\nlet res1 = ui.prompt(\"Enter Your Name\");\nlet txt1 = res1.getResponseText();\nui.alert(txt1);\n\n\n  \/\/2\n let res2 = ui.prompt(\"Enter Your Name\", ui.ButtonSet.YES_NO);\n let txt2 = res2.getResponseText();\n let btn2 = res2.getSelectedButton();\n if (btn2 == ui.Button.YES)  {\n    ui.alert(txt2);\n }\n \n \n  \/\/3\n  let res3 = ui.prompt(\"Name\", \"Enter Your Name\", ui.ButtonSet.YES_NO);\n  let txt3 = res3.getResponseText();\n  let btn3 = res3.getSelectedButton();\n  if (btn3 == ui.Button.YES)  {\n      ui.alert(txt3);\n  }\n\n\n}\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"Toast\">Toast<\/h2>\n\n\n\n<p>\u091c\u092c \u0939\u092e\u0928\u0947 Bottom Right Corner \u092a\u0930 \u090f\u0915 \u0910\u0938\u093e box \u0926\u093f\u0916\u093e\u0928\u093e \u0939\u094b \u091c\u094b \u0926\u093f\u0916\u093e\u0908 \u0926\u0947 \u0914\u0930 \u0915\u0941\u091b \u0938\u092e\u092f \u092c\u093e\u0926 Hide \u0939\u094b \u091c\u093e\u090f\u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"java\" class=\"language-java\">function myFunction() {\n\n  let sheet = SpreadsheetApp.getActive();\n  \n  sheet.toast(\"Write Message \");\n  sheet.toast(\"Write Message\", \"Title Here\");\n  sheet.toast(\"Write Message\", \"Title Here\", 3);\n  sheet.toast(\"Write Message\", \"Title Here\", 100);\n  \n}<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"showModelessDialog\"><\/h2>\n\n\n\n<p>\u0907\u0938 Article \u092e\u0947 \u0939\u092e\u0928\u0947 Apps Script \u0915\u0940 Basic \u0938\u0947 Advance \u092c\u0939\u0941\u0924 \u0938\u0947 Topic \u0915\u094b Cover \u0915\u093f\u092f\u093e \u0939\u0948\u0902\u0964  \u0906\u0936\u093e \u0939\u0948\u0902 \u0915\u0940 \u0906\u092a\u0915\u094b \u092f\u0939 Google Apps Script Tutorial in Hidi \u092c\u0939\u0941\u0924 \u0905\u091a\u094d\u091b\u0947 \u0938\u0947 \u0938\u092e\u091d \u092e\u0947 \u0906 \u0917\u092f\u093e \u0939\u094b\u0917\u093e\u0964<\/p>\n\n\n\n<p>\u0906\u092a\u0915\u094b \u092f\u0939 Google Apps Script Tutorial \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>Google Apps Script Tutorial : Learn how to utilize Google Apps Script through this comprehensive English tutorial. With live searching option included, you&#8217;ll receive a step-by-step guide to help you automate your projects. Dive in now and streamline your workflows! Google Apps Script \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0948\u0938\u0947 \u0915\u0930\u0947\u0902 \u0938\u0940\u0916\u0947\u0902 \u092f\u0939 \u090f\u0915 \u0938\u0930\u0932 \u0939\u093f\u0902\u0926\u0940 \u091f\u094d\u092f\u0942\u091f\u094b\u0930\u093f\u092f\u0932 \u0915\u0947 \u092e\u093e\u0927\u094d\u092f\u092e [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":12500,"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-12359","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\/2024\/03\/Apps-Script-Tutorial.jpg?fit=1280%2C720&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/12359","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=12359"}],"version-history":[{"count":139,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/12359\/revisions"}],"predecessor-version":[{"id":12508,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/12359\/revisions\/12508"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/12500"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=12359"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=12359"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=12359"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}