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

Automate Your Business Process with MuleSoft Composer


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.


Cloudy standing near a cliff and text that says, "Easy Integrations with Flow HTTP Callouts."

Integrations Are Easier Than Ever with Flow HTTP Callouts

Are you tired of waiting for IT resources to build out an integration to your supplier? Are you frustrated that your payroll system lacks reliable application programming interface (API) documentation, leaving your IT team to weed through JSON and just hoping it’ll work? Then Flow HTTP Callout is for you! This feature does the hard […]

Max sitting on a log next to text that says, "How to Integrate Salesforce Flow with MuleSoft RPA."

How to Integrate Salesforce Flow with MuleSoft RPA

Salesforce Flow empowers you to build complex business solutions using clicks, not code. Flow RPA provides the ability to automate repetitive tasks using RPA Bots. Together, admins can build powerful business workflows to achieve end-to-end automation. Let’s assume we have a use case for document processing. For this use case, we’ll need the ability to […]