Popular Google Sheets tools
- Read data from a cell range in A1 notation — Read data from a cell range in A1 notation (e.g. “Sheet1!A1:D10”).
- Write data to a cell range — Write data to a cell range. Values are interpreted as if typed by the user (USER_ENTERED).
- Append rows to the end of a sheet’s data — Append rows to the end of a sheet’s existing data.
- Find rows matching criteria in a column — Search for rows where a given column matches a value using the specified operator (equals, contains, greater_than, less_than). The column can be identified by letter or by its header name in the first row.
- Create a new spreadsheet — Create a new Google Sheets spreadsheet with an optional initial sheet name.
- List all worksheets in a spreadsheet — List all worksheet tabs and their properties in a spreadsheet.
- Add a new worksheet tab — Add a new worksheet tab to an existing spreadsheet.
- Get metadata about a spreadsheet — Retrieve metadata about a spreadsheet including its title, URL, locale, and worksheet list.
- Clear cell contents while preserving formatting — Clear the contents of cells in a range while preserving formatting.
- Apply formatting to cells — Apply formatting (bold, italic, text colour, background colour) to a range of cells.