Skip to main content

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 / Daily sheet, deduped by transaction ID.
  • Pull the values from the Q2 Forecast sheet and post the rollup in #finance.
  • Find rows in the Leads sheet 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.

  1. Go to Organization > Connectors and find Google Sheets. Click Enable, and choose which tools to allow.
  2. Create a Google Cloud project.
  3. Turn on the Google Sheets API.
  4. Configure the OAuth consent screen.
  5. Create credentials, choose OAuth client ID, and set the type to Web application.
  6. Add the exact Redirect URI shown in the connector settings.
  7. Copy the client ID and client secret into the connector, then save it.
  8. 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.file
  • https://www.googleapis.com/auth/drive.readonly
  • https://www.googleapis.com/auth/spreadsheets
  • https://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.

ToolWhat it does
batch_get_valuesRead cell values from multiple ranges in a single efficient API call.
get_spreadsheetRetrieve spreadsheet information including metadata, sheets, and optionally cell data.
get_table_schemaGet one table's column names and types, plus the sheet and range it covers.
get_valuesRead cell values from a specified range using A1 notation (e.g., 'Sheet1!A1:B10').
list_spreadsheetsList the user's spreadsheets, most recently modified first.
list_tablesList the named tables defined across a spreadsheet, with their sheet, range and column types.
query_tableQuery a spreadsheet with a SQL-like Google Visualization query: filter rows, aggregate columns, group and sort, in one call.
search_spreadsheetsFind spreadsheets by title.
validate_credentialValidate Google Sheets credentials.

Write (14)​

Create or send data.

ToolWhat it does
add_bandingApply alternating row or column colors (zebra striping) to a range. range accepts A1 notation (e.g. 'Sheet1!A1:E20') or a GridRange object.
add_chartAdd a chart (bar, line, area, column, scatter, combo, stepped area) to a spreadsheet.
add_conditional_format_ruleAdd a conditional formatting rule to one or more ranges.
add_dimension_groupCreate 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_viewCreate a named filter view with persistent filter/sort criteria.
add_named_rangeCreate a named range so the cells can be referenced by name in formulas (e.g. =SUM(SalesData)).
add_protected_rangeLock a range from edits. warning_only=True shows a warning but still allows edits; False blocks them.
add_sheetAdd a new sheet (tab) to an existing spreadsheet with customizable properties.
add_tableAdd a table to a sheet over a GridRange (include the header row).
append_valuesAppend rows to the end of a table, automatically finding the last row with data.
copy_sheetCopy a sheet within the same spreadsheet or to a different spreadsheet.
create_spreadsheetCreate a new spreadsheet with specified title and optional properties.
duplicate_sheetDuplicate a sheet within the same spreadsheet using DuplicateSheetRequest.
insert_dimensionInsert 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.

ToolWhat it does
auto_fillExtend a pattern (formula, date sequence, number series) by auto-fill instead of writing each value.
auto_resize_dimensionsAuto-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_valuesClear values from multiple ranges in a single API call while preserving formatting.
batch_update_valuesUpdate multiple ranges with values in a single efficient API call.
clear_valuesClear cell values from a range while preserving formatting and structure.
delete_bandingDelete a banding rule by ID.
delete_conditional_format_ruleDelete a conditional format rule at the given 0-based index on a sheet.
delete_dimensionDelete rows or columns from a sheet. range.dimension is ROWS or COLUMNS; range.start_index/end_index are zero-based, end-exclusive.
delete_duplicatesRemove duplicate rows from a range, comparing only the columns listed in comparison_columns (DimensionRange list).
delete_embedded_objectDelete an embedded chart or image by its id.
delete_filter_viewDelete a named filter view by ID.
delete_named_rangeDelete a named range by ID.
delete_sheetPermanently delete a sheet (tab) from a spreadsheet.
find_replaceBulk find and replace text.
format_cellsApply cell-level formatting (number format, colors, fonts, alignment, wrap, borders, padding) to a range using RepeatCellRequest.
merge_cellsMerge cells across a range.
move_dimensionReorder 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_filterSets a basic filter on a sheet with optional sorting and column-specific filter criteria.
set_data_validationSets data validation rules to cells in a range.
sort_rangeSorts data in rows based on a sort order per column.
trim_whitespaceStrip leading and trailing whitespace from string cells in a range.
unmerge_cellsUnmerge previously merged cells in a range.
update_bandingUpdate an existing banding rule's range or colors.
update_bordersSet borders around a cell range.
update_chartUpdate an existing chart's spec — change chart type, title, or data ranges.
update_conditional_format_ruleReplace 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_propertiesSet 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_positionReposition an embedded object (chart or image) by id.
update_filter_viewUpdate an existing named filter view.
update_named_rangeUpdate an existing named range's name or cell range.
update_sheet_propertiesUpdate sheet properties like title, position, visibility, or tab color.
update_spreadsheet_propertiesUpdate spreadsheet properties such as title, locale, or timezone.
update_valuesWrite cell values to a specified range.
⌘J