Google Sheets
Google Sheets is a cloud-based spreadsheet tool enabling real-time collaboration, data analysis, and integration with other Google Workspace apps
Sign in with one click. Composio asks the app for you; Quilt never sees the login.
Reads on its own17
Agents use these right away.
- Batch get spreadsheetRetrieves values from specified cell ranges in a Google Spreadsheet.
- Export Drive SpreadsheetExport an entire native spreadsheet as XLSX, ODS, PDF, ZIP, CSV, or TSV; use Export Sheet as PDF for print layout and range controls.
- Export Sheet as PDFRender one sheet tab or rectangular range as PDF with orientation, gridline, margin, and fit-to-width controls.
- Get Drive File MetadataGet JSON metadata for one Drive file without downloading its content.
- Get sheet namesLists all worksheet names from a specified Google Spreadsheet (which must exist), useful for discovering sheets before further operations.
- Get Spreadsheet by Data FilterReturns the spreadsheet at the given ID, filtered by the specified data filters.
- Get spreadsheet infoRetrieves metadata for a Google Spreadsheet using its ID.
- List Charts in Google SheetsLists all charts in a Google Sheets spreadsheet across all sheets, returning chart_id, sheet metadata, chart type, title, and position.
- List Drive ChangesStart a Drive change monitor or list one page after an existing token.
- Search Developer MetadataTool to search for developer metadata in a spreadsheet.
- Search SpreadsheetsSearch for Google spreadsheets accessible in Drive by name, content, dates, and other filters, including starred and shared-with-me status.
- Batch Get Spreadsheet Values by Data FilterRetrieves one or more ranges of values from a Google Spreadsheet using data filters.
- Get spreadsheet valuesReturns a range of values from a spreadsheet.
- Aggregate Column DataAggregates data from a column in a Google Sheet, either across all rows or rows matching column-value filters.
- Get conditional format rulesList conditional formatting rules for each sheet (or a selected sheet) in a normalized, easy-to-edit form.
- Get Data Validation RulesTool to extract data validation rules from a Google Sheets spreadsheet.
- Look up spreadsheet rowFinds the first row in a specified A1 range or the first sheet where a cell matches the query after Unicode and invisible-character normalization.
Asks someone first33
Anything that sends, creates, changes or deletes waits for a person to approve it in the session’s chat.
- Add Sheet to Existing SpreadsheetAdd a GRID sheet with rows and columns to an existing spreadsheet.
- Append DimensionTool to append new rows or columns to a sheet, increasing its size.
- Batch Clear Values By Data FilterClears one or more ranges of values from a spreadsheet using data filters.
- Clear Basic FilterTool to clear the basic filter from a sheet.
- Create a Google SheetCreates a new Google Spreadsheet in Drive with an optional title and folder ID or exact folder name.
- Delete Dimension (Rows/Columns)Tool to delete specified rows or columns from a sheet in a Google Spreadsheet.
- Delete SheetTool to delete a sheet (worksheet) from a spreadsheet.
- Find and Replace in SpreadsheetFinds and replaces text across cells in a Google Spreadsheet, scoped to a sheet, range, or all sheets; if no scope is specified, it searches all sheets.
- Insert Dimension in Google SheetTool to insert new rows or columns into a sheet at a specified location.
- Move or Resize Chart in Google SheetsMove or resize an existing chart on a Google Sheets spreadsheet.
- Move Spreadsheet to FolderMove an existing Google Spreadsheet to a different Google Drive folder.
- Mutate conditional format rulesAdd, update, delete, or reorder conditional format rules on a Google Sheet.
- Set Basic FilterTool to set a basic filter on a sheet in a Google Spreadsheet.
- Set Data Validation RuleTool to set or clear data validation rules (including dropdowns) on a range in Google Sheets.
- Sort RangeSorts data within a specified range in a Google Sheet based on one or more sort criteria.
- Copy Sheet to Another SpreadsheetTool to copy a single sheet from a spreadsheet to another spreadsheet.
- Append Values to SpreadsheetTool to append values to a spreadsheet.
- Batch Clear Spreadsheet ValuesTool to clear one or more ranges of values from a spreadsheet.
- Update Dimension Properties (Hide/Unhide & Resize)Tool to hide/unhide rows or columns and set row heights or column widths.
- Update Sheet PropertiesTool to update properties of a sheet (worksheet) within a Google Spreadsheet, such as its title, index, visibility, tab color, or grid properties.
- Update Spreadsheet PropertiesTool to update SPREADSHEET-LEVEL properties such as the spreadsheet's title, locale, time zone, or auto-recalculation settings.
- Batch update spreadsheet valuesTool to set values in one or more ranges of a spreadsheet.
- Upsert Rows (Smart Update/Insert)Upserts rows in a Google Sheet by matching a key column: updates matching rows and appends new ones.
- Update spreadsheet valuesSets or overwrites values in a Google Spreadsheet range, adjusting the range to fit the supplied values and potentially expanding the sheet by default.
- Auto-Resize Rows or ColumnsAuto-fit column widths or row heights for a dimension range using batchUpdate.autoResizeDimensions.
- Batch Update Values by Data FilterTool to update values in ranges matching data filters.
- Clear spreadsheet valuesClears cell content (preserving formatting and notes) from a specified A1 notation range in a Google Spreadsheet; the range must correspond to an existing sheet and cells.
- Create Chart in Google SheetsCreate a chart in a Google Sheets spreadsheet using a specified data range and chart type, or an optional full chart specification.
- Create spreadsheet columnInserts a new column in a Google Spreadsheet at a specified index.
- Create spreadsheet rowInserts a new, empty row into a specified sheet of a Google Spreadsheet at a given index, optionally inheriting formatting from the row above.
- Delete Chart from Google SheetsDelete an existing chart from a Google Sheets spreadsheet.
- Format cellFormats a specified cell range in a Google Sheets worksheet.
- Update Chart in Google SheetsUpdates an existing chart in a Google Sheets spreadsheet by replacing its chart specification.
8 more of its actions are no longer kept up by Google Sheets and are left out.