Extension pointers for integrating Zoho CRM with Zoho products #4: Handle and keep track of your Zoho Mail for deals within Zoho CRM

Regular email communication with Zoho CRM contacts, before or after signing or closing a deal, is a key component of effective customer relationship management. Having a separate section within the record page in Zoho CRM for emails associated with a specific deal makes it simple and easy to check the respective email data and set up further follow-ups.

In this post, we'll take a look at how to integrate Zoho Mail with Zoho CRM.

Consider the following scenario: A sales representative successfully closes and wins a deal. For the deal to close successfully, multiple emails will have been exchanged, along with several other emails in the future. Having all of the emails received from the deal's contact in your Zoho CRM as a related list in your deal's record can help you manage this data better.

Creating a connector for Zoho Mail and adding connector APIs

Create a new connector in your extension for Zoho Mail using the Connectors feature under Utilities in the left panel of the Zoho Developer console.

Note: Zoho Mail follows OAuth2.0 protocols for authentication. You can refer to this post to better understand the steps to register Zoho Desk and retrieve your client credentials.

The connector details for our example are:

Request Token URL	https://accounts.zoho.com/oauth/v2/auth?scope=ZohoMail.accounts.READ,ZohoMail.messages.READ,&access_type=offline
Access Token URL	https://accounts.zoho.com/oauth/v2/token
Refresh Token URL	https://accounts.zoho.com/oauth/v2/token
Scopes	ZohoMail.accounts.READ,ZohoMail.messages.READ

Add the necessary connector APIs for your functionality. Please refer to the Zoho Mail API guide for details.

The Zoho Mail APIs added for our example are mentioned below.

Connector API Name	Method type	URL
Get accounts details	GET	http://mail.zoho.com/api/accounts
Search results	GET	http://mail.zoho.com/api/accounts/${accountId}/messages/search?searchKey=sender:${emailid}::entire:${dealname}

Note: You can refer to this post to learn about the detailed steps involved in creating a connector, adding the connector APIs, and associating it with the extension.

Creating a related list and associating a function to it

Create a related list called "Related mails" using the Related details option present in the Components feature available in the Build section of the Zoho Developer console, then associate a function to perform the desired action.

Related mails - Related list code snippet

//Retrieving the deal record and fetching the deal name, contact name and contact ID

response = zoho.crm.getRecordById("Deals",deal.get("Deals.ID").toLong());

dealname = response.get("Deal_Name");

dealname = dealname.trim().toUpperCase();

dealname = replaceAll(dealname," ","_");

contact = response.get("Contact_Name");

id = contact.get("id");

// Retrieving the email ID of the contact associated with the deal by passing the id retrieved

response1 = zoho.crm.getRecordById("Contacts",id);

email = response1.get("Email");

dynamic_map = Map();

// Invoking the get account details API to fetch the account ID

response2 = zoho.crm.invokeConnector("jssdkextension.zohomail.getaccountsdetails",dynamic_map);

resp = response2.get("response");

data = resp.get("data");

for each item in data

{

zuid = item.get("zuid");

info zuid;

accountid = item.get("accountId");

info accountid;

}

dynamic_map = Map();

dynamic_map.put("accountId",accountid);

dynamic_map.put("emailid",email);

dynamic_map.put("dealname",dealname);

// Invoking the search results API to get the emails associated with the deal and contact of the deal

response3 = zoho.crm.invokeConnector("jssdkextension.zohomail.searchresults",dynamic_map);

info response3;

responsedata1 = response3.get("response");

data1 = responsedata1.get("data");

info data1;

// Constructing the related list

resp = "";

count = 1;

recordsXmlStr = "<record>";

for each value in data1

{

recordsXmlStr = recordsXmlStr + "<row no='" + count + "'>";

recordsXmlStr = recordsXmlStr + "<FL val='Subject'>" + value.get("subject") + "</FL>";

recordsXmlStr = recordsXmlStr + "<FL val='Summary'>" + value.get("summary") + "</FL>";

recordsXmlStr = recordsXmlStr + "<FL val='Sender'>" + value.get("sender") + "</FL>";

recordsXmlStr = recordsXmlStr + "</row>";

count = count + 1;

}

recordsXmlStr = recordsXmlStr + "</record>";

resp = resp + recordsXmlStr;

return resp;

The deal record details are fetched using the getRecord API and the deal name along with the contact name is retrieved from it. Similarly, the contact ID is passed to the getRecord API for the contacts module from which the contact's email ID is retrieved.
The account ID is also retrieved by invoking the get account details API.
This account ID is passed to the search results API along with the deal name and the email ID retrieved which are the search criteria for the mails to be filtered and displayed as a related list.

Now let's see a sample output of how this functionality works.

When a deal record is opened, the emails in the Zoho Mail account having the sender as the deal's contact's email address, and the deal name as a part of the mail are fetched and displayed as a related list.

This way you can integrate Zoho CRM with Zoho Mail, and the functionality can be enhanced based on your business requirements.

We hope you find this information useful. Keep following this space for more tips and recommendations!

France ZUGs

Zoho SalesIQ Resources

Topic Participants
Nanditha Somasundaram Somasundaram

Sticky Posts
Extension pointers for integrating Zoho CRM with Zoho products #8: Upload and manage Zoho Workdrive folders and files from within Zoho CRM
Keeping records on your customers and business prospects is essential for tracking data, conducting follow-ups, and running a business smoothly. When you use two separate applications, and store relevant data in each, checking and tracking data becomes
Extension pointers: Handle cases with personalized solutions using custom actions
In our last post, we detailed the steps involved in creating a custom action and the workflow from the developer and end user's side. Now let's look at a working example of how we can create a custom action and implement it in a Zoho CRM account to make
Extension pointers - Simple yet significant pointers #13: On change of field value for CRM variables
CRM variables provide global access to a variable across an entire extension. They also help in the storage of user-specific data provided by the user at the time of installation, which can later be fetched to perform data functionalities. Additionally,
Extension pointers: Extend end-user benefits and allow personalization by implementing extensions with custom actions
From our earlier post on custom actions, we know that we can create templated actions, share them with end users, and allow them to reuse those actions to achieve personalized outcomes. In this post, we'll look at how custom actions make it easy for users
Extension pointers - Simple yet significant pointers #12: Functions for Zoho CRM extensions
Functions are essential in achieving logical functionality for an extension. You can easily code your functions in Deluge using drag-and-drop tools to meet your requirements. How to create functions for Zoho CRM extensions in Sigma Go to Sigma and select