Stop Wasting Hours: n8n Daily Salesforce Sales Report
Build an n8n workflow to pull Salesforce data, fill Google Docs templates, and email daily reports via Outlook.
The problem: slow, error-prone daily sales reporting
Many sales teams spend the first hour of each day assembling yesterday's numbers: exporting Salesforce lists, copy-pasting into templates, formatting, and manually emailing a distribution list. This process is repetitive, fragile, and often leads to late or inconsistent reports that slow decision-making.
Before automation, reports are vulnerable to human error (missing fields, wrong filters), take valuable time from revenue-facing staff, and make it hard for leadership to get a consistent daily snapshot. That lack of timeliness lowers the quality of pipeline conversations and delays corrective action.
Solution overview: n8n workflow to aggregate, format, and deliver
The automated solution uses n8n as the orchestrator: a scheduled trigger runs daily, a Salesforce node pulls the relevant opportunity and activity data, a set/function nodes aggregate and compute KPIs, a Google Docs template is filled and exported, and the Microsoft Outlook node emails the final document to stakeholders.
At a glance the node sequence is: Cron Trigger -> Salesforce (SOQL) -> Function/Set (aggregate & format) -> Google Docs (create from template / replace placeholders) -> Google Drive (export as PDF) -> Microsoft Outlook (send email with attachment). Authentication uses OAuth credentials configured in n8n for Salesforce, Google, and Microsoft accounts.
Technical implementation details in n8n
Start with a Cron Trigger node set to your timezone and desired run time (for example 07:00 local time). Use a Salesforce node with a SOQL query such as: SELECT Id, Name, StageName, Amount, CloseDate FROM Opportunity WHERE LastModifiedDate >= YESTERDAY. In n8n, enable pagination or set returnAll to true to handle larger datasets and avoid missing records.
After pulling raw records, use a Function node (JavaScript) or Set node to compute KPIs: total closed amount, new opportunities, average deal size, top reps by closed amount. Create an HTML or plain-text block for summary sections and prepare a data object of replacements matching placeholders in your Google Docs template. Use the Google Docs node to 'copy from template' or 'replace text' operations, then export the result to PDF using the Google Drive 'Export' functionality. Finally, attach the binary PDF to the Microsoft Outlook 'Send Email' node; use dynamic fields in the subject and body to include today's KPIs.
Business benefits and measurable ROI
Automating this daily report removes repetitive work and cuts report generation time from hours to minutes. Example ROI: if two employees spend 1 hour each every workday composing reports, automation saves ~40 hours per month; at a fully-burdened cost of $50/hr, that's $2,000 monthly saved. Time recovered goes back to selling activities and higher-value analysis.
Beyond time savings, automation improves accuracy and consistency, delivering always-on, timely insights. Faster, reliable reporting enables sales leaders to act earlier on pipeline shifts, improving win rates and reducing churn from missed opportunities. The soft ROI from better decisions often exceeds the direct labor savings within a few months.
Before and after scenarios plus deployment best practices
Before: a Sales Ops rep manually exports Salesforce, edits a Google Doc template, and emails a PDF by mid-morning. The report sometimes misses late updates, formatting breaks, or is sent late. After: n8n runs at a set time, pulls all records, computes KPIs, produces a polished Google Docs report, exports it as PDF, and emails the distribution list automatically — consistently and on time.
Deployment tips: use environment variables for credentials and distribution lists, implement error handling with an IF node and an Error Trigger to notify admins on failures, and log outputs to a secure folder or Slack channel. Test workflows with a staging Salesforce account, monitor run history in n8n, and roll out iteratively — start with a summary email and then add attachments or per-rep digests. Small, measurable rollouts minimize risk and demonstrate ROI quickly.