✨ Meta ads campaign report by period – auto-send via WhatsApp & email

by Amanda Benks ✓ · 2,563 views · created 2025-04-17 · Market Research

What this workflow does

This workflow has 17 nodes and runs on a schedule (every day). Along the way it connects Google Sheets, Facebook Graph API and Gmail.

How it runs

Trigger: On a schedule (every day).

1. Filter: keeps only the items that match a condition
2. Ad Accounts (Google Sheets): uses Google Sheets
3. Click Next (Loop Over Items (Split in Batches)): loops over the items in batches
4. Set Data (Edit Fields (Set)): sets or maps fields
5. Ads by Period (Facebook Graph API): uses Facebook Graph API
6. So if (If): checks a condition and branches into true / false
7. Data by Creative (Code): runs custom JavaScript code
8. Save Data (Google Sheets): uses Google Sheets
9. Filter if there was Conversion (If): checks a condition and branches into true / false
10. Rename Titles (Edit Fields (Set)): sets or maps fields

…plus 5 more steps. See the full node list below.

Services it uses

Google SheetsFacebook Graph APIGmail

Before you upgrade to n8n 3.0

Nodes used (13)

• Aggregaten8n-nodes-base.aggregate
• Filtern8n-nodes-base.filter
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Google Sheetsn8n-nodes-base.googleSheets
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• Edit Fields (Set)n8n-nodes-base.set
• Facebook Graph APIn8n-nodes-base.facebookGraphApi
• Ifn8n-nodes-base.if
• Switchn8n-nodes-base.switch
• Gmailn8n-nodes-base.gmail
• HTTP Requestn8n-nodes-base.httpRequest
• No Operation, do nothingn8n-nodes-base.noOp
• Coden8n-nodes-base.code

From the author

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…

View the original on n8n.io → Check your own copy