The SpreadsheetApp
library allows you to interact with Google Sheets, enabling tasks like reading, writing, and formatting data, as well as creating new sheets or modifying existing ones.
-
Write Data to a Sheet:
Add a row of data to a specific sheet. -
Read Data from a Range:
Retrieve and log values from a defined range. -
Format Cells:
Apply formatting like bold text, colors, or number formats to cells. -
Create a New Sheet:
Add a new sheet to an existing spreadsheet.