Loading

Exporting data from Salesforce to Google Sheets using MuleSoft Composer

게시 일자: Jul 14, 2025
상세 설명
When a record is created/ updated in a Salesforce Org, the details should be updated in a Google Spreadsheet using a Composer Flow. 
솔루션

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 기사 번호

000389662

 
로드 중
Salesforce Help | Article