Google Sheets Tools

Clear (delete) values in a spreadsheet range (Sheets API spreadsheets.values.clear).

Create a conditional formatting rule in a Google Sheet.

Add a new sheet (tab) to an existing Google Spreadsheet.

Create a new Google Spreadsheet with specified title and sheet count.

Create a comment on a Google Spreadsheet (Drive comments.create).

Delete a conditional formatting rule from a Google Sheet.

Apply cell formatting (colors, fonts, borders, etc.) to a range in Google Sheets.

Fetch a spreadsheet by ID (Sheets API spreadsheets.get).

Read a range of cells from a spreadsheet (Sheets API spreadsheets.values.get).

List Google Sheets spreadsheets accessible to the authenticated user (via Drive files.list).

List comments on a Google Spreadsheet (Drive comments.list).

Reply to a spreadsheet comment (Drive replies.create).

Resolve (or unresolve) a spreadsheet comment (Drive comments.update).

Update an existing conditional formatting rule in a Google Sheet.

Update cell values in a Google Sheet range.

Validate the Google Sheets OAuth token and confirm required scopes are granted.