Automated marketing performance email reports with Google Sheets & Outlook

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 reporting without manual data processing.

What This Workflow Does

This automated workflow: - Retrieves marketing campaign data from Google Sheets - Calculates 5 key performance metrics (customers, campaigns, clicks, conversions, spend) - Merges all statistics into a single data object - Sends a professional HTML email report with modern styling - Can be run manually or scheduled for regular reporting

The workflow processes data including Customer ID, Campaign names, Clicks, Conversions, and Spend amounts to generate comprehensive performance summaries.

Tools & Services Used

- N8N - Workflow automation platform - Google Sheets - Marketing data source and storage - Microsoft Outlook - Email delivery system - HTML/CSS - Professional report formatting

Step-by-Step Implementation

Step 1: Set Up Your Google Sheets Data Source