Creates a new blank spreadsheet file in Drive.
class SpreadsheetApp method .create()
SpreadsheetApp is the Apps Script service.
.create() is the method name you will see after a dot in your code.
What it does
Why it's used
- Spin up a fresh report or export file at the end of a workflow.
- Create a blank workbook for each client or project automatically.
Common errors
- Forgetting parentheses on create. Write SpreadsheetApp.create(), not SpreadsheetApp.create or create by itself.
- Skipping dots between chained calls. Each step needs a dot, like SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Data').create().
- Adding spaces where they do not belong. Write SpreadsheetApp.create(), not SpreadsheetApp .create(), SpreadsheetApp.create (), or SpreadsheetApp . create().
- Wrong capitalization. Use SpreadsheetApp and create, not spreadsheetapp or create.
Snippets using this method
- Visicalc 2023 Design Walkthrough
- Visicalc 2023 Quick Walkthrough
- Self Destructing Google Sheet
- I Created an Automatic Emailer
- How to Power Testimonials with Google Forms and Sheets
- How to Create a Google Form Automatically
- Curate Google Sheets Easily - Automatic Bookmarklet Maker
- Create an Automated Task List
- Create a new Spreadsheet from just a Name in a Sheet.
- Built a Cookie Clicker Clone in Google Sheets
- Automatically Copy Spreadsheet Tab to New File with Values Only, No Formulas
- Different Kinds of Automation
Explore
Related methods
-
.openById()
Opens an existing spreadsheet using its Drive file ID.
-
.insertSheet()
Adds a new sheet tab to the spreadsheet.
-
.activate()
Makes a sheet or range the active selection.
-
.createMenu()
Builds a custom menu in the spreadsheet toolbar.
-
.appendRow()
Adds a new row of data at the bottom of the sheet.
More Apps Script
Better Sheets tutorials
Automate Emails
Automatically Copy Spreadsheet Tab to New File with Values Only, No Formulas
Built a Cookie Clicker Clone in Google Sheets
Create an Automated Task List
Create a new Spreadsheet from just a Name in a Sheet.
Curate Google Sheets Easily - Automatic Bookmarklet Maker
How to Create a Google Form Automatically
I Created an Automatic Emailer
Self Destructing Google Sheet
Visicalc 2023 Design Walkthrough
Related blog posts
Written guides about SpreadsheetApp.create().
What's Better Than Google Sheets?
Nothing is better than Google Sheets. You just need to learn more about the unlimited power of Google Sheets. Functions, Formulas, Apps Script and more.
Read post →How to Use Google Sheets as a Website Database
Did you know you can use Google Apps Script to turn a Google Sheet into a free, auto-syncing database for your website? This guide shows you exactly how to set it up. You’ll prepare your spreadsheet, write a few lines of code and publish your site. Don’t worry if you’re not a developer, we’ll walk you through it. Why Use Google Sheets as a Database? For small projects, Google Sheets offers many advantages over traditional databases: * Free hosting and storage * Easy to edit data without...
Read post →Learn Google Sheets Apps Script
Learning Google Sheets coding and Apps Script can have several outcomes and results. Become more productive, more of an asset to your company. No matter if you work there or if you own the company.
Read post →