WSO2 is now Choreo LabsLearn more

Trusted AI Governance
Build

Create agents and AI apps with the tools and languages your teams already use.

Connect

Link agents securely to your APIs, data, models and business systems.

Run

Deploy, observe and operate agents and AI apps reliably at any scale.

Govern

Control identity, access, cost and policy for every agent in production.

Agent Management

Developer Platform

  • API Management Cloud

    Design, secure and publish APIs with governance and analytics built in.

    Sign Up Now
  • Integration Cloud

    Connect apps, data and AI agents with low-code and pro-code integration.

    Sign Up Now
  • Identity & Access Management Cloud

    Secure sign-in and access for customers, partners, workforce and agents.

    Sign Up Now
  • Agent Management Cloud

    Build, run and govern AI agents with full visibility and control.

    Sign Up Now
  • Developer Platform Cloud

    Ship cloud-native apps faster on an internal developer platform.

    Sign Up Now

Self-Hosted

Full control over your stack. Deploy directly to your own servers, bare metal, cloud, or Kubernetes environment. Your data never leaves your perimeter.

Product Downloads
Choreo Labs
AI Governance
Platform
Solutions
Resources
Blog

How to synchronize new Salesforce leads to Google sheets and get gmail notifications using WSO2 connectors

WSO2 provides Connectors dedicated to the most popular business-critical services that you will need such as SalesForce, Amazon, Twitter, Google, SAP &  Microsoft Dynamics. You can simply download the required connector from the WSO2 Connector Store and plug it into your integration flow with just a few clicks.

One such simple solution is exporting Salesforce leads to Google sheets. This lets you create your own Customer relationship management (CRM) system and a sales pipeline based on your email data. You can even use this information to send customized mailers to selected target groups.

Let's take a look at how you can use the Salesforce SOAP connector to get details of new leads to use the Google Spreadsheet connector to add that information to a spreadsheet.

This is a pre-built solution. The  required artifacts can be downloaded via the WSO2 Store. *You can even take a look at the source code here. 

  1.  To customize this solution for your own salesforce account, google docs, you have to configure the salesforce and google docs accordingly and obtain the required credentials.
  2. You can download the sample json file with default values. Update the json file with the credentials extracted in above step.
  3. You can deploy the solution in Integration Cloud using the artifacts downloaded in step1 and the environment variable json file modified in step3.
  4. Finally, to test this scenario create a new lead in Salesforce.

Your spreadsheet gets updated with the information you provided when creating the new lead and an email notification will be generated.

You can extend this solution by using  the WSO2 Developer Studio . The graphical interface of the Developer Studio makes it easier and faster for you to modify existing templates and customize to  your specific requirements.  

For a detailed step by step guide on how to integrate Salesforce leads to Google sheets visit the WSO2 Store!