How do I automatically generate a new sheet from a template?
I have a template in Zoho Sheet that I'm trying to use to automatically generate a spreadsheet. I was looking through the Zoho Sheet API and I found a way to create a spreadsheet through the API but it only creates a blank spreadsheet and not one that looks like the template I have. Here's my code to generate the spreadsheet.
sheetMap = Map();
sheetMap.put("apikey", "//key");
callbackSettings = Map();
callbackSettings.put("save_format", "zsheet");
callbackSettings.put("save_url", "//url
"); sheetMap.put("callback_settings", callbackSettings);
response = invokeUrl[
type: POST
parameters: sheetMap
];
Does anyone know if there's a way for me to generate a new spreadsheet using a Zoho Sheet template so the new sheet being created isn't blank? Here's the API that I used.