Automated marketing performance email reports with Google Sheets & Outlook
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 9 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and Microsoft Outlook.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get Google Sheets Data (Google Sheets): uses Google Sheets
- Count Unique Customers (Summarize): summarizes / groups the items
- Count Unique Campaigns (Summarize): summarizes / groups the items
- Sum Total Clicks (Summarize): summarizes / groups the items
- Sum Total Conversions (Summarize): summarizes / groups the items
- Sum Total Spend (Summarize): summarizes / groups the items
- Merge: merges the data from its input branches
- Send Email Report (Microsoft Outlook): uses Microsoft Outlook
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (5)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Summarize
n8n-nodes-base.summarize - Microsoft Outlook
n8n-nodes-base.microsoftOutlook - Merge
n8n-nodes-base.merge
From the author
This n8n workflow template automatically pulls marketing data from Google Sheets, calculates key performance metrics, and sends beautifully formatted HTML email reports. Perfect for marketing teams, agencies, or businesses that need regular performance…