Code With Mark
Home
About
Resources
Contact

Easily Create Multiple Google Sheets In 5 Seconds

This is the fastest way to create multiple google sheets from a google sheet template.

Get the code:

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  // Or DocumentApp or FormApp.
  ui.createMenu('Clone Menu')
      .addItem('Clone Sheet', 'cloneGoogleSheet')
      .addSeparator()      
      .addToUi();
}

function cloneGoogleSheet() {

  var source = SpreadsheetApp.getActiveSpreadsheet();
  
  var sheet = source.getSheetByName('Sheet1');

  //get sheet names
  var ss_names = source.getSheetByName('SheetNames');
  var ss_last_row = ss_names.getLastRow();
 
  console.log('Row ' + ss_last_row );

  for (let i = 0; i < ss_last_row; i++) 
  {   
    var row_id = i+1;
    var get_sheet_name = ss_names.getRange("A"+ row_id).getValue();

    console.log(get_sheet_name);

    
    var old = source.getSheetByName(get_sheet_name);
    if (old) source.deleteSheet(old); // or old.setName(new Name);

    
    if(get_sheet_name != "Names")
    {
      sheet.copyTo(source).setName(get_sheet_name);
    }
  }
  

}
For Web Developers

Working Hard But Still Not Getting Ahead?

You finish a project, get paid, and then it's back to finding the next client.

Month after month, the cycle repeats.

That's why many web developers never build real financial freedom—even though they're highly skilled.

The developers creating long-term wealth are using those same skills to build SaaS products, plugins, and digital tools that generate recurring income.

What if your next project could pay you more than once?

Learn How To Build Monthly Income →
Best Way To Create Single Page ApplicationsBest Way To Create Single Page Applications←Previous
Create Website With Google SheetCreate Website With Google SheetNext→

Related Posts

  • GOOGLE SHEETS HACK That Creates Files Automatically
  • How Google Developers Think (And Why You Should Too)
  • Add Google Sign-In in 2 Minutes

Top Posts Viewed

Easily Edit HTML Table Rows Or Cells With jQuery
145 views
How To Create A Secure Login System With PHP And MySQL
134 views
PHP Simple Database Class
134 views

Categories

Courses
Excel
Google Script
Javascript
jQuery
Microsoft Access
MongoDB
Node JS
PHP
Quick Tip
Uncategorized
Wordpress