The Zoho Sheets modulesThe module is an application or tool within the Boost.space system. The entire system is built on this concept of modularity. (module - Contacts) More allow you to create, update, list, and delete the worksheets and search the content in worksheets from your Zoho Sheets account.
Prerequisites
-
A Zoho Sheets account – create an account at zoho.com/sheet/.
Connecting Zoho Sheets to Boost.spaceCentralization and synchronization platform, where you can organize and manage your data. More IntegratorPart of the Boost.space system, where you can create your connections and automate your processes. More
-
Log in to your Boost.space Integrator account, add a Zoho Sheets moduleThe module is an application or tool within the Boost.space system. The entire system is built on this concept of modularity. (module - Contacts) More, and click the Add button next to the ConnectionUnique, active service acces point to a network. There are different types of connections (API key, Oauth…). More field.
-
In the Connection name field, enter a name for the connection.
-
Optional: Click Show Advanced Settings and enter the client credentials. See Create your own app and client credentials.
-
Click Save.
-
Confirm the access by clicking Accept.
The connection has been established.
To create your own app:
-
Log in to your Zoho Developer account.
-
Click ADD CLIENT and choose a client type.
-
Enter the app detail as described below and click CREATE.
Client Name
Enter the application name you want to register with Zoho.
Homepage URL
Enter the homepage URL, for example,
https://www.make.com/en.Redirect URI
Add,
https://www.integromat.com/oauth/cb/zohocrm2 -
Copy the Client ID and Client Secret to a safe place.
You have successfully retrieved the client credentials.
Using the following modules, you can create, copy, list, rename, and delete worksheets.
Lists all worksheets.
|
Connection |
|
|
Resource / Workbook ID |
Select or map the Workbook ID whose worksheets you want to list. |
|
Limit |
Set the maximum number of worksheets Boost.space Integrator should return during one execution cycleA cycle is the operation and commit/rollback phases of scenario execution. A scenario may have one or more cycles (one is the default).. |
Creates a new worksheet within a workbook.
|
Connection |
|
|
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 |
|
|
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:
|
|
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 |
|
|
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 |
|
|
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:
|
|
Worksheet ID |
Select or map the Worksheet ID you want to delete. |
|
Worksheet Name |
Select or map the worksheet you want to delete. |
Using the following modules, you can search, set, and clear content.
Searches for contents of the specified range.
|
Connection |
|
|
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:
|
|
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 Boost.space Integrator should return during one execution cycle. |
Sets the CSV content to the specified range.
|
Connection |
|
|
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:
|
|
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 |
|
|
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:
|
|
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:
|
|
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. |
Performs an arbitrary authorized API Call.
|
Connection |
|
|
URL |
Enter a path relative to 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
Matches of the search can be found in the module’s Output under BundleA bundle is a chunk of data and the basic unit for use with modules. A bundle consists of items, similar to how a bag may contain separate, individual items. More > Body > workbooks.
In our example, 3 workbooks were returned:
