Step 1: Prepare a sheet with the work order values

Step 2: Create a custom function

1. Navigate to Setup > Automation > Functions and click Create Function.
   
2. Enter the following details and click Save:
   
1. Function Name: CreateBulkWOs
   
2. Module: Work Orders
   
3. In the Deluge Script Editor, enter the following script:
   
   

   url = "https://sheet.zoho.com/api/v2/<resource_id>?method=worksheet.records.fetch&worksheet_name=<worksheet_name>&worksheet_id=<worksheet_id>"; bodyMap = Map(); headerMap = Map(); headerMap.put("Authorization","Zoho-oauthtoken 1000.XXXXX"); response = postUrl(url,bodyMap,headerMap); response_list = response.get("records").toList(); for each  response_map in response_list {  create_response = zoho.fsm.createRecord("Work_Orders",response_map.toMap());  info create_response; }

1. <resource_id>
   The resource_id is the alphanumeric value in the sheet's URL. Refer to the screenshot below.
   
   
   
   
2. <worksheet_name>
   The worksheet_name is the value after sheet=. Refer to the screenshot below.
   
   
   
   Here the worksheet_name value is Sheet1.
   
   
3. <worksheet_id>
   
   Go to the List all worksheets API page. Select your Spreadsheet Name and click Submit. You can find the worksheet_id in the Response. Refer to the screenshot below.
   
   
   
   Here the value of worksheet_id is 0#.

1. Click Generate Access Token.
   
   
   
   
2. The Zoho-oauthtoken value will be displayed as shown in the screenshot below.
   
   

Testing the usecase

1. Navigate to Setup > Automation > Functions and click on the function CreateBulkWOs.
   
2. In the Deluge Script Editor, click Save & Execute.
   
3. In the Execute Function pop-up, enter a Request record ID or click Click here to get the list to obtain the list of available Request IDs.
   
4. Select a Request ID and click Execute.