How to connect Zoho Sheet to Claude

Connect Claude Web, Desktop and Cowork to Zoho Sheet MCP. Read sales data from zoho sheet, update inventory totals in zoho sheet, and more using natural language, with authentication handled for you.

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

Introduction

Claude is Anthropic's AI assistant, available on the web, in the desktop app, and on mobile. Cowork is its agent for knowledge work, and it runs on all of those surfaces too. Connected to your apps, Claude can work with your files and services to accomplish complex tasks on your behalf.

This guide walks you through the easiest and most secure way to connect your Zoho Sheet account to Claude via Composio Connect, enabling it to read sales data from Zoho Sheet, update inventory totals in Zoho Sheet, create monthly budget workbook in Zoho Sheet, and more such actions on your behalf without compromising your account security.

Setup is the same on Claude Web, Desktop, and Cowork, and you only need to do it once. The connector is tied to your account, so it's available in all three.

For exact tool slugs and parameter tables, see the tool catalog in the Composio docs.

Also integrate Zoho Sheet with

Connecting Zoho Sheet to Claude Web, Desktop, and Cowork

Two ways to add the Composio connector. Pick whichever you prefer.

1. Add with one click

Click the button. Claude opens with the Composio connector filled in. Click Add, then go to step 2.

Add to Claude

Add manually

In Claude Desktop, click Customize in the left sidebar, then select Connectors and click the + icon at the top.

Claude Desktop connectors screen with Add custom connector selected

Click Add custom connector and paste in the Composio MCP server URL:

bash
https://connect.composio.dev/mcp
Add custom connector dialog with Composio MCP server URL

2. Authorize in your browser

Click Connect. You'll be redirected to a browser window where you can authorize Composio to continue.

Composio authorization screen for Claude Web, Desktop, and Cowork

3. Connect your Zoho Sheet account

Back in Claude, ask it to connect to Zoho Sheet or give it any Zoho Sheet-related task.

For example, ask Claude to:

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

It will prompt you to authenticate and authorize access.

That's it. Composio's tools are now available in Claude, and your Zoho Sheet account is ready to use.

What is the Zoho Sheet Claude Connector, and what's possible with it?

The Zoho Sheet MCP server is an implementation of the Model Context Protocol that connects your AI agent and assistants like Claude, Cursor, etc directly to your Zoho Sheet account. It provides structured and secure access to your workbooks, worksheets, tables, ranges, charts, and pivot tables, so your agent can create, update, organize, format, and clean up spreadsheet data on your behalf.

  • Workbook and worksheet management: Have your agent create workbooks and worksheets, copy entire workbooks, duplicate worksheets, move worksheets between workbooks, or create workbooks from templates.
  • Record and table updates: Let the agent append JSON or CSV rows, add records to worksheets and tables, create tables over selected ranges, or delete records using defined criteria.
  • Spreadsheet formatting and validation: Direct your agent to set or automatically fit column widths, apply picklists to ranges, add sparklines, and clear contents, formatting, notes, filters, or data validation when needed.
  • Charts, pivots, and named ranges: Instruct your agent to create, copy, and delete pivot tables and charts, create named ranges, or remove named ranges that are no longer needed.
  • Sheet cleanup and versioning: Have your agent delete columns, cells, or worksheets, clear selected ranges, and create named workbook versions for important spreadsheet milestones.

Troubleshooting

1. Why does Claude not use the Composio connector for Zoho Sheet?

The connector can show as connected, but Claude must use it in each Zoho Sheet conversation.

  • Click + at the lower left of the chat, or type /.
  • Hover Connectors.
  • Turn on Composio.
  • Ask Claude to connect to Zoho Sheet again.

2. Why does Claude show an MCP server error before Zoho Sheet connects?

Claude can show Couldn't reach the MCP server or Authorization with the MCP server failed when you add the connector for Zoho Sheet.

  • Check that the connector URL is https://connect.composio.dev/mcp.
  • Connectors run from Anthropic's cloud, so your device network is usually not the problem.
  • Add the connector again from Customize > Connectors, then ask Claude to connect Zoho Sheet.
  • If it fails again, send the error and the ofid_ reference id to support@composio.dev.

3. Why does the Zoho Sheet authorization link not work?

The Composio connector is one server. Your Zoho Sheet account connects separately when Claude asks for it.

  • If the browser does not open, or the link expires, ask Claude to retry the Zoho Sheet connection.
  • Composio creates a fresh Zoho Sheet authorization link.
  • Open that link in your browser and finish the Zoho Sheet sign-in.

4. Why do Zoho Sheet actions fail after they worked before?

The Zoho Sheet connection can expire or lose permission.

  • Ask Claude to inspect the Zoho Sheet connection.
  • If the connection is unhealthy, disconnect it when Claude prompts you.
  • Reconnect the Zoho Sheet account and retry the action.
  • If Claude shows a permission prompt, approve it before Claude changes data in Zoho Sheet.
  • If the action still fails with a permission error, check that the connected account has that permission in Zoho Sheet itself.

5. How do I switch to a different Zoho Sheet account?

Claude can manage the Zoho Sheet connection for you.

  • Ask Claude to disconnect or delete the current Zoho Sheet account.
  • Ask Claude to connect Zoho Sheet again.
  • Open the new Composio authorization link for Zoho Sheet.
  • Sign in with the other Zoho Sheet account in the browser.
  • After the account connects, ask Claude to retry the Zoho Sheet task.

6. Why is my Zoho Sheet connection missing in Claude Desktop or on a Team plan?

The connector belongs to your Claude account, so your Zoho Sheet connection works in Claude Web, Desktop, and Cowork.

  • In Claude Desktop, open Customize > Connectors.
  • Next to Composio, click ⋮ and click Clear cache.
  • If Zoho Sheet tools still do not appear, click ⋮, disconnect, remove the connector, and add it again.
  • On Team or Enterprise, an Owner or Primary Owner must enable the connector before you can connect Zoho Sheet.
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.

FRAMEWORKS

How to build Zoho Sheet MCP Agent with another framework

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