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.
2 Snippets using this methods
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
3 Better Sheets tutorials
Automate Emails
Automatically Copy Spreadsheet Tab to New File with Values Only, No Formulas
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 →