# Zoho Sheet

```json
{
  "name": "Zoho Sheet",
  "slug": "zoho_sheet",
  "url": "https://composio.dev/toolkits/zoho_sheet",
  "markdown_url": "https://composio.dev/toolkits/zoho_sheet.md",
  "logo_url": "https://logos.composio.dev/api/zoho_sheet",
  "categories": [
    "productivity & project management"
  ],
  "is_composio_managed": false,
  "updated_at": "2026-11-20T05:43:31.715Z"
}
```

![Zoho Sheet logo](https://logos.composio.dev/api/zoho_sheet)

## Description

Securely connect your AI agents and chatbots (Claude, ChatGPT, Cursor, etc) with Zoho Sheet MCP or direct API to read workbooks, update cell ranges, analyze data, and automate spreadsheet workflows through natural language.

## Summary

Zoho Sheet is a collaborative spreadsheet platform for creating, managing, and analyzing workbook data.
It helps teams work together on structured data with sharing, formatting, and automation tools.

## Categories

- productivity & project management

## Toolkit Details

- Tools: 127

## Images

- Logo: https://logos.composio.dev/api/zoho_sheet

## Authentication

- **Oauth2**
  - Type: `oauth2`
  - Description: Oauth2 authentication for Zoho Sheet.
  - Setup:
    - Configure Oauth2 credentials for Zoho Sheet.
    - Use the credentials when creating an auth config in Composio.

## Suggested Prompts

- Read sales data from Zoho Sheet
- Update inventory totals in Zoho Sheet
- Create monthly budget workbook in Zoho Sheet

## Supported Tools

| Tool slug | Name | Description |
|---|---|---|
| `ZOHO_SHEET_ADD_RECORDS` | Add records | Append one JSON row to a worksheet. Requires a paid WorkDrive account or Zoho One. |
| `ZOHO_SHEET_ADD_RECORDS_TO_TABLE` | Add records to table | Add JSON-formatted records to a Zoho Sheet table, appending them by default or inserting them at the top. |
| `ZOHO_SHEET_ADD_RECORDS_TO_WORKSHEET` | Add records to worksheet | Append JSON-formatted records to a Zoho Sheet worksheet. |
| `ZOHO_SHEET_APPEND_ROWS_WITH_CSV_DATA` | Append rows with CSV data | Append CSV data as rows in a Zoho Sheet worksheet. |
| `ZOHO_SHEET_APPEND_ROWS_WITH_JSON_DATA` | Append rows with JSON data | Append object-shaped JSON rows to a Zoho Sheet worksheet. |
| `ZOHO_SHEET_APPLY_PICKLIST_TO_RANGE` | Apply picklist to range | Apply a picklist to one or more ranges in a Zoho Sheet workbook. |
| `ZOHO_SHEET_APPLY_SPARKLINE_TO_A_RANGE` | Apply sparkline to a range | Create sparklines in destination ranges from corresponding source ranges. |
| `ZOHO_SHEET_CLEAR_CONDITIONAL_FORMAT_FROM_RANGE` | Clear conditional format from range | Clear conditional formatting from a specified worksheet range. |
| `ZOHO_SHEET_CLEAR_CONTENTS_OF_RANGE` | Clear contents of range | Clear cell contents while retaining other range properties. |
| `ZOHO_SHEET_CLEAR_DATA_VALIDATION_FROM_RANGE` | Clear data validation from range | Clear data validation rules from specified worksheet ranges. |
| `ZOHO_SHEET_CLEAR_FILTERS` | Clear filters | Clear filters from a Zoho Sheet worksheet. |
| `ZOHO_SHEET_CLEAR_NOTES_FROM_RANGE` | Clear notes from range | Clear notes from a worksheet range, or from the whole worksheet when no range is provided. |
| `ZOHO_SHEET_CLEAR_RANGE` | Clear range | Clear the style, format, and content of a worksheet range. |
| `ZOHO_SHEET_CLONE_CHART` | Clone chart | Creates a duplicate of the specified chart. |
| `ZOHO_SHEET_COLUMN_WIDTH` | Column width | Set or automatically fit the width of multiple discontinuous worksheet columns. |
| `ZOHO_SHEET_CONVERT_INDEX_TO_RANGE` | Convert Index to Range | Convert start and end row and column indices to an A1-style range. |
| `ZOHO_SHEET_CONVERT_RANGE_TO_INDEX` | Convert Range to Index | Convert an A1-style range to start and end row and column indices. |
| `ZOHO_SHEET_COPY_PIVOT_TABLE` | Copy pivot table | Copy a pivot table to another location in the same Zoho Sheet workbook. |
| `ZOHO_SHEET_COPY_WORKBOOK` | Copy workbook | Make a new copy of an existing Zoho Sheet workbook. |
| `ZOHO_SHEET_COPY_WORKSHEET_NEW_WORKBOOK` | Copy worksheet to new workbook | Copy a Zoho Sheet worksheet into a newly created workbook. |
| `ZOHO_SHEET_COPY_WORKSHEET_OTHER_WORKBOOK` | Copy worksheet - other workbook | Copy a worksheet from one Zoho Sheet workbook into another workbook. |
| `ZOHO_SHEET_COPY_WORKSHEET_SAME_WORKBOOK` | Copy worksheet - same workbook | Copy or duplicate a worksheet within the same Zoho Sheet workbook. |
| `ZOHO_SHEET_CREATE_NAMED_RANGE` | Create named range | Create an absolute named range in a Zoho Sheet workbook. |
| `ZOHO_SHEET_CREATE_PIVOT_CHART` | Create pivot chart | Create a supported chart from a Zoho Sheet pivot table with structured chart and sheet metadata. |
| `ZOHO_SHEET_CREATE_PIVOT_TABLE` | Create pivot table | Create a pivot table from a named range or worksheet range in Zoho Sheet. |
| `ZOHO_SHEET_CREATE_TABLE` | Create table | Create a table over a selected range in a Zoho Sheet worksheet. |
| `ZOHO_SHEET_CREATE_VERSION` | Create version | Create a named version of a Zoho Sheet workbook. |
| `ZOHO_SHEET_CREATE_WORKBOOK` | Create workbook | Create a new Zoho Sheet workbook. |
| `ZOHO_SHEET_CREATE_WORKBOOK_FROM_TEMPLATE` | Create workbook from template | Create a new Zoho Sheet workbook from an existing template. |
| `ZOHO_SHEET_CREATE_WORKSHEET` | Create worksheet | Add a new worksheet to an existing Zoho Sheet workbook. |
| `ZOHO_SHEET_DELETE_CELLS` | Delete cells | Delete a range of cells and shift remaining cells left or up. |
| `ZOHO_SHEET_DELETE_CHART` | Delete chart | Deletes the specified charts from the sheet. |
| `ZOHO_SHEET_DELETE_COLUMN` | Delete column | Delete a single column from a worksheet. |
| `ZOHO_SHEET_DELETE_COLUMNS_FROM_TABLE` | Delete columns from table | Delete multiple columns from a Zoho Sheet table. |
| `ZOHO_SHEET_DELETE_MULTIPLE_WORKSHEETS` | Delete multiple worksheets | Delete multiple worksheets from a Zoho Sheet workbook. The workbook must retain at least one worksheet. |
| `ZOHO_SHEET_DELETE_NAMED_RANGE` | Delete named range | Delete an existing named range from a Zoho Sheet workbook. |
| `ZOHO_SHEET_DELETE_PIVOT_CHART` | Delete pivot chart | Delete selected pivot charts or all pivot charts on a worksheet in Zoho Sheet. |
| `ZOHO_SHEET_DELETE_PIVOT_TABLE` | Delete pivot table | Delete selected pivot tables or pivot tables in a target worksheet range. |
| `ZOHO_SHEET_DELETE_RECORDS_FROM_TABLE` | Delete records from table | Delete records from a Zoho Sheet table based on criteria. |
| `ZOHO_SHEET_DELETE_RECORDS_FROM_WORKSHEET` | Delete records from worksheet | Delete or erase Zoho Sheet worksheet records selected by criteria. |
| `ZOHO_SHEET_DELETE_ROW` | Delete row | Delete a single row from a worksheet. |
| `ZOHO_SHEET_DELETE_ROWS` | Delete rows | Delete multiple discontinuous rows from a worksheet. |
| `ZOHO_SHEET_DELETE_SPARKLINE_FROM_A_RANGE` | Delete sparkline from a range | Delete sparklines from specified ranges of a Zoho Sheet worksheet. |
| `ZOHO_SHEET_DELETE_WORKBOOK` | Delete workbook | Permanently delete up to 10 Zoho Sheet workbooks from the trash. |
| `ZOHO_SHEET_DELETE_WORKSHEET` | Delete worksheet | Delete an existing worksheet from a Zoho Sheet workbook that contains more than one worksheet. |
| `ZOHO_SHEET_DOWNLOAD_WORKBOOK` | Download workbook | Download an existing Zoho Sheet workbook as XLSX, XLSB, XLTX, CSV, TSV, ODS, or PDF. |
| `ZOHO_SHEET_EDIT_PIVOT_TABLE` | Edit pivot table | Edit the source, fields, grouping, settings, style, or name of a Zoho Sheet pivot table. |
| `ZOHO_SHEET_EXPORT_CHART` | Export chart | Retrieves chart image data from the spreadsheet. |
| `ZOHO_SHEET_FETCH_RECORDS` | Fetch records | Fetch and filter high-throughput worksheet records. Requires a paid WorkDrive account or Zoho One. |
| `ZOHO_SHEET_FETCH_RECORDS_FROM_TABLE` | Fetch records from table | Fetch records from a Zoho Sheet table, optionally filtering up to five criteria and selecting specific columns. |
| `ZOHO_SHEET_FETCH_RECORDS_FROM_WORKSHEET` | Fetch records from worksheet | Fetch and optionally filter records from a Zoho Sheet worksheet. |
| `ZOHO_SHEET_FILL_SERIES` | Fill series | Fill cells in a direction based on an existing Zoho Sheet source range. |
| `ZOHO_SHEET_FILTER_PIVOT_TABLE` | Filter pivot table | Apply or clear member, label, and value filters on a Zoho Sheet pivot table. |
| `ZOHO_SHEET_FIND` | Find | Search for a string in a Zoho Sheet workbook, worksheet, row, or column. |
| `ZOHO_SHEET_FIND_AND_REPLACE` | Find and replace | Find and replace text in a Zoho Sheet workbook, worksheet, row, or column. |
| `ZOHO_SHEET_FORMAT_RANGES` | Format ranges | Add or edit text and cell-level formatting on one or more worksheet ranges. |
| `ZOHO_SHEET_FREEZE_PANES` | Freeze panes | Freeze or unfreeze rows, columns, or panes in a Zoho Sheet worksheet. |
| `ZOHO_SHEET_GET_CONTENT_OF_CELL` | Get content of cell | Get the content and note of a particular Zoho Sheet cell. |
| `ZOHO_SHEET_GET_CONTENT_OF_NAMED_RANGE` | Get content of named range | Get the contents of a named range in a Zoho Sheet workbook. |
| `ZOHO_SHEET_GET_CONTENT_OF_RANGE` | Get content of range | Get the contents of a range in a Zoho Sheet worksheet. |
| `ZOHO_SHEET_GET_CONTENT_OF_WORKSHEET` | Get content of worksheet | Get the complete or bounded contents of a Zoho Sheet worksheet. |
| `ZOHO_SHEET_GET_MERGE_FIELDS` | Get merge fields | List all merge fields in a Zoho Sheet workbook. |
| `ZOHO_SHEET_GET_MERGE_JOB_DETAILS` | Get merge job details | Get status and generated-file details for a Zoho Sheet merge job. |
| `ZOHO_SHEET_GET_MERGE_JOBS` | Get merge jobs | List merge jobs for a Zoho Sheet merge-template workbook. |
| `ZOHO_SHEET_GET_MERGE_TEMPLATES` | Get merge templates | Get the merge templates available to the connected Zoho Sheet user. |
| `ZOHO_SHEET_GET_PIVOT_DATA` | Get pivot data | Retrieve one aggregate value from a Zoho Sheet pivot table. |
| `ZOHO_SHEET_GET_USED_AREA` | Get used area | Get the used row and column bounds of a Zoho Sheet worksheet. |
| `ZOHO_SHEET_IMAGE_FIT_OPTIONS` | Image fit options | Change the fit option of cell images in a worksheet range. |
| `ZOHO_SHEET_INSERT_CELLS` | Insert cells | Insert a range of cells and shift existing cells right or down. |
| `ZOHO_SHEET_INSERT_CHART` | Insert chart | Creates a new chart in the specified sheet using the provided data sources and chart type. |
| `ZOHO_SHEET_INSERT_CHECKBOX` | Insert checkbox | Insert checkboxes into a range in a Zoho Sheet worksheet. |
| `ZOHO_SHEET_INSERT_COLUMN` | Insert column | Insert a new column into a worksheet with default cell formats. |
| `ZOHO_SHEET_INSERT_COLUMNS_TO_RECORDS` | Insert columns to records | Insert one or more columns with headers into worksheet records. |
| `ZOHO_SHEET_INSERT_COLUMNS_TO_TABLE` | Insert columns to table | Append one or more columns with headers to a Zoho Sheet table. |
| `ZOHO_SHEET_INSERT_IMAGES` | Insert images | Insert uploaded images or images already in the Zoho Sheet image library into a workbook. |
| `ZOHO_SHEET_INSERT_ROW` | Insert row | Insert a new row with optional JSON data into a worksheet. |
| `ZOHO_SHEET_INSERT_ROW_WITH_JSON_DATA` | Insert row with JSON data | Insert a new Zoho Sheet row at a specified index using JSON data. |
| `ZOHO_SHEET_LIST_ALL_NAMED_RANGES` | List all named ranges | Get all named ranges and tables in a Zoho Sheet workbook. |
| `ZOHO_SHEET_LIST_ALL_PICKLISTS` | List all picklists | List workbook picklists, their applied ranges, source ranges, and items. |
| `ZOHO_SHEET_LIST_ALL_PIVOT_CHARTS` | List all pivot charts | List pivot charts in a Zoho Sheet workbook, optionally filtered by worksheet. |
| `ZOHO_SHEET_LIST_ALL_PIVOT_TABLES` | List all pivot tables | List pivot tables in a Zoho Sheet workbook, optionally filtered by target worksheet or range. |
| `ZOHO_SHEET_LIST_ALL_TABLES` | List All Tables | List all tables in a Zoho Sheet workbook, including their table IDs and ranges. |
| `ZOHO_SHEET_LIST_ALL_TEMPLATES` | List all templates | List all Zoho Sheet templates belonging to the connected user. |
| `ZOHO_SHEET_LIST_ALL_VERSIONS` | List all versions | List all saved versions of a Zoho Sheet workbook. |
| `ZOHO_SHEET_LIST_ALL_WORKBOOKS` | List all workbooks | List the connected user's owned and shared Zoho Sheet workbooks. |
| `ZOHO_SHEET_LIST_ALL_WORKSHEET` | List All Worksheets | List all worksheets in a Zoho Sheet workbook, including their worksheet IDs. |
| `ZOHO_SHEET_LIST_CHART` | List chart | Returns all charts in the workbook grouped by worksheet name. |
| `ZOHO_SHEET_LIST_CONDITIONAL_FORMATS` | List conditional formats | List conditional formatting rules in a workbook, worksheet, or worksheet range. |
| `ZOHO_SHEET_LOCK` | Lock | Lock a Zoho Sheet worksheet or selected range for shared users or external share links. |
| `ZOHO_SHEET_MERGE_AND_EMAIL_AS_ATTACHMENT` | Merge and email as attachment | Merge template data and email generated documents as attachments without saving them. |
| `ZOHO_SHEET_MERGE_AND_SAVE` | Merge and save | Merge template data and save the generated documents in Zoho WorkDrive. |
| `ZOHO_SHEET_MOVE_CHART` | Move chart | Moves the specified chart to another worksheet within the spreadsheet. |
| `ZOHO_SHEET_MOVE_PIVOT_TABLE` | Move pivot table | Move a pivot table to another location in the same Zoho Sheet workbook. |
| `ZOHO_SHEET_PUBLISH` | Publish | Publish a Zoho Sheet workbook, worksheet, or worksheet range. |
| `ZOHO_SHEET_PUBLISH_CHART` | Publish Chart | Publishes one or more charts and generates unique publish keys for each chart. |
| `ZOHO_SHEET_READ_DATA_VALIDATION_IN_CELL` | Read data validation in cell | Read the data validation rule applied to a Zoho Sheet cell. |
| `ZOHO_SHEET_RECALCULATE` | Recalculate | Recalculate formula cells after adding or updating Zoho Sheet records. |
| `ZOHO_SHEET_REFRESH_PIVOT_TABLE` | Refresh pivot table | Refresh selected pivot tables or pivot tables in a target worksheet range. |
| `ZOHO_SHEET_REMOVE_PICKLIST_FROM_RANGE` | Remove picklist from range | Remove picklists from specified ranges in a Zoho Sheet workbook. |
| `ZOHO_SHEET_REMOVE_PUBLISH` | Remove publish | Remove a published Zoho Sheet workbook, worksheet, or range. |
| `ZOHO_SHEET_REMOVE_TABLE` | Remove table | Remove a table from a Zoho Sheet workbook, optionally clearing its table formatting. |
| `ZOHO_SHEET_RENAME_HEADERS_OF_TABLE` | Rename headers of table | Rename header values in a table in a Zoho Sheet workbook. |
| `ZOHO_SHEET_RENAME_WORKSHEET` | Rename worksheet | Rename an existing worksheet in a Zoho Sheet workbook. |
| `ZOHO_SHEET_RESTORE_WORKBOOK` | Restore workbook | Restore up to 10 Zoho Sheet workbooks from the trash. |
| `ZOHO_SHEET_REVERT_VERSION` | Revert version | Revert a Zoho Sheet workbook to an older version. |
| `ZOHO_SHEET_ROW_HEIGHT` | Row height | Set or automatically fit the height of multiple discontinuous worksheet rows. |
| `ZOHO_SHEET_SET_CONDITIONAL_FORMAT_TO_RANGE` | Set conditional format to range | Apply classic, color-scale, data-bar, or icon-set conditional formatting to worksheet ranges. |
| `ZOHO_SHEET_SET_CONTENT_TO_CELL` | Set content to cell | Set content in a particular cell of a Zoho Sheet worksheet. |
| `ZOHO_SHEET_SET_CONTENT_TO_MULTIPLE_CELLS` | Set content to multiple cells | Set content in multiple discrete cells in a Zoho Sheet workbook. |
| `ZOHO_SHEET_SET_CONTENT_TO_RANGE` | Set content to range | Insert CSV data into a Zoho Sheet worksheet at a specified cell. |
| `ZOHO_SHEET_SET_CONTENT_TO_ROW` | Set content to row | Update discrete columns in a particular Zoho Sheet row. |
| `ZOHO_SHEET_SET_DATA_VALIDATION_TO_RANGE` | Set data validation to range | Apply a data validation rule to one or more ranges in a worksheet. |
| `ZOHO_SHEET_SET_NOTE_TO_CELL` | Set note to cell | Create or replace a note on a worksheet cell. |
| `ZOHO_SHEET_SET_ZOOM_LEVEL` | Set zoom level | Set the zoom level of a worksheet in a Zoho Sheet workbook. |
| `ZOHO_SHEET_SHARE_WORKBOOK` | Share workbook | Share a Zoho Sheet workbook with one or more users. |
| `ZOHO_SHEET_SORT_PIVOT_TABLE` | Sort pivot table | Sort fields in a Zoho Sheet pivot table by labels or data values. |
| `ZOHO_SHEET_TRASH_WORKBOOK` | Trash workbook | Move up to 10 Zoho Sheet workbooks to trash. |
| `ZOHO_SHEET_UNLOCK` | Unlock | Unlock a Zoho Sheet worksheet or selected range for shared users or external share links. |
| `ZOHO_SHEET_UNPUBLISH_CHART` | Unpublish Chart | Revokes public access to previously published charts. |
| `ZOHO_SHEET_UPDATE_CHART` | Update chart | Updates the metadata of a chart in a single call. |
| `ZOHO_SHEET_UPDATE_NAMED_RANGE` | Update named range | Update the source range of an existing Zoho Sheet named range. |
| `ZOHO_SHEET_UPDATE_PIVOT_CHART` | Update pivot chart | Update a Zoho Sheet pivot chart with structured chart and sheet metadata. |
| `ZOHO_SHEET_UPDATE_RECORDS` | Update records | Update up to ten high-throughput worksheet records. Requires a paid WorkDrive account or Zoho One. |
| `ZOHO_SHEET_UPDATE_RECORDS_IN_TABLE` | Update records in table | Update records in a Zoho Sheet table that match specified criteria. |
| `ZOHO_SHEET_UPDATE_RECORDS_IN_WORKSHEET` | Update records in worksheet | Update Zoho Sheet worksheet records selected by criteria. |
| `ZOHO_SHEET_UPDATE_ROWS_WITH_JSON_DATA` | Update rows with JSON data | Update multiple discontinuous Zoho Sheet rows by row index using JSON data. |
| `ZOHO_SHEET_UPLOAD_WORKBOOK` | Upload workbook | Upload a workbook file or import one from a public URL into Zoho Sheet. Supported file formats are XLS, XLSX, XLSB, XLTX, CSV, TSV, SXC, and ODS. |

## Supported Triggers

None listed.

## Installation and MCP Setup

### Path 1: SDK Installation

#### Path 1, Step 1: Install Composio

Install the Composio SDK, the OpenAI provider, and the OpenAI SDK
```python
pip install composio composio_openai openai
```

```typescript
npm install @composio/core @composio/openai openai
```

#### Path 1, Step 2: Create a Composio session

Initialize Composio with the OpenAI Responses provider and create a session scoped to Zoho Sheet
```python
import json
from openai import OpenAI
from composio import Composio
from composio_openai import OpenAIResponsesProvider

composio = Composio(provider=OpenAIResponsesProvider())
client = OpenAI()

session = composio.create(user_id="your-user-id", toolkits=["zoho_sheet"])
tools = session.tools()
```

```typescript
import OpenAI from "openai";
import { Composio } from "@composio/core";
import { OpenAIResponsesProvider } from "@composio/openai";

const composio = new Composio({ provider: new OpenAIResponsesProvider() });
const client = new OpenAI();

const session = await composio.create("your-user-id", { toolkits: ["zoho_sheet"] });
const tools = await session.tools();
```

#### Path 1, Step 3: Run Zoho Sheet tools with your agent

Send a request, execute the Zoho Sheet tool calls through the session, and print the final answer
```python
response = client.responses.create(
    model="gpt-5.6-sol",
    tools=tools,
    input=[{"role": "user", "content": "Read range A1:F20 from my Zoho Sheet workbook named Sales Forecast"}],
)

while True:
    tool_calls = [o for o in response.output if o.type == "function_call"]
    if not tool_calls:
        break
    results = composio.provider.handle_tool_calls(response=response, session=session)
    response = client.responses.create(
        model="gpt-5.6-sol",
        tools=tools,
        previous_response_id=response.id,
        input=[
            {"type": "function_call_output", "call_id": call.call_id, "output": json.dumps(results[i])}
            for i, call in enumerate(tool_calls)
        ],
    )

print(response.output_text)
```

```typescript
let response = await client.responses.create({
  model: "gpt-5.6-sol",
  tools,
  input: [{ role: "user", content: "Read range A1:F20 from my Zoho Sheet workbook named Sales Forecast" }],
});

while (response.output.some((o) => o.type === "function_call")) {
  const outputs = await composio.provider.handleToolCalls(session, response.output);
  response = await client.responses.create({
    model: "gpt-5.6-sol",
    tools,
    previous_response_id: response.id,
    input: outputs,
  });
}

console.log(response.output_text);
```

### Path 2: MCP Server Setup

#### Path 2, Step 1: Install Composio

Install the Composio SDK and your agent framework
```python
pip install composio claude-agent-sdk
```

```typescript
npm install @composio/core ai @ai-sdk/mcp @ai-sdk/openai
```

#### Path 2, Step 2: Create a session with MCP enabled

Create a session scoped to Zoho Sheet and read its MCP URL and headers
```python
from composio import Composio

composio = Composio()
session = composio.create(user_id="your-user-id", toolkits=["zoho_sheet"], mcp=True)
```

```typescript
import { Composio } from "@composio/core";

const composio = new Composio();
const { mcp } = await composio.create("your-user-id", {
  toolkits: ["zoho_sheet"],
  mcp: true,
});
```

#### Path 2, Step 3: Connect your agent to the MCP server

Pass the session's MCP URL and headers to your agent and run a Zoho Sheet request
```python
import asyncio
from claude_agent_sdk import ClaudeSDKClient, ClaudeAgentOptions, AssistantMessage, TextBlock

options = ClaudeAgentOptions(
    mcp_servers={
        "composio": {
            "type": "http",
            "url": session.mcp.url,
            "headers": session.mcp.headers,
        }
    },
    system_prompt="You are a helpful assistant with access to Zoho Sheet tools.",
    tools=[],
    allowed_tools=["mcp__composio__*"],
)

async def main():
    async with ClaudeSDKClient(options=options) as client:
        await client.query("Read range A1:F20 from my Zoho Sheet workbook named Sales Forecast")
        async for message in client.receive_response():
            if isinstance(message, AssistantMessage):
                for block in message.content:
                    if isinstance(block, TextBlock):
                        print(block.text)

asyncio.run(main())
```

```typescript
import { createMCPClient } from "@ai-sdk/mcp";
import { openai } from "@ai-sdk/openai";
import { generateText, stepCountIs } from "ai";

const client = await createMCPClient({
  transport: { type: "http", url: mcp.url, headers: mcp.headers },
});

const { text } = await generateText({
  model: openai("gpt-5.6-sol"),
  tools: await client.tools(),
  prompt: "Read range A1:F20 from my Zoho Sheet workbook named Sales Forecast",
  stopWhen: stepCountIs(10),
});

console.log(text);
await client.close();
```

## Why Use Composio?

### 1. AI Native Zoho Sheet Integration

- Supports both Zoho Sheet MCP and direct API based integrations
- Structured, LLM-friendly schemas for reliable tool execution
- Rich coverage for reading, writing, formatting, and querying your Zoho Sheet workbooks

### 2. Managed Auth

- Connect your Zoho Sheet OAuth credentials securely through Composio
- Central place to manage, scope, and revoke Zoho Sheet access
- Per user and per environment credentials instead of hard-coded secrets

### 3. Agent Optimized Design

- Tools are tuned using real error and success rates to improve reliability over time
- Comprehensive execution logs so you always know what ran, when, and on whose behalf

### 4. Enterprise Grade Security

- Fine-grained RBAC so you control which agents and users can access Zoho Sheet
- Scoped, least privilege access to Zoho Sheet workbooks and sheet data
- Full audit trail of agent actions to support review and compliance

## Use Zoho Sheet with any AI Agent Framework

Choose a framework you want to connect Zoho Sheet with:

- [ChatGPT](https://composio.dev/toolkits/zoho_sheet/framework/chatgpt)
- [Claude Cowork](https://composio.dev/toolkits/zoho_sheet/framework/claude-cowork)

## Related Toolkits

- [Google Sheets](https://composio.dev/toolkits/googlesheets) - Google Sheets is a cloud-based spreadsheet tool for real-time collaboration and data analysis. It lets teams work together from anywhere, updating information instantly.
- [Notion](https://composio.dev/toolkits/notion) - Notion is a collaborative workspace for notes, docs, wikis, and tasks. It streamlines team knowledge, project tracking, and workflow customization in one place.
- [Airtable](https://composio.dev/toolkits/airtable) - Airtable combines the flexibility of spreadsheets with the power of a database for easy project and data management. Teams use Airtable to organize, track, and collaborate with custom views and automations.
- [Asana](https://composio.dev/toolkits/asana) - Asana is a collaborative work management platform for teams to organize and track projects. It streamlines teamwork, boosts productivity, and keeps everyone aligned on goals.
- [Google Tasks](https://composio.dev/toolkits/googletasks) - Google Tasks is a to-do list and task management tool integrated into Gmail and Google Calendar. It helps you organize, track, and complete tasks across your Google ecosystem.
- [Linear](https://composio.dev/toolkits/linear) - Linear is a modern issue tracking and project planning tool for fast-moving teams. It helps streamline workflows, organize projects, and boost productivity.
- [Jira](https://composio.dev/toolkits/jira) - Jira is Atlassian’s platform for bug tracking, issue tracking, and agile project management. It helps teams organize work, prioritize tasks, and deliver projects efficiently.
- [Clickup](https://composio.dev/toolkits/clickup) - ClickUp is an all-in-one productivity platform for managing tasks, docs, goals, and team collaboration. It streamlines project workflows so teams can work smarter and stay organized in one place.
- [Monday](https://composio.dev/toolkits/monday) - Monday.com is a customizable work management platform for project planning and collaboration. It helps teams organize tasks, automate workflows, and track progress in real time.
- [Addressfinder](https://composio.dev/toolkits/addressfinder) - Addressfinder is a data quality platform for verifying addresses, emails, and phone numbers. It helps you ensure accurate customer and contact data every time.
- [Agiled](https://composio.dev/toolkits/agiled) - Agiled is an all-in-one business management platform for CRM, projects, and finance. It helps you streamline workflows, consolidate client data, and manage business processes in one place.
- [Aha!](https://composio.dev/toolkits/aha) - Aha! is a product management platform for setting strategy, prioritizing ideas, and planning roadmaps. It helps product teams align goals with development work and make better decisions.
- [AirOps MCP](https://composio.dev/toolkits/airops_mcp) - AirOps MCP is AirOps' managed content platform exposing brand context, knowledge bases, and workflows. Use it to give agents brand-aware content, automate content workflows, and track Brand Kit edits.
- [Amazing Marvin](https://composio.dev/toolkits/amazing_marvin) - Amazing Marvin is a personal productivity app for tasks, projects, habits, planning, time tracking, and rewards. It helps you build a flexible workflow that matches how you actually work.
- [Ambiguous MCP](https://composio.dev/toolkits/ambiguous_mcp) - Ambiguous MCP is a provider-hosted workspace service for documents, spreadsheets, tasks, CRM, calendar, mail, chat, and administration. It provides one workspace-scoped connection for managing these resources through natural language.
- [AnyDB](https://composio.dev/toolkits/any_db) - AnyDB is a flexible collaborative database platform for organizing records, files, and automated workflows. It helps teams centralize data, collaborate on records, and automate routine tasks.
- [ApptiveGrid](https://composio.dev/toolkits/apptivegrid) - ApptiveGrid is a collaborative no-code database and app platform for spaces, grids, forms, and structured records. It helps teams organize operational data, collect inputs, and build lightweight business apps without custom backend work.
- [Ascora](https://composio.dev/toolkits/ascora) - Ascora is a cloud-based field service management platform for service businesses. It streamlines scheduling, invoicing, and customer operations in one place.
- [Atlassian MCP](https://composio.dev/toolkits/atlassian_mcp) - Atlassian Rovo MCP connects agents to Jira, Jira Service Management, Confluence, Bitbucket, Compass, and Teamwork Graph workflows. It lets teams surface and act on Atlassian data while respecting existing user permissions.
- [Basecamp](https://composio.dev/toolkits/basecamp) - Basecamp is a project management and team collaboration tool by 37signals. It helps teams organize tasks, share files, and communicate efficiently in one place.

## Frequently Asked Questions

### Do I need my own developer credentials to use Zoho Sheet with Composio?

Yes, Zoho Sheet requires you to configure your own OAuth credentials. Once set up, Composio handles token storage, refresh, and lifecycle management for you.

### Can I use multiple toolkits together?

Yes! Composio's Tool Router enables agents to use multiple toolkits. [Learn more](https://docs.composio.dev/tool-router/overview).

### Is Composio secure?

Composio is SOC 2 and ISO 27001 compliant with all data encrypted in transit and at rest. [Learn more](https://trust.composio.dev).

### What if the API changes?

Composio maintains and updates all toolkit integrations automatically, so your agents always work with the latest API versions.

---
[See all toolkits](https://composio.dev/toolkits) · [Composio docs](https://docs.composio.dev/llms.txt)
