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).
No operations match.
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
- Open Space settings → Connections and search for Google Sheets.
- Connect your account and add the connection to the Space.
- Ask for what you need in any thread in that Space.
See How connections work for access and permissions, or browse all integrations.