Google Sheets
ProductivityOAuth 2.0
Create spreadsheets and read, write and append cell values in Google Sheets.
8 actions
| Action | Effect | Data handled | Scope |
|---|---|---|---|
| google_sheets_create_spreadsheetCreates a Google Sheets spreadsheet, optionally with named tabs | write | Personal data | https://www.googleapis.com/auth/spreadsheets |
| google_sheets_get_spreadsheetReads a spreadsheet's title and its tabs with their ids and sizes, without cell data | read | Personal data | https://www.googleapis.com/auth/spreadsheets.readonly |
| google_sheets_get_valuesReads the cell values of a range of a spreadsheet as rows | read | Personal data | https://www.googleapis.com/auth/spreadsheets.readonly |
| google_sheets_batch_get_valuesReads the cell values of several ranges of a spreadsheet at once | read | Personal data | https://www.googleapis.com/auth/spreadsheets.readonly |
| google_sheets_update_valuesWrites cell values into a range of a spreadsheet, overwriting what is there | write | Personal data | https://www.googleapis.com/auth/spreadsheets |
| google_sheets_append_valuesAdds rows after the last row of data in a range, such as a new entry in a log or tracker | write | Personal data | https://www.googleapis.com/auth/spreadsheets |
| google_sheets_clear_valuesClears the cell values of a range, keeping formatting | destructive | Personal data | https://www.googleapis.com/auth/spreadsheets |
| google_sheets_add_sheetAdds a tab to a spreadsheet | write | General | https://www.googleapis.com/auth/spreadsheets |