Skip to content
Changelog

Report a bug

Google Sheets integration: operations for AI agents

Google Sheets connects to Type.com as an integration. This page lists the 12 operations documented for Claude and Codex in Type.com: 2 read, 5 write, 5 destructive.

About Google Sheets

Read and write Google Sheets: create spreadsheets, read and update cells, append rows, format ranges, and manage rows, columns and tabs.

Categories: Spreadsheets

How to connect Google Sheets to Type.com

Connect
Sign in with Google (OAuth)
Access
Organization connection: one shared account for the workspace.

To add the connection, follow the steps in Space connections.

Documented operations

12 operations. Your connection's permissions determine which operations are available.

  • Read

    Google sheets get

    Get a Google Sheets spreadsheet's metadata including title and list of sheet tabs.

  • Read

    Google sheets read cells

    Read cell values from a range in a Google Sheets spreadsheet. Uses A1 notation for ranges (e.g. 'Sheet1!A1:D10', 'Sheet1!A:D').

  • Write

    Google sheets add sheet

    Add a new sheet tab to an existing Google Sheets spreadsheet.

  • Write

    Google sheets append rows

    Append rows of data after the last row with content in a Google Sheets spreadsheet. Useful for adding entries to a log, table, or list without overwriting existing data.

  • Write

    Google sheets create

    Create a new Google Sheets spreadsheet with a given title. Optionally pass a Google Drive folder ID selected in the integration settings to create it in that folder.

  • Write

    Google sheets format cells

    Apply cell formatting to a range in a Google Sheets spreadsheet. Can set the cell fill (background) color, text color, bold, italic, underline, strikethrough, font size, horizontal and vertical alignment, text wrapping, and number formats (currency, percent, dates). Colors are hex strings like '#FFF2CC'. Set clearFormatting to true to reset a range to default formatting. Uses A1 notation for ranges (e.g. 'Sheet1!A1:D10', 'Sheet1!A:D').

  • Write

    Google sheets insert rows columns

    Insert empty rows or columns into a sheet tab, shifting existing cells down or right. Indexes are 0-based and endIndex is exclusive: inserting 3 rows above UI row 5 = startIndex 4, endIndex 7. Only works on native Google Sheets, not .xlsx files stored in Drive (download those, edit them, and write them back with google_drive_update_file_content).

  • Destructive

    Google sheets clear range

    Clear cell values from one or more A1 ranges in a Google Sheets spreadsheet. Only values are cleared; formatting, validation, and the rows/columns themselves are kept. Only works on native Google Sheets, not .xlsx files stored in Drive (download those, edit them, and write them back with google_drive_update_file_content).

  • Destructive

    Google sheets delete rows columns

    Delete rows or columns (and their contents) from a sheet tab, shifting remaining cells up or left. Indexes are 0-based and endIndex is exclusive: rows 5-7 in the UI = startIndex 4, endIndex 7; columns B-C = startIndex 1, endIndex 3. Only works on native Google Sheets, not .xlsx files stored in Drive (download those, edit them, and write them back with google_drive_update_file_content).

  • Destructive

    Google sheets find replace

    Find and replace text in a Google Sheets spreadsheet. Searches all tabs by default; pass sheet or sheetId to limit to one tab, or an A1 range (e.g. 'Sheet1!A1:D50') to limit to a range. Returns how many occurrences, cells, rows, sheets, and formulas changed. Only works on native Google Sheets, not .xlsx files stored in Drive (download those, edit them, and write them back with google_drive_update_file_content).

  • Destructive

    Google sheets update tab

    Rename, duplicate, or delete a sheet tab. Rename requires newTitle; duplicate places the copy right after the source tab and uses newTitle if given; delete permanently removes the tab and its data. Only works on native Google Sheets, not .xlsx files stored in Drive (download those, edit them, and write them back with google_drive_update_file_content).

  • Destructive

    Google sheets write cells

    Write values to a range of cells in a Google Sheets spreadsheet. Overwrites existing data in the specified range. Values are provided as a 2D array (rows of columns).

Not supported

  • Editing .xlsx files stored in Drive directly (download, edit and upload them instead)
  • Creating charts, pivot tables or conditional formatting
  • Changing a spreadsheet's sharing settings

Example prompts

  • Add today's new signups as rows in the Signups sheet.
  • Read the Pipeline tab and tell me which deals are past their close date.
  • Format column C as currency and bold the header row.

Get started

  1. Open Space settings → Connections and search for Google Sheets.
  2. Connect your account and add the connection to the Space.
  3. Ask for what you need in any thread in that Space.

See How connections work for access and permissions, or browse all integrations.