Add recordsAppend one JSON row to a worksheet.
Add records to tableAdd JSON-formatted records to a Zoho Sheet table, appending them by default or inserting them at the top.
Add records to worksheetAppend JSON-formatted records to a Zoho Sheet worksheet.
Append rows with CSV dataAppend CSV data as rows in a Zoho Sheet worksheet.
Append rows with JSON dataAppend object-shaped JSON rows to a Zoho Sheet worksheet.
Apply picklist to rangeApply a picklist to one or more ranges in a Zoho Sheet workbook.
Apply sparkline to a rangeCreate sparklines in destination ranges from corresponding source ranges.
Clear conditional format from rangeClear conditional formatting from a specified worksheet range.
Clear contents of rangeClear cell contents while retaining other range properties.
Clear data validation from rangeClear data validation rules from specified worksheet ranges.
Clear filtersClear filters from a Zoho Sheet worksheet.
Clear notes from rangeClear notes from a worksheet range, or from the whole worksheet when no range is provided.
Clear rangeClear the style, format, and content of a worksheet range.
Clone chartCreates a duplicate of the specified chart.
Column widthSet or automatically fit the width of multiple discontinuous worksheet columns.
Convert Index to RangeConvert start and end row and column indices to an A1-style range.
Convert Range to IndexConvert an A1-style range to start and end row and column indices.
Copy pivot tableCopy a pivot table to another location in the same Zoho Sheet workbook.
Copy workbookMake a new copy of an existing Zoho Sheet workbook.
Copy worksheet to new workbookCopy a Zoho Sheet worksheet into a newly created workbook.
Copy worksheet - other workbookCopy a worksheet from one Zoho Sheet workbook into another workbook.
Copy worksheet - same workbookCopy or duplicate a worksheet within the same Zoho Sheet workbook.
Create named rangeCreate an absolute named range in a Zoho Sheet workbook.
Create pivot chartCreate a supported chart from a Zoho Sheet pivot table with structured chart and sheet metadata.
Create pivot tableCreate a pivot table from a named range or worksheet range in Zoho Sheet.
Create tableCreate a table over a selected range in a Zoho Sheet worksheet.
Create versionCreate a named version of a Zoho Sheet workbook.
Create workbookCreate a new Zoho Sheet workbook.
Create workbook from templateCreate a new Zoho Sheet workbook from an existing template.
Create worksheetAdd a new worksheet to an existing Zoho Sheet workbook.
Delete cellsDelete a range of cells and shift remaining cells left or up.
Delete chartDeletes the specified charts from the sheet.
Delete columnDelete a single column from a worksheet.
Delete columns from tableDelete multiple columns from a Zoho Sheet table.
Delete multiple worksheetsDelete multiple worksheets from a Zoho Sheet workbook.
Delete named rangeDelete an existing named range from a Zoho Sheet workbook.
Delete pivot chartDelete selected pivot charts or all pivot charts on a worksheet in Zoho Sheet.
Delete pivot tableDelete selected pivot tables or pivot tables in a target worksheet range.
Delete records from tableDelete records from a Zoho Sheet table based on criteria.
Delete records from worksheetDelete or erase Zoho Sheet worksheet records selected by criteria.
Delete rowDelete a single row from a worksheet.
Delete rowsDelete multiple discontinuous rows from a worksheet.
Delete sparkline from a rangeDelete sparklines from specified ranges of a Zoho Sheet worksheet.
Delete workbookPermanently delete up to 10 Zoho Sheet workbooks from the trash.
Delete worksheetDelete an existing worksheet from a Zoho Sheet workbook that contains more than one worksheet.
Download workbookDownload an existing Zoho Sheet workbook as XLSX, XLSB, XLTX, CSV, TSV, ODS, or PDF.
Edit pivot tableEdit the source, fields, grouping, settings, style, or name of a Zoho Sheet pivot table.
Export chartRetrieves chart image data from the spreadsheet.
Fetch recordsFetch and filter high-throughput worksheet records.
Fetch records from tableFetch records from a Zoho Sheet table, optionally filtering up to five criteria and selecting specific columns.
Fetch records from worksheetFetch and optionally filter records from a Zoho Sheet worksheet.
Fill seriesFill cells in a direction based on an existing Zoho Sheet source range.
Filter pivot tableApply or clear member, label, and value filters on a Zoho Sheet pivot table.
FindSearch for a string in a Zoho Sheet workbook, worksheet, row, or column.
Find and replaceFind and replace text in a Zoho Sheet workbook, worksheet, row, or column.
Format rangesAdd or edit text and cell-level formatting on one or more worksheet ranges.
Freeze panesFreeze or unfreeze rows, columns, or panes in a Zoho Sheet worksheet.
Get content of cellGet the content and note of a particular Zoho Sheet cell.
Get content of named rangeGet the contents of a named range in a Zoho Sheet workbook.
Get content of rangeGet the contents of a range in a Zoho Sheet worksheet.
Get content of worksheetGet the complete or bounded contents of a Zoho Sheet worksheet.
Get merge fieldsList all merge fields in a Zoho Sheet workbook.
Get merge job detailsGet status and generated-file details for a Zoho Sheet merge job.
Get merge jobsList merge jobs for a Zoho Sheet merge-template workbook.
Get merge templatesGet the merge templates available to the connected Zoho Sheet user.
Get pivot dataRetrieve one aggregate value from a Zoho Sheet pivot table.
Get used areaGet the used row and column bounds of a Zoho Sheet worksheet.
Image fit optionsChange the fit option of cell images in a worksheet range.
Insert cellsInsert a range of cells and shift existing cells right or down.
Insert chartCreates a new chart in the specified sheet using the provided data sources and chart type.
Insert checkboxInsert checkboxes into a range in a Zoho Sheet worksheet.
Insert columnInsert a new column into a worksheet with default cell formats.
Insert columns to recordsInsert one or more columns with headers into worksheet records.
Insert columns to tableAppend one or more columns with headers to a Zoho Sheet table.
Insert imagesInsert uploaded images or images already in the Zoho Sheet image library into a workbook.
Insert rowInsert a new row with optional JSON data into a worksheet.
Insert row with JSON dataInsert a new Zoho Sheet row at a specified index using JSON data.
List all named rangesGet all named ranges and tables in a Zoho Sheet workbook.
List all picklistsList workbook picklists, their applied ranges, source ranges, and items.
List all pivot chartsList pivot charts in a Zoho Sheet workbook, optionally filtered by worksheet.
List all pivot tablesList pivot tables in a Zoho Sheet workbook, optionally filtered by target worksheet or range.
List All TablesList all tables in a Zoho Sheet workbook, including their table IDs and ranges.
List all templatesList all Zoho Sheet templates belonging to the connected user.
List all versionsList all saved versions of a Zoho Sheet workbook.
List all workbooksList the connected user's owned and shared Zoho Sheet workbooks.
List All WorksheetsList all worksheets in a Zoho Sheet workbook, including their worksheet IDs.
List chartReturns all charts in the workbook grouped by worksheet name.
List conditional formatsList conditional formatting rules in a workbook, worksheet, or worksheet range.
LockLock a Zoho Sheet worksheet or selected range for shared users or external share links.
Merge and email as attachmentMerge template data and email generated documents as attachments without saving them.
Merge and saveMerge template data and save the generated documents in Zoho WorkDrive.
Move chartMoves the specified chart to another worksheet within the spreadsheet.
Move pivot tableMove a pivot table to another location in the same Zoho Sheet workbook.
PublishPublish a Zoho Sheet workbook, worksheet, or worksheet range.
Publish ChartPublishes one or more charts and generates unique publish keys for each chart.
Read data validation in cellRead the data validation rule applied to a Zoho Sheet cell.
RecalculateRecalculate formula cells after adding or updating Zoho Sheet records.
Refresh pivot tableRefresh selected pivot tables or pivot tables in a target worksheet range.
Remove picklist from rangeRemove picklists from specified ranges in a Zoho Sheet workbook.
Remove publishRemove a published Zoho Sheet workbook, worksheet, or range.
Remove tableRemove a table from a Zoho Sheet workbook, optionally clearing its table formatting.
Rename headers of tableRename header values in a table in a Zoho Sheet workbook.
Rename worksheetRename an existing worksheet in a Zoho Sheet workbook.
Restore workbookRestore up to 10 Zoho Sheet workbooks from the trash.
Revert versionRevert a Zoho Sheet workbook to an older version.
Row heightSet or automatically fit the height of multiple discontinuous worksheet rows.
Set conditional format to rangeApply classic, color-scale, data-bar, or icon-set conditional formatting to worksheet ranges.
Set content to cellSet content in a particular cell of a Zoho Sheet worksheet.
Set content to multiple cellsSet content in multiple discrete cells in a Zoho Sheet workbook.
Set content to rangeInsert CSV data into a Zoho Sheet worksheet at a specified cell.
Set content to rowUpdate discrete columns in a particular Zoho Sheet row.
Set data validation to rangeApply a data validation rule to one or more ranges in a worksheet.
Set note to cellCreate or replace a note on a worksheet cell.
Set zoom levelSet the zoom level of a worksheet in a Zoho Sheet workbook.
Share workbookShare a Zoho Sheet workbook with one or more users.
Sort pivot tableSort fields in a Zoho Sheet pivot table by labels or data values.
Trash workbookMove up to 10 Zoho Sheet workbooks to trash.
UnlockUnlock a Zoho Sheet worksheet or selected range for shared users or external share links.
Unpublish ChartRevokes public access to previously published charts.
Update chartUpdates the metadata of a chart in a single call.
Update named rangeUpdate the source range of an existing Zoho Sheet named range.
Update pivot chartUpdate a Zoho Sheet pivot chart with structured chart and sheet metadata.
Update recordsUpdate up to ten high-throughput worksheet records.
Update records in tableUpdate records in a Zoho Sheet table that match specified criteria.
Update records in worksheetUpdate Zoho Sheet worksheet records selected by criteria.
Update rows with JSON dataUpdate multiple discontinuous Zoho Sheet rows by row index using JSON data.
Upload workbookUpload a workbook file or import one from a public URL into Zoho Sheet.