{"id":15559,"date":"2023-08-11T09:00:00","date_gmt":"2023-08-11T00:00:00","guid":{"rendered":"https:\/\/www.autooffice.co.kr\/blog\/2023\/08\/11\/copying-a-tab-in-apps-script\/"},"modified":"2026-08-21T16:52:38","modified_gmt":"2026-08-21T07:52:38","slug":"copying-a-tab-in-apps-script","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/08\/11\/copying-a-tab-in-apps-script\/","title":{"rendered":"Copying a Tab 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 learn how to copy a tab in Google Sheets using Apps Script. We will explore the code that copies a specific sheet to the same spreadsheet and to a new spreadsheet. Finally, we will retrieve the URL of the newly created spreadsheet.<\/p>\n

    Code<\/h2>\n
    function copyTab() {\n  const SS = SpreadsheetApp.getActiveSpreadsheet()\n  const T_SHEET2 = SS.getSheetByName('Sheet2')\n  const NEW_SS = SpreadsheetApp.create('newSheet')\n\n  T_SHEET2.copyTo(SS)\n  T_SHEET2.copyTo(NEW_SS)\n  Logger.log(NEW_SS.getUrl())\n}<\/code><\/pre>\n
    Code Explanation<\/h2>\n
    The copyTab<\/code> function begins by getting the active spreadsheet using SpreadsheetApp.getActiveSpreadsheet()<\/code>. It then retrieves the sheet named ‘Sheet2’ using SS.getSheetByName('Sheet2')<\/code>.<\/p>\n
    A new spreadsheet is created using SpreadsheetApp.create('newSheet')<\/code>. The copyTo<\/code> method is used to copy ‘Sheet2’ to both the original spreadsheet and the newly created spreadsheet.<\/p>\n
    When you select a range and use copyTo, you must have set the destination to the range. However, if you select a tab (sheet) and use copyTo, set the Google Spreadsheet file as the destination.<\/span><\/p>\n
    Finally, the URL of the newly created spreadsheet is logged using NEW_SS.getUrl()<\/code>.<\/p>\n
    Example<\/h2>\n
    Let’s say you have a Google Sheets document with two sheets: ‘Sheet1’ and ‘Sheet2’. You want to create a new spreadsheet and copy ‘Sheet2’ to both the original and new spreadsheets. The code mentioned above can be used to achieve this.<\/p>\n
    After running the copyTab<\/code> function, you will have two copies of ‘Sheet2’ – one in the original spreadsheet and another in the newly created spreadsheet. The URL of the newly created spreadsheet will be logged in the Apps Script Logger.<\/p>\n
    AI Prompt<\/h2>\n
    Write a function that copies a specific sheet to the same spreadsheet and to a new spreadsheet. Log the URL of the newly created spreadsheet.<\/p>\n","protected":false},"excerpt":{"rendered":"
    In this blog post, we will learn how to copy a tab in Google Sheets using Apps Script. We will explore the code that copies a specific sheet to the same spreadsheet and to a new spreadsheet. Finally, we will retrieve the URL of the newly created spreadsheet.<\/p>\n","protected":false},"author":1,"featured_media":15581,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_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":[118],"tags":[512,355,537,7],"class_list":["post-15559","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-apps-script","tag-ai-assisted","tag-apps-script","tag-copyto","tag-spreadsheet"],"translation":{"provider":"WPGlobus","version":"3.0.5","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\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