{"id":11268,"date":"2023-07-31T20:11:43","date_gmt":"2023-07-31T14:41:43","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=11268"},"modified":"2023-07-31T20:11:46","modified_gmt":"2023-07-31T14:41:46","slug":"google-sheets-api-apps-script","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/google-sheets-api-apps-script\/","title":{"rendered":"How to Use Google Sheets API | Google Sheet to HTML Table in 5 Steps"},"content":{"rendered":"\n<p>Discover how to leverage the power of <strong>Google Sheets API<\/strong> to programmatically access, read, and extract data from Google Sheets. Learn how to transform this data into dynamic HTML tables, allowing you to display and interact with your Google Sheets data on web pages seamlessly. Enhance collaboration, automate data updates, and create user-friendly visualizations with this step-by-step guide to integrating Google Sheets with HTML tables.<\/p>\n\n\n\n<p>Google Sheet API \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0915\u0947 Google Sheet \u0915\u094b HTML Table \u092e\u0947\u0902 \u092c\u0926\u0932\u0928\u0947 \u0915\u0947 \u0924\u0930\u0940\u0915\u0947\u0964 \u0907\u0938 \u092c\u094d\u0932\u0949\u0917 \u092e\u0947\u0902 \u0939\u092e \u092c\u0924\u093e\u090f\u0902\u0917\u0947 \u0915\u093f \u0915\u0948\u0938\u0947 \u0906\u092a Google Sheet API \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0915\u0947 \u0905\u092a\u0928\u0947 Data \u0915\u094b \u090f\u0915 HTML Table \u092e\u0947\u0902 \u092c\u0926\u0932 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 Google Sheet API \u0915\u0947 \u092b\u093e\u092f\u0926\u0947 \u0914\u0930 \u0907\u0938\u0915\u0947 \u0909\u092a\u092f\u094b\u0917 \u0915\u0947 \u0924\u0930\u0940\u0915\u0947 \u0915\u0947 \u0938\u093e\u0925 \u090f\u0915 \u0938\u0930\u0932 \u0914\u0930 \u0938\u094d\u092a\u0937\u094d\u091f \u0935\u093f\u0927\u093f \u0915\u0947 \u092e\u093e\u0927\u094d\u092f\u092e \u0938\u0947 \u0905\u092a\u0928\u0947 \u0921\u0947\u091f\u093e \u0915\u094b Visual \u0930\u0942\u092a \u092e\u0947\u0902 \u092a\u094d\u0930\u0938\u094d\u0924\u0941\u0924 \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0907\u0938 \u092c\u094d\u0932\u0949\u0917 \u0915\u094b \u091c\u0930\u0942\u0930 \u092a\u0922\u093c\u0947\u0902\u0964<\/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-google-sheet\">Step 1 : Create a Google Sheet<\/a><\/li><li><a href=\"#step-2-adding-google-sheets-api\">Step 2 : Adding Google Sheets API<\/a><\/li><li><a href=\"#step-3-google-apps-script-code\">Step 3 : Google Apps Script Code<\/a><\/li><li><a href=\"#step-4-add-html-file\">Step 4 : Add HTML File <\/a><ul><li><a href=\"#related-video-how-to-use-google-sheets-api\">Related Video : How to Use Google Sheets API<\/a><\/li><\/ul><\/li><li><a href=\"#step-5-deploy-google-sheets-api\">Step 5 : Deploy Google Sheets API<\/a><\/li><li><a href=\"#step-6-execution-of-google-sheets-api\">Step 6 : Execution of Google Sheets API<\/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-google-sheet\">Step 1 : Create a Google Sheet<\/h2>\n\n\n\n<p>\u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0947 \u0906\u092a \u090f\u0915 Google Sheet \u092c\u0928\u093e \u0932\u0940\u091c\u093f\u090f, \u091c\u094b \u092d\u0940 Data \u0906\u092a\u0915\u094b HTML \u092a\u0930 \u0926\u093f\u0916\u093e\u0928\u093e \u0939\u094b \u0906\u092a \u0909\u0938\u0947 \u0907\u0938 Sheet \u092e\u0947 \u0907\u0902\u091f\u0930 \u0915\u0930 \u0926\u0940\u091c\u093f\u090f \u0964 Sheet \u092c\u0928\u093e\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0906\u092a\u0915\u094b \u091c\u094b Browser \u092a\u0930 URL \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0917\u0940, \u0909\u0938\u092e\u0947 \u0938\u0947 \u091c\u094b \/ \u0915\u0947 \u092c\u093e\u0926 \u0915\u093e \u0915\u094b\u0921 \u0939\u0948\u0902 \u0935\u0939\u093e\u0901 \u0938\u0947 \/ \u0915\u0947 \u092a\u0939\u0932\u0947 \u0915\u093e \u0915\u094b\u0921 Sheet ID \u0939\u094b\u0924\u093e \u0939\u0948 \u091c\u0948\u0938\u093e \u0915\u0940 \u0928\u0940\u091a\u0947 Image \u092e\u0947 \u0926\u093f\u0916\u093e\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0902 \u0964 \u0938\u093e\u0925 \u0939\u0940 \u092e\u0947 \u0906\u092a\u0915\u094b Bottom \u092e\u0947 \u091c\u094b Sheet Name \u0939\u0948\u0902 \u0909\u0938\u0915\u094b \u092d\u0940 Copy \u0915\u0930\u0928\u093e \u0939\u0948\u0902 , \u0907\u0928 \u0926\u094b\u0928\u094b\u0902 \u0915\u093e \u0939\u0940 \u0909\u092a\u092f\u094b\u0917 \u0906\u0917\u0947 Sheet \u0915\u094b link \u0915\u0930\u0928\u0947 \u092e\u0947 \u0939\u094b\u0917\u093e\u0964 <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-20.png?resize=640%2C374&#038;ssl=1\" alt=\"Google Sheets \" class=\"wp-image-11269\" width=\"640\" height=\"374\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-20.png?resize=1024%2C599&amp;ssl=1 1024w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-20.png?resize=300%2C176&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-20.png?resize=768%2C449&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-20.png?resize=150%2C88&amp;ssl=1 150w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-20.png?w=1461&amp;ssl=1 1461w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-20.png?w=1280&amp;ssl=1 1280w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n<\/div>\n\n\n<p>\u092f\u0939\u093e \u0924\u0915 Step 1 Complete \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0964 \u092f\u0926\u093f \u0906\u092a\u0915\u0947 \u092a\u093e\u0938 \u092a\u0939\u0932\u0947 \u0938\u0947 \u092d\u0940 Sheet \u0939\u0948\u0902 \u0924\u094b \u0909\u0938\u092e\u0947 \u0915\u0947\u0935\u0932 \u0906\u092a\u0915\u094b Sheet ID \u0914\u0930 Sheet \u0915\u093e \u0928\u093e\u092e Copy \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \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-2-adding-google-sheets-api\">Step 2 : Adding Google Sheets API<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0907\u0938\u0915\u0947 \u092c\u093e\u0926 \u0906\u092a Menu \u092e\u0947 \u091c\u093e \u0915\u0930 Extensions \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947 , \u0914\u0930 Apps Script Open \u0915\u0930\u0947 \u0964 <\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-21.png?resize=186%2C108&#038;ssl=1\" alt=\"\" class=\"wp-image-11270\" width=\"186\" height=\"108\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-21.png?w=493&amp;ssl=1 493w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-21.png?resize=300%2C175&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-21.png?resize=150%2C87&amp;ssl=1 150w\" sizes=\"auto, (max-width: 186px) 100vw, 186px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>1. \u0905\u092c \u0906\u092a\u0915\u094b Services \u0915\u0947 \u0938\u093e\u092e\u0928\u0947 \u0935\u093e\u0932\u0947 + Button \u0915\u094b \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0928\u093e \u0939\u0948\u0902  \u0964 <\/li>\n\n\n\n<li>2. \u0907\u0938\u0915\u0947 \u092c\u093e\u0926 \u091c\u094b Page open \u0939\u094b\u0917\u093e \u0909\u0938\u092e\u0947 \u0906\u092a\u0915\u094b Google Sheets API Search \u0915\u0930 Select \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li>3. \u0907\u0938\u0915\u0947 \u092c\u093e\u0926 \u0928\u0940\u091a\u0947 \u090f\u0915 Identifier \u0906\u090f\u0917\u093e , Default \u092e\u0947 \u0907\u0938\u092e\u0947 Sheets \u0932\u093f\u0916\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0906\u092a \u091a\u093e\u0939\u0947 \u0924\u094b Change \u092d\u0940 \u0915\u0930 \u0938\u0915\u0924 \u0939\u0948\u0902 , \u0906\u092a \u091c\u094b \u092d\u0940 Identifier \u0930\u0916\u0947 \u0909\u0938\u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0906\u092a\u0915\u094b Apps Script \u092e\u0947 \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u093e\u0964 <\/li>\n\n\n\n<li>4. \u0907\u0938\u0915\u0947 \u092c\u093e\u0926 \u0906\u092a Add Button \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947\u0902\u0917\u0947 \u091c\u093f\u0938\u0938\u0947 \u0915\u0940 Apps Script \u092e\u0947 Google Sheet Service add \u0939\u094b \u091c\u093e\u090f\u0917\u0940\u0964 <\/li>\n\n\n\n<li>5. \u0914\u0930 Add \u0939\u0941\u0908 Service \u0906\u092a\u0915\u094b Left Panel \u092a\u0930 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0928\u0947 \u0932\u0917\u0947\u0917\u0940\u0964 <\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"316\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-24.png?resize=640%2C316&#038;ssl=1\" alt=\"Google Sheets API Add a Service\" class=\"wp-image-11277\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-24.png?resize=1024%2C506&amp;ssl=1 1024w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-24.png?resize=300%2C148&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-24.png?resize=768%2C379&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-24.png?resize=1536%2C759&amp;ssl=1 1536w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-24.png?resize=60%2C31&amp;ssl=1 60w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-24.png?resize=150%2C74&amp;ssl=1 150w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-24.png?w=1646&amp;ssl=1 1646w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-24.png?w=1280&amp;ssl=1 1280w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<p>\u0907\u0924\u0928\u093e \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0939\u092e Google Apps Script Code \u0932\u093f\u0916\u0947\u0902\u0917\u0947\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-3-google-apps-script-code\">Step 3 : Google Apps Script Code<\/h2>\n\n\n\n<p>Left Panel \u092a\u0930 \u0906\u092a\u0915\u094b Code.js File \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0917\u0940 \u091c\u093f\u0938\u092e\u0947 \u0906\u092a\u0915\u094b \u0928\u093f\u092e\u094d\u0928 Code \u0932\u093f\u0916\u0928\u093e \u0939\u0948\u0964 <\/p>\n\n\n\n<pre title=\"Code.gs\" class=\"wp-block-code\"><code lang=\"javascript\" class=\"language-javascript\">function doGet(e) \/\/01\n{\n    return HtmlService.createTemplateFromFile(\"index\").evaluate();  \/\/02\n}\n\nfunction TableData() \/\/03\n {\n  return Sheets.Spreadsheets.Values.get(\"1Fa9V.......................QI\", \"Inv!A:E\").values; \/\/04\n}<\/code><\/pre>\n\n\n\n<p>\u0906\u0907\u090f \u0905\u092c \u092e\u0947 \u0906\u092a\u0915\u094b \u0909\u092a\u0930\u094b\u0915\u094d\u0924 Code \u0915\u0940 \u092a\u094d\u0930\u0924\u094d\u092f\u0947\u0915 Line \u092e\u0947 \u0915\u094d\u092f\u093e \u0932\u093f\u0916\u093e \u0939\u0948\u0902 \u0909\u0938\u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947 \u0938\u092e\u091d \u0926\u0947\u0924\u093e \u0939\u0941 \u0964 <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>01:<\/strong> doGet() : \u091c\u092c \u092d\u0940 \u0906\u092a Deployment \u0932\u093f\u0902\u0915 \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0924\u092c \u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0947 doGet Function Call \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li><strong>02:<\/strong> \u0907\u0938 Syntax \u092a\u0930 \u0939\u092e \u091c\u094b Next Step \u092e\u0947 HTML File (index.html)  \u092c\u0928\u093e\u090f\u0902\u0917\u0947 \u0909\u0938\u0915\u094b \u0932\u093f\u0902\u0915 \u0915\u0930\u0928\u0947 \u0932\u093f\u090f \u0915\u093f\u092f\u093e \u0939\u0948\u0902\u0964 \u091c\u094b \u092d\u0940 Code \u0907\u0938 Page \u092e\u0947 \u0932\u093f\u0916\u093e \u0939\u094b\u0917\u093e \u0935\u0939 \u0939\u092e\u0947 Browser \u092a\u0930 Display \u0939\u094b \u091c\u093e\u090f\u0917\u093e\u0964 <\/li>\n\n\n\n<li><strong>03:<\/strong> TableData() : \u092f\u0939 \u0939\u092e\u0928\u0947 \u090f\u0915 Custom Function \u092c\u0928\u093e\u092f\u093e \u0939\u0948\u0902 \u0907\u0938 Function \u0915\u094b \u0939\u092e\u0928\u0947 JavaScript Code \u0926\u094d\u0935\u093e\u0930\u093e Call \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0964 \u0914\u0930 \u0907\u0938\u0915\u0947 \u091c\u094b \u0935\u0948\u0932\u094d\u092f\u0942 Return \u0939\u094b\u0917\u0940 \u0909\u0938\u0915\u093e \u0909\u092a\u092f\u094b\u0917 HTML \u092e\u0947 data \u0926\u093f\u0916\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0915\u093f\u092f\u093e \u0939\u0948\u0964 <\/li>\n\n\n\n<li><strong>04:<\/strong> \u0907\u0938 \u0932\u093e\u0907\u0928 \u092a\u0930 \u0939\u092e \u0939\u092e\u093e\u0930\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u092c\u0928\u093e\u0908 \u0917\u0908 Google Sheet File \u0915\u0947 URL \u092e\u0947 \u0938\u0947 ID \u0935\u093e\u0932\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 \u0915\u094b Pass \u0915\u0930\u0947\u0902\u0917\u0947 \u0914\u0930 \u0926\u0942\u0938\u0930\u0947 Parameter \u092e\u0947 \u0939\u092e Sheet \u0915\u093e \u0928\u093e\u092e Pass \u0915\u0930\u0947\u0902\u0917\u0947 \u0914\u0930 ! \u0915\u0947 sign \u0938\u0947 \u0938\u093e\u0925 \u0939\u092e Range Define \u0915\u0930\u0947\u0902\u0917\u0947 \u0964 \u0939\u092e \u091c\u094b \u092d\u0940 Range \u0926\u0947\u0902\u0917\u0947 \u0909\u0924\u0928\u093e Data \u0939\u0940 Google Sheet \u0938\u0947 Read \u0939\u094b \u0915\u0930 HTML \u092a\u0930 display \u0939\u094b\u0928\u0947 \u0932\u0917\u0947\u0917\u093e\u0964 <\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"182\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-22.png?resize=640%2C182&#038;ssl=1\" alt=\"\" class=\"wp-image-11272\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-22.png?resize=1024%2C291&amp;ssl=1 1024w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-22.png?resize=300%2C85&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-22.png?resize=768%2C218&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-22.png?resize=1536%2C436&amp;ssl=1 1536w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-22.png?resize=150%2C43&amp;ssl=1 150w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-22.png?w=1654&amp;ssl=1 1654w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-22.png?w=1280&amp;ssl=1 1280w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-4-add-html-file\">Step 4 : Add HTML File <\/h2>\n\n\n\n<p>\u0907\u0924\u0928\u093e \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0939\u092e HTML File \u092c\u0928\u093e\u090f\u0902\u0917\u0947 \u0964 \u0906\u0907\u090f \u092e\u0947 \u0906\u092a\u0915\u094b HTML \u092b\u093e\u0907\u0932 \u092c\u0928\u093e\u0928\u0947 \u0915\u0940 Process \u0938\u092e\u091d\u093e\u0924\u093e \u0939\u0941 \u0964 <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>1. \u0906\u092a\u0915\u094b File \u0915\u0947 \u0938\u093e\u092e\u0928\u0947 \u0932\u093f\u0916\u0947 \u0939\u0941\u0935\u0947 (+) Add Button \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0928\u093e \u0939\u0948\u0964 <\/li>\n\n\n\n<li>2. \u0909\u0938\u0915\u0947 \u092c\u093e\u0926 \u0906\u092a\u0915\u094b HTML Option select \u0915\u0930\u0928\u093e \u0939\u0948\u0902\u0964 <\/li>\n\n\n\n<li>3. \u0907\u0938\u0915\u0947 \u092c\u093e\u0926 \u0906\u092a\u0915\u094b index \u0932\u093f\u0916\u0928\u093e \u0939\u0948\u0902 \u092f\u0939 file \u0915\u093e \u0928\u093e\u092e \u0939\u0948\u0902 \u092e\u093e\u0928\u093e index connect \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0907\u0938\u0932\u093f\u090f \u092e\u0947 \u092f\u0902\u0939\u093e \u092a\u0930 index \u0932\u093f\u0916 \u0930\u0939\u093e \u0939\u0941\u0964 \u0915\u0947\u0935\u0932 index \u0939\u0940 \u0932\u093f\u0916\u0928\u093e \u0939\u0948\u0902 .html \u0905\u092a\u0928\u0947 \u0906\u092a \u0939\u0940 \u091c\u0941\u095c \u091c\u093e\u090f\u0917\u093e\u0964 <\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"195\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-23.png?resize=640%2C195&#038;ssl=1\" alt=\"Google Apps Script add HTML File\" class=\"wp-image-11273\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-23.png?resize=1024%2C312&amp;ssl=1 1024w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-23.png?resize=300%2C91&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-23.png?resize=768%2C234&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-23.png?resize=1536%2C468&amp;ssl=1 1536w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-23.png?resize=150%2C46&amp;ssl=1 150w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-23.png?w=1654&amp;ssl=1 1654w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-23.png?w=1280&amp;ssl=1 1280w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<p>\u0905\u092c \u091c\u094b \u092b\u093e\u0907\u0932 \u0906\u092a\u0915\u094b \u0926\u093f\u0916\u093e \u0926\u0947 \u0930\u0939\u0940 \u0939\u0948\u0902 \u0909\u0938\u0915\u0947 Code \u0915\u094b \u0906\u092a \u0928\u093f\u092e\u094d\u0928 HTML Code \u0938\u0947 Replace \u0915\u0930 \u0926\u0940\u091c\u093f\u090f\u0917\u093e\u0964<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"related-video-how-to-use-google-sheets-api\">Related Video : How to Use Google Sheets API<\/h4>\n\n\n\n<p>\u092f\u0926\u093f \u091c\u094b \u092d\u0940 \u0907\u0938 Google Sheets API Article \u092e\u0947 \u0932\u093f\u0916\u093e \u0939\u0948\u0902 \u0907\u0938\u0947 \u0906\u092a Video Format \u092e\u0947 \u0926\u0947\u0916\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u092f\u0939\u093e \u0938\u0947 \u0926\u0947\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 <\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Use of Google Sheet API | Google Sheet to HTML Table\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/N9kgbSgRAPE?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<pre title=\"index.html\" class=\"wp-block-code\"><code lang=\"markup\" class=\"language-markup\">&lt;!DOCTYPE html>\n&lt;html>\n  &lt;head>\n    &lt;base target=\"_top\">\n      &lt;link href=\"https:\/\/cdn.jsdelivr.net\/npm\/bootstrap@5.2.3\/dist\/css\/bootstrap.min.css\" rel=\"stylesheet\" integrity=\"sha384-rbsA2VBKQhggwzxH7pPCaAqO46MgnOM80zW1RWuH61DGLwZJEdK2Kadq2F9CUG65\" crossorigin=\"anonymous\">\n      &lt;script src=\"https:\/\/code.jquery.com\/jquery-3.6.3.js\" >&lt;\/script>\n  &lt;\/head>\n  &lt;body>\n      &lt;h1>Welcome&lt;\/h1>\n\n     &lt;table  class=\"table table-striped\">\n      &lt;tbody id=\"MyTBody\">  &lt;!-- 01 -->\n      &lt;\/tbody>\n    &lt;\/table>\n\n\n\n    &lt;script>\n\n      google.script.run.withSuccessHandler(DisplayData).TableData(); \/\/ 02. \n\n      function DisplayData(data)  \/\/ 03.\n      {\n\n        $(document).ready(function () {\n\n\n          var Table=\"\", Rows=\"\", Columns=\"\";\n\n          $.each(data, function(key, value) \/\/ 04 \n          {\n              Columns = \"\";\n              $.each(value, function(key1, value1) \/\/ 05 \n              {\n                Columns = Columns + '&lt;td>' + value1 + '&lt;\/td>'; \/\/ 06 \n              });\n\n              if (Columns != \"\") \/\/ 07 \n              {\n                  Rows = Rows + '&lt;tr>' + Columns + '&lt;\/tr>';\n              }\n          });\n\n          $(\"#MyTBody\").append(Rows); \/\/ 08  \n\n        });\n      }\n\n    &lt;\/script>\n  &lt;\/body>\n&lt;\/html>\n<\/code><\/pre>\n\n\n\n<p>\u0909\u092a\u0930\u094b\u0915\u094d\u0924 Code \u0915\u094b \u0906\u092a\u0915\u094b \u092f\u0939\u093e\u0901 \u092a\u0930 \u0938\u092e\u091d\u0924\u093e \u0939\u0941 \u0964 <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>01.<\/strong> \u092f\u0939\u093e\u0901 \u092a\u0930 \u0939\u092e\u0928\u0947 \u090f\u0915 HTML Table Body \u0915\u093e \u0915\u094b \u090f\u0915 ID Provide \u0915\u0940 \u0939\u0948\u0902\u0964 \u0914\u0930 \u0907\u0938\u0915\u093e \u0907\u0938 \u092a\u0930 \u0939\u092e JavaScript \u0938\u0947 Dynamic TR \u0914\u0930 TD tag \u092c\u0928\u093e \u0915\u0930 Append \u0915\u0930 \u0926\u0947\u0902\u0917\u0947\u0964 <\/li>\n\n\n\n<li><strong>02.<\/strong> \u092f\u0939\u093e\u0901 \u092a\u0930 \u0939\u092e\u0928\u0947 \u091c\u094b Apps Script \u092e\u0947 TableData Function \u092c\u0928\u093e\u092f\u093e \u0925\u093e \u0909\u0938\u0947  JavaScript \u0915\u0947 DisplayData Function \u0938\u0947 \u0932\u093f\u0902\u0915 \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0964 \u091c\u0948\u0938\u0947 \u0939\u0940 JavaScript Execute \u0939\u094b\u0917\u0940 \u0935\u0948\u0938\u0947 \u0939\u0940 Apps Script \u0915\u093e TableData Function Call \u0939\u094b\u0917\u093e \u0914\u0930 \u0909\u0938\u0915\u093e Return \u0906\u0928\u0947 \u092a\u0930 Javascript \u0915\u093e DisplayData Function Call \u0939\u094b \u091c\u093e\u090f\u0917\u093e\u0964 <\/li>\n\n\n\n<li><strong>03.<\/strong>  \u0907\u0938 Function \u092e\u0947 \u0905\u092a\u0928\u0947 \u090f\u0915 Parameter \u0932\u093f\u092f\u093e \u0939\u0948\u0902 \u0907\u0938\u092e\u0947 \u0915\u0940 data Apps Script \u0938\u0947 \u0906\u090f\u0917\u093e\u0964 <\/li>\n\n\n\n<li><strong>04.<\/strong> \u092f\u0939\u093e \u092a\u0930 \u0939\u092e\u0928\u0947 \u091c\u094b Google Sheet \u0938\u0947 Data \u0906\u092f\u093e \u0939\u0948\u0902 \u0909\u0938\u092e\u0947 \u092c\u0939\u0941\u0924 \u0938\u0940 Rows \u0939\u0948\u0902 \u0907\u0938 Function \u0938\u0947 \u0939\u092e\u0928\u0947 \u092a\u094d\u0930\u0924\u094d\u092f\u0947\u0915 Row \u0915\u094b \u0905\u0932\u0917 \u0905\u0932\u0917 \u0915\u093f\u092f\u093e \u0939\u0948\u0902\u0964 <\/li>\n\n\n\n<li><strong>05.<\/strong> \u0907\u0938 Function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0939\u092e\u0928\u0947 \u091c\u094b \u0909\u092a\u0930\u094b\u0915\u094d\u0924  Function \u0938\u0947 Row \u0906\u0908 \u0939\u0948\u0902 \u0909\u0938\u0915\u094b Column \u092e\u0947 Distribute \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0964 Column \u0915\u0940 value Get \u0915\u0930 \u0932\u0940 \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li><strong>06.<\/strong> \u092f\u0939\u093e \u092a\u0930 \u0939\u092e\u0928\u0947 \u091c\u094b Columns \u0915\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 \u0906\u0908 \u0939\u0948\u0902 \u0909\u0928\u0915\u094b \u0938\u092d\u0940 \u0915\u094b \u091c\u094b\u095c \u0915\u0930 \u090f\u0915 String \u092c\u0928\u093e \u0932\u0940 \u0939\u0948\u0902, \u0938\u093e\u0925 \u092e\u0947 \u0939\u092e\u0928\u0947 \u0906\u0935\u0936\u094d\u092f\u0915\u0924\u093e \u0905\u0928\u0941\u0938\u093e\u0930 TD \u0914\u0930 TR tag \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u092d\u0940 \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u091c\u093f\u0938\u0938\u0947 \u0915\u0940 Dynamic Table Creation \u0939\u094b \u091c\u093e\u090f\u0917\u0940\u0964 <\/li>\n\n\n\n<li><strong>07.<\/strong> \u091c\u093f\u0928 Column \u0915\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 Blank \u0939\u094b\u0917\u0940 \u0909\u0928\u0915\u094b \u092f\u0902\u0939\u093e \u0938\u0947 \u0939\u091f\u093e \u0926\u093f\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0964 <\/li>\n\n\n\n<li><strong>08.<\/strong> \u091c\u094b \u0939\u092e\u0928\u0947 HTML \u092e\u0947 Table \u092c\u0928\u093e\u0908 \u0925\u0940 \u0909\u0938\u0915\u0940 tbody \u092a\u0930 \u0939\u092e\u0928\u0947 \u092f\u0939 \u0909\u092a\u0930\u094b\u0915\u094d\u0924 String \u0915\u094b Append \u0915\u0930 \u0926\u093f\u092f\u093e \u0939\u0948\u0902 \u091c\u093f\u0938\u0938\u0947 \u0915\u0940 \u0906\u092a\u0915\u094b HTML \u092a\u0930 Table \u0915\u093e data display \u0939\u094b \u091c\u093e\u090f\u0917\u093e\u0964 <\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-5-deploy-google-sheets-api\">Step 5 : Deploy Google Sheets API<\/h2>\n\n\n\n<p>\u0907\u0938\u0915\u0947 \u092c\u093e\u0926 \u0905\u092c \u0939\u092e \u0907\u0938 Project \u0915\u094b Deploy \u0915\u0930 \u0932\u0947\u0902\u0917\u0947\u0964 <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"253\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-25.png?resize=640%2C253&#038;ssl=1\" alt=\"Google Sheet API (Web)\" class=\"wp-image-11279\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-25.png?resize=1024%2C404&amp;ssl=1 1024w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-25.png?resize=300%2C118&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-25.png?resize=768%2C303&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-25.png?resize=1536%2C606&amp;ssl=1 1536w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-25.png?resize=150%2C59&amp;ssl=1 150w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-25.png?w=1920&amp;ssl=1 1920w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-25.png?w=1280&amp;ssl=1 1280w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>1. \u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0947 \u0906\u092a\u0915\u094b Deploy Button \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0928\u093e \u0939\u0948\u0902\u0964 <\/li>\n\n\n\n<li>2. New Deployment Select \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li>3. \u0907\u0938\u0915\u0947 \u092c\u093e\u0926 \u091c\u094b Window open \u0939\u094b\u0917\u0940 \u0909\u0938\u092e\u0947 Select Type \u092e\u0947 \u091c\u093e\u090f\u0902\u0917\u0947\u0964 <\/li>\n\n\n\n<li>4. \u0914\u0930 Web App \u0935\u093e\u0932\u0947 Option \u0915\u094b Select \u0915\u0930\u0947\u0902\u0917\u0947\u0964 <\/li>\n\n\n\n<li>5. \u0914\u0930 \u0909\u0938\u0915\u0947 \u092c\u093e\u0926 Deploy Button \u0915\u094b Click \u0915\u0930\u0947\u0902\u0917\u0947\u0964 <\/li>\n<\/ul>\n\n\n\n<p>\u0907\u0938\u0915\u0947 \u092c\u093e\u0926 \u091c\u094b \u092d\u0940 Window open \u0939\u094b \u0906\u092a \u0909\u0928\u0915\u094b Permission \u0926\u0947\u0924\u0947 \u0930\u0939\u0947, \u092f\u0939 Security \u0938\u0947 Related \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0909\u0928 \u0938\u092d\u0940 Message \u0915\u094b Allow \u0915\u0930\u0928\u0947 \u092a\u0930 \u0905\u0902\u0924 \u092e\u0947 \u0906\u092a\u0915\u0947 \u092a\u093e\u0938 \u0928\u093f\u092e\u094d\u0928 \u092a\u094d\u0930\u0915\u093e\u0930 \u0938\u0947 \u0932\u093f\u0902\u0915 \u0906 \u091c\u093e\u090f\u0917\u0940\u0964 <\/p>\n\n\n\n<p><a href=\"https:\/\/selfimagination.in\/tips\/deploying-apps-script-as-a-web-api\/\">Deployment \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947 \u0905\u0927\u093f\u0915 \u091c\u093e\u0928\u0915\u093e\u0930\u0940 \u092f\u093e Deployment \u0915\u0948\u0938\u0947 \u0915\u0930\u0924\u0947 \u0939\u0948 \u091c\u093e\u0928\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947 <\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-6-execution-of-google-sheets-api\">Step 6 : Execution of Google Sheets API<\/h2>\n\n\n\n<p>\u0905\u092c \u0905\u0902\u0924 \u092e\u0947 \u0939\u092e \u0939\u092e\u093e\u0930\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u092c\u0928\u093e\u090f \u0917\u090f Project \u0915\u094b Execute \u0915\u0930 \u0926\u0947\u0916\u0947\u0902\u0917\u0947\u0964 \u0907\u0938\u0915\u0947 \u0932\u093f\u090f \u0906\u092a \u091c\u094b Web App \u0932\u093f\u0902\u0915 \u0906\u0908 \u0939\u0948\u0902 \u0909\u0938\u0915\u0947 Copy \u092d\u0940 \u0915\u0930 \u0932\u0947\u0935\u0947 \u0914\u0930 \u0909\u0938 \u092a\u0930 Click \u0915\u0930 \u0909\u0938\u0947 Execute \u0915\u0930\u0947 \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=\"508\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-27.png?resize=640%2C508&#038;ssl=1\" alt=\"\" class=\"wp-image-11283\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-27.png?w=933&amp;ssl=1 933w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-27.png?resize=300%2C238&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-27.png?resize=768%2C610&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-27.png?resize=150%2C119&amp;ssl=1 150w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<p>Execute \u0915\u0930\u0928\u0947 \u092a\u0930 \u0906\u092a\u0928\u0940 \u0915\u0941\u091b \u0939\u0940 \u0938\u092e\u092f \u092e\u0947 \u0928\u093f\u092e\u094d\u0928 Image \u0905\u0928\u0941\u0938\u093e\u0930 Google Sheets  \u0915\u093e Data HTML Table \u092a\u0930 display \u0939\u094b\u0928\u0947 \u0932\u0917\u0947\u0917\u093e\u0964 <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"119\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-26.png?resize=640%2C119&#038;ssl=1\" alt=\"\" class=\"wp-image-11281\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-26.png?resize=1024%2C191&amp;ssl=1 1024w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-26.png?resize=300%2C56&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-26.png?resize=768%2C143&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-26.png?resize=1536%2C287&amp;ssl=1 1536w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-26.png?resize=150%2C28&amp;ssl=1 150w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-26.png?w=1761&amp;ssl=1 1761w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/07\/image-26.png?w=1280&amp;ssl=1 1280w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<p>\u0906\u0936\u093e \u0939\u0948\u0902 \u092e\u0941\u091d\u0947 \u0906\u092a\u0915\u094b \u0915\u093f\u0938 \u0924\u0930\u0939 \u0938\u0947 Google Sheets API \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 HTML Table \u092e\u0947 data \u0926\u093f\u0916\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902, \u092c\u0939\u0941\u0924 \u0939\u0940 \u0905\u091a\u094d\u091b\u0947 \u0938\u0947 \u0938\u092e\u091d \u0906 \u0917\u092f\u093e \u0939\u094b\u0917\u093e\u0964 \u092f\u0939 Article \u0906\u092a\u0915\u094b \u0915\u0948\u0938\u093e \u0932\u0917\u093e \u091c\u0930\u0942\u0930 \u092c\u0924\u093e\u090f , \u0905\u092a\u0928\u093e \u0915\u0940\u092e\u0924\u0940 \u0938\u092e\u092f \u0926\u0947\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0927\u0928\u094d\u092f\u0935\u093e\u0926 \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=\"\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>Discover how to leverage the power of Google Sheets API to programmatically access, read, and extract data from Google Sheets. Learn how to transform this data into dynamic HTML tables, allowing you to display and interact with your Google Sheets data on web pages seamlessly. Enhance collaboration, automate data updates, and create user-friendly visualizations with [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":11287,"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-11268","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\/07\/Google-Sheet-Api-Apps-Script.jpg?fit=1280%2C720&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/11268","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=11268"}],"version-history":[{"count":98,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/11268\/revisions"}],"predecessor-version":[{"id":11376,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/11268\/revisions\/11376"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/11287"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=11268"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=11268"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=11268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}