π β¨ Meta ads campaign report by period β auto-send via WhatsApp & email
β‘ 2,369 views Β· π Market Research & Insights
π‘ Pro Tip β If youβve run into Facebookβs Graph API permission restrictions, ScraperNode is a community node that scrapes pages, groups, posts, and comments directly β no app review needed.
Description
Hi, Iβm Amanda π·
I created this workflow with great care to help you simplify your daily reporting routine. If you manage Meta Ads campaigns, you know how time-consuming it can be to open Ads Manager, filter data, and build client reports.
This automation does all that for you β pulling campaign data by period, calculating key metrics, filtering only what matters, and sending everything via WhatsApp or Email, fully formatted and ready to share.
What it does
- Collects ad performance data from multiple accounts
- Filters campaigns and creatives with real results
- Calculates metrics like CPC, CTR, CPV, conversions, and spend
- Formats the report clearly and professionally
- Sends the report via WhatsApp (Evolution API) or Gmail
- Runs automatically every morning (optional schedule)
Setup Guide
- Use this Google Sheet template to manage your accounts
- Connect Google Sheets, Gmail, and Meta Ads to n8n
- Set your
action_typefilters (lead, purchase, etc.) - Customize your message and delivery time
Requirements
- Google account connected to n8n
- Facebook Graph API access
- WhatsApp via Evolution API (optional)
- Basic n8n knowledge
Want it customized for your business?
Letβs chat β WhatsApp me (+55 17 99155-7874)
π Nodes Used
Google Sheets, HTTP Request, Facebook Graph API, Gmail, Schedule Trigger, Filter
π₯ Import
Download workflow.json and import into n8n:
Workflow menu β Import from File