{"id":15464,"date":"2023-08-02T09:00:00","date_gmt":"2023-08-02T00:00:00","guid":{"rendered":"https:\/\/www.autooffice.co.kr\/blog\/2023\/08\/02\/retrieving-data-range-values-in-apps-script\/"},"modified":"2025-09-15T18:42:06","modified_gmt":"2025-09-15T09:42:06","slug":"retrieving-data-range-values-in-apps-script","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/08\/02\/retrieving-data-range-values-in-apps-script\/","title":{"rendered":"Retrieving Data Range Values in Apps Script"},"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 data range values in Apps Script. We will learn how to access data from multiple sheets in a spreadsheet using a loop and the getDataRange()<\/code> method.<\/p>\n

    Code<\/h2>\n
    function getDataRangeValues() {\n  const SS = SpreadsheetApp.getActiveSpreadsheet()\n  const sheetNames = ['Sheet1', 'Sheet2']\n\n  for (let i = 0; i < sheetNames.length; i++) {\n    const sheet = SS.getSheetByName(sheetNames[i])\n    const values = sheet.getDataRange().getValues()\n    Logger.log(values)\n  }\n}<\/code><\/pre>\n
    Code Explanation<\/h2>\n
    The code declares a function named getDataRangeValues<\/code>. Inside the function, the active spreadsheet is accessed using SpreadsheetApp.getActiveSpreadsheet()<\/code>. An array sheetNames<\/code> is defined with the names of the sheets to retrieve data from.<\/p>\n
    A for loop is used to iterate over the sheet names array. For each sheet, the getSheetByName()<\/code> method is used to retrieve the sheet object. The getDataRange()<\/code> method is then called on the sheet object to get the range of data. Finally, the getValues()<\/code> method is used to retrieve the values in the data range, and the values are logged using Logger.log()<\/code>.<\/p>\n
    Example<\/h2>\n
    Let's say we have a spreadsheet with two sheets named \"Sheet1\" and \"Sheet2\". Each sheet contains a table with some data. We want to retrieve all the values from these sheets and log them using the Logger.log()<\/code> method.<\/p>\n
    When we execute the getDataRangeValues()<\/code> function, it will loop through the sheet names array, retrieve the sheet objects, get the data range, and log the values from each sheet.<\/p>\n
    AI Prompt<\/h2>\n
    Write a function that retrieves data range values from multiple sheets in a spreadsheet. Use a for loop to iterate over the sheet names array and retrieve the values using the getDataRange()<\/code> and getValues()<\/code> methods. Log the values for each sheet using Logger.log()<\/code>.<\/p>\n","protected":false},"excerpt":{"rendered":"
    In this blog post, we will explore how to retrieve data range values in Apps Script. We will learn how to access data from multiple sheets in a spreadsheet using a loop and the getDataRange() method.<\/p>\n","protected":false},"author":1,"featured_media":15470,"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,530,7],"class_list":["post-15464","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheet","category-apps-script","tag-ai-assisted","tag-script","tag-getdatarange","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\/15464","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=15464"}],"version-history":[{"count":4,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15464\/revisions"}],"predecessor-version":[{"id":17231,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15464\/revisions\/17231"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/15470"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=15464"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=15464"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=15464"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}