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 Integromat scenario, not in this documentation article) are mandatory!

Connecting Zoho Sheets to Integromat

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

2. Click Add next to the Connection field.

2. In the Connection name field, enter a name for the connection and click Continue.

3. Confirm the access by clicking Accept.

The connection has been established.

List Worksheets

Lists all worksheets.

ConnectionEstablish a connection to your Zoho Sheets account.
Resource / Workbook ID
Select or map the Workbook ID whose worksheets you want to list.
LimitSet the maximum number of worksheets Integromat should return during one execution cycle.

Create a Worksheets

Creates a new worksheet within a workbook.

ConnectionEstablish 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 NameEnter (map) a name for the worksheet.

Copy a Worksheet

Copies an existing worksheet.

ConnectionEstablish a connection to your Zoho Sheets account.
Resource / Workbook ID
Select or map the Workbook ID whose worksheet you want to copy.
Select WorksheetSelect or map the option to choose the worksheet:
  • By ID
  • By Name
Worksheet IDSelect or map the Worksheet ID you want to copy.
Worksheet NameSelect or map the worksheet you want to copy.
Insert after IDSelect or map the Worksheet ID after which you want to insert the copied worksheet.
New Worksheet NameEnter (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. 

Rename a Worksheet

Renames a worksheet.

ConnectionEstablish a connection to your Zoho Sheets account.
Resource / Workbook ID
Select or map the Workbook ID whose worksheets you want to rename.
Old NameSelect or map the worksheet which you want to rename.
New NameEnter (map) a new name for the worksheet.

Delete a Worksheet

Deletes a worksheet specified by ID or name.

ConnectionEstablish a connection to your Zoho Sheets account.
Resource / Workbook ID
Select or map the Workbook ID whose worksheet you want to delete.
Select WorksheetSelect or map the option to choose the worksheet:
  • By ID
  • By Name
Worksheet IDSelect or map the Worksheet ID you want to delete.
Worksheet NameSelect or map the worksheet you want to delete.

Contents

Search Content of a Range

Searches for contents of the specified range.

Connection Establish a connection to your Zoho Sheets account.
Resource / Workbook IDSelect or map the Workbook ID whose content you want to search.
Select WorksheetSelect or map the option to choose the worksheet whose content you want to search:
  • By ID
  • By Name
Worksheet IDSelect or map the Worksheet ID whose content you want to search.
Worksheet NameSelect or map the worksheet name whose content you want to search.
Start RowEnter (map) the row number from which you want to search. Enter a value between 1 and 65536.
Start ColumnEnter (map) the column number from which you want to search. Enter a value between 1 and 256.
End RowEnter (map) the row number until which you want to search. Enter a value between 1 and 65536.
End ColumnEnter (map) the column number until which you want to search. Enter a value between 1 and 256.
LimitSet the maximum number of search results Integromat should return during one execution cycle.

Set Content to Range

Sets the CSV content to the specified range.

Connection Establish a connection to your Zoho Sheets account.
Resource / Workbook IDSelect or map the Workbook ID whose content you want to set for a specified range.
Select WorksheetSelect or map the option to choose the worksheet whose content you want to set:
  • By ID
  • By Name
Worksheet IDSelect or map the Worksheet ID whose content you want to set.
Worksheet NameSelect or map the worksheet name whose content you want to set.
RowEnter (map) a row index of the cell from which the CSV data will start. Enter a value between 1 and 65536.
ColumnEnter (map) a column index of the cell from which the CSV data will start. Enter a value between 1 and 256.
DataEnter (map) the CSV data to be set to search the specified content. 
Ignore EmptySelect whether you want to ignore the empty cells with no content.

Clear Content of a Range

Clears the content of the specified range.

Connection Establish a connection to your Zoho Sheets account.
Resource / Workbook IDSelect or map the Workbook ID whose content you want to clear within the specified range.
Select WorksheetSelect or map the option to choose the worksheet whose content you want to clear:
  • By ID
  • By Name
Worksheet IDSelect or map the Worksheet ID whose content you want to clear.
Worksheet NameSelect or map the worksheet name whose content you want to clear.
Clear MethodSelect or map the option to choose the method:
  • Clear Content and Formatting
  • Clear Content Only
Start RowEnter (map) the row number from which you want to clear the content. Enter a value between 1 and 65536.
Start ColumnEnter (map) the column number from which you want to clear the content. Enter a value between 1 and 256.
End RowEnter (map) the row number until which you want to clear the content. Enter a value between 1 and 65536.
End ColumnEnter (map) the column number from which you want to clear the content. Enter a value between 1 and 256.

Other

Make an API Call

Performs an arbitrary authorized API Call.

ConnectionEstablish 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.

MethodSelect 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.
HeadersEnter the desired request headers. You don't have to add authorization headers; we already did that for you.
Query StringEnter the request query string.
BodyEnter the body content for your API call.

Example of Use - List Workbooks

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

URL:
/v2/workbooks

Method:
GET

Matches of the search can be found in the module's Output under Bundle > Body > workbooks
In our example, 3 workbooks were returned:


Popular use cases from our blog

automated-data-collection-crm-illustration

How to Automate Data Collection - Part 5: CRM Systems

automated-data-collection-chatbot-marketing-illustration

How to Automate Data Collection - Part 4: Chatbot Marketing

automated-data-collection-paid-ads-illustration

How to Automate Data Collection - Part 3: Paid Ads

automated-data-collection-email-illustration

How to Automate Data Collection - Part 2: Email Marketing Segmentation

personalized-customer-experience-illustration-integromat

5 Automated Solutions to Personalize Customer Experience

data-collection-automation-forms-pt-1

How to Automate Data Collection - Part 1: Online Forms

Didn’t find what you were looking for?

Ticket

Create a ticket

Contact our world-class support team and tell us what’s happening.

Create a ticket
Expert

Find an expert

We feature a network of 450+ certified partners across the globe who are ready to help

Find an expert

Automate any workflow in your business

Sign up for a free account today. No credit card required, no time limits on free plan.