Zoho Sheets

The Zoho Sheets modules allow you to create, update, list, and delete the worksheets and search the content in worksheets from your Zoho Sheets account.

Getting Started with Zoho Sheets

Prerequisites

The module dialog fields that are displayed in bold (in the Make scenario, not in this documentation article) are mandatory!

Connecting Zoho Sheets to Make

  1. Log in to your Make account, add a module from the Zoho Sheets app into an Make scenario.

  2. Click Add next to the Connection field.

    61d6bf6da76e3.gif
  3. In the Connection name field, enter a name for the connection and click Continue.

  4. Confirm the access by clicking Accept.

    61d6bf700b857.png

The connection has been established.

Lists all worksheets.

Connection

Establish a connection to your Zoho Sheets account.

Resource / Workbook ID

Select or map the Workbook ID whose worksheets you want to list.

Limit

Set the maximum number of worksheets Make should return during one execution cycle.

Creates a new worksheet within a workbook.

Connection

Establish a connection to your Zoho Sheets account.

Resource / Workbook ID

Select or map the Workbook ID in which you want to create the worksheet.

Worksheet Name

Enter (map) a name for the worksheet.

Copies an existing worksheet.

Connection

Establish a connection to your Zoho Sheets account.

Resource / Workbook ID

Select or map the Workbook ID whose worksheet you want to copy.

Select Worksheet

Select or map the option to choose the worksheet:

  • By ID

  • By Name

Worksheet ID

Select or map the Worksheet ID you want to copy.

Worksheet Name

Select or map the worksheet you want to copy.

Insert after ID

Select or map the Worksheet ID after which you want to insert the copied worksheet.

New Worksheet Name

Enter (map) a new name for the worksheet you have copied. By default, the new worksheet name will be similar to Sheet11, Sheet12, etc. Provide a unique name.

Renames a worksheet.

Connection

Establish a connection to your Zoho Sheets account.

Resource / Workbook ID

Select or map the Workbook ID whose worksheets you want to rename.

Old Name

Select or map the worksheet which you want to rename.

New Name

Enter (map) a new name for the worksheet.

Deletes a worksheet specified by ID or name.

Connection

Establish a connection to your Zoho Sheets account.

Resource / Workbook ID

Select or map the Workbook ID whose worksheet you want to delete.

Select Worksheet

Select or map the option to choose the worksheet:

  • By ID

  • By Name

Worksheet ID

Select or map the Worksheet ID you want to delete.

Worksheet Name

Select or map the worksheet you want to delete.

Contents

Searches for contents of the specified range.

Connection

Establish a connection to your Zoho Sheets account.

Resource / Workbook ID

Select or map the Workbook ID whose content you want to search.

Select Worksheet

Select or map the option to choose the worksheet whose content you want to search:

  • By ID

  • By Name

Worksheet ID

Select or map the Worksheet ID whose content you want to search.

Worksheet Name

Select or map the worksheet name whose content you want to search.

Start Row

Enter (map) the row number from which you want to search. Enter a value between 1 and 65536.

Start Column

Enter (map) the column number from which you want to search. Enter a value between 1 and 256.

End Row

Enter (map) the row number until which you want to search. Enter a value between 1 and 65536.

End Column

Enter (map) the column number until which you want to search. Enter a value between 1 and 256.

Limit

Set the maximum number of search results Make should return during one execution cycle.

Sets the CSV content to the specified range.

Connection

Establish a connection to your Zoho Sheets account.

Resource / Workbook ID

Select or map the Workbook ID whose content you want to set for a specified range.

Select Worksheet

Select or map the option to choose the worksheet whose content you want to set:

  • By ID

  • By Name

Worksheet ID

Select or map the Worksheet ID whose content you want to set.

Worksheet Name

Select or map the worksheet name whose content you want to set.

Row

Enter (map) a row index of the cell from which the CSV data will start. Enter a value between 1 and 65536.

Column

Enter (map) a column index of the cell from which the CSV data will start. Enter a value between 1 and 256.

Data

Enter (map) the CSV data to be set to search the specified content.

Ignore Empty

Select whether you want to ignore the empty cells with no content.

Clears the content of the specified range.

Connection

Establish a connection to your Zoho Sheets account.

Resource / Workbook ID

Select or map the Workbook ID whose content you want to clear within the specified range.

Select Worksheet

Select or map the option to choose the worksheet whose content you want to clear:

  • By ID

  • By Name

Worksheet ID

Select or map the Worksheet ID whose content you want to clear.

Worksheet Name

Select or map the worksheet name whose content you want to clear.

Clear Method

Select or map the option to choose the method:

  • Clear Content and Formatting

  • Clear Content Only

Start Row

Enter (map) the row number from which you want to clear the content. Enter a value between 1 and 65536.

Start Column

Enter (map) the column number from which you want to clear the content. Enter a value between 1 and 256.

End Row

Enter (map) the row number until which you want to clear the content. Enter a value between 1 and 65536.

End Column

Enter (map) the column number from which you want to clear the content. Enter a value between 1 and 256.

Other

Performs an arbitrary authorized API Call.

Connection

Establish a connection to your Zoho Sheets account.

URL

Enter a path relative to https://sheet.zoho.in/api For example: /v2/workbooks

For the list of available endpoints, refer to the Zoho Sheets Developer Documentation.

Method

Select the HTTP method you want to use:

GET

to retrieve information for an entry.

POST

to create a new entry.

PUT

to update/replace an existing entry.

PATCH

to make a partial entry update.

DELETE

to delete an entry.

Headers

Enter the desired request headers. You don't have to add authorization headers; we already did that for you.

Query String

Enter the request query string.

Body

Enter the body content for your API call.

The following API call returns all the workbooks from your Zoho Sheets account:

URL:

/v2/workbooks

Method:

GET

61d6bf7130238.png

Matches of the search can be found in the module's Output under Bundle > Body > workbooks.

In our example, 3 workbooks were returned:

61d6bf726bd82.png