Getting information from Zoho CRM in Zoho Sheets for each record on new row

Hi there,

I am looking for a code to get the information from Zoho CRM to Zoho Sheets, but each record on a new row. The information is now merged on one cell in Zoho Sheets. I want to get the records from a list view in the sheet.

The code which I am using is:

//====================================================

Log_Sheet_ID = "9ka6e26921b7660754ed2824a399670f8d1bb";

Log_Sheet_Name = "Sheet1";

IdsList = input.Id.toList("ld");

for each IdStr in IdsList

{

row1 = Map();

row1.put("DateTime",DatumAfspraak);

row1.put("Record ID","Shawn");

row1.put("Response","Trade Show");

}

queryData = Map();

response = zoho.sheet.createRecords(Log_Sheet_ID,Log_Sheet_Name,row1,queryData,"ze_sheet");

return response;

How I want to use the code:

Results in Zoho Sheets right now:

Hopefully you could help me with this problem.

Kind regards,

Matthijs