Automate Salesforce Reports with Flow

Can you automate Salesforce reports with Flow?

Quick Answer: Yes. Salesforce Flow can trigger scheduled report generation, distribute reports via email, and take action based on report results. Use a "Schedule-Triggered Flow" to run at defined intervals, query records with criteria matching report filters, and send formatted results or trigger follow-up actions.

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

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

Approach 2: Report Subscription (Native)

Salesforce also provides native report subscriptions without Flow:

Open any report
Click "Subscribe"
Set schedule (daily or weekly)
Add conditions (only send if record count > 0, or if a field value exceeds a threshold)
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