{"id":15527,"date":"2023-08-05T09:00:00","date_gmt":"2023-08-05T00:00:00","guid":{"rendered":"https:\/\/www.autooffice.co.kr\/blog\/2023\/08\/05\/inserting-values-to-a-small-range-in-apps-script\/"},"modified":"2025-09-15T18:46:52","modified_gmt":"2025-09-15T09:46:52","slug":"inserting-values-to-a-small-range-in-apps-script","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/08\/05\/inserting-values-to-a-small-range-in-apps-script\/","title":{"rendered":"Inserting Values to a Small Range 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 insert values from one range to another in Apps Script. We will write a function that retrieves values from a specific range in one sheet and inserts them into a small range in another sheet.<\/p>\n

    Code<\/h2>\n
    function insertValuesToSmallRange() {\n  const SS = SpreadsheetApp.getActiveSpreadsheet()\n  const T_SHEET2 = SS.getSheetByName('Sheet2')\n  const T_SHEET4 = SS.getSheetByName('Sheet4')\n\n  const values = T_SHEET2.getDataRange().getValues()  \n  const ranges = 'A1:E1'\n\n  let cell = T_SHEET4.getRange(ranges)\n  cell.setValues(values)\n}<\/code><\/pre>\n
    Code Explanation<\/h2>\n
    The code defines a function named insertValuesToSmallRange<\/code>. It retrieves the active spreadsheet and assigns it to the SS<\/code> variable. It also gets references to two sheets named ‘Sheet2’ and ‘Sheet4’ and assigns them to T_SHEET2<\/code> and T_SHEET4<\/code> variables respectively.<\/p>\n
    Using the getDataRange<\/code> method, the code retrieves all the values from the range in ‘Sheet2’ and assigns them to the values<\/code> variable.<\/p>\n
    The code specifies the range ‘A1:E1’ in ‘Sheet4’ using the getRange<\/code> method and assigns it to the cell<\/code> variable. Finally, it sets the values from ‘Sheet2’ into the specified range in ‘Sheet4’ using the setValues<\/code> method.<\/p>\n
    Example<\/h2>\n
    Let’s say we have a spreadsheet with two sheets: ‘Data’ and ‘Summary’. The ‘Data’ sheet contains a range of values in cells A1:E5, and we want to insert these values into cells A1:E1 in the ‘Summary’ sheet.<\/p>\n
    We can use the insertValuesToSmallRange<\/code> function to achieve this. Here’s how:<\/p>\n
    \/\/ Assuming the active spreadsheet is the one we're working with\ninsertValuesToSmallRange();<\/code><\/pre>\n
    Running the above code will retrieve the values from the ‘Data’ sheet and insert them into the specified range in the ‘Summary’ sheet.<\/p>\n
    AI Prompt<\/h2>\n
    Write a function that retrieves values from a specific range in one sheet and inserts them into a small range in another sheet.<\/p>\n
    Function Signature: function insertValuesToSmallRange()<\/code><\/p>\n
    Required variables: SS<\/code>, T_SHEET2<\/code>, T_SHEET4<\/code>, values<\/code>, ranges<\/code>, cell<\/code><\/p>\n
    Hint: Use the getSheetByName<\/code>, getDataRange<\/code>, getRange<\/code>, and setValues<\/code> methods.<\/p>\n","protected":false},"excerpt":{"rendered":"
    In this blog post, we will explore how to insert values from one range to another in Apps Script. We will write a function that retrieves values from a specific range in one sheet and inserts them into a small range in another sheet.<\/p>\n","protected":false},"author":1,"featured_media":15546,"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,536,7],"class_list":["post-15527","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheet","category-apps-script","tag-ai-assisted","tag-script","tag-setvalues","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\/15527","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=15527"}],"version-history":[{"count":4,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15527\/revisions"}],"predecessor-version":[{"id":17237,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15527\/revisions\/17237"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/15546"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=15527"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=15527"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=15527"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}