Can you automate Salesforce reports with Flow?

Automating Salesforce Reports with Flow

Salesforce Flow provides multiple ways to automate reporting: scheduled flows that query data and distribute results, record-triggered flows that update report-relevant fields, and flows that call the Salesforce Reports API. As of April 2026, these features are available in Enterprise Edition and above.

Approach 1: Schedule-Triggered Flow

1. Create a new "Schedule-Triggered Flow"
2. Set the schedule (daily, weekly, monthly)
3. Add a "Get Records" element to query the data (equivalent to a report filter)
4. Add a "Loop" element to iterate over results
5. Build a text template with the formatted report data
6. Add a "Send Email" action to distribute the report

Approach 2: Report Subscription (Native)

Salesforce also provides native report subscriptions without Flow:

1. Open any report
2. Click "Subscribe"
3. Set schedule (daily or weekly)
4. Add conditions (only send if record count > 0, or if a field value exceeds a threshold)
5. Choose delivery: email notification or Chatter post

Approach 3: Flow + Analytics API

For complex reporting, use an Apex-invocable action within Flow to call the Analytics REST API, retrieve report results, and process them programmatically.

Common Report Automations

Weekly Pipeline Summary

• Schedule: Every Monday at 8 AM
• Query: Open opportunities with close date in next 30 days
• Group by: Sales rep, stage
• Action: Email summary to VP Sales with total pipeline value

Overdue Task Alert

• Schedule: Daily at 9 AM
• Query: Tasks where due date < today AND status is not "Completed"
• Action: Send email to each task owner with their overdue items

Monthly Revenue Report

• Schedule: First business day of each month
• Query: Opportunities closed won in previous month
• Calculate: Total revenue, average deal size, win rate
• Action: Post to Chatter group "Sales Leadership" with formatted summary

Limitations

• Schedule-Triggered Flows can process up to 250,000 records per batch
• Flow cannot directly render charts or graphs (text and table format only for email reports)
• For visual dashboards, use Salesforce native dashboards with scheduled refresh
• Flow-generated emails have a 15 MB size limit per email action