Loading

Exporting data from Salesforce to Google Sheets using MuleSoft Composer

Publiseringsdato: Jul 14, 2025
Beskrivelse
When a record is created/ updated in a Salesforce Org, the details should be updated in a Google Spreadsheet using a Composer Flow. 
Løsning

Steps to follow to create a row of data in Google Spreadsheet using a Composer flow. 

  1. Create a Composer Flow
  2. Configure the Trigger event: 
    • Select Salesforce connector
    • Set up the connection by Authenticating the Salesforce credentials (Source Org)
    • Choose the "New Record" event to start the flow
    • Choose the Object type that caters to the requirement
    • Select the fields (This is an optional step). To optimise the flow it is recommended to select the fields as per the requirement, as we will be using those in the next steps. By default, all the fields from that object will be returned.
  3. Configure the Action event: 
    • Select Google Sheets connector
    • Set up the connection by Authenticating the credentials
    • Choose the "Create row" event to create a new row of data in the spreadsheet
    • Select the Spreadsheet and Worksheet
    • Add the columns from the spreadsheet and map them with the fields from the source org
  4. Save the Flow (Make sure the flow is named for future reference)
  5. Test the Flow will live data
  6. Activate the flow
Knowledge-artikkelnummer

000389662

 
Laster
Salesforce Help | Article