How to connect Zoho Sheet with ChatGPT

Connect ChatGPT 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

How to connect Zoho Sheet MCP with ChatGPT

ChatGPT can take action across your apps and files, stay with a project for hours, and turn a goal into finished materials like sheets, slides, and docs, not just answers.

In this guide, I will explain the easiest and most secure way to connect your Zoho Sheet account to ChatGPT via Composio Connect, so it can read workbooks, update cell ranges, analyze spreadsheet data, format sheets, and manage sharing through natural language commands without ever putting your account credentials at risk.

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

Also integrate Zoho Sheet with

Why use Composio over default connectors?

  • Apps with read and write access. Default connectors mostly can read your data. Composio's Zoho Sheet integration lets ChatGPT take actions like creating drafts, sending updates, labeling records, and more.
  • 1,700+ SaaS toolkits out of the box. Composio gives you instant access to a vast catalog of pre-built connectors, from Gmail and Slack to Notion, Linear, and Salesforce.
  • One MCP server for every app. Connect any of your applications on demand through a single endpoint, rather than juggling a separate server for each app.
  • Smart, context-aware tool loading. Unlike traditional MCP servers that dump every available tool into the LLM context window, Composio searches for and loads only the tools relevant to the task at hand.
  • Cross-app automation. Chain actions across multiple apps in a single run - fetch a thread, summarize it in Notion, and post highlights to Slack without leaving the conversation.

Prerequisites

Note: Composio connects through OAuth. You will be asked to sign in and approve specific permissions. Review the permission screen carefully if you are using a work account.

Step-by-step: Connect Zoho Sheet to ChatGPT

1. Install the Composio plugin

Click the button. ChatGPT opens the Composio plugin page. Click Install plugin.

Install in ChatGPT

Composio plugin page in ChatGPT with the Install plugin button

You can also find it inside ChatGPT: go to Settings, open Plugins, search the marketplace for Composio, and click Install plugin.

2. Authenticate

After you install, ChatGPT asks you to authenticate with Composio. Log in and click Allow access to authorize ChatGPT to use your Composio account.

Composio login and Allow access screen for ChatGPT

3. Start using Composio

That is it. Composio tools are now available in ChatGPT. Type @Composio followed by your request, for example @Composio find unread Zoho Sheet messages and summarize them, and it will run the actions you authorize. On first use it asks you to authorize Zoho Sheet.

Option 2: Add Composio as an MCP server

If you cannot use the plugin marketplace, add Composio as a custom MCP server instead.

1. Open the MCP settings

In ChatGPT, go to Settings and open the Plugins section. Inside the Plugins page, click the MCP tab.

ChatGPT settings showing the Plugins page with the MCP tab selected

2. Add the server

Click Add server. In the Name field enter Composio, for Type select Streamable HTTP, and in the URL field paste the Composio MCP server URL:

bash
https://connect.composio.dev/mcp
ChatGPT Add server dialog with the name Composio, type Streamable HTTP, and the Composio MCP URL

Then click Save. The Composio server now appears in your MCP plugins list.

ChatGPT Plugins page showing the Composio MCP server added to the list

3. Authenticate

Click Authenticate on the Composio entry, log in via Composio, and click Allow access. Composio tools are then available in ChatGPT the same way as with the plugin.

What you can do after connecting Zoho Sheet

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

Security + privacy notes (important)

  • Use least-privilege access: Only grant permissions you actually need.
  • Review OAuth permissions before approving: Make sure requested scopes match what you expect Composio and ChatGPT to do.
  • Keep write actions human-reviewed: For actions like sending messages, creating labels, or editing drafts, keep manual confirmation enabled.
  • Be careful with sensitive data: Avoid using this setup with highly sensitive information unless allowed by your personal, company, or client policies.
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