Create a new Spreadsheet from just a Name in a Sheet.

About this Tutorial

Create the Apps Script to create a new sheet from some data inside your sheet. Script included in the sheet below.

Video Transcript

 Hello, welcome to a very quick video on Better Sheets. Um, this video is to go through how we can programmatically possibly make, um, a new spreadsheet based on a name. Um, this could fit into a lot of little use cases. Maybe you have a CRM that you need to create, um, new sheets based on names for, um, clients or for, uh, your sales team, or, um, you have to, um, Maybe create a new sheet every week where it has a very specific date and name.

Um, and you want to create a brand new sheet and you find yourself going to, you know, sheet.new, uh, fairly often or not fairly often on a rigid scale, uh, not rigid scale. What is it? Uh, a cadence, uh, a specific cadence. And you know, like, Hey, I wish there could be just like fired off, um, a. Like I know the name now of like 50 sheets or 52 sheets cuz it's one every week.

Um, or. You wanna set up one sheet a day kind of thing, and you want them all in one place, this is going to help you. It's not gonna be the complete solution. It is sort of a, um, uh, a little Google script, uh, that you can find on class spreadsheet, app. Um, and it's this here just, uh, spreadsheet.app, uh, sorry, spreadsheet app dot create, and then you can fill in the name and then you.

Log, they're just getting the, uh, URL of that, and that's what you can copy from the developer page. But I'm gonna show you just a couple of edits you can do to make this a little bit. Better. Um, and then you can take this and put it into your script as you wish. Uh, wherever you wish, uh, or run it as a trigger, um, based on some input.

Um, you'll see how it goes. So right now all I have is sort of a name that I know I want to name, uh, a new spreadsheet, and then I wanna get the URL right here. So the script I wrote based on the developer one, um, is this function, create new sheet. Um, and what it does is first it, um, creates, uh, the sheet, uh, based on the sheet name, so it's grabbing the sheet name.

It is, um, from the A two here. Right here is the range of a two. Here's the sheet name, sheet one, and it's grabbing that value, the name of the sheet, and then it's creating that sheet. And what it returns here is sheet new. , uh, dot gate url. So we're getting the URL of this new sheet and we're setting the value in B2 here.

So we hard coded b2. So if you want, um, well you can run this script in like a loop, uh, based on, um, say you just write the 50 names here. Um, and maybe it's like, um, sales for January. Uh, sales for, I can't type here, uh, February, and maybe you have like 50 of these. You can loop, uh, this over and let's, uh, let's see what it does, right.

So I'm just gonna hit play here. Um, I'm just running it from here, but you can run it from a trigger. You can run it. , if you wanna create a new menu, I've shown you another couple of other videos where to create a new menu. And here it is. Here's the url. Url. So if we go to the url, let's open it up and see what it looks like.

It is gonna be just a brand new sheet. Um, there are a couple of things you can do with this. Like you can set the number of rows and columns if you add some options here, rose columns. So I'm gonna show you how to do that right now. Um, so right in here, we just created a name, but let's say we only want 10 rows and 10 columns.

I dunno, maybe it's, we just wanna create a dashboard or something. Um, so I'm, I'm also going to go in here and change this to three just so that we, um, use the next one down. So I'm gonna command S for save and I'm gonna run this, I'm gonna see what it does for the sales for February. . This is exciting.

There it is. So here is a brand new, um, URL of a sheet and let's see what it's named. It's gonna be named, fingers crossed. We don't have to cross our fingers. We know it's sales for February, and here it is 10 columns and 10 rows ready for, um, for whatever use you might need. So there's uh, a few other things, uh, you might want to do here.

Um, you might want to be copy a spread. Um, but I'm not gonna go into this. That's not part of the scope. This is just to create a brand new, uh, sheet based on the name. Um, and unfortunately, uh, it's gonna be a quite a much longer video. If I, um, go into how to create sort of a copy, we can just do file, um, make a copy.

If you have the URLs in terms, you can make a copy of that. Um, but yeah, I think this is really useful if you have say, you know, one sheet, a. Um, or you want to create, you know, sheets for the future and you don't wanna sit there and, uh, create those names over and over again. Again, thank you so much for watching.

Bye.

Courses

Sheet Stories / Video Notes + ADDED: Email Notifications

00:00:00

Fast FAQS

ChatGPT Clone in Google Sheets Part 2

Create an Internal Google Sheets Add-on

Why Different Cell References in AI Integration in Sheets?

Show Sheet Tabs Based on Edit

Add Title Case to Google Sheets

Getting Started Coding in Apps Script

How to Power Testimonials with Google Forms and Sheets

Seek Errors When Coding Apps Script

Think Like a Programmer: Develop The Mindset of an Apps Script Coder

ChatGPT Clone in Google Sheets Part 1

Embed a Number in a Website from a Google Sheet

Create Navigation Like A Book or Presentation

Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet

00:29:08

Hold a Giveaway Raffle in a Google Sheet

Quickstart Tutorial OpenAI API in Google Sheets

Capture Emails from Website Form to a Google Sheet (Without Zapier)

Embed a Headline in a Website from Google Sheets

Create a new Spreadsheet from just a Name in a Sheet.

00:05:21

Bjarne Asks: Can I show the Last Time of the Last Edit in a sheet?

00:05:43

Email Yourself a Cell from a Google Sheet, Every Day

OpenSea Data Inside Sheets

Create an Email Campaign Stats Calculator

00:35:13

Twitter App Clone in a Google Sheet

Dylan Asks: How to Automatically Delete Rows If Cell Contains Value

Highlight Row as You Move Your Cell Selection

Create a Timer with Apps Script

LinkTree in a Google Sheet

00:11:22

Password Protecting Data In a Google Sheet

Automatic Weekly Backup of Google Sheets

Create a CPM Custom Function (Create Better Calculators!)

Move Entire Row when a Cell is changed to "Yes" - The $75,000 Google Script

00:12:29

What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users

Sync Two Tabs Without ImportRange()

Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.

00:00:00

Password Protecting Data In a Google Sheet Part 2 The Basics

Benoit Asks: How to Convert Case

00:07:35

Learn to Code in Google Sheets, For Programmers

Add a Checkbox to Turn on Dark Mode

00:05:10

Write Your First Script

00:08:31

Find Keywords in Any Column. Create quick search dropdown to find keywords

00:09:37

Basic CRM - Add a Powerful Script To Move Row Based on Status

How To Improve: 1,000 Business ideas: Business Idea Generator

00:11:20

Let's Make a Bookmarklet!

00:12:37

Troubleshooting Bitly in a Google Sheet Script

00:07:07

Unique Features - Design a Better Dashboard Part 2

00:04:13

How To Set Up Stripe Webhook to Google Sheets with Google Script

00:22:10

How to Edit a Macro

00:08:22

Sheet Stories / Video Notes + Clear 24 Hour Old Videos

00:35:10

Add A Timestamp to Task Lists (without Now Formula)

00:07:44

Make your Custom Functions Like Native Functions | Custom Function Autocomplete

00:17:58

Create a Changelog Between 2 Cells Custom Function | To learn Double For Loop

00:23:26

New Syntax for WhatChanged Formula in Google Script

00:07:14

How to Record Macros

00:06:20

2 Ways to Delete Lines Quickly (CAREFUL, it's a script!)

00:09:53

Deep Inside Dark Habits Google Script

00:18:54

How to Trigger Macros Daily

00:06:58

5 Ways to Create Coupon Codes | Create UUIDs

Create a Radio Button From Checkboxes Using Google Apps Script

00:15:01