{"id":15309,"date":"2023-07-24T09:00:00","date_gmt":"2023-07-24T00:00:00","guid":{"rendered":"https:\/\/www.autooffice.co.kr\/blog\/2023\/07\/24\/understanding-variables-in-apps-script\/"},"modified":"2025-09-15T18:13:30","modified_gmt":"2025-09-15T09:13:30","slug":"understanding-variables-in-apps-script","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/24\/understanding-variables-in-apps-script\/","title":{"rendered":"Understanding Variables in Apps Script"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">This post is a corrected post after AI explains the code included in the book <a href=\"https:\/\/www.autooffice.io\/content\/ebizbooks-apps-script\" target=\"_blank\" rel=\"noopener\" title=\"\">&#8220;Google Apps Script 101: Building Work Automation For Free&#8221;<\/a>. Added a <s>strikethrough<\/s> when editing what AI has written, and added <span style=\"color: #ff3366;\">color<\/span> when edited by author<\/p>\n\n\n<h2>Summary<\/h2>\n<p>In this blog post, we will explore the concept of variables in Apps Script. We will discuss how to declare and assign values to variables, and how their values can be changed throughout the script.<\/p>\n<h2>Table of Contents<\/h2>\n<ul>\n<li><a href=\"#code\">Code<\/a><\/li>\n<li><a href=\"#explanation\">Code Explanation<\/a><\/li>\n<li><a href=\"#example\">Example<\/a><\/li>\n<li><a href=\"#prompt\">AI Prompt<\/a><\/li>\n<\/ul>\n<h2 id=\"code\">Code<\/h2>\n<pre>function variables(){\n  var value = 1\n  Logger.log(value)\n\n  var value = 2\n  Logger.log(value)\n\n  Logger.log(value)\n}\n    <\/pre>\n<h2 id=\"explanation\">Code Explanation<\/h2>\n<p>In the given code, we have a function named &#8220;variables&#8221; that contains three lines of code.<\/p>\n<p><span style=\"color: #ff3366;\">(It&#8217;s actually 5 lines of code, but the AI seems to recognize them as 3 blocks.)<\/span><\/p>\n<ul>\n<li>First, we declare a variable named &#8220;value&#8221; and assign it a value of 1.<\/li>\n<li>Then, we declare another variable with the same name &#8220;value&#8221; and assign it a value of 2. This reassignment does not cause an error and the variable&#8217;s value is updated.<\/li>\n<li>Finally, we log the value of the variable to the logger. Here, the value will be 2, as it was reassigned in the previous line.<\/li>\n<\/ul>\n<h2 id=\"example\">Example<\/h2>\n<p>Let&#8217;s run the &#8220;variables&#8221; function and see the output in the logger:<\/p>\n<pre>variables()\n    <\/pre>\n<h2 id=\"prompt\">AI Prompt<\/h2>\n<p>Write <span style=\"color: #ff3366;\">Apps Script<\/span> function that declares a variable &#8220;value&#8221; and assigns it a value of 1. Then, reassign the variable with the same name &#8220;value&#8221; and assign it a value of 2. Finally, log the value of the variable to the logger.<\/p>","protected":false},"excerpt":{"rendered":"<p>In this blog post, we will explore the concept of variables in Apps Script. We will discuss how to declare and assign values to variables, and how their values can be changed throughout the script.<\/p>\n","protected":false},"author":1,"featured_media":15305,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[5,118],"tags":[512,69,7,518],"class_list":["post-15309","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheet","category-apps-script","tag-ai-assisted","tag-script","tag-spreadsheet","tag-variables"],"translation":{"provider":"WPGlobus","version":"3.0.3","language":"en","enabled_languages":["ko","en"],"languages":{"ko":{"title":true,"content":true,"excerpt":true},"en":{"title":true,"content":true,"excerpt":true}}},"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"{:ko}\uc774 \ube14\ub85c\uadf8 \uae00\uc5d0\uc11c\ub294 \uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8\uc5d0\uc11c \ubcc0\uc218\uc758 \uac1c\ub150\uc744 \ud0d0\uad6c\ud569\ub2c8\ub2e4. \ubcc0\uc218\ub97c \uc120\uc5b8\ud558\uace0 \uac12\uc5d0 \ud560\ub2f9\ud558\ub294 \ubc29\ubc95, \uadf8\ub9ac\uace0 \uc2a4\ud06c\ub9bd\ud2b8 \uc804\uccb4\uc5d0\uc11c \uac12\uc774 \uc5b4\ub5bb\uac8c \ubcc0\uacbd\ub420 \uc218 \uc788\ub294\uc9c0\uc5d0 \ub300\ud574 \ub17c\uc758\ud569\ub2c8\ub2e4.{:}{:en}In this blog post, we will explore the concept of variables in Apps Script. We will discuss how to declare and assign values to variables, and how their values can be changed throughout the script.{:}\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"autooffice\"\/>\n\t<meta name=\"keywords\" content=\"ai assisted,apps script,spreadsheet,variables,\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8,\uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/24\/understanding-variables-in-apps-script\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Tech Blog of autooffice - Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Understanding Variables in Apps Script - Tech Blog of autooffice\" \/>\n\t\t<meta property=\"og:description\" content=\"{:ko}\uc774 \ube14\ub85c\uadf8 \uae00\uc5d0\uc11c\ub294 \uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8\uc5d0\uc11c \ubcc0\uc218\uc758 \uac1c\ub150\uc744 \ud0d0\uad6c\ud569\ub2c8\ub2e4. \ubcc0\uc218\ub97c \uc120\uc5b8\ud558\uace0 \uac12\uc5d0 \ud560\ub2f9\ud558\ub294 \ubc29\ubc95, \uadf8\ub9ac\uace0 \uc2a4\ud06c\ub9bd\ud2b8 \uc804\uccb4\uc5d0\uc11c \uac12\uc774 \uc5b4\ub5bb\uac8c \ubcc0\uacbd\ub420 \uc218 \uc788\ub294\uc9c0\uc5d0 \ub300\ud574 \ub17c\uc758\ud569\ub2c8\ub2e4.{:}{:en}In this blog post, we will explore the concept of variables in Apps Script. We will discuss how to declare and assign values to variables, and how their values can be changed throughout the script.{:}\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/24\/understanding-variables-in-apps-script\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png\" \/>\n\t\t<meta property=\"og:image:width\" content=\"400\" \/>\n\t\t<meta property=\"og:image:height\" content=\"210\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2023-07-24T00:00:00+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-09-15T09:13:30+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Understanding Variables in Apps Script - Tech Blog of autooffice\" \/>\n\t\t<meta name=\"twitter:description\" content=\"{:ko}\uc774 \ube14\ub85c\uadf8 \uae00\uc5d0\uc11c\ub294 \uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8\uc5d0\uc11c \ubcc0\uc218\uc758 \uac1c\ub150\uc744 \ud0d0\uad6c\ud569\ub2c8\ub2e4. \ubcc0\uc218\ub97c \uc120\uc5b8\ud558\uace0 \uac12\uc5d0 \ud560\ub2f9\ud558\ub294 \ubc29\ubc95, \uadf8\ub9ac\uace0 \uc2a4\ud06c\ub9bd\ud2b8 \uc804\uccb4\uc5d0\uc11c \uac12\uc774 \uc5b4\ub5bb\uac8c \ubcc0\uacbd\ub420 \uc218 \uc788\ub294\uc9c0\uc5d0 \ub300\ud574 \ub17c\uc758\ud569\ub2c8\ub2e4.{:}{:en}In this blog post, we will explore the concept of variables in Apps Script. We will discuss how to declare and assign values to variables, and how their values can be changed throughout the script.{:}\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/07\\\/24\\\/understanding-variables-in-apps-script\\\/#blogposting\",\"name\":\"Understanding Variables in Apps Script - Tech Blog of autooffice\",\"headline\":\"Understanding Variables in Apps Script\",\"author\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/autooffice\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/wp\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/02-02_variables.png\",\"width\":696,\"height\":400},\"datePublished\":\"2023-07-24T09:00:00+09:00\",\"dateModified\":\"2025-09-15T18:13:30+09:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/07\\\/24\\\/understanding-variables-in-apps-script\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/07\\\/24\\\/understanding-variables-in-apps-script\\\/#webpage\"},\"articleSection\":\"\\uc2a4\\ud504\\ub808\\ub4dc\\uc2dc\\ud2b8, \\uc571\\uc2a4 \\uc2a4\\ud06c\\ub9bd\\ud2b8, AI Assisted, Apps Script, Spreadsheet, variables\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/07\\\/24\\\/understanding-variables-in-apps-script\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/category\\\/spreadsheet\\\/#listItem\",\"name\":\"\\uc2a4\\ud504\\ub808\\ub4dc\\uc2dc\\ud2b8\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/category\\\/spreadsheet\\\/#listItem\",\"position\":2,\"name\":\"\\uc2a4\\ud504\\ub808\\ub4dc\\uc2dc\\ud2b8\",\"item\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/category\\\/spreadsheet\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/07\\\/24\\\/understanding-variables-in-apps-script\\\/#listItem\",\"name\":\"Understanding Variables in Apps Script\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/07\\\/24\\\/understanding-variables-in-apps-script\\\/#listItem\",\"position\":3,\"name\":\"Understanding Variables in Apps Script\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/category\\\/spreadsheet\\\/#listItem\",\"name\":\"\\uc2a4\\ud504\\ub808\\ub4dc\\uc2dc\\ud2b8\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#organization\",\"name\":\"\\uc624\\ud1a0\\uc624\\ud53c\\uc2a4\",\"description\":\"Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/\",\"telephone\":\"+821024904264\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/wp\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/logo-new2023.png\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/07\\\/24\\\/understanding-variables-in-apps-script\\\/#organizationLogo\",\"width\":1461,\"height\":250},\"image\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/07\\\/24\\\/understanding-variables-in-apps-script\\\/#organizationLogo\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/autooffice\\\/#author\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/autooffice\\\/\",\"name\":\"autooffice\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/07\\\/24\\\/understanding-variables-in-apps-script\\\/#webpage\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/07\\\/24\\\/understanding-variables-in-apps-script\\\/\",\"name\":\"Understanding Variables in Apps Script - Tech Blog of autooffice\",\"description\":\"{:ko}\\uc774 \\ube14\\ub85c\\uadf8 \\uae00\\uc5d0\\uc11c\\ub294 \\uc571\\uc2a4 \\uc2a4\\ud06c\\ub9bd\\ud2b8\\uc5d0\\uc11c \\ubcc0\\uc218\\uc758 \\uac1c\\ub150\\uc744 \\ud0d0\\uad6c\\ud569\\ub2c8\\ub2e4. \\ubcc0\\uc218\\ub97c \\uc120\\uc5b8\\ud558\\uace0 \\uac12\\uc5d0 \\ud560\\ub2f9\\ud558\\ub294 \\ubc29\\ubc95, \\uadf8\\ub9ac\\uace0 \\uc2a4\\ud06c\\ub9bd\\ud2b8 \\uc804\\uccb4\\uc5d0\\uc11c \\uac12\\uc774 \\uc5b4\\ub5bb\\uac8c \\ubcc0\\uacbd\\ub420 \\uc218 \\uc788\\ub294\\uc9c0\\uc5d0 \\ub300\\ud574 \\ub17c\\uc758\\ud569\\ub2c8\\ub2e4.{:}{:en}In this blog post, we will explore the concept of variables in Apps Script. We will discuss how to declare and assign values to variables, and how their values can be changed throughout the script.{:}\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/07\\\/24\\\/understanding-variables-in-apps-script\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/autooffice\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/autooffice\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/wp\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/02-02_variables.png\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/07\\\/24\\\/understanding-variables-in-apps-script\\\/#mainImage\",\"width\":696,\"height\":400},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/07\\\/24\\\/understanding-variables-in-apps-script\\\/#mainImage\"},\"datePublished\":\"2023-07-24T09:00:00+09:00\",\"dateModified\":\"2025-09-15T18:13:30+09:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/\",\"name\":\"\\uc624\\ud1a0\\uc624\\ud53c\\uc2a4\",\"alternateName\":\"autooffice\",\"description\":\"Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Understanding Variables in Apps Script - Tech Blog of autooffice","description":"{:ko}\uc774 \ube14\ub85c\uadf8 \uae00\uc5d0\uc11c\ub294 \uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8\uc5d0\uc11c \ubcc0\uc218\uc758 \uac1c\ub150\uc744 \ud0d0\uad6c\ud569\ub2c8\ub2e4. \ubcc0\uc218\ub97c \uc120\uc5b8\ud558\uace0 \uac12\uc5d0 \ud560\ub2f9\ud558\ub294 \ubc29\ubc95, \uadf8\ub9ac\uace0 \uc2a4\ud06c\ub9bd\ud2b8 \uc804\uccb4\uc5d0\uc11c \uac12\uc774 \uc5b4\ub5bb\uac8c \ubcc0\uacbd\ub420 \uc218 \uc788\ub294\uc9c0\uc5d0 \ub300\ud574 \ub17c\uc758\ud569\ub2c8\ub2e4.{:}{:en}In this blog post, we will explore the concept of variables in Apps Script. We will discuss how to declare and assign values to variables, and how their values can be changed throughout the script.{:}","canonical_url":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/24\/understanding-variables-in-apps-script\/","robots":"max-image-preview:large","keywords":"ai assisted,apps script,spreadsheet,variables,\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8,\uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/24\/understanding-variables-in-apps-script\/#blogposting","name":"Understanding Variables in Apps Script - Tech Blog of autooffice","headline":"Understanding Variables in Apps Script","author":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/autooffice\/#author"},"publisher":{"@id":"https:\/\/www.autooffice.co.kr\/en\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/02-02_variables.png","width":696,"height":400},"datePublished":"2023-07-24T09:00:00+09:00","dateModified":"2025-09-15T18:13:30+09:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/24\/understanding-variables-in-apps-script\/#webpage"},"isPartOf":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/24\/understanding-variables-in-apps-script\/#webpage"},"articleSection":"\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8, \uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8, AI Assisted, Apps Script, Spreadsheet, variables"},{"@type":"BreadcrumbList","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/24\/understanding-variables-in-apps-script\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en#listItem","position":1,"name":"Home","item":"https:\/\/www.autooffice.co.kr\/en","nextItem":{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/spreadsheet\/#listItem","name":"\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8"}},{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/spreadsheet\/#listItem","position":2,"name":"\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8","item":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/spreadsheet\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/24\/understanding-variables-in-apps-script\/#listItem","name":"Understanding Variables in Apps Script"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/24\/understanding-variables-in-apps-script\/#listItem","position":3,"name":"Understanding Variables in Apps Script","previousItem":{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/spreadsheet\/#listItem","name":"\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8"}}]},{"@type":"Organization","@id":"https:\/\/www.autooffice.co.kr\/en\/#organization","name":"\uc624\ud1a0\uc624\ud53c\uc2a4","description":"Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.","url":"https:\/\/www.autooffice.co.kr\/en\/","telephone":"+821024904264","logo":{"@type":"ImageObject","url":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/logo-new2023.png","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/24\/understanding-variables-in-apps-script\/#organizationLogo","width":1461,"height":250},"image":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/24\/understanding-variables-in-apps-script\/#organizationLogo"}},{"@type":"Person","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/autooffice\/#author","url":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/autooffice\/","name":"autooffice"},{"@type":"WebPage","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/24\/understanding-variables-in-apps-script\/#webpage","url":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/24\/understanding-variables-in-apps-script\/","name":"Understanding Variables in Apps Script - Tech Blog of autooffice","description":"{:ko}\uc774 \ube14\ub85c\uadf8 \uae00\uc5d0\uc11c\ub294 \uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8\uc5d0\uc11c \ubcc0\uc218\uc758 \uac1c\ub150\uc744 \ud0d0\uad6c\ud569\ub2c8\ub2e4. \ubcc0\uc218\ub97c \uc120\uc5b8\ud558\uace0 \uac12\uc5d0 \ud560\ub2f9\ud558\ub294 \ubc29\ubc95, \uadf8\ub9ac\uace0 \uc2a4\ud06c\ub9bd\ud2b8 \uc804\uccb4\uc5d0\uc11c \uac12\uc774 \uc5b4\ub5bb\uac8c \ubcc0\uacbd\ub420 \uc218 \uc788\ub294\uc9c0\uc5d0 \ub300\ud574 \ub17c\uc758\ud569\ub2c8\ub2e4.{:}{:en}In this blog post, we will explore the concept of variables in Apps Script. We will discuss how to declare and assign values to variables, and how their values can be changed throughout the script.{:}","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/www.autooffice.co.kr\/en\/#website"},"breadcrumb":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/24\/understanding-variables-in-apps-script\/#breadcrumblist"},"author":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/autooffice\/#author"},"creator":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/autooffice\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/02-02_variables.png","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/24\/understanding-variables-in-apps-script\/#mainImage","width":696,"height":400},"primaryImageOfPage":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/24\/understanding-variables-in-apps-script\/#mainImage"},"datePublished":"2023-07-24T09:00:00+09:00","dateModified":"2025-09-15T18:13:30+09:00"},{"@type":"WebSite","@id":"https:\/\/www.autooffice.co.kr\/en\/#website","url":"https:\/\/www.autooffice.co.kr\/en\/","name":"\uc624\ud1a0\uc624\ud53c\uc2a4","alternateName":"autooffice","description":"Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.","inLanguage":"en-US","publisher":{"@id":"https:\/\/www.autooffice.co.kr\/en\/#organization"}}]},"og:locale":"en_US","og:site_name":"Tech Blog of autooffice - Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.","og:type":"article","og:title":"Understanding Variables in Apps Script - Tech Blog of autooffice","og:description":"{:ko}\uc774 \ube14\ub85c\uadf8 \uae00\uc5d0\uc11c\ub294 \uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8\uc5d0\uc11c \ubcc0\uc218\uc758 \uac1c\ub150\uc744 \ud0d0\uad6c\ud569\ub2c8\ub2e4. \ubcc0\uc218\ub97c \uc120\uc5b8\ud558\uace0 \uac12\uc5d0 \ud560\ub2f9\ud558\ub294 \ubc29\ubc95, \uadf8\ub9ac\uace0 \uc2a4\ud06c\ub9bd\ud2b8 \uc804\uccb4\uc5d0\uc11c \uac12\uc774 \uc5b4\ub5bb\uac8c \ubcc0\uacbd\ub420 \uc218 \uc788\ub294\uc9c0\uc5d0 \ub300\ud574 \ub17c\uc758\ud569\ub2c8\ub2e4.{:}{:en}In this blog post, we will explore the concept of variables in Apps Script. We will discuss how to declare and assign values to variables, and how their values can be changed throughout the script.{:}","og:url":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/24\/understanding-variables-in-apps-script\/","og:image":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png","og:image:secure_url":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png","og:image:width":400,"og:image:height":210,"article:published_time":"2023-07-24T00:00:00+00:00","article:modified_time":"2025-09-15T09:13:30+00:00","twitter:card":"summary_large_image","twitter:title":"Understanding Variables in Apps Script - Tech Blog of autooffice","twitter:description":"{:ko}\uc774 \ube14\ub85c\uadf8 \uae00\uc5d0\uc11c\ub294 \uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8\uc5d0\uc11c \ubcc0\uc218\uc758 \uac1c\ub150\uc744 \ud0d0\uad6c\ud569\ub2c8\ub2e4. \ubcc0\uc218\ub97c \uc120\uc5b8\ud558\uace0 \uac12\uc5d0 \ud560\ub2f9\ud558\ub294 \ubc29\ubc95, \uadf8\ub9ac\uace0 \uc2a4\ud06c\ub9bd\ud2b8 \uc804\uccb4\uc5d0\uc11c \uac12\uc774 \uc5b4\ub5bb\uac8c \ubcc0\uacbd\ub420 \uc218 \uc788\ub294\uc9c0\uc5d0 \ub300\ud574 \ub17c\uc758\ud569\ub2c8\ub2e4.{:}{:en}In this blog post, we will explore the concept of variables in Apps Script. We will discuss how to declare and assign values to variables, and how their values can be changed throughout the script.{:}","twitter:image":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png"},"aioseo_meta_data":{"post_id":"15309","title":null,"description":null,"keywords":null,"keyphrases":{"focus":{"keyphrase":"apps script","score":43,"analysis":{"keyphraseInTitle":{"score":3,"maxScore":9,"error":1},"keyphraseInDescription":{"score":3,"maxScore":9,"error":1},"keyphraseLength":{"score":9,"maxScore":9,"error":0,"length":2},"keyphraseInURL":{"score":5,"maxScore":5,"error":0},"keyphraseInIntroduction":{"score":3,"maxScore":9,"error":1},"keyphraseInSubHeadings":{"score":3,"maxScore":9,"error":1},"keyphraseInImageAlt":{"score":3,"maxScore":9,"error":1},"keywordDensity":{"score":0,"type":"low","maxScore":9,"error":1}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"BlogPosting","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":{"faqs":[],"keyPoints":[],"titles":[],"descriptions":[],"socialPosts":{"email":[],"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"created":"2023-07-24 00:29:06","updated":"2025-09-15 09:14:20","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.autooffice.co.kr\/en\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/spreadsheet\/\" title=\"\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\">\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tUnderstanding Variables in Apps Script\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.autooffice.co.kr\/en"},{"label":"\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/spreadsheet\/"},{"label":"Understanding Variables in Apps Script","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/24\/understanding-variables-in-apps-script\/"}],"_links":{"self":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15309","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/comments?post=15309"}],"version-history":[{"count":4,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15309\/revisions"}],"predecessor-version":[{"id":17204,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15309\/revisions\/17204"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/15305"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=15309"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=15309"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=15309"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}