Integrate Zoho CRM with Google sheets
In this video I am going to show you. How we can integrate Zoho CRM with Google Sheet to populate the records of any module into the sheets. There will be multiple columns in the sheet for every field of the records that we want to send to the sheets.
https://djtechblog.com/google-sheets-...
The Google sheets API.
https://developers.google.com/sheets/...
This is the code.
response = zoho.crm.getRecords("Deals");
for each res in response
{
name = res.getJSON("Deal_Name");
amount = res.getJSON("Amount");
contact = res.getJSON("Contact_Name").getJSON("name");
account = res.getJSON("Account_Name").getJSON("name");
lst = List();
lst1 = List();
lst2 = List();
lst3 = List();
lst4 = List();
lst1.add(name);
lst2.add(account);
lst3.add(contact);
lst4.add(amount);
lst.add(lst1);
lst.add(lst2);
lst.add(lst3);
lst.add(lst4);
var = Map();
var.put("majorDimension","COLUMNS");
var.put("range","Sheet1");
var.put("values",lst);
opt = "RAW";
response = invokeurl
[
url :"https://sheets.googleapis.com/v4/spre..." + opt
type :POST
parameters:var.toString()
connection:"googlesheet"
];
info response;
}