Zoho Sheet MCP server for AI agents and assistants

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.

Zoho Sheet logoZoho Sheet
Oauth2

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.

127 Tools

Try Zoho Sheet now

Type what you want done — sign in and watch it run live in the Tool Router playground.

TOOL ROUTER PLAYGROUND
Zoho Sheet
Try asking
TOOLS

Supported Tools

Every Zoho Sheet action and event your agent gets out of the box.

Add records

Append one JSON row to a worksheet.

Add records to table

Add JSON-formatted records to a Zoho Sheet table, appending them by default or inserting them at the top.

Add records to worksheet

Append JSON-formatted records to a Zoho Sheet worksheet.

Append rows with CSV data

Append CSV data as rows in a Zoho Sheet worksheet.

Append rows with JSON data

Append object-shaped JSON rows to a Zoho Sheet worksheet.

Apply picklist to range

Apply a picklist to one or more ranges in a Zoho Sheet workbook.

Apply sparkline to a range

Create sparklines in destination ranges from corresponding source ranges.

Clear conditional format from range

Clear conditional formatting from a specified worksheet range.

Clear contents of range

Clear cell contents while retaining other range properties.

Clear data validation from range

Clear data validation rules from specified worksheet ranges.

Clear filters

Clear filters from a Zoho Sheet worksheet.

Clear notes from range

Clear notes from a worksheet range, or from the whole worksheet when no range is provided.

Clear range

Clear the style, format, and content of a worksheet range.

Clone chart

Creates a duplicate of the specified chart.

Column width

Set or automatically fit the width of multiple discontinuous worksheet columns.

Convert Index to Range

Convert start and end row and column indices to an A1-style range.

Convert Range to Index

Convert an A1-style range to start and end row and column indices.

Copy pivot table

Copy a pivot table to another location in the same Zoho Sheet workbook.

Copy workbook

Make a new copy of an existing Zoho Sheet workbook.

Copy worksheet to new workbook

Copy a Zoho Sheet worksheet into a newly created workbook.

Copy worksheet - other workbook

Copy a worksheet from one Zoho Sheet workbook into another workbook.

Copy worksheet - same workbook

Copy or duplicate a worksheet within the same Zoho Sheet workbook.

Create named range

Create an absolute named range in a Zoho Sheet workbook.

Create pivot chart

Create a supported chart from a Zoho Sheet pivot table with structured chart and sheet metadata.

Create pivot table

Create a pivot table from a named range or worksheet range in Zoho Sheet.

Create table

Create a table over a selected range in a Zoho Sheet worksheet.

Create version

Create a named version of a Zoho Sheet workbook.

Create workbook

Create a new Zoho Sheet workbook.

Create workbook from template

Create a new Zoho Sheet workbook from an existing template.

Create worksheet

Add a new worksheet to an existing Zoho Sheet workbook.

Delete cells

Delete a range of cells and shift remaining cells left or up.

Delete chart

Deletes the specified charts from the sheet.

Delete column

Delete a single column from a worksheet.

Delete columns from table

Delete multiple columns from a Zoho Sheet table.

Delete multiple worksheets

Delete multiple worksheets from a Zoho Sheet workbook.

Delete named range

Delete an existing named range from a Zoho Sheet workbook.

Delete pivot chart

Delete selected pivot charts or all pivot charts on a worksheet in Zoho Sheet.

Delete pivot table

Delete selected pivot tables or pivot tables in a target worksheet range.

Delete records from table

Delete records from a Zoho Sheet table based on criteria.

Delete records from worksheet

Delete or erase Zoho Sheet worksheet records selected by criteria.

Delete row

Delete a single row from a worksheet.

Delete rows

Delete multiple discontinuous rows from a worksheet.

Delete sparkline from a range

Delete sparklines from specified ranges of a Zoho Sheet worksheet.

Delete workbook

Permanently delete up to 10 Zoho Sheet workbooks from the trash.

Delete worksheet

Delete an existing worksheet from a Zoho Sheet workbook that contains more than one worksheet.

Download workbook

Download an existing Zoho Sheet workbook as XLSX, XLSB, XLTX, CSV, TSV, ODS, or PDF.

Edit pivot table

Edit the source, fields, grouping, settings, style, or name of a Zoho Sheet pivot table.

Export chart

Retrieves chart image data from the spreadsheet.

Fetch records

Fetch and filter high-throughput worksheet records.

Fetch records from table

Fetch records from a Zoho Sheet table, optionally filtering up to five criteria and selecting specific columns.

Fetch records from worksheet

Fetch and optionally filter records from a Zoho Sheet worksheet.

Fill series

Fill cells in a direction based on an existing Zoho Sheet source range.

Filter pivot table

Apply or clear member, label, and value filters on a Zoho Sheet pivot table.

Find

Search for a string in a Zoho Sheet workbook, worksheet, row, or column.

Find and replace

Find and replace text in a Zoho Sheet workbook, worksheet, row, or column.

Format ranges

Add or edit text and cell-level formatting on one or more worksheet ranges.

Freeze panes

Freeze or unfreeze rows, columns, or panes in a Zoho Sheet worksheet.

Get content of cell

Get the content and note of a particular Zoho Sheet cell.

Get content of named range

Get the contents of a named range in a Zoho Sheet workbook.

Get content of range

Get the contents of a range in a Zoho Sheet worksheet.

Get content of worksheet

Get the complete or bounded contents of a Zoho Sheet worksheet.

Get merge fields

List all merge fields in a Zoho Sheet workbook.

Get merge job details

Get status and generated-file details for a Zoho Sheet merge job.

Get merge jobs

List merge jobs for a Zoho Sheet merge-template workbook.

Get merge templates

Get the merge templates available to the connected Zoho Sheet user.

Get pivot data

Retrieve one aggregate value from a Zoho Sheet pivot table.

Get used area

Get the used row and column bounds of a Zoho Sheet worksheet.

Image fit options

Change the fit option of cell images in a worksheet range.

Insert cells

Insert a range of cells and shift existing cells right or down.

Insert chart

Creates a new chart in the specified sheet using the provided data sources and chart type.

Insert checkbox

Insert checkboxes into a range in a Zoho Sheet worksheet.

Insert column

Insert a new column into a worksheet with default cell formats.

Insert columns to records

Insert one or more columns with headers into worksheet records.

Insert columns to table

Append one or more columns with headers to a Zoho Sheet table.

Insert images

Insert uploaded images or images already in the Zoho Sheet image library into a workbook.

Insert row

Insert a new row with optional JSON data into a worksheet.

Insert row with JSON data

Insert a new Zoho Sheet row at a specified index using JSON data.

List all named ranges

Get all named ranges and tables in a Zoho Sheet workbook.

List all picklists

List workbook picklists, their applied ranges, source ranges, and items.

List all pivot charts

List pivot charts in a Zoho Sheet workbook, optionally filtered by worksheet.

List all pivot tables

List pivot tables in a Zoho Sheet workbook, optionally filtered by target worksheet or range.

List All Tables

List all tables in a Zoho Sheet workbook, including their table IDs and ranges.

List all templates

List all Zoho Sheet templates belonging to the connected user.

List all versions

List all saved versions of a Zoho Sheet workbook.

List all workbooks

List the connected user's owned and shared Zoho Sheet workbooks.

List All Worksheets

List all worksheets in a Zoho Sheet workbook, including their worksheet IDs.

List chart

Returns all charts in the workbook grouped by worksheet name.

List conditional formats

List conditional formatting rules in a workbook, worksheet, or worksheet range.

Lock

Lock a Zoho Sheet worksheet or selected range for shared users or external share links.

Merge and email as attachment

Merge template data and email generated documents as attachments without saving them.

Merge and save

Merge template data and save the generated documents in Zoho WorkDrive.

Move chart

Moves the specified chart to another worksheet within the spreadsheet.

Move pivot table

Move a pivot table to another location in the same Zoho Sheet workbook.

Publish

Publish a Zoho Sheet workbook, worksheet, or worksheet range.

Publish Chart

Publishes one or more charts and generates unique publish keys for each chart.

Read data validation in cell

Read the data validation rule applied to a Zoho Sheet cell.

Recalculate

Recalculate formula cells after adding or updating Zoho Sheet records.

Refresh pivot table

Refresh selected pivot tables or pivot tables in a target worksheet range.

Remove picklist from range

Remove picklists from specified ranges in a Zoho Sheet workbook.

Remove publish

Remove a published Zoho Sheet workbook, worksheet, or range.

Remove table

Remove a table from a Zoho Sheet workbook, optionally clearing its table formatting.

Rename headers of table

Rename header values in a table in a Zoho Sheet workbook.

Rename worksheet

Rename an existing worksheet in a Zoho Sheet workbook.

Restore workbook

Restore up to 10 Zoho Sheet workbooks from the trash.

Revert version

Revert a Zoho Sheet workbook to an older version.

Row height

Set or automatically fit the height of multiple discontinuous worksheet rows.

Set conditional format to range

Apply classic, color-scale, data-bar, or icon-set conditional formatting to worksheet ranges.

Set content to cell

Set content in a particular cell of a Zoho Sheet worksheet.

Set content to multiple cells

Set content in multiple discrete cells in a Zoho Sheet workbook.

Set content to range

Insert CSV data into a Zoho Sheet worksheet at a specified cell.

Set content to row

Update discrete columns in a particular Zoho Sheet row.

Set data validation to range

Apply a data validation rule to one or more ranges in a worksheet.

Set note to cell

Create or replace a note on a worksheet cell.

Set zoom level

Set the zoom level of a worksheet in a Zoho Sheet workbook.

Share workbook

Share a Zoho Sheet workbook with one or more users.

Sort pivot table

Sort fields in a Zoho Sheet pivot table by labels or data values.

Trash workbook

Move up to 10 Zoho Sheet workbooks to trash.

Unlock

Unlock a Zoho Sheet worksheet or selected range for shared users or external share links.

Unpublish Chart

Revokes public access to previously published charts.

Update chart

Updates the metadata of a chart in a single call.

Update named range

Update the source range of an existing Zoho Sheet named range.

Update pivot chart

Update a Zoho Sheet pivot chart with structured chart and sheet metadata.

Update records

Update up to ten high-throughput worksheet records.

Update records in table

Update records in a Zoho Sheet table that match specified criteria.

Update records in worksheet

Update Zoho Sheet worksheet records selected by criteria.

Update rows with JSON data

Update multiple discontinuous Zoho Sheet rows by row index using JSON data.

Upload workbook

Upload a workbook file or import one from a public URL into Zoho Sheet.

SETUP GUIDE

Connect Zoho Sheet MCP Tool with your Agent

1

Install Composio

typescript
npm install @composio/core ai @ai-sdk/mcp @ai-sdk/openai
Install the Composio SDK and your agent framework
2

Create a session with MCP enabled

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

const composio = new Composio();
const { mcp } = await composio.create("your-user-id", {
  toolkits: ["zoho_sheet"],
  mcp: true,
});
Create a session scoped to Zoho Sheet and read its MCP URL and headers
3

Connect your agent to the MCP server

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();
Pass the session's MCP URL and headers to your agent and run a Zoho Sheet request
SETUP GUIDE

Connect Zoho Sheet API Tool with your Agent

1

Install Composio

typescript
npm install @composio/core @composio/openai openai
Install the Composio SDK, the OpenAI provider, and the OpenAI SDK
2

Create a Composio session

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();
Initialize Composio with the OpenAI Responses provider and create a session scoped to Zoho Sheet
3

Run Zoho Sheet tools with your agent

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);
Send a request, execute the Zoho Sheet tool calls through the session, and print the final answer

Why Use Composio?

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

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

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

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
FRAMEWORKS

Use Zoho Sheet with any AI Agent Framework

Choose a Framework you want to connect Zoho Sheet with

Rolling this out across your team?

Give your team centralized access control across every framework with Composio’s MCP Gateway.

EXPLORE MCP GATEWAY
FAQ

Frequently asked questions

Start with Zoho Sheet.It takes 30 seconds.

Managed auth, hosted MCP servers, and every Zoho Sheet tool your agent needs.Free to start.

Start building