Zoho Drive CRUD Operations

Automate Zoho Drive file management and spreadsheet operations in UiPath with activities for creating, moving, updating, and securing data. Authentication via Zoho API ensures secure integration.

The Zoho Drive activities for UiPath enable seamless integration with Zoho Drive, allowing users to automate file and folder management, as well as work with spreadsheets efficiently. Below is a high-level overview of the key activities:

File & Folder Operations

1. CreateFolder – Creates a new folder in Zoho Drive under a specified parent folder.
2. DeleteFileFolder – Deletes a specified file or folder from Zoho Drive.
3. DownloadFile – Downloads a file from Zoho Drive to a specified local path.
4. FileFolderList – Retrieves a list of files and folders from a given directory.
5. FileFolderMove – Moves a file or folder to a different location within Zoho Drive.
6. FileFolderCopy – Copies a file or folder to another location within Zoho Drive.
7. UploadFiles – Uploads files from the local system to a specific folder in Zoho Drive.

Spreadsheet Operations

1. CreateWorkbook – Creates a new workbook in Zoho Drive.
2. CreateWorksheet – Adds a new worksheet to a specified workbook.
3. CopyWorksheet – Duplicates a worksheet within a workbook.
4. DeleteColumn – Deletes a column from a worksheet based on its position.
5. DeleteRow – Removes a specific row from a worksheet.
6. DeleteWorksheet – Deletes a worksheet from a workbook.
7. InsertColumn – Adds a column at a specified position in a worksheet.
8. InsertRow – Inserts a new row at a given position in a worksheet.
9. ReadWorksheet – Reads data from a worksheet in Zoho Drive.
10. RenameWorksheet – Renames a worksheet within a workbook.
11. UpdateWorksheet – Updates values in a worksheet based on given criteria.

Authentication & Security

1. Generating Authorization Code – Users must generate an authorization code via the Zoho API Console to authenticate UiPath with Zoho Drive.
2. Master Password Requirement – Certain activities require a master password to decrypt sensitive data, ensuring secure access to Zoho Vault information.

These activities streamline Zoho Drive operations within UiPath, enabling efficient file management and automation of spreadsheet tasks.

1. Seamless ZOHO Drive Integration – Enables automation of file and folder operations within ZOHO Drive.
2. Comprehensive File Management – Supports creating, deleting, moving, copying, downloading, and uploading files and folders.
3. Advanced Spreadsheet Handling – Automates workbook and worksheet operations, including creating, updating, reading, and modifying spreadsheet data.
4. Secure Authentication – Uses OAuth 2.0 authentication with client credentials and authorization codes for secure access.
5. Flexible Data Updates – Allows inserting, deleting, renaming, and modifying columns, rows, and worksheets dynamically.
6. Efficient Bulk Operations – Facilitates batch processing of files, folders, and spreadsheet entries, improving workflow efficiency.
7. Error Handling & Logging – Provides error tracking and debugging capabilities for smooth execution.