Loading

Exporting data from Salesforce to Google Sheets using MuleSoft Composer

Fecha de publicación: Jul 14, 2025
Descripción
When a record is created/ updated in a Salesforce Org, the details should be updated in a Google Spreadsheet using a Composer Flow. 
Solución

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
Número del artículo de conocimiento

000389662

 
Cargando
Salesforce Help | Article