MuleSoft Composer - A example

Introduction to MuleSoft Composer:
MuleSoft Composer represents a paradigm shift in integration, offering a low-code approach that empowers users to design comprehensive automations spanning multiple systems with just a few clicks. Leveraging its intuitive interface, MuleSoft Composer provides a streamlined experience, significantly reducing the need for extensive coding expertise. With an extensive library of pre-built connectors—including popular platforms like NetSuite, Tableau, Slack, Workday, Teams, Stripe, Twilio, Google Sheets, Salesforce, and more—MuleSoft Composer simplifies the process of automating integrations between various systems.
By embracing MuleSoft Composer's low-code methodology, users can automate workflows and orchestrate seamless integrations without the complexities of traditional coding practices. In the upcoming article, we'll delve into a practical example, illustrating how effortless it is to establish integration between Google Sheets and Slack using MuleSoft Composer. Stay tuned to witness firsthand the simplicity and efficiency of MuleSoft Composer in action.
 
Starting with MuleSoft Composer:
1. Sign in to your Salesforce Org that has MuleSoft Composer activated.
2. Make a new Flow. A Flow is like a blueprint that shows how different parts of a system work together.

3. After creating a new flow, you'll see two options:
    1. System Events: Pick this if you want your flow to start when certain system events happen, like actions in Salesforce, NetSuite, Teams, and more.
    2. Trigger: Use this option to start the flow at specific time intervals.

Let's see how to connect Google Sheets with Slack:
Google Sheets: It's an online tool for making and editing spreadsheets right in your web browser.
Slack: This app is widely used for messaging in workplaces.
Goal: We want to send information from Google Sheets to Slack channels. The Google Sheets have data about employee purchase limits. If the requirement exceeds a certain amount, send the message to the supervisory channel; otherwise, send it to the manager.

1. Let's Get Started: 

Rename your flow to whatever you want.

 
 
2. Choose System Event

3. From the available options, select Google Sheets

4. Click on “Add new Connection” like shown below

5. Set a name for your connection

6. Click on “Create”
7. Choose “Sign in with Google”
 
 

 8. Choose your google account
 

 
9. Click “Continue”
10. Make sure you have a Google sheet ready which contains the required data
 
 

If the expense exceeds $15,000, we'll route the message to the SUPERVISORY CHANNEL for approval. If it's less than $15,000, the message will go to the manager via Slack.
We're now updating the trigger to reflect this.

 
We're selecting "New Row" so that whenever a new row is added to the spreadsheet, it will trigger the flow automatically. Next, under "Select Fields," we're choosing all the fields that were mentioned in our spreadsheet.
 
 

13. Click “Apply”
14. In the next step choose for a if/else block
 

 
You have the option to create your own condition by selecting "custom expression" or choose from the available options in the dropdown menu.

As Mentioned above, if the cost greater than $15,000 then we want the message to be posted to the supervisory Slack channel.
 
 

 
15. Click on the '+' symbol.
16. Select a system action.
17. Choose Slack.
18. Log in to Slack just like we did for Google Sheets.
19. Once logged in, select "Post message to channel" or choose to send a direct message or email from the available options.
20. Select the person's name or a random name from the list.

21. For the message, select "custom expression" and write the desired message. Then click "Apply."
22. Add an else condition.
23.In the next screen, select system actions from the available options. I'm choosing Slack again.
24. Design the else block in the same way as before

25. Click on "Test."
26. Once the Flow runs successfully without any errors, you can add new data to the spreadsheet

Once the data in Google Sheets is updated, you should see a message in Slack similar to the one shown below.
 

If everything is working as expected at this point, you can click on "Activate" to deploy the application and enable the flow to run continuously.

Congratulations! You've successfully built a Google Sheets and Slack Integration without writing any code!