{"id":15401,"date":"2023-07-31T09:00:00","date_gmt":"2023-07-31T00:00:00","guid":{"rendered":"https:\/\/www.autooffice.co.kr\/blog\/2023\/07\/31\/retrieving-values-from-a-specific-range-in-google-sheets-using-apps-script\/"},"modified":"2025-09-15T18:31:36","modified_gmt":"2025-09-15T09:31:36","slug":"retrieving-values-from-a-specific-range-in-google-sheets-using-apps-script","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/31\/retrieving-values-from-a-specific-range-in-google-sheets-using-apps-script\/","title":{"rendered":"Get the value of a range by specifying the number of rows and columns in getRange"},"content":{"rendered":"

This post is a corrected post after AI explains the code included in the book “Google Apps Script 101: Building Work Automation For Free”<\/a>. Added a strikethrough<\/s> when editing what AI has written, and added color<\/span> when edited by author<\/p>\n

Table of Contents<\/h2>\n
    \n
  1. Summary<\/a><\/li>\n
  2. Code<\/a><\/li>\n
  3. Code Explanation<\/a><\/li>\n
  4. Example<\/a><\/li>\n
  5. AI Prompt<\/a><\/li>\n<\/ol>\n

    Summary<\/h2>\n

    In this blog post, we will explore how to retrieve values from a specific range in Google Sheets using Apps Script. We will use the getActiveSheet()<\/code> method to get the active sheet, getRange()<\/code> method to specify the range, and getValues()<\/code> method to retrieve the values within that range.<\/p>\n

    Code<\/h2>\n
    function getD3E4Values() {\n  const value = SpreadsheetApp.getActiveSheet().getRange(3, 4, 2, 2).getValues();\n  Logger.log(value);\n}<\/code><\/pre>\n
    Code Explanation<\/h2>\n
    The code defines a function named getD3E4Values<\/code>. Within the function, we use the getActiveSheet()<\/code> method to get the currently active sheet. Then, we use the getRange()<\/code> method to specify the range starting from cell D3 (row 3, column 4) with a width of 2 rows and 2 columns. Finally, the getValues()<\/code> method retrieves the values within the specified range and assigns them to the value<\/code> variable.<\/p>\n
    The retrieved values are then logged using the Logger.log()<\/code> method.<\/p>\n
    Example<\/h2>\n
    When the getD3E4Values()<\/code> function is executed, the values within the range D3:E4 will be logged in the Apps Script Logger.<\/p>\n
    AI Prompt<\/h2>\n
    Write a function that retrieves the values from the range D3:E4 in the active sheet of a Google Sheets document and logs them using the Logger.log()<\/code> method.<\/p>\n","protected":false},"excerpt":{"rendered":"
    In this blog post, we will explore how to retrieve values from a specific range in Google Sheets using Apps Script. We will use the getActiveSheet() method to get the active sheet, getRange() method to specify the range, and getValues() method to retrieve the values within that range.<\/p>\n","protected":false},"author":1,"featured_media":15413,"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,525,524,521,7],"class_list":["post-15401","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheet","category-apps-script","tag-ai-assisted","tag-script","tag-getactivesheet","tag-getrange","tag-getvalues","tag-spreadsheet"],"translation":{"provider":"WPGlobus","version":"3.0.2","language":"en","enabled_languages":["ko","en"],"languages":{"ko":{"title":true,"content":true,"excerpt":true},"en":{"title":true,"content":true,"excerpt":true}}},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15401","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=15401"}],"version-history":[{"count":4,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15401\/revisions"}],"predecessor-version":[{"id":17218,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15401\/revisions\/17218"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/15413"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=15401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=15401"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=15401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}