Automated Marketing Performance Email Report

This n8n workflow automates the process of gathering marketing campaign data from Google Sheets, analyzing key metrics, and sending a detailed HTML report via email. Triggered manually, it fetches data such as customer reach, campaigns, clicks, conversions, and spend. The workflow then summarizes these metrics—counting unique customers and campaigns, and summing total clicks, conversions, and spend. Finally, it compiles the results into a professional HTML email template, offering a visual and comprehensive marketing performance report sent through Microsoft Outlook. This automation is ideal for marketers and business owners seeking quick, reliable insights without manual effort, enhancing decision-making and reporting efficiency.