Zoho Sheet API

Setup Zoho Sheet API to get Workbook, Worksheet table data, add rows, update row, delete rows with simple API without any server setup or coding

List all workbooks

Make GET request on this endpoint to list all workbooks with required parameters(if any required).

https://v1.nocodeapi.com/<username>/zohosheet/<token>/workbooks

List all worksheets

Make GET request on this endpoint to list all worksheets with required parameters(if any required).

https://v1.nocodeapi.com/<username>/zohosheet/<token>/worksheets

Create worksheet

Make POST request on this endpoint to create worksheet with required parameters(if any required).

https://v1.nocodeapi.com/<username>/zohosheet/<token>/worksheets

- Request Parameters:

ObjectDescription
workSheetName[Optional] Name of the new worksheet

Fetch records

Make GET request on this endpoint to fetch records with required parameters(if any required).

https://v1.nocodeapi.com/<username>/zohosheet/<token>/sheetData

- Request Parameters:

ObjectDescription
workSheetName[Required] Name of the new worksheet
header_row[Optional] By default, first row of the worksheet is considered as header row. This can be used if tabular data starts from any row other than the first row.
criteria[Optional] Can be used to filter records. example: "Name"="Jack", "email"="hello@example.com", "age">14, etc
column_names[Optional] Name of the new worksheet
render_option[Optional] It defines how the value should be rendered. Possible options are formatted, unformatted, and formula.
page[Optional] pagination for next page
perPage[Optional] It denotes the number of records.

Add records

Make POST request on this endpoint to add records with required parameters(if any required).

https://v1.nocodeapi.com/<username>/zohosheet/<token>/sheetData

- Request Parameters:

ObjectDescription
workSheetName[Required] Name of the new worksheet
body[Required] JSON Array. Example : [{"Name":"Joe","Region":"South","Units":284},{"Name":"Beth","Region":"East","Units":290}]. "Name", "Region", and "Units" are the table headers.

- Body data format example:

[
    {
        "Name": "Joe",
        "Region": "South",
        "Units": 284
    },
    {
        "Name": "Beth",
        "Region": "East",
        "Units": 290
    }
]

Update records

Make PUT request on this endpoint to update records with required parameters(if any required).

https://v1.nocodeapi.com/<username>/zohosheet/<token>/sheetData

- Request Parameters:

ObjectDescription
workSheetName[Required] Name of the new worksheet
criteria[Optional] If criteria is not set all available rows will get updated. Mention the criteria as described as: example: "Name"="Jack", "email"="hello@example.com", "age">14, etc
header_row[Optional] By default, first row of the worksheet is considered as header row. This can be used if tabular data starts from any row other than the first row.
first_match_only[Optional] If true and if there are multiple records on the specified criteria, records will be updated for first match alone. Otherwise, all the matched records will be updated.
is_case_sensitive[Optional] By default it is true. Can be set as false for case incensitive search.
body[Required] The JSON data that needs to be updated. Example:{"Month":"May","Amount":50}

- Body data format example:

{
    "Month": "May",
    "Amount": 50
}
NoCodeAPI 3.0 - The easiest way to connect with APIs without code. | Product Hunt