Google Sheets - Veryfront

At a glance

Availability: Enabled by default.
Authentication: OAuth 2.0.
Connection: A user authorizes the connection in the provider’s consent screen.
Scopes: https://www.googleapis.com/auth/spreadsheets, https://www.googleapis.com/auth/drive.readonly, https://www.googleapis.com/auth/drive.file.

Credentials

Set these per environment. See Connect an integration. These variables are required only when you supply your own OAuth app. If a managed app is available, you can connect without setting them. Provider permissions and consent still apply.

Variable	Required	Description
`GOOGLE_CLIENT_ID`	Yes	Google OAuth Client ID Docs.
`GOOGLE_CLIENT_SECRET`	Yes	Google OAuth Client Secret Docs.

Tools

Tool	Access	Description
List Spreadsheets `sheets__list_spreadsheets`	Read	List recent Google Sheets spreadsheets from Drive
Get Spreadsheet `sheets__get_spreadsheet`	Read	Get spreadsheet metadata including sheet names and properties
Read Range `sheets__read_range`	Read	Read cell data from a spreadsheet range
Write Range `sheets__write_range`	Write	Write data to a spreadsheet range
Create Spreadsheet `sheets__create_spreadsheet`	Write	Create a new spreadsheet with optional initial data
Append Rows `sheets__append_rows`	Write	Append rows to a spreadsheet range
Clear Range `sheets__clear_range`	Write	Clear values from a spreadsheet range
Batch Update `sheets__batch_update`	Write	Run raw Google Sheets batchUpdate requests for formatting and structural changes
Add Sheet `sheets__add_sheet`	Write	Add a new sheet/tab to a spreadsheet
Delete Sheet `sheets__delete_sheet`	Write	Delete a sheet/tab from a spreadsheet by sheet ID
Rename Sheet `sheets__rename_sheet`	Write	Rename a sheet/tab by sheet ID
Delete Spreadsheet `sheets__delete_spreadsheet`	Write	Move an app-accessible spreadsheet file to trash
Find and Replace `sheets__find_replace`	Write	Find and replace text in a spreadsheet or sheet
Copy Sheet `sheets__copy_sheet`	Write	Copy a sheet/tab to another spreadsheet
Create Chart `sheets__create_chart`	Write	Create an embedded chart using a Sheets API chart specification
Set Data Validation `sheets__set_data_validation`	Write	Set data validation rules on a sheet range

Verify the connection

Call a read tool such as sheets__list_spreadsheets with arguments for your account. Confirm that the result comes from the intended account or workspace before enabling write tools.