Seeking Assistance with Zoho Sheet ID Extraction in CRM Deluge Script

Seeking Assistance with Zoho Sheet ID Extraction in CRM Deluge Script

Hello,

I am currently working on a Deluge script triggered by a button in a custom module in Zoho CRM. My goal is to extract the Zoho Sheet ID from a Zoho Sheet file within a designated WorkDrive folder. I am exploring the feasibility of the following options:
  1. Using Deluge to Create a Zoho Sheet File: I would like to know if it's possible to use Deluge to create a Zoho Sheet file within a given WorkDrive folder. If achievable, I intend to use the response to obtain the Sheet ID and populate a designated field in the CRM record for future reference in other functions.
  2. Manual Creation and Search Function: Alternatively, I am considering manually creating the Zoho Sheet file and then using if possible, a search by-criteria file function within Deluge to retrieve the Zoho Sheet ID. The criteria for the search could include the WorkDrive folder ID and the Zoho Sheet file name.
I have not found a solution for either of these options. Can anyone provide guidance or assistance?
Thanks