Daily Meta Ads report: data to Google Sheets and HTML e

This automation workflow fetches yesterday´s ad performance metrics from Meta Ads, processes them, and delivers structured data to both Google Sheets for analysis and as an HTML-formatted email report. Designed for marketers, agencies, and business owners who need consistent, hands-free monitoring of advertising efficiency.

## Who it´s for
- Marketers managing Facebook/Instagram ad campaigns
- Agencies delivering daily client reporting
- Business owners tracking ad spend and ROI
- Analysts consolidating multi-source data into spreadsheets

## What the automation does
- Triggers daily at 9:00 AM via cron schedule
- Pulls yesterday’s campaign metrics from Meta Ads using Graph API
- Processes raw JSON response and extracts key KPIs: spend, results, CPM
- Writes cleaned data into a designated Google Sheet
- Generates an HTML-formatted report
- Sends the report via Gmail to predefined recipients
- Supports centralized management across multiple clients or accounts

## What´s included
- Ready-to-use n8n workflow
- Cron-based trigger logic and data handlers
- Integrations with Meta Ads (Graph API), Google Sheets, and Gmail
- Basic setup and adaptation guide

## Requirements for setup
- n8n instance (cloud or self-hosted)
- Meta Business Manager access with Ads Read permissions
- Google Account with Google Sheets API enabled
- Gmail account with API send permissions
- Basic understanding of API keys and environment variables

## Benefits and outcomes
- Saves time on manual data export and formatting
- Ensures consistent daily reporting without delays
- Centralizes historical campaign data in Google Sheets
- Delivers professional-looking HTML reports for stakeholders
- Easily scalable across multiple clients or campaigns
- Reduces human error in data handling

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via в чате.