Class SpreadsheetApp

The SpreadsheetApp class is used to access and create Google Sheets files and is the parent class for the Spreadsheet service.

The SpreadsheetApp class contains various properties, which are enumerations representing different options or types within a spreadsheet, such as AutoFillSeries, BandingTheme, and BorderStyle.

The SpreadsheetApp class offers methods to manage spreadsheets, including creating new spreadsheets, opening existing ones by ID or URL, and controlling data execution for data sources.

Methods like getActive(), getActiveRange(), getActiveSheet(), and getSelection() allow scripts to interact with the currently active components of a spreadsheet.

The SpreadsheetApp class also provides methods to create builders for various spreadsheet elements like CellImage, Color, ConditionalFormatRule, and DataValidation.