Zoho Sheet logo

Integrate Zoho Sheet with your AI CRM

Zoho Sheet is a collaborative spreadsheet platform for creating, reading, formatting, analyzing, sharing, and automating workbook data.

Explore Triggers and Actions

Add records

Append one JSON row to a worksheet. Requires a paid WorkDrive account or Zoho One.

ActionTry it

Add records to table

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

ActionTry it

Add records to worksheet

Append JSON-formatted records to a Zoho Sheet worksheet.

ActionTry it

Append rows with CSV data

Append CSV data as rows in a Zoho Sheet worksheet.

ActionTry it

Append rows with JSON data

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

ActionTry it

Apply picklist to range

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

ActionTry it

Apply sparkline to a range

Create sparklines in destination ranges from corresponding source ranges.

ActionTry it

Clear conditional format from range

Clear conditional formatting from a specified worksheet range.

ActionTry it

Clear contents of range

Clear cell contents while retaining other range properties.

ActionTry it

Clear data validation from range

Clear data validation rules from specified worksheet ranges.

ActionTry it

Clear filters

Clear filters from a Zoho Sheet worksheet.

ActionTry it

Clear notes from range

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

ActionTry it

Clear range

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

ActionTry it

Clone chart

Creates a duplicate of the specified chart.

ActionTry it

Column width

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

ActionTry it

Convert Index to Range

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

ActionTry it

Convert Range to Index

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

ActionTry it

Copy pivot table

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

ActionTry it

Copy workbook

Make a new copy of an existing Zoho Sheet workbook.

ActionTry it

Copy worksheet - other workbook

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

ActionTry it

Copy worksheet - same workbook

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

ActionTry it

Copy worksheet to new workbook

Copy a Zoho Sheet worksheet into a newly created workbook.

ActionTry it

Create named range

Create an absolute named range in a Zoho Sheet workbook.

ActionTry it

Create pivot chart

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

ActionTry it

Create pivot table

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

ActionTry it

Create table

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

ActionTry it

Create version

Create a named version of a Zoho Sheet workbook.

ActionTry it

Create workbook

Create a new Zoho Sheet workbook.

ActionTry it

Create workbook from template

Create a new Zoho Sheet workbook from an existing template.

ActionTry it

Create worksheet

Add a new worksheet to an existing Zoho Sheet workbook.

ActionTry it

Delete cells

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

ActionTry it

Delete chart

Deletes the specified charts from the sheet.

ActionTry it

Delete column

Delete a single column from a worksheet.

ActionTry it

Delete columns from table

Delete multiple columns from a Zoho Sheet table.

ActionTry it

Delete multiple worksheets

Delete multiple worksheets from a Zoho Sheet workbook. The workbook must retain at least one worksheet.

ActionTry it

Delete named range

Delete an existing named range from a Zoho Sheet workbook.

ActionTry it

Delete pivot chart

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

ActionTry it

Delete pivot table

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

ActionTry it

Delete records from table

Delete records from a Zoho Sheet table based on criteria.

ActionTry it

Delete records from worksheet

Delete or erase Zoho Sheet worksheet records selected by criteria.

ActionTry it

Delete row

Delete a single row from a worksheet.

ActionTry it

Delete rows

Delete multiple discontinuous rows from a worksheet.

ActionTry it

Delete sparkline from a range

Delete sparklines from specified ranges of a Zoho Sheet worksheet.

ActionTry it

Delete workbook

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

ActionTry it

Delete worksheet

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

ActionTry it

Download workbook

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

ActionTry it

Edit pivot table

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

ActionTry it

Export chart

Retrieves chart image data from the spreadsheet.

ActionTry it

Fetch records

Fetch and filter high-throughput worksheet records. Requires a paid WorkDrive account or Zoho One.

ActionTry it

Fetch records from table

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

ActionTry it

Fetch records from worksheet

Fetch and optionally filter records from a Zoho Sheet worksheet.

ActionTry it

Fill series

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

ActionTry it

Filter pivot table

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

ActionTry it

Find

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

ActionTry it

Find and replace

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

ActionTry it

Format ranges

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

ActionTry it

Freeze panes

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

ActionTry it

Get content of cell

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

ActionTry it

Get content of named range

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

ActionTry it

Get content of range

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

ActionTry it

Get content of worksheet

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

ActionTry it

Get merge fields

List all merge fields in a Zoho Sheet workbook.

ActionTry it

Get merge job details

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

ActionTry it

Get merge jobs

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

ActionTry it

Get merge templates

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

ActionTry it

Get pivot data

Retrieve one aggregate value from a Zoho Sheet pivot table.

ActionTry it

Get used area

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

ActionTry it

Image fit options

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

ActionTry it

Insert cells

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

ActionTry it

Insert chart

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

ActionTry it

Insert checkbox

Insert checkboxes into a range in a Zoho Sheet worksheet.

ActionTry it

Insert column

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

ActionTry it

Insert columns to records

Insert one or more columns with headers into worksheet records.

ActionTry it

Insert columns to table

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

ActionTry it

Insert images

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

ActionTry it

Insert row

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

ActionTry it

Insert row with JSON data

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

ActionTry it

List all named ranges

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

ActionTry it

List all picklists

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

ActionTry it

List all pivot charts

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

ActionTry it

List all pivot tables

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

ActionTry it

List All Tables

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

ActionTry it

List all templates

List all Zoho Sheet templates belonging to the connected user.

ActionTry it

List all versions

List all saved versions of a Zoho Sheet workbook.

ActionTry it

List all workbooks

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

ActionTry it

List All Worksheets

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

ActionTry it

List chart

Returns all charts in the workbook grouped by worksheet name.

ActionTry it

List conditional formats

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

ActionTry it

Lock

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

ActionTry it

Merge and email as attachment

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

ActionTry it

Merge and save

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

ActionTry it

Move chart

Moves the specified chart to another worksheet within the spreadsheet.

ActionTry it

Move pivot table

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

ActionTry it

Publish

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

ActionTry it

Publish Chart

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

ActionTry it

Read data validation in cell

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

ActionTry it

Recalculate

Recalculate formula cells after adding or updating Zoho Sheet records.

ActionTry it

Refresh pivot table

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

ActionTry it

Remove picklist from range

Remove picklists from specified ranges in a Zoho Sheet workbook.

ActionTry it

Remove publish

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

ActionTry it

Remove table

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

ActionTry it

Rename headers of table

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

ActionTry it

Rename worksheet

Rename an existing worksheet in a Zoho Sheet workbook.

ActionTry it

Restore workbook

Restore up to 10 Zoho Sheet workbooks from the trash.

ActionTry it

Revert version

Revert a Zoho Sheet workbook to an older version.

ActionTry it

Row height

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

ActionTry it

Set conditional format to range

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

ActionTry it

Set content to cell

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

ActionTry it

Set content to multiple cells

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

ActionTry it

Set content to range

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

ActionTry it

Set content to row

Update discrete columns in a particular Zoho Sheet row.

ActionTry it

Set data validation to range

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

ActionTry it

Set note to cell

Create or replace a note on a worksheet cell.

ActionTry it

Set zoom level

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

ActionTry it

Share workbook

Share a Zoho Sheet workbook with one or more users.

ActionTry it

Sort pivot table

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

ActionTry it

Trash workbook

Move up to 10 Zoho Sheet workbooks to trash.

ActionTry it

Unlock

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

ActionTry it

Unpublish Chart

Revokes public access to previously published charts.

ActionTry it

Update chart

Updates the metadata of a chart in a single call.

ActionTry it

Update named range

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

ActionTry it

Update pivot chart

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

ActionTry it

Update records

Update up to ten high-throughput worksheet records. Requires a paid WorkDrive account or Zoho One.

ActionTry it

Update records in table

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

ActionTry it

Update records in worksheet

Update Zoho Sheet worksheet records selected by criteria.

ActionTry it

Update rows with JSON data

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

ActionTry it

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.

ActionTry it

How the Zoho Sheet integration works

The Zoho Sheet integration connects your Dench AI CRM directly to Zoho Sheet, so agents can read and act on your Zoho Sheet data as part of everyday work — answering questions in chat, keeping your CRM in sync, and running automations without anyone copying data between tools.

127 actions are available for agents to invoke on your behalf. Every call runs through Zoho Sheet's own authorization, scoped to the account you connect.

Set up Zoho Sheet in Dench

  1. 1

    Sign in to your Dench workspace and open Integrations.

  2. 2

    Find Zoho Sheet and click Connect — you'll authorize access through Zoho Sheet's own sign-in flow. No API keys or code required.

  3. 3

    Ask an agent to use Zoho Sheet in chat, or call it from an automation.

  4. 4

    Manage or disconnect the connection any time from workspace settings.

Frequently asked questions

How does the Zoho Sheet integration work with Dench?

The Dench Zoho Sheet integration connects your AI CRM to Zoho Sheet, so AI agents can work with your Zoho Sheet data as part of chats, automations, and CRM workflows. You connect your account once, and every agent in your workspace can use it — governed by your workspace permissions.

What actions can AI agents perform with Zoho Sheet via Dench?

The Zoho Sheet integration currently exposes 127 actions, including Add records, Add records to table, Add records to worksheet, Append rows with CSV data, Append rows with JSON data, and Apply picklist to range. Agents invoke them on your behalf from chat or from automations.

Do I need to write code to connect Zoho Sheet to Dench?

No. You connect Zoho Sheet from your Dench workspace using Zoho Sheet's own sign-in and authorization flow — no API keys to copy, no glue code to maintain.

Is the Zoho Sheet integration secure?

Connections are authorized through Zoho Sheet's own authentication flow, and Dench stores only the authorization needed to act on your behalf. You can review and disconnect the Zoho Sheet connection from your workspace settings at any time.

Zoho Sheet | Dench AI CRM