{"id":15380,"date":"2023-07-28T09:00:00","date_gmt":"2023-07-28T00:00:00","guid":{"rendered":"https:\/\/www.autooffice.co.kr\/blog\/2023\/07\/28\/getting-values-from-range-a1a4-in-google-sheets\/"},"modified":"2026-08-21T16:53:39","modified_gmt":"2026-08-21T07:53:39","slug":"getting-values-from-range-a1a4-in-google-sheets","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/28\/getting-values-from-range-a1a4-in-google-sheets\/","title":{"rendered":"Getting Values from Range A1:A4 in Google Sheets"},"content":{"rendered":"<p>This post is a corrected post after AI explains the code included in the book <a title=\"\" href=\"https:\/\/www.autooffice.io\/content\/ebizbooks-apps-script\" target=\"_blank\" rel=\"noopener\">&#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<h2>Table of Contents<\/h2>\n<ul>\n<li><a href=\"#summary\">Summary<\/a><\/li>\n<li><a href=\"#code\">Code<\/a><\/li>\n<li><a href=\"#code-explanation\">Code Explanation<\/a><\/li>\n<li><a href=\"#example\">Example<\/a><\/li>\n<li><a href=\"#ai-prompt\">AI Prompt<\/a><\/li>\n<\/ul>\n<h2 id=\"summary\">Summary<\/h2>\n<p>In this blog post, we will learn how to use Apps Script to get values from a specified range in Google Sheets. Specifically, we will focus on retrieving values from the range A1:A4.<\/p>\n<h2 id=\"code\">Code<\/h2>\n<pre>    function getA1A4Values() {\n      const value = SpreadsheetApp.getActiveSheet().getRange('A1:A4').getValues();\n      Logger.log(value);\n    }\n<\/pre>\n<h2 id=\"code-explanation\">Code Explanation<\/h2>\n<p>The provided code snippet defines a function named <code>getA1A4Values<\/code>. Inside the function, it uses Apps Script&#8217;s <code>SpreadsheetApp<\/code> class to access the active sheet and retrieve the values from the range A1:A4. The retrieved values are then logged to the Logger.<\/p>\n<p><span style=\"color: #ff3366;\">Retrieving data from A1:A4 is different from retrieving data from A1:E1 because the former involves fetching values from a column, while the latter deals with values from a row. A1:E1 represents a 2D array with a single row containing five elements, whereas A1:A4 represents a 2D array with four rows, each containing a single element. Understanding these differences is crucial as it forms the foundation for utilizing Apps Script in Google Sheets. <\/span><\/p>\n<p><span style=\"color: #ff3366;\">If you ask the AI for examples of each log, it would respond as follows:<\/span><\/p>\n<p>Data from range A1:E1:<br \/>\n[ [John, Alice, Bob, Mary, Eve] ]<\/p>\n<p>Data from range A1:A4:<br \/>\n[ [John], [Alice], [Bob], [Mary] ]<\/p>\n<h2 id=\"example\">Example<\/h2>\n<p>Before running the code, open a Google Sheet and activate the sheet from which you want to retrieve the values. Then, follow these steps:<\/p>\n<ol>\n<li>Click on the &#8220;Extensions&#8221; menu.<\/li>\n<li>Select &#8220;Apps Script&#8221;.<\/li>\n<li>A new tab will open with the Apps Script editor.<\/li>\n<li>Paste the provided code into the editor.<\/li>\n<li>Save the script by clicking on the floppy disk icon or using the &#8220;File&#8221; menu.<\/li>\n<li>Click on the play button to run the script.<\/li>\n<li>Open the &#8220;View&#8221; menu and select &#8220;Logs&#8221; to see the retrieved values logged in the console.<\/li>\n<\/ol>\n<p><span style=\"color: #ff3366;\">Since there is no context provided to AI, AI explained the basics.<\/span><\/p>\n<h2 id=\"ai-prompt\">AI Prompt<\/h2>\n<p>How can I retrieve the values from the range A1:A4 in Google Sheets using Apps Script?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this blog post, we will learn how to use Apps Script to get values from a specified range in Google Sheets. Specifically, we will focus on retrieving values from the range A1:A4.<\/p>\n","protected":false},"author":1,"featured_media":15384,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_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":[118],"tags":[512,355,521,7],"class_list":["post-15380","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-apps-script","tag-ai-assisted","tag-apps-script","tag-getvalues","tag-spreadsheet"],"translation":{"provider":"WPGlobus","version":"3.0.5","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 5.0.3 - aioseo.com -->\n\t<meta name=\"description\" content=\"{:ko}\uc774 \ube14\ub85c\uadf8 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 Apps Script\ub97c \uc0ac\uc6a9\ud558\uc5ec \uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 \uc9c0\uc815\ub41c \ubc94\uc704\uc5d0\uc11c \uac12\uc744 \uac00\uc838\uc624\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ud2b9\ud788, A1:A4 \ubc94\uc704\uc5d0\uc11c \uac12\uc744 \uac00\uc838\uc624\ub294 \uac83\uc5d0 \ucd08\uc810\uc744 \ub9de\ucd9c \uac83\uc785\ub2c8\ub2e4.{:}{:en}In this blog post, we will learn how to use Apps Script to get values from a specified range in Google Sheets. Specifically, we will focus on retrieving values from the range A1:A4.{:}\" \/>\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,getvalues,spreadsheet,\uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/28\/getting-values-from-range-a1a4-in-google-sheets\/\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\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=\"Getting Values from Range A1:A4 in Google Sheets - Tech Blog of autooffice\" \/>\n\t\t<meta property=\"og:description\" content=\"{:ko}\uc774 \ube14\ub85c\uadf8 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 Apps Script\ub97c \uc0ac\uc6a9\ud558\uc5ec \uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 \uc9c0\uc815\ub41c \ubc94\uc704\uc5d0\uc11c \uac12\uc744 \uac00\uc838\uc624\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ud2b9\ud788, A1:A4 \ubc94\uc704\uc5d0\uc11c \uac12\uc744 \uac00\uc838\uc624\ub294 \uac83\uc5d0 \ucd08\uc810\uc744 \ub9de\ucd9c \uac83\uc785\ub2c8\ub2e4.{:}{:en}In this blog post, we will learn how to use Apps Script to get values from a specified range in Google Sheets. Specifically, we will focus on retrieving values from the range A1:A4.{:}\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/28\/getting-values-from-range-a1a4-in-google-sheets\/\" \/>\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-28T00:00:00+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-08-21T07:53:39+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Getting Values from Range A1:A4 in Google Sheets - Tech Blog of autooffice\" \/>\n\t\t<meta name=\"twitter:description\" content=\"{:ko}\uc774 \ube14\ub85c\uadf8 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 Apps Script\ub97c \uc0ac\uc6a9\ud558\uc5ec \uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 \uc9c0\uc815\ub41c \ubc94\uc704\uc5d0\uc11c \uac12\uc744 \uac00\uc838\uc624\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ud2b9\ud788, A1:A4 \ubc94\uc704\uc5d0\uc11c \uac12\uc744 \uac00\uc838\uc624\ub294 \uac83\uc5d0 \ucd08\uc810\uc744 \ub9de\ucd9c \uac83\uc785\ub2c8\ub2e4.{:}{:en}In this blog post, we will learn how to use Apps Script to get values from a specified range in Google Sheets. Specifically, we will focus on retrieving values from the range A1:A4.{:}\" \/>\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\\\/28\\\/getting-values-from-range-a1a4-in-google-sheets\\\/#blogposting\",\"name\":\"Getting Values from Range A1:A4 in Google Sheets - Tech Blog of autooffice\",\"headline\":\"Getting Values from Range A1:A4 in Google Sheets\",\"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\\\/getA1A4Values.png\",\"width\":696,\"height\":400},\"datePublished\":\"2023-07-28T09:00:00+09:00\",\"dateModified\":\"2026-08-21T16:53:39+09:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/07\\\/28\\\/getting-values-from-range-a1a4-in-google-sheets\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/07\\\/28\\\/getting-values-from-range-a1a4-in-google-sheets\\\/#webpage\"},\"articleSection\":\"\\uc571\\uc2a4 \\uc2a4\\ud06c\\ub9bd\\ud2b8, AI Assisted, Apps Script, getValues, Spreadsheet\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/07\\\/28\\\/getting-values-from-range-a1a4-in-google-sheets\\\/#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\\\/apps-script\\\/#listItem\",\"name\":\"\\uc571\\uc2a4 \\uc2a4\\ud06c\\ub9bd\\ud2b8\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/category\\\/apps-script\\\/#listItem\",\"position\":2,\"name\":\"\\uc571\\uc2a4 \\uc2a4\\ud06c\\ub9bd\\ud2b8\",\"item\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/category\\\/apps-script\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/07\\\/28\\\/getting-values-from-range-a1a4-in-google-sheets\\\/#listItem\",\"name\":\"Getting Values from Range A1:A4 in Google Sheets\"},\"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\\\/28\\\/getting-values-from-range-a1a4-in-google-sheets\\\/#listItem\",\"position\":3,\"name\":\"Getting Values from Range A1:A4 in Google Sheets\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/category\\\/apps-script\\\/#listItem\",\"name\":\"\\uc571\\uc2a4 \\uc2a4\\ud06c\\ub9bd\\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\\\/28\\\/getting-values-from-range-a1a4-in-google-sheets\\\/#organizationLogo\",\"width\":1461,\"height\":250},\"image\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/07\\\/28\\\/getting-values-from-range-a1a4-in-google-sheets\\\/#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\\\/28\\\/getting-values-from-range-a1a4-in-google-sheets\\\/#webpage\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/07\\\/28\\\/getting-values-from-range-a1a4-in-google-sheets\\\/\",\"name\":\"Getting Values from Range A1:A4 in Google Sheets - Tech Blog of autooffice\",\"description\":\"{:ko}\\uc774 \\ube14\\ub85c\\uadf8 \\ud3ec\\uc2a4\\ud2b8\\uc5d0\\uc11c\\ub294 Apps Script\\ub97c \\uc0ac\\uc6a9\\ud558\\uc5ec \\uad6c\\uae00 \\uc2a4\\ud504\\ub808\\ub4dc\\uc2dc\\ud2b8\\uc758 \\uc9c0\\uc815\\ub41c \\ubc94\\uc704\\uc5d0\\uc11c \\uac12\\uc744 \\uac00\\uc838\\uc624\\ub294 \\ubc29\\ubc95\\uc5d0 \\ub300\\ud574 \\uc54c\\uc544\\ubcf4\\uaca0\\uc2b5\\ub2c8\\ub2e4. \\ud2b9\\ud788, A1:A4 \\ubc94\\uc704\\uc5d0\\uc11c \\uac12\\uc744 \\uac00\\uc838\\uc624\\ub294 \\uac83\\uc5d0 \\ucd08\\uc810\\uc744 \\ub9de\\ucd9c \\uac83\\uc785\\ub2c8\\ub2e4.{:}{:en}In this blog post, we will learn how to use Apps Script to get values from a specified range in Google Sheets. Specifically, we will focus on retrieving values from the range A1:A4.{:}\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/07\\\/28\\\/getting-values-from-range-a1a4-in-google-sheets\\\/#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\\\/getA1A4Values.png\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/07\\\/28\\\/getting-values-from-range-a1a4-in-google-sheets\\\/#mainImage\",\"width\":696,\"height\":400},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/07\\\/28\\\/getting-values-from-range-a1a4-in-google-sheets\\\/#mainImage\"},\"datePublished\":\"2023-07-28T09:00:00+09:00\",\"dateModified\":\"2026-08-21T16:53:39+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":"Getting Values from Range A1:A4 in Google Sheets - Tech Blog of autooffice","description":"{:ko}\uc774 \ube14\ub85c\uadf8 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 Apps Script\ub97c \uc0ac\uc6a9\ud558\uc5ec \uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 \uc9c0\uc815\ub41c \ubc94\uc704\uc5d0\uc11c \uac12\uc744 \uac00\uc838\uc624\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ud2b9\ud788, A1:A4 \ubc94\uc704\uc5d0\uc11c \uac12\uc744 \uac00\uc838\uc624\ub294 \uac83\uc5d0 \ucd08\uc810\uc744 \ub9de\ucd9c \uac83\uc785\ub2c8\ub2e4.{:}{:en}In this blog post, we will learn how to use Apps Script to get values from a specified range in Google Sheets. Specifically, we will focus on retrieving values from the range A1:A4.{:}","canonical_url":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/28\/getting-values-from-range-a1a4-in-google-sheets\/","robots":"max-image-preview:large","keywords":"ai assisted,apps script,getvalues,spreadsheet,\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\/28\/getting-values-from-range-a1a4-in-google-sheets\/#blogposting","name":"Getting Values from Range A1:A4 in Google Sheets - Tech Blog of autooffice","headline":"Getting Values from Range A1:A4 in Google Sheets","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\/getA1A4Values.png","width":696,"height":400},"datePublished":"2023-07-28T09:00:00+09:00","dateModified":"2026-08-21T16:53:39+09:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/28\/getting-values-from-range-a1a4-in-google-sheets\/#webpage"},"isPartOf":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/28\/getting-values-from-range-a1a4-in-google-sheets\/#webpage"},"articleSection":"\uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8, AI Assisted, Apps Script, getValues, Spreadsheet"},{"@type":"BreadcrumbList","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/28\/getting-values-from-range-a1a4-in-google-sheets\/#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\/apps-script\/#listItem","name":"\uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8"}},{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/apps-script\/#listItem","position":2,"name":"\uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8","item":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/apps-script\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/28\/getting-values-from-range-a1a4-in-google-sheets\/#listItem","name":"Getting Values from Range A1:A4 in Google Sheets"},"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\/28\/getting-values-from-range-a1a4-in-google-sheets\/#listItem","position":3,"name":"Getting Values from Range A1:A4 in Google Sheets","previousItem":{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/apps-script\/#listItem","name":"\uc571\uc2a4 \uc2a4\ud06c\ub9bd\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\/28\/getting-values-from-range-a1a4-in-google-sheets\/#organizationLogo","width":1461,"height":250},"image":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/28\/getting-values-from-range-a1a4-in-google-sheets\/#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\/28\/getting-values-from-range-a1a4-in-google-sheets\/#webpage","url":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/28\/getting-values-from-range-a1a4-in-google-sheets\/","name":"Getting Values from Range A1:A4 in Google Sheets - Tech Blog of autooffice","description":"{:ko}\uc774 \ube14\ub85c\uadf8 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 Apps Script\ub97c \uc0ac\uc6a9\ud558\uc5ec \uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 \uc9c0\uc815\ub41c \ubc94\uc704\uc5d0\uc11c \uac12\uc744 \uac00\uc838\uc624\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ud2b9\ud788, A1:A4 \ubc94\uc704\uc5d0\uc11c \uac12\uc744 \uac00\uc838\uc624\ub294 \uac83\uc5d0 \ucd08\uc810\uc744 \ub9de\ucd9c \uac83\uc785\ub2c8\ub2e4.{:}{:en}In this blog post, we will learn how to use Apps Script to get values from a specified range in Google Sheets. Specifically, we will focus on retrieving values from the range A1:A4.{:}","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/www.autooffice.co.kr\/en\/#website"},"breadcrumb":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/28\/getting-values-from-range-a1a4-in-google-sheets\/#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\/getA1A4Values.png","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/28\/getting-values-from-range-a1a4-in-google-sheets\/#mainImage","width":696,"height":400},"primaryImageOfPage":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/28\/getting-values-from-range-a1a4-in-google-sheets\/#mainImage"},"datePublished":"2023-07-28T09:00:00+09:00","dateModified":"2026-08-21T16:53:39+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":"Getting Values from Range A1:A4 in Google Sheets - Tech Blog of autooffice","og:description":"{:ko}\uc774 \ube14\ub85c\uadf8 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 Apps Script\ub97c \uc0ac\uc6a9\ud558\uc5ec \uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 \uc9c0\uc815\ub41c \ubc94\uc704\uc5d0\uc11c \uac12\uc744 \uac00\uc838\uc624\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ud2b9\ud788, A1:A4 \ubc94\uc704\uc5d0\uc11c \uac12\uc744 \uac00\uc838\uc624\ub294 \uac83\uc5d0 \ucd08\uc810\uc744 \ub9de\ucd9c \uac83\uc785\ub2c8\ub2e4.{:}{:en}In this blog post, we will learn how to use Apps Script to get values from a specified range in Google Sheets. Specifically, we will focus on retrieving values from the range A1:A4.{:}","og:url":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/28\/getting-values-from-range-a1a4-in-google-sheets\/","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-28T00:00:00+00:00","article:modified_time":"2026-08-21T07:53:39+00:00","twitter:card":"summary_large_image","twitter:title":"Getting Values from Range A1:A4 in Google Sheets - Tech Blog of autooffice","twitter:description":"{:ko}\uc774 \ube14\ub85c\uadf8 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 Apps Script\ub97c \uc0ac\uc6a9\ud558\uc5ec \uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 \uc9c0\uc815\ub41c \ubc94\uc704\uc5d0\uc11c \uac12\uc744 \uac00\uc838\uc624\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ud2b9\ud788, A1:A4 \ubc94\uc704\uc5d0\uc11c \uac12\uc744 \uac00\uc838\uc624\ub294 \uac83\uc5d0 \ucd08\uc810\uc744 \ub9de\ucd9c \uac83\uc785\ub2c8\ub2e4.{:}{:en}In this blog post, we will learn how to use Apps Script to get values from a specified range in Google Sheets. Specifically, we will focus on retrieving values from the range A1:A4.{:}","twitter:image":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png"},"aioseo_meta_data":{"post_id":"15380","title":null,"description":null,"keywords":null,"keyphrases":{"focus":{"keyphrase":"\uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8","score":56},"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-28 08:25:26","updated":"2026-08-21 08:48:28","seo_analyzer_scan_date":null,"focus_keyword":"\uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8","additional_keywords":null,"truseo_locale":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\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/apps-script\/\" title=\"\uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8\">\uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tGetting Values from Range A1:A4 in Google Sheets\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.autooffice.co.kr\/en\/"},{"label":"\uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/apps-script\/"},{"label":"Getting Values from Range A1:A4 in Google Sheets","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/28\/getting-values-from-range-a1a4-in-google-sheets\/"}],"_links":{"self":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15380","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=15380"}],"version-history":[{"count":3,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15380\/revisions"}],"predecessor-version":[{"id":17213,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15380\/revisions\/17213"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/15384"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=15380"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=15380"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=15380"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}