Integrate Google Sheets, Salesforce & Slack within 20 minute

Table of Contents

Introduction

In the previous blog post, we talked about What is MuleSoft Composer

and we covered the basic concept of the MuleSoft Composer and also covered the first use case Salesforce-to-Salesforce Integration.

In this blog post, we will cover a different use case where we are going to integrate Google Sheets with Salesforce and Slack within 20 minutes.

Use Case

You are working for a Company called pantherschools.com. Their Sales Team is Working over Google Sheet and do not have access to Salesforce.

Now, the requirement is when a new lead/prospect is created inside Salesforce it should sync to Google Sheets in near-real time and also a message should be posted into the Slack channel.

Prerequisite

To work on this scenario there are a few prerequisites that are given below

1. Access to Salesforce Developer Org
2. Slack Account
3. Google Sheets

If you do not have a Slack account you can signup for free Slack account from the slack.com official page.

Structure of the Google Sheet

As our use case is to take the data from the Google Sheets so you need to create a Google Sheet using your Gmail account.

Below is the structure of the Google Sheets

MuleSoft Composer Flow

We should always work on the solution on paper before we start developing/designing any solution over Salesforce or any other platform.

Here is the flow for our requirements.

•  When a new row is added to Google Sheets
• The MuleSoft composer should keep listening to the row added in Google Sheets
• Map the Google Sheets columns to the correct field of the target system.
• Post the message in the Slack channel
• Post the direct message in the Slack account

YouTube Video

Resources

• https://www.mulesoft.com/platform/composer
• https://docs.mulesoft.com/composer/ms_composer_overview