| List Spreadsheets | Read | List recent Google Sheets spreadsheets from Drive |
| Get Spreadsheet | Read | Get spreadsheet metadata including sheet names and properties |
| Read Range | Read | Read cell data from a spreadsheet range |
| Write Range | Write | Write data to a spreadsheet range |
| Create Spreadsheet | Write | Create a new spreadsheet with optional initial data |
| Append Rows | Write | Append rows to a spreadsheet range |
| Clear Range | Write | Clear values from a spreadsheet range |
| Batch Update | Write | Run raw Google Sheets batchUpdate requests for formatting and structural changes |
| Add Sheet | Write | Add a new sheet/tab to a spreadsheet |
| Delete Sheet | Write | Delete a sheet/tab from a spreadsheet by sheet ID |
| Rename Sheet | Write | Rename a sheet/tab by sheet ID |
| Delete Spreadsheet | Write | Move an app-accessible spreadsheet file to trash |
| Find and Replace | Write | Find and replace text in a spreadsheet or sheet |
| Copy Sheet | Write | Copy a sheet/tab to another spreadsheet |
| Create Chart | Write | Create an embedded chart using a Sheets API chart specification |
| Set Data Validation | Write | Set data validation rules on a sheet range |
