{"id":15400,"date":"2023-07-31T09:00:00","date_gmt":"2023-07-31T00:00:00","guid":{"rendered":"https:\/\/www.autooffice.co.kr\/blog\/2023\/07\/31\/accessing-cell-values-in-apps-script\/"},"modified":"2025-09-15T18:30:59","modified_gmt":"2025-09-15T09:30:59","slug":"accessing-cell-values-in-apps-script","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/31\/accessing-cell-values-in-apps-script\/","title":{"rendered":"Get Cell Values using 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 access cell values in Apps Script. We will learn how to use the getActiveSheet()<\/code> method, the getRange()<\/code> method, and the getValues()<\/code> method to retrieve the value of a specific cell in a Google Sheets spreadsheet.<\/p>\n

    Code<\/h2>\n
    function getD3Value() {\n  const value = SpreadsheetApp.getActiveSheet().getRange(3, 4).getValues();\n  Logger.log(value);\n}<\/code><\/pre>\n
    Code Explanation<\/h2>\n
    The code declares a function named getD3Value<\/code>. Inside the function, the getActiveSheet()<\/code> method is used to get the currently active sheet. The getRange()<\/code> method is then called with the parameters 3<\/code> and 4<\/code> to specify the cell at the third row and fourth column.<\/p>\n
    The getValues()<\/code> method is used to retrieve the value of the specified cell. The value is stored in the value<\/code> variable.<\/p>\n
    Finally, the Logger.log()<\/code> method is used to print the value to the Apps Script Logger.<\/p>\n
    Example<\/h2>\n
    When the getD3Value<\/code> function is executed, the value of the cell at the third row and fourth column will be logged in the Apps Script Logger.<\/p>\n
    [[Value]]<\/code><\/pre>\n
    AI Prompt<\/h2>\n
    Write a function that retrieves the value of a specific cell in a Google Sheets spreadsheet using Apps Script. Log the value in the Apps Script Logger.<\/p>\n","protected":false},"excerpt":{"rendered":"
    In this blog post, we will explore how to access cell values in Apps Script. We will learn how to use the getActiveSheet() method, the getRange() method, and the getValues() method to retrieve the value of a specific cell in a Google Sheets spreadsheet.<\/p>\n","protected":false},"author":1,"featured_media":15410,"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,517,7],"class_list":["post-15400","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-getvalue","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\/15400","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=15400"}],"version-history":[{"count":5,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15400\/revisions"}],"predecessor-version":[{"id":17217,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15400\/revisions\/17217"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/15410"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=15400"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=15400"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=15400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}