Google Sheets
Comprehensive Google Sheets connector for managing spreadsheets, worksheets, cell data, and formatting through the Google Sheets API v4.
What you can ask
- Append today's Stripe payouts to the
Finance / Dailysheet, deduped by transaction ID. - Pull the values from the
Q2 Forecastsheet and post the rollup in #finance. - Find rows in the
Leadssheet where the email domain matches our top 10 target accounts.
Set up
Google Sheets needs an OAuth application from your organization before anyone can connect. An organization admin completes these steps once.
- Go to Organization > Connectors and find Google Sheets. Click Enable, and choose which tools to allow.
- Create a Google Cloud project.
- Turn on the Google Sheets API.
- Configure the OAuth consent screen.
- Create credentials, choose OAuth client ID, and set the type to Web application.
- Add the exact Redirect URI shown in the connector settings.
- Copy the client ID and client secret into the connector, then save it.
- Each member connects their own account the first time they use it.
⚠️ Warning: Do not enter your Devs.ai or Google Sheets login email or password in the OAuth application fields.
To use one account for the whole organization, turn on Share one connection with everyone. Every member's agents then act as that account, with exactly the access it has.
OAuth scopes used by these tools (4)
Grant the scopes for the tools you plan to allow.
https://www.googleapis.com/auth/drive.filehttps://www.googleapis.com/auth/drive.readonlyhttps://www.googleapis.com/auth/spreadsheetshttps://www.googleapis.com/auth/spreadsheets.readonly
Tools
Google Sheets offers 56 tools. Admins choose which ones agents can use. See Tool permission groups.
Read (9)
View and search information without changing it.
| Tool | What it does |
|---|---|
batch_get_values | Read cell values from multiple ranges in a single efficient API call. |
get_spreadsheet | Retrieve spreadsheet information including metadata, sheets, and optionally cell data. |
get_table_schema | Get one table's column names and types, plus the sheet and range it covers. |
get_values | Read cell values from a specified range using A1 notation (e.g., 'Sheet1!A1:B10'). |
list_spreadsheets | List the user's spreadsheets, most recently modified first. |
list_tables | List the named tables defined across a spreadsheet, with their sheet, range and column types. |
query_table | Query a spreadsheet with a SQL-like Google Visualization query: filter rows, aggregate columns, group and sort, in one call. |
search_spreadsheets | Find spreadsheets by title. |
validate_credential | Validate Google Sheets credentials. |
Write (14)
Create or send data.
| Tool | What it does |
|---|---|
add_banding | Apply alternating row or column colors (zebra striping) to a range. range accepts A1 notation (e.g. 'Sheet1!A1:E20') or a GridRange object. |
add_chart | Add a chart (bar, line, area, column, scatter, combo, stepped area) to a spreadsheet. |
add_conditional_format_rule | Add a conditional formatting rule to one or more ranges. |
add_dimension_group | Create a collapsible row or column group for hierarchical reports. range.dimension is ROWS or COLUMNS; range.start_index/end_index are zero-based, end-exclusive. |
add_filter_view | Create a named filter view with persistent filter/sort criteria. |
add_named_range | Create a named range so the cells can be referenced by name in formulas (e.g. =SUM(SalesData)). |
add_protected_range | Lock a range from edits. warning_only=True shows a warning but still allows edits; False blocks them. |
add_sheet | Add a new sheet (tab) to an existing spreadsheet with customizable properties. |
add_table | Add a table to a sheet over a GridRange (include the header row). |
append_values | Append rows to the end of a table, automatically finding the last row with data. |
copy_sheet | Copy a sheet within the same spreadsheet or to a different spreadsheet. |
create_spreadsheet | Create a new spreadsheet with specified title and optional properties. |
duplicate_sheet | Duplicate a sheet within the same spreadsheet using DuplicateSheetRequest. |
insert_dimension | Insert empty rows or columns into a sheet. range.dimension selects ROWS or COLUMNS; range.start_index/end_index are zero-based, end-exclusive. inherit_from_before controls whether the new cells inherit formatting from the row/column before (True) or after (False). |
Delete or overwrite (33)
Remove or replace existing data.
| Tool | What it does |
|---|---|
auto_fill | Extend a pattern (formula, date sequence, number series) by auto-fill instead of writing each value. |
auto_resize_dimensions | Auto-fit row heights or column widths to content. dimensions.dimension is ROWS or COLUMNS; start_index/end_index are zero-based, end-exclusive. |
batch_clear_values | Clear values from multiple ranges in a single API call while preserving formatting. |
batch_update_values | Update multiple ranges with values in a single efficient API call. |
clear_values | Clear cell values from a range while preserving formatting and structure. |
delete_banding | Delete a banding rule by ID. |
delete_conditional_format_rule | Delete a conditional format rule at the given 0-based index on a sheet. |
delete_dimension | Delete rows or columns from a sheet. range.dimension is ROWS or COLUMNS; range.start_index/end_index are zero-based, end-exclusive. |
delete_duplicates | Remove duplicate rows from a range, comparing only the columns listed in comparison_columns (DimensionRange list). |
delete_embedded_object | Delete an embedded chart or image by its id. |
delete_filter_view | Delete a named filter view by ID. |
delete_named_range | Delete a named range by ID. |
delete_sheet | Permanently delete a sheet (tab) from a spreadsheet. |
find_replace | Bulk find and replace text. |
format_cells | Apply cell-level formatting (number format, colors, fonts, alignment, wrap, borders, padding) to a range using RepeatCellRequest. |
merge_cells | Merge cells across a range. |
move_dimension | Reorder rows or columns. source.dimension is ROWS or COLUMNS; source.start_index/end_index are zero-based, end-exclusive. destination_index is the position before which the rows/columns are inserted (zero-based, in the dimension's pre-move coordinates). |
set_basic_filter | Sets a basic filter on a sheet with optional sorting and column-specific filter criteria. |
set_data_validation | Sets data validation rules to cells in a range. |
sort_range | Sorts data in rows based on a sort order per column. |
trim_whitespace | Strip leading and trailing whitespace from string cells in a range. |
unmerge_cells | Unmerge previously merged cells in a range. |
update_banding | Update an existing banding rule's range or colors. |
update_borders | Set borders around a cell range. |
update_chart | Update an existing chart's spec — change chart type, title, or data ranges. |
update_conditional_format_rule | Replace a conditional format rule at a given index, or move it to a new position. sheet_id targets the sheet; index is the rule's current 0-based position. |
update_dimension_properties | Set column widths or row heights, or hide/show dimensions. range.dimension is ROWS or COLUMNS; range.start_index/end_index are zero-based, end-exclusive. |
update_embedded_object_position | Reposition an embedded object (chart or image) by id. |
update_filter_view | Update an existing named filter view. |
update_named_range | Update an existing named range's name or cell range. |
update_sheet_properties | Update sheet properties like title, position, visibility, or tab color. |
update_spreadsheet_properties | Update spreadsheet properties such as title, locale, or timezone. |
update_values | Write cell values to a specified range. |