{"id":15368,"date":"2023-07-26T09:00:00","date_gmt":"2023-07-26T00:00:00","guid":{"rendered":"https:\/\/www.autooffice.co.kr\/blog\/2023\/07\/26\/apps-script-reading-values-from-a1-to-e4\/"},"modified":"2025-09-15T18:25:26","modified_gmt":"2025-09-15T09:25:26","slug":"apps-script-reading-values-from-a1-to-e4","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/07\/26\/apps-script-reading-values-from-a1-to-e4\/","title":{"rendered":"Reading Values from A1 to E4 from Google Sheet"},"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

    This Apps Script code demonstrates how to read values from the range A1 to E4 in a Google Sheets spreadsheet.<\/p>\n

    Code<\/h2>\n
    function getA1E4Values() {\n  const value = SpreadsheetApp.getActiveSheet().getRange('A1:E4').getValues()\n  Logger.log(value)\n}<\/code><\/pre>\n
    Code Explanation<\/h2>\n
    The function getA1E4Values()<\/code> retrieves the active sheet using SpreadsheetApp.getActiveSheet()<\/code>.
    \nIt then selects the range from A1 to E4 using getRange('A1:E4')<\/code>.
    \nFinally, it gets the values of the range using getValues()<\/code> and logs them using Logger.log()<\/code>.<\/p>\n
    Example<\/h2>\n
    Assuming you have a Google Sheets spreadsheet with values in the range A1 to E4, running this function will log those values to the Logger.<\/p>\n
    AI Prompt<\/h2>\n
    Write a function that retrieves the values from the range A1 to E4 in a Google Sheets spreadsheet and logs them to the Logger.<\/p>\n","protected":false},"excerpt":{"rendered":"
    This Apps Script code demonstrates how to read values from the range A1 to E4 in a Google Sheets spreadsheet.<\/p>\n","protected":false},"author":1,"featured_media":15377,"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,521,7],"class_list":["post-15368","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheet","category-apps-script","tag-ai-assisted","tag-script","tag-getvalues","tag-spreadsheet"],"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\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t