Creating a Gmail integration using custom connectors

Hello everyone!

Greetings from Deluge. Following up on our series aimed at exploring the capabilities of Deluge, today we'll take an in-depth look into the Deluge custom connections that can be created across Zoho services.

Deluge boasts an extensive range of over 260 built-in integrations spanning more than 35 Zoho services. These integrations streamline data access and modification with these services, from a single point in Zoho, without having to toggle between services. However, we understand that the needs of our users vary widely, and sometimes existing integrations may not cover every scenario.

That's where custom connections come in. Think of them as the Swiss Army Knife of integrations, enabling connections with hundreds of services—such as Gmail and Outlook—and seamlessly integrating them with your favorite Zoho services. With custom connections, you have the power to build your own integrations with virtually any third-party service and tailor them to meet your requirements. Moreover, since the custom connections use the OAuth 2.0 authentication mechanism, you're getting best-in-class security while integrating with third-party services.

What are connections? 

Before we dive into the details of custom connectors, let's take a glimpse at what connections are in Deluge. Connections are a means to connect your Zoho account and any third-party accounts you wish to integrate with. Once a connection is created and connected, you can use it in Deluge integration tasks or invokeURL scripts to perform REST operations on the target service from the required Zoho service. For more information, visit our Connections help doc.

  

Use case 

Assume the sales team of an organization uses Zoho CRM for managing leads, customer retention, and customer acquisition, and uses Gmail for communication purposes, like following up with potential clients via email.   While the system works as is, it's time-consuming and prone to error, so an integration between Gmail and Zoho CRM is necessary to improve efficiency.

A custom connection to your Google account will enable you to sync your Zoho CRM and Google accounts, allowing you to perform actions related to your Google account from Zoho CRM. For example, you can invoke the connection using the invokeURL task in Zoho CRM and send an email to your leads from your Gmail address.

Steps to configure the Google custom connection

Configuration video

Configuration steps

Creating Google OAuth credentials

1. Visit https://console.cloud.google.com/.
   
2. Click the dropdown and choose the required project.
   
3. Navigate to the hamburger menu on the left and click APIs and services -> Library.
   
4. You'll be taken to the API library page. Navigate to the Google Workspace section and click Gmail API.
   
5. Next, click Enable on the Gmail API product details page.
   
6. In order to use this API, you'll need to create credentials. Click CREATE CREDENTIALS.
   
7. On the Create credentials page, choose Gmail API in the Select an API dropdown and User Data under the What data will you be accessing? section. Click Next.
   
8. Next, on the OAuth consent screen, enter the App name, User support email, and Developer contact email address. Then click Save and Continue.
   
9. Next, under the Scopes section, click the ADD OR REMOVE SCOPES button.
   
10. In the Update selected scopes pane, search and select the gmail.readonly scope. Click Update, and then click Save and continue.
    
    
    
11. Now, under the OAuth Client ID section, choose Web application in the Application type dropdown. Then name your app.
    
    
    
12. Enter https://deluge.zoho.com/delugeauth/callback as the Authorized redirect URI.
    
13. Click Create and download your credentials. This Client ID and others will be required later, while creating a connection in Zoho CRM.
    
14. Navigate to the OAuth consent screen and click Add users under Test users. Enter the user's email address and click Save.
    

Creating a custom connector for Gmail

1. Now the action shifts to Zoho CRM. Navigate to crm.zoho.com -> Settings -> Connections.
   
2. Choose Custom Services and click Create Service.
   
3. On the Create Service screen, choose OAuth 2.0 as the Authentication type and Header as the Parameter.
   
4. Enter the Client ID, Client Secret, and Authorize URL generated from Google as shown in step 12 above.
   Tip: Having the Offline access type will allow your application to refresh tokens even when the user is not actively using the application.
5. Then enter https://oauth2.googleapis.com/token as the Access token URL and Refresh token URL.
   
6. Specify the necessary scopes like read and create, etc. and then click Create Service.
   
7. On the next page, click Create Connection. Give the connection name and choose the scopes. Then click Create and Connect.
   
8. Finally, authenticate the connection on the Google accounts page. Your custom connection will be created, and the two services can be integrated!
   

Now that the connection between Zoho CRM and Gmail has been established, you can use the invokeURL task to access and modify data in Gmail using the different APIs.

Sample

You can use the below code in invokeURL task to get the latest emails from Gmail.

userId = "emailaddress@gmail.com";
get_gmail = invokeurl
[
url: "https://gmail.googleapis.com/gmail/v1/users/"+userId+"/messages"
type: GET
connection : "connectionname"
];
messageID = get_gmail.get("messages").get(0).get("id");

get_gmail_withID = invokeurl
[
url: "https://gmail.googleapis.com/gmail/v1/users/"+userId+"/messages/"+messageID
type: GET
connection : "connectionname"
];

Content_of_the_mail = get_gmail_withID.get("snippet");
info "Mail Content : " + Content_of_the_mail;

gmail_values = get_gmail_withID.get("payload").get("headers");
for each headers in gmail_values
{
if ( headers.get("name") == "Subject" )
{
info "Subject of the Mail : " + headers.get("value");
}
if ( headers.get("name") == "From" )
{
info "From Address : " + headers.get("value");
}
}

References

Connections
invokeURL

----

And that's a wrap for today! We hope you found this post informative and start using custom connections to experience the full capabilities of Deluge and Zoho.

Kindly let us know if you have any questions, feedback, or suggestions in the comments, or write to us at support@zohodeluge.com!

 

Regards,

The Deluge Team

• Topic Participants

• Ashwin Vishal R

  

• Kaushal

• Anand M B

  

• Recent Topics

• [Free Webinar] Learning Table Series - Creator for the Education Industry

  Hello Everyone! We're thrilled to invite you to the Learning Table Series—a year-long initiative to demonstrate how Zoho Creator can transform industries with innovative and automated solutions. Each month focuses on a specific industry, and this time,

• Remove the [## XXXX ###] from subject replies

  For our organisation we would like to have the [## XXXX ###] removed from subject replies. Cheers, Jurgen 365VitaalWerken

• Self Client Authorization Issue

  Hi. Trying to test the api integration for Zoho Desk with the Self Client - Client Credintials flow method. I've created the self client, obtained the client id and secret, inputted "Desk.tickets.ALL" as my scope, and "ZohoDesk.[My Zoho Desk Org ID]"

• How Can I Easily Access and Manage My GEPCO Online Bill Using Zoho Sheets?

  Hello everyone, I'm looking for an efficient way to access and manage my GEPCO online bills. I've heard that Zoho Sheets can be a powerful tool for organizing and tracking bills, but I'm not sure how to set it up for this specific purpose. Does anyone

• All notes disappeared

  I've been using the notebook app for over five years on my phone without being logged into an account. A few days ago I opened the app and all my notes had disappeared. Since then I tried restarting my phone, updating the app and logging into my account,

• How to add tags to a record with jS SDK 1.2/ZohoEmbededAppSDK

  Hello Is it possible to add tags to a record with jS SDK : https://live.zwidgets.com/js-sdk/1.2/ZohoEmbededAppSDK.min.js ZOHO.CRM.API.updateRecord Thanks for insights

• URGENT: Zoho Forms reCAPTCHA v2 Spam Issue

  Hello Everyone, We are encountering a critical issue with Zoho Forms despite having reCAPTCHA v2 enabled. Our business is accessibility-focused, and we are receiving a high volume of spam submissions, which is significantly affecting our workflow and

• View all Products by pipeline deal

  Very good CRM I use it everyday only problem is modules not being interconnected especially products module. The main problem of products module are separated from contacts and company modules and only being connected to the Deals module. This way there's

• Add "Lead Image" in Bulk?

  Each of our Leads is accompanied with a URL containing a photo of the lead when they come in. We currently have to manually download then upload the photo to the lead. This is a HUGE waste of time. Is there any way to AUTOMATICALLY add the photos to the

• Map fields from CRM record to Finance Suite/Books Invoice fields

  I'm trying to auto-fill unique record specific field inputs that I have in my Contacts and Deals modules onto Invoices created from the record's finance suite related list upon creation.  One example is a field called "Job Number" that I have in my Contact

• What's New in Zoho Analytics - December 2024

  Hello Users! We’re excited to bring you a roundup of the latest features and improvements in Zoho Analytics. These updates are designed to elevate your data analytics experience, making it more powerful, interactive, and seamless. Let’s dive in! Expanded

• trying to access CRM Variables with JS SDK

  Hello i built a widget with Sigma, i create CRM VARIABLES in custom properties. I try to access them in function : ZOHO.embeddedApp.on("PageLoad",function(data) with : ZOHO.CRM.CONFIG.getVariable("mycrmvariable").then(function(data){ console.log("mycrmvariable

• Writing on sketch cards is bugged when zoomed in

  When zoomed in, it writes a noticeable distance above or to the side of where you're actually trying to write. The further you're zoomed in, the more noticeable it is. Zooming is also entirely absent on the desktop version.

• Private Project

  Hi, I would like to know if a user can create a Private project that only he's able to see it. Not even the ADMIN user. Thanks

• Accordion in tabs to create FAQs, etc.

  Accordion elements do not seem to be able to be placed in the tabs. It would be useful to be able to do this. Thank you.

• Which are the IP addresses to use for 'split delivery' with Office 365? (Zoho mail inbound gateway)

  Hi, I'm trying to set up 'split delivery' (email routing) with Office 365. I'm following the instructions to set up Office 365 as the primary server (https://www.zoho.com/mail/help/adminconsole/coexistence-with-office365.html) One of the prerequisites

• Zoho Projects 2024 Recap

  Dear Users, As we conclude another remarkable year, it's the time to reflect on the journey we've just completed. The year 2024, defined by significant milestones, challenges, achievements, and important lessons. Every moment has contributed to the story

• Custom Fields at Line Level

  Hi, is there an ability to add custom fields at line level? I need to track the start and the end date for each product within an invoice and I can't seem to find an option to do this.

• Zoho API Error Code 7019 when adding job.

  Hello, I am following the documentation found here. https://www.zoho.com/people/api/timesheet/adding-jobs.html Regardless of how I try and post the data (including just using the example requests), I receive back the response {'response': {'message':

• How to see changes with ZOHO.CRM.API.updateRecord(config) without reload page

  hello got a widget in account, trigger with a button i copy data to account when click on a button, in my popup All is working well. But i need to reload the page to see the update. How can i see the changes without reloading page, only when close the

• How to call a Creator function which is in a different Creator application?

  How to call a Creator function which is in a different Creator application?

• Unable to send message; Reason: 554 5.1.8 Email Outgoing Blocked

  My account is mino@flawless-frames.com, or flawlessframesstudio@gmail.com Could you please unblock my account, I've got restricted from sending more emails

• Stock Count

  The stock count is a nice new feature, but we cannot figure out how to: 1. Use it without assigning to a person, we have a team or one of multiple do stock counts as do most any company. 2. Add any extra fields to what the "counter" sees. The most important

• Move a Contact from Current Account to a NEW Account

  I do not believe the functionality to Move a Contact from a Current Account to a New Account is not available. Please someone tell me I am missing something! I have been through designing, developing, using and selling CRM systems for over 25 years and had this functionality20+ years ago in other CRMs.  In the real world people move from one organisation to another. In the sales, finance and technical world it is nice to see the communication history with that person in their old account and also

• Force Specific Layout for CRM Contacts Portal

  Hello: We're in trial on ZOHO One and looking at the CRM Portal (just for the contacts module). We have a client layout set up for Contacts that is working well for our internally, but for the portal we don't want to require (make mandatory) some of the

• Automatic Removal of Departments and Groups for Inactive Employees in Zoho One

  Hi Zoho One Team, We hope you're doing well. Currently, when an employee is marked as inactive in Zoho One, they remain listed as a member of their department and associated groups. This creates a challenge in maintaining accurate records and ensuring

• Change eMail Template for Event-Invitations

  Hello ZOHO-CRM Team How I can change the eMail Template for Event-Invitations? I work with the German Version of the Free Version. I know how I can modify eMail alerts or Signature Templates, but where I can other eMails modify you send out? Thank you for your answer. Regards, Juerg

• Zoho Social integration with Zoho Flow

  Is there any plans for Zoho Social integration with Zoho Flow?

• Zoho CRM Widget and translations

  Hi everyone! We're building a Widget with zoho-extension-toolkit, how is localization supposed to work? "zet init" created a translations/en.json file, but what should go inside it and how is it supposed to be accessed from the Widget/javascript? Thanks

• Bienvenue à Zoho FSM : l'optimisation des opérations locales qui offre une expérience de service impeccable

  Nous sommes ravis de vous présenter Zoho FSM, la plateforme de gestion des services terrain de bout en bout. Les solutions de gestion des services locaux s'adressent aux organisations qui effectuent des activités d'installation, de réparation et de maintenance

• Adding tag to specific record as an acion in a workflow

  Hi! I've created the following workflow in the module 'Leads'. When a record meets the criteria, there should be a tag added to the specific record in the module 'Contacts'. In the module 'Leads', there is a look-up field named 'Kandidaat' which is connected

• Trying to catch error with ZOHO.CRM.HTTP.get (Response Code)

  Hello, I'm trying to get response header from ZOHO.CRM.HTTP.get, in order to catch error like 404 or something else but it seems that ZOHO.CRM.HTTP.get() method only returns the body of the response, and I see no way to access the headers returned. Is

• FSM - How to ADD PHOTOS to Estimates & Invoices

  How can you add photos to estimates and invoices that are being emailed to the client so the can see what you are estimating and your completed work?

• Free developer edition of Zoho CRM

  A question for Zoho and other developers: How can you set up a demonstration version of a Zoho CRM implementation to show employers/clients what can be achieved? Do you pay for Zoho CRM Enterprise/Zoho One for this purpose? Does Zoho offer a free version

• Can I add Conditional merge tags on my Templates?

  Hi I was wondering if I can use Conditional Mail Merge tags inside my Email templates/Quotes etc within the CRM? In spanish and in our business we use gender and academic degree salutations , ie: Dr., Dra., Sr., Srta., so the beginning of an email / letter

• Where are scheduled emails stored?

  After you schedule an email to go out through the CRM, how do you go about changing that scheduled email? Or even where can I see the list of emails scheduled to go out? They are not listed in my Zoho Mail account in Outbox which has been the only answer

• CRM Home Page Dashboard, how can i add zoho desk cases?

  How can i see which tickets are in my group as a dashboard component on the home tab in zoho crm? I don't see any way of adding this.

• Custom Module missing SDK function fetchRelatedRecords(...) in a Client Script

  Good day, We have added a new module with a Multi-Lookup relation to Contacts.  When we tried to use the fetchRelatedRecords(id, related_list_api_name) function to get Related Records it is missing for our new custom module. https://js.zohocdn.com/crm/5124797/documentation/DotSDK/Modules.html

• Assistance with Setting Default Values for Zoho Chat Custom Fields

  I am currently using the Zoho Chat JavaScript API to successfully add custom fields to the chat interface. While the implementation of these fields has been smooth, I am now looking to set default values for these custom fields. However, I couldn't find

• Subform Client Script

  Good day,  I have a subform where users can subscribe to various magazines. I would like to prevent the user from selecting the same magazine twice when adding a new row. Is there a way to prevent the user from doing this? (Can it be done via a client

• Next Page