Skip to main content
Version: Streamsheets 3.0

GOOGLE.SHEETS.SPREADSHEET.CREATE

Premium
Experimental

Creates a new spreadsheet with an empty sheet.

Syntax

=GOOGLE.SHEETS.SPREADSHEET.CREATE(Spreadsheet Name, [Sheet-Name], [ResponseTarget])

Arguments

NameTypeDescription
Spreadsheet NameTextName of the new spreadsheet
Sheet-Name (optional)TextName of the sheet. Defaults to Sheet1
ResponseTarget (optional)TargetSpecify inbox, outbox, cell or cell-range to write any response to.

Return

TypeDescription
JSONA JSON with spreadsheet title and id as well as name and id of its inner sheet.

Examples

FormulaResultComment
=GOOGLE.SHEETS.SPREADSHEET.CREATE("Calculations", "Quarter")
JSONCreates a new spreadsheet titled "Calculations" with an empty sheet named "Quarter".