Computer monitor and text that says, "Automate with MuleSoft Composer."

Automate Your Business Process with MuleSoft Composer

By

Importing and exporting data is incredibly useful. But as any admin can tell you, it can also be very time-consuming. Data loads often require manual adjustments, ID mappings, and troubleshooting.

Your time is valuable, and automating this process can make you a more efficient admin, freeing you up for important feature requests or maintenance. Historically, this automation has been tough. It required middleware, custom code, and IT partners. But did you know, dear Salesforce Admin, that you can integrate and automate your data with clicks?

I’ve got an exciting use case to share, but let’s discuss a few practices first.

First, MuleSoft Composer isn’t intended for high-volume extract, transform, and load (ETL) operations. But it’s perfect for automating tedious and manual data loads that are a regular part of your business processes.

Second, all of the steps contained in this article should be configured in a sandbox environment and thoroughly tested before moving to a production environment.

So here’s our use case: Northern Trail Outfitters (NTO) uses Google Forms and Google Sheets to collect suggestions from employees. Maria, NTO’s #AwesomeAdmin, has to review the Google Sheet each week, export to .csv, and then data load into Salesforce, where each row becomes a Suggestion record. The store operations team reviews the suggestions in Salesforce and chooses which suggestions to implement.

But Maria sees the data load as an unnecessary manual step in an otherwise automated business process. So, that’s why she wants to…

Automate with MuleSoft Composer

A list of MuleSoft Composer’s prebuilt connectors including Google Sheets.

MuleSoft Composer lets you choose prebuilt connectors to many popular services. It’s as simple as click, authenticate, and configure. Let’s take a look.

First, Maria clicks the Google Sheets icon and names the connection.

 Configuring the Connection Display Name as NTO Google Suite.

Then, Maria chooses her preferred Google account. As a best practice, we recommend creating an account specifically for this integration. Next, Maria approves the permission scopes.

 The Google sign-in screen.

After that? Maria is connected!

Configuring the Google Sheets trigger.

Once Maria’s connection is established, she can choose the event within Google Sheets that starts the automation process. She can trigger the flow when a new row is added to an existing spreadsheet, when a new spreadsheet is created, or when a row is updated in an existing spreadsheet.

Google Sheets trigger options including New Row, New Spreadsheet, and Updated Row.

In our example, Maria triggers the flow whenever a new row is created. Then, she chooses a spreadsheet from her preferred Google account and a worksheet within that spreadsheet.

Choosing which spreadsheet and worksheet should trigger the Composer flow.

Now that Maria has chosen a worksheet, she can select the fields she wants to bring into Salesforce. Clicking the Select Fields button brings Maria to an intuitive, clean interface.

A list of available fields to use in the Composer flow.

After selecting the fields she wants to bring into Salesforce, Maria’s ready to add a step by clicking the + below the triggering event.

A screen displaying that all fields from the spreadsheet have been selected.

Maria is then presented with the same option for connectors.

A list of MuleSoft prebuilt connectors, including Salesforce.

Maria selects Salesforce, names her connection, and clicks Create.

A screen with the Connection Display Name, which has been set to “NTO Salesforce Instance”.

Maria is prompted to authenticate into her Salesforce org. Remember, as a best practice, you should configure this in a sandbox and test it thoroughly.

The Salesforce login screen.

Then, she allows access.

The Salesforce allow access screen for MuleSoft Platform STG.

Now, she’s connected to Salesforce! Maria can take several actions, like creating, updating, deleting, or retrieving record information. Since we’re trying to automate data and save ourselves time on data loads, Maria chooses “Create new record” for her custom Suggestion object.

Configuring the Salesforce event to create a new Suggestion record.

Next, she chooses the fields she wants to populate, which is a simple field mapping exercise very similar to the Salesforce Data Import Wizard.

A screen showing the field mapping from Google Sheets columns to Salesforce fields.

And that’s it! She saves and activates the flow.

Name this flow dialogue window for the Suggestion Box Composer Flow.

The end result? A really clean list of Suggestion records in Salesforce.

A list of Suggestion records in Salesforce.

Maria made sure to follow best practices as she went along. She built her connection in a sandbox first, tested along the way, confirmed her Composer flow worked as designed, swapped her connection to production, tested again, and then activated her Composer flow.

It’s really that easy! If you’re an admin finding that your time is disappearing into the rabbit hole of data cleansing, exporting, importing, and troubleshooting, consider giving MuleSoft Composer a try. If you want to start learning right away, check out this awesome MuleSoft Composer Trailmix.

Resources

Image of Salesforce characters on a green field next to text that says, "Trailblazer DX '22 Admin Recap."

6 TrailblazerDX ’22 Takeaways for Salesforce Admins

Two weeks ago, TrailblazerDX returned, marking our first big in-person event together in more than 800 days! The energy, enthusiasm, and excitement on-site was equally matched by those joining us on Salesforce+, with two full days of content, connection, and collaboration. From keynotes to campfires and everything in between, TDX ’22 was full of knowledge […]

READ MORE
Cloudy in the meadow next to text that says "Transform Your Data with the MuleSoft Composer Custom Expression Editor."

Introducing the MuleSoft Composer Custom Expression Editor

As admins, you know that the needs of your business stretch beyond the bounds of a cookie-cutter approach—especially when it comes to integrations and automation. We kept this in mind as we built MuleSoft Composer for Salesforce, the no-code integrations and automation tool built for admins. Today, we are introducing a new formula editor feature […]

READ MORE

Have an Idea for a Story?

We are all about the community and sharing ideas.
Do you have an interesting idea or useful tip that you want to share?

SHARE YOUR IDEA