{"id":13329,"date":"2023-05-06T01:59:02","date_gmt":"2023-05-06T05:59:02","guid":{"rendered":"https:\/\/buzapps.net\/info\/?post_type=knowledgebase&#038;p=13329"},"modified":"2024-06-23T13:42:30","modified_gmt":"2024-06-23T17:42:30","slug":"google-apps-script-setup-with-google-sheets","status":"publish","type":"knowledgebase","link":"https:\/\/buzapps.net\/info\/knowledgebase\/how-to\/google-apps-script-setup-with-google-sheets\/","title":{"rendered":"Google Apps Script Setup (With Google Sheets)"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Follow the instructions below to utilize the Google Apps Script setup.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>1) <\/strong><strong>Open Google Apps Script<\/strong> (<a href=\"https:\/\/script.google.com\/home\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/script.google.com\/home<\/a>).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Click on \u201c<strong>+ New project<\/strong>\u201c.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>2)<\/strong> Rename project name to \u201c<strong>Custom Sheet API<\/strong>\u201c.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>3) <\/strong><strong>Remove default code<\/strong> from the editor.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"768\" height=\"378\" src=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2024\/06\/knowledgebase_google_sheets2_02.png\" alt=\"\" class=\"wp-image-15511\" srcset=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2024\/06\/knowledgebase_google_sheets2_02.png 768w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2024\/06\/knowledgebase_google_sheets2_02-300x148.png 300w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>4)<\/strong><strong> Copy-paste our provided code into the editor<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If not done already, <strong>put your google sheet ID in that code. <\/strong>You can get sheet ID from the sheet URL.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"768\" height=\"35\" src=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2024\/06\/knowledgebase_google_sheets2_01.png\" alt=\"\" class=\"wp-image-15510\" srcset=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2024\/06\/knowledgebase_google_sheets2_01.png 768w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2024\/06\/knowledgebase_google_sheets2_01-300x14.png 300w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/ Your Google Sheet ID.\nconst SHEET_ID = \"\";\n\n\n\/\/ Default Sheet tab name.\nconst SHEET_NAME = \"\";\n\n\n\/\/ Properties\nconst ADD_DATE = false; \/\/ Add time to end column (like the: 22.04.2021 15:30:13)<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>5)<\/strong> Click on the <strong>save project icon<\/strong> and then after click on \u201c<strong>Deploy<\/strong>\u201d button. Select \u201c<strong>New deployment<\/strong>\u201d.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"768\" height=\"170\" src=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2024\/06\/knowledgebase_google_sheets2_03.png\" alt=\"\" class=\"wp-image-15512\" srcset=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2024\/06\/knowledgebase_google_sheets2_03.png 768w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2024\/06\/knowledgebase_google_sheets2_03-300x66.png 300w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>6)<\/strong> Now choose \u201c<strong>Web app<\/strong>\u201d as select type. If you want you can change description. Choose Web app Execute as:\u00a0<strong>Me<\/strong>\u00a0&amp;amp; Who has access:\u00a0<strong>Anyone.<\/strong>\u00a0Then click on the \u201c<strong>Deploy<\/strong>\u201d button.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"768\" height=\"419\" src=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2024\/06\/knowledgebase_google_sheets2_04.png\" alt=\"\" class=\"wp-image-15513\" srcset=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2024\/06\/knowledgebase_google_sheets2_04.png 768w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2024\/06\/knowledgebase_google_sheets2_04-300x164.png 300w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>7)<\/strong> Now <strong>authorize access<\/strong> screen will be displayed like below. <strong>Click on it<\/strong> and select your Google account.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"768\" height=\"167\" src=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2024\/06\/knowledgebase_google_sheets2_05.png\" alt=\"\" class=\"wp-image-15514\" srcset=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2024\/06\/knowledgebase_google_sheets2_05.png 768w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2024\/06\/knowledgebase_google_sheets2_05-300x65.png 300w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">A Google hasn\u2019t verified this app warning will be shown. Click on <strong>Advanced<\/strong>\u00a0and then click on Go to link. Then click on \u201c<strong>Allow<\/strong>\u201c.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"768\" height=\"542\" src=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2024\/06\/knowledgebase_google_sheets2_06.png\" alt=\"\" class=\"wp-image-15515\" srcset=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2024\/06\/knowledgebase_google_sheets2_06.png 768w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2024\/06\/knowledgebase_google_sheets2_06-300x212.png 300w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>8)<\/strong> You should now see the deployment details like <strong>Web app URL<\/strong> as shown in the image below. <strong>Copy web app URL<\/strong> and click on <strong>Done<\/strong>. button.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"768\" height=\"429\" src=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2024\/06\/knowledgebase_google_sheets2_07.png\" alt=\"\" class=\"wp-image-15516\" srcset=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2024\/06\/knowledgebase_google_sheets2_07.png 768w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2024\/06\/knowledgebase_google_sheets2_07-300x168.png 300w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>9) Save the copied information<\/strong> to provide to us.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Follow the instructions below to utilize the Google Apps Script setup. 1) Open Google Apps Script (https:\/\/script.google.com\/home). Click on \u201c+ New project\u201c. 2) Rename project name to \u201cCustom Sheet API\u201c. 3) Remove default code from the editor. 4) Copy-paste our provided code into the editor. If not done already, put your google sheet ID in that code. You can get sheet ID from the sheet URL. 5) Click on the save project icon and then after click on \u201cDeploy\u201d button. Select \u201cNew deployment\u201d. 6) Now choose \u201cWeb app\u201d as select type. If you want you can change description. Choose Web<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","knowledgebase_cat":[35],"class_list":["post-13329","knowledgebase","type-knowledgebase","status-publish","hentry","knowledgebase_cat-how-to"],"_links":{"self":[{"href":"https:\/\/buzapps.net\/info\/wp-json\/wp\/v2\/knowledgebase\/13329","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buzapps.net\/info\/wp-json\/wp\/v2\/knowledgebase"}],"about":[{"href":"https:\/\/buzapps.net\/info\/wp-json\/wp\/v2\/types\/knowledgebase"}],"author":[{"embeddable":true,"href":"https:\/\/buzapps.net\/info\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/buzapps.net\/info\/wp-json\/wp\/v2\/comments?post=13329"}],"version-history":[{"count":3,"href":"https:\/\/buzapps.net\/info\/wp-json\/wp\/v2\/knowledgebase\/13329\/revisions"}],"predecessor-version":[{"id":15517,"href":"https:\/\/buzapps.net\/info\/wp-json\/wp\/v2\/knowledgebase\/13329\/revisions\/15517"}],"wp:attachment":[{"href":"https:\/\/buzapps.net\/info\/wp-json\/wp\/v2\/media?parent=13329"}],"wp:term":[{"taxonomy":"knowledgebase_cat","embeddable":true,"href":"https:\/\/buzapps.net\/info\/wp-json\/wp\/v2\/knowledgebase_cat?post=13329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}