Add records
Append one JSON row to a worksheet. Requires a paid WorkDrive account or Zoho One.
Zoho Sheet is a collaborative spreadsheet platform for creating, reading, formatting, analyzing, sharing, and automating workbook data.
Append one JSON row to a worksheet. Requires a paid WorkDrive account or Zoho One.
Add JSON-formatted records to a Zoho Sheet table, appending them by default or inserting them at the top.
Append JSON-formatted records to a Zoho Sheet worksheet.
Append CSV data as rows in a Zoho Sheet worksheet.
Append object-shaped JSON rows to a Zoho Sheet worksheet.
Apply a picklist to one or more ranges in a Zoho Sheet workbook.
Create sparklines in destination ranges from corresponding source ranges.
Clear conditional formatting from a specified worksheet range.
Clear cell contents while retaining other range properties.
Clear data validation rules from specified worksheet ranges.
Clear filters from a Zoho Sheet worksheet.
Clear notes from a worksheet range, or from the whole worksheet when no range is provided.
Clear the style, format, and content of a worksheet range.
Creates a duplicate of the specified chart.
Set or automatically fit the width of multiple discontinuous worksheet columns.
Convert start and end row and column indices to an A1-style range.
Convert an A1-style range to start and end row and column indices.
Copy a pivot table to another location in the same Zoho Sheet workbook.
Make a new copy of an existing Zoho Sheet workbook.
Copy a worksheet from one Zoho Sheet workbook into another workbook.
Copy or duplicate a worksheet within the same Zoho Sheet workbook.
Copy a Zoho Sheet worksheet into a newly created workbook.
Create an absolute named range in a Zoho Sheet workbook.
Create a supported chart from a Zoho Sheet pivot table with structured chart and sheet metadata.
Create a pivot table from a named range or worksheet range in Zoho Sheet.
Create a table over a selected range in a Zoho Sheet worksheet.
Create a named version of a Zoho Sheet workbook.
Create a new Zoho Sheet workbook.
Create a new Zoho Sheet workbook from an existing template.
Add a new worksheet to an existing Zoho Sheet workbook.
Delete a range of cells and shift remaining cells left or up.
Deletes the specified charts from the sheet.
Delete a single column from a worksheet.
Delete multiple columns from a Zoho Sheet table.
Delete multiple worksheets from a Zoho Sheet workbook. The workbook must retain at least one worksheet.
Delete an existing named range from a Zoho Sheet workbook.
Delete selected pivot charts or all pivot charts on a worksheet in Zoho Sheet.
Delete selected pivot tables or pivot tables in a target worksheet range.
Delete records from a Zoho Sheet table based on criteria.
Delete or erase Zoho Sheet worksheet records selected by criteria.
Delete a single row from a worksheet.
Delete multiple discontinuous rows from a worksheet.
Delete sparklines from specified ranges of a Zoho Sheet worksheet.
Permanently delete up to 10 Zoho Sheet workbooks from the trash.
Delete an existing worksheet from a Zoho Sheet workbook that contains more than one worksheet.
Download an existing Zoho Sheet workbook as XLSX, XLSB, XLTX, CSV, TSV, ODS, or PDF.
Edit the source, fields, grouping, settings, style, or name of a Zoho Sheet pivot table.
Retrieves chart image data from the spreadsheet.
Fetch and filter high-throughput worksheet records. Requires a paid WorkDrive account or Zoho One.
Fetch records from a Zoho Sheet table, optionally filtering up to five criteria and selecting specific columns.
Fetch and optionally filter records from a Zoho Sheet worksheet.
Fill cells in a direction based on an existing Zoho Sheet source range.
Apply or clear member, label, and value filters on a Zoho Sheet pivot table.
Search for a string in a Zoho Sheet workbook, worksheet, row, or column.
Find and replace text in a Zoho Sheet workbook, worksheet, row, or column.
Add or edit text and cell-level formatting on one or more worksheet ranges.
Freeze or unfreeze rows, columns, or panes in a Zoho Sheet worksheet.
Get the content and note of a particular Zoho Sheet cell.
Get the contents of a named range in a Zoho Sheet workbook.
Get the contents of a range in a Zoho Sheet worksheet.
Get the complete or bounded contents of a Zoho Sheet worksheet.
List all merge fields in a Zoho Sheet workbook.
Get status and generated-file details for a Zoho Sheet merge job.
List merge jobs for a Zoho Sheet merge-template workbook.
Get the merge templates available to the connected Zoho Sheet user.
Retrieve one aggregate value from a Zoho Sheet pivot table.
Get the used row and column bounds of a Zoho Sheet worksheet.
Change the fit option of cell images in a worksheet range.
Insert a range of cells and shift existing cells right or down.
Creates a new chart in the specified sheet using the provided data sources and chart type.
Insert checkboxes into a range in a Zoho Sheet worksheet.
Insert a new column into a worksheet with default cell formats.
Insert one or more columns with headers into worksheet records.
Append one or more columns with headers to a Zoho Sheet table.
Insert uploaded images or images already in the Zoho Sheet image library into a workbook.
Insert a new row with optional JSON data into a worksheet.
Insert a new Zoho Sheet row at a specified index using JSON data.
Get all named ranges and tables in a Zoho Sheet workbook.
List workbook picklists, their applied ranges, source ranges, and items.
List pivot charts in a Zoho Sheet workbook, optionally filtered by worksheet.
List pivot tables in a Zoho Sheet workbook, optionally filtered by target worksheet or range.
List all tables in a Zoho Sheet workbook, including their table IDs and ranges.
List all Zoho Sheet templates belonging to the connected user.
List all saved versions of a Zoho Sheet workbook.
List the connected user's owned and shared Zoho Sheet workbooks.
List all worksheets in a Zoho Sheet workbook, including their worksheet IDs.
Returns all charts in the workbook grouped by worksheet name.
List conditional formatting rules in a workbook, worksheet, or worksheet range.
Lock a Zoho Sheet worksheet or selected range for shared users or external share links.
Merge template data and email generated documents as attachments without saving them.
Merge template data and save the generated documents in Zoho WorkDrive.
Moves the specified chart to another worksheet within the spreadsheet.
Move a pivot table to another location in the same Zoho Sheet workbook.
Publish a Zoho Sheet workbook, worksheet, or worksheet range.
Publishes one or more charts and generates unique publish keys for each chart.
Read the data validation rule applied to a Zoho Sheet cell.
Recalculate formula cells after adding or updating Zoho Sheet records.
Refresh selected pivot tables or pivot tables in a target worksheet range.
Remove picklists from specified ranges in a Zoho Sheet workbook.
Remove a published Zoho Sheet workbook, worksheet, or range.
Remove a table from a Zoho Sheet workbook, optionally clearing its table formatting.
Rename header values in a table in a Zoho Sheet workbook.
Rename an existing worksheet in a Zoho Sheet workbook.
Restore up to 10 Zoho Sheet workbooks from the trash.
Revert a Zoho Sheet workbook to an older version.
Set or automatically fit the height of multiple discontinuous worksheet rows.
Apply classic, color-scale, data-bar, or icon-set conditional formatting to worksheet ranges.
Set content in a particular cell of a Zoho Sheet worksheet.
Set content in multiple discrete cells in a Zoho Sheet workbook.
Insert CSV data into a Zoho Sheet worksheet at a specified cell.
Update discrete columns in a particular Zoho Sheet row.
Apply a data validation rule to one or more ranges in a worksheet.
Create or replace a note on a worksheet cell.
Set the zoom level of a worksheet in a Zoho Sheet workbook.
Share a Zoho Sheet workbook with one or more users.
Sort fields in a Zoho Sheet pivot table by labels or data values.
Move up to 10 Zoho Sheet workbooks to trash.
Unlock a Zoho Sheet worksheet or selected range for shared users or external share links.
Revokes public access to previously published charts.
Updates the metadata of a chart in a single call.
Update the source range of an existing Zoho Sheet named range.
Update a Zoho Sheet pivot chart with structured chart and sheet metadata.
Update up to ten high-throughput worksheet records. Requires a paid WorkDrive account or Zoho One.
Update records in a Zoho Sheet table that match specified criteria.
Update Zoho Sheet worksheet records selected by criteria.
Update multiple discontinuous Zoho Sheet rows by row index using JSON data.
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.
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.
Sign in to your Dench workspace and open Integrations.
Find Zoho Sheet and click Connect — you'll authorize access through Zoho Sheet's own sign-in flow. No API keys or code required.
Ask an agent to use Zoho Sheet in chat, or call it from an automation.
Manage or disconnect the connection any time from workspace settings.
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.
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.
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.
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.