Automated Report from Salesforce to Journey Builder

Salesforce Asked by CRM Admin on January 2, 2022

I am needing to automate a report in Salesforce to go to Journey Builder as a data extension but can’t find a good way to do so. I need Journey Builder to receive the updated report daily and then send out emails based on the report.

One Answer

You can create an import inside of email studio that will import a sales cloud report:

From there, you can setup an automation to run daily in automation studio that would look like this:

Import File>SQL Query>Journey Entry

Import File would import the sales cloud report you created, SQL Query would allow you to join to any other tables (Like Subscribers), Journey Entry to inject the results into your journey.



Answered by Kevin on January 2, 2022

Add your own answers!

Related Questions

Add CC/BCC in Journey Builder email send

3  Asked on January 9, 2021 by zuzannamj


Pulling Subscriber Status from Lists using SSJS

1  Asked on January 8, 2021 by shuckyducky


Mass Delete flow and flow versions

1  Asked on January 7, 2021 by ghosty


Create dynamic picklist in lwc

1  Asked on January 6, 2021 by ajinkyasd


Page layout assignments with XML metadata API

1  Asked on January 3, 2021 by baxter


Link is not rendering correctly for non-English emails

1  Asked on January 3, 2021 by mike-marks


Fail Record video Html

0  Asked on January 2, 2021 by daniela-cerqueira


Allow community-users to create employees for multiple accounts

1  Asked on January 2, 2021 by hans-christian-milman


On Lead Conversion update Contact field

2  Asked on January 1, 2021 by mahesh-raghuraman


Ask a Question

Get help from others!

© 2023 All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP