# Zoho Sheet MCP MCP > Zoho Sheet connects your AI agent directly to your Zoho cloud data arrays. It lets you manage entire workbooks, read specific cell ranges, append new rows of structured data, and audit who has access—all without opening the browser or touching a spreadsheet manually. ## Overview - **Category:** productivity - **Price:** Free - **Tags:** spreadsheets, data-analysis, cloud-collaboration, cell-automation, workbook-management, data-rows ## Description This MCP gives your AI client programmatic control over complex sheet structures. You can treat spreadsheets like databases through natural language commands. Need to update pricing across 50 worksheets? Your agent handles that using `update_cells`. Trying to find out which department owns the master list? It can run a search for workbooks and then use `list_shared_users` to audit permissions instantly. The system also lets you build entire data structures from scratch, handling everything from creating an empty workbook via `create_workbook` to appending large batches of new records with `add_row`. For complex operations that touch multiple sheets or require tracking every change, Vinkius AI Analytics provides a full audit trail, showing exactly what data flowed and which tools were called. It's built for people who need data accuracy and verifiable steps behind every action. ## Tools ### add_row Appends a complete, structured row of data to an existing worksheet. ### create_workbook Initializes and creates a new, blank workbook container in Zoho Sheets. ### create_worksheet Adds a new tab or worksheet to an existing workbook. ### delete_worksheet Removes an entire sheet (tab) from a workbook, deleting the data inside. ### get_cells Reads and returns the current content of specific cell ranges within a worksheet. ### get_workbook Retrieves high-level metadata about an entire workbook container. ### get_worksheet Gets detailed structural information and properties for a specific worksheet tab. ### list_rows Retrieves a full list of existing data rows from a targeted worksheet. ### list_shared_users Provides a list of all users who currently have access to the workbook, along with their roles. ### list_workbooks Returns an index of all workbooks accessible by the connected account. ### list_worksheets Lists all available worksheets (tabs) within a specified workbook. ### search_workbooks Searches across your workbooks using keywords or filters to find specific data sets. ### update_cells Changes the content of specified cells, overwriting existing data or formulas. ## Prompt Examples **Prompt:** ``` Find the 'Q3 Financials' workbook and read the data in cells A1 to D20 from the first worksheet. ``` **Response:** ``` I found the 'Q3 Financials' workbook. The data in range A1:D20 shows your quarterly revenue at $1.2M and expenses at $850K. Would you like me to analyze these figures further? ``` **Prompt:** ``` Create a new workbook called 'Event Attendees' and add a new row with name 'Sarah Connor' and email 'sarah.c@example.com'. ``` **Response:** ``` I have successfully created the 'Event Attendees' workbook. The first worksheet has been set up, and I've added the new data row for 'Sarah Connor' (sarah.c@example.com). You can now access it in your Zoho console. ``` **Prompt:** ``` List all my workbooks and tell me who has shared access to the 'Master Inventory' spreadsheet. ``` **Response:** ``` You have 5 active workbooks. For the 'Master Inventory' spreadsheet, the shared users are Alex (Editor) and Taylor (Viewer). Would you like to update any permissions? ``` ## Capabilities ### Read specific cell ranges Get the contents of defined cells or entire groups of cells within a worksheet. ### Structure workbooks dynamically Create, search for, and delete entire data containers (workbooks) or individual tabs (worksheets). ### Audit sheet sharing permissions List all users who have access to a workbook and check their specific roles. ### Input and update structured data Append new full rows of data or overwrite existing values in specific cell locations. ### Manage dataset lists List all available workbooks, worksheets, or records within a defined scope. ## Use Cases ### Consolidating quarterly sales reports The user needs to combine regional data into one master sheet. They ask the agent to search for all 'Q3 Sales' workbooks using `search_workbooks`, pull the key revenue figures from each, and then use `update_cells` on a central summary sheet. ### Onboarding new team members A manager needs to set up standardized tracking sheets. They ask the agent to create a brand-new workbook using `create_workbook`, add multiple tabs with `create_worksheet`, and then ensure the sheet is accessible by calling `list_shared_users`. ### Cleaning dirty raw data dumps Raw data comes in messy. The user asks the agent to read the specific ranges using `get_cells`, process them (e.g., format dates), and then write the clean result back into a new location on the sheet, or append it using `add_row`. ### Archiving old projects A project is finished and needs to be moved. The agent can retrieve all necessary metadata with `get_workbook`, list its contents with `list_worksheets`, and then delete the entire sheet using `delete_worksheet` after confirming it's backed up. ## Benefits - Stop manually copying data. Instead of updating cell ranges one by one, the agent can read specific cell ranges using `get_cells` and then write corrected values to a different location using `update_cells` in a single sequence. - Never lose track of your data structure again. The MCP lets you list all available workbooks via `list_workbooks` or search for them by name with `search_workbooks`, making the starting point clear. - Audit permissions instantly. You can call `list_shared_users` to see who has access and check if a specific user needs their viewing rights upgraded, which saves time compared to checking multiple share links. - Build complex data pipelines by chaining actions. For example, you can list the worksheets using `list_worksheets`, then use that information to create a new worksheet with `create_worksheet` for clean data separation. - Handle large datasets efficiently. Instead of manual row-by-row entry, your agent can append entire batches of records using `add_row` or pull bulk data via `list_rows`. ## How It Works The bottom line is, you define the data operation in plain English, and the platform handles all the complex API sequencing required to execute it inside Zoho Sheets. 1. Subscribe to this MCP and enter your Zoho API credentials in the Vinkius platform. 2. Tell your AI agent what data you need. For example: 'Create a workbook named Project Alpha, then add three sheets for Budget, Staff, and Timeline.' 3. Your agent executes the necessary sequence of calls (like `create_workbook` followed by `create_worksheet`) using its integrated connection to build or modify your cloud sheet. ## Frequently Asked Questions **How do I find out which sheets exist in my workbook using the Zoho Sheet MCP?** You use `list_worksheets`. This tool reads the metadata of the entire workbook and returns a clean list of all available tabs, letting you know exactly what's inside. **Can I update cells with the Zoho Sheet MCP if I don't know the exact range?** No. The `update_cells` tool requires precise coordinates (e.g., 'A1:D10'). You must first use `get_cells` to read and determine the correct ranges before you can write new data. **What is the difference between `list_rows` and `get_cells` with Zoho Sheet?** `list_rows` pulls all existing records in a structured format, giving you rows of data. `get_cells` lets you target specific, non-consecutive cells (like A1 and D5) for reading or writing. **How do I check who can view my workbooks with the Zoho Sheet MCP?** Run `list_shared_users`. This tool reports back on every user connected to the workbook and specifies their exact permission level—Editor, Viewer, etc. **If I use the `delete_worksheet` tool, what happens if that worksheet doesn't exist?** The MCP handles this gracefully. It won't fail; instead, it returns a structured error indicating the sheet wasn't found. This means your agent can write reliable code without having to check for existence first. **When using `list_rows`, how does the platform handle very large datasets?** The MCP processes data in paginated batches. Your agent won't hit a memory limit; it receives manageable chunks of data, allowing you to process millions of records sequentially. **What is the best way to find a workbook when I don't know its exact name?** Use the `search_workbooks` tool. It performs fuzzy matching across titles and owners, giving you results that are much better than just listing everything via `list_workbooks`. **After I connect my agent, does it have full write access using `add_row` by default?** No. Your AI client only uses the credentials you authorize for that session. The MCP enforces granular permissions; if your API key can't write data, the `add_row` call fails immediately. **Can I read and write cells?** Yes, read cell contents from any range (e.g. A1:D10) and write new values to specific cell ranges. **Can I manage sharing?** Yes, view all users with access to a workbook and their permission levels.