Automatically Add Data to Zoho Sheets from Zoho CRM using Deluge Script | ZEPartner.net

ANNOUNCEMENT - Aug 2023: Check out our new Zoho CRM Extension that adds Client Portal Functionality to your Zoho Account in a matter of minutes: • ZE Portal Support me by signing up for Zoho using one of my affiliate links:
- Zoho One Free Trial: go.zoho.com/Zod
- Zoho CRM Forever Free (up to 3 users): go.zoho.com/icg
In this video I teach you how to automatically send data from Zoho CRM to a specific Zoho Sheet.
Here is the final code from the video:
//====================================================
MyList = list();
MyList.add(1);
MyList.add(2);
MyList.add(3);
MyList.add(4);
MyList.add(5);
MyList.add(6);
MyList.add(7);
MyList.add(8);
Log_Sheet_ID = "86za2b6244532c640436eb60189dddcce9650";
Log_Sheet_Name = "Sheet1";
//
for each Item in MyList
{
//
EmptyMap = Map();
Row_Data_Map = Map();
//
Row_Data_Map.put("DateTime",zoho.currenttime);
Row_Data_Map.put("Record ID",Item + 1);
Row_Data_Map.put("Response","Response from Zoho After Updating Record");
//
Add_Row_to_Log_Response = zoho.sheet.createRecords(Log_Sheet_ID,Log_Sheet_Name,Row_Data_Map,EmptyMap,"ze_sheet");
info "===========================";
info "LOG RESPONSE:";
info Add_Row_to_Log_Response;
info "===========================";
//
}
return Add_Row_to_Log_Response;
//====================================================
Thanks for watching! Please support our channel with a thumbs up, commenting, and subscribing!
For more information about me, my training courses, hiring me, and my Zoho Community Form, please visit:
- My website: zepartner.net
- Training Courses: training.zepartner.net
- Zoho Forum: community.zepartner.net
- Hire me: hire.zepartner.net

[@godfredocansey767]

wonderful work sir, you made it so simple. Please sir, I have json object and i want to update the excel sheet with it, how do i make the text go to the next line ( not the next row, just the next line) i'd appreciate if you can respond sir.
Thank you.

[@ZohoExpert]

This is complicated. I will see if I can find some template code to share with you

[@godfredocansey767]

That would be appreciated. I had to use macro in the mean time(after using ypur template of course) Thank you.
You saved me a ton of time and o really appreciate it

[@leandrosabadomyvideos]

Hi ZE, thank you I found Your YT Channel. Can you create integration between Zoho Mail and Zoho Sheet. We would like to automate our zoho sheet when we send an email to a specific client so that it update a specific check box so we can know that we already sent an email to that client. thank you

[@ZohoExpert]

Yes, that’s possible, but I’d recommend rather using Zoho CRM as your data source. Using a spreadsheet isn’t ideal.

[@brianizquierdo10]

Hello, do you know how I can create a workbook (zoho sheet) from zoho deluge?

[@ZohoExpert]

I don’t think this is possible, unfortunately. However, bear in mind that spreadsheets are designed to work as a sheet, not as multiple sheets. E.g, if you plan to make a file with multiple sheets, you are probably trying to use Zoho Sheets in the incorrect way. You should have 1 sheet with headers in row A and data in the rows below this.
If you need multiple sheets, then you probably shouldn’t be storing the data in a spreadsheet. Instead, store it in a module in Zoho CRM (or some other database)