Hi, I’m Amina
Hi, I’m Amina I built this workflow to remove the daily pain of Meta Ads reporting. If you manage multiple ad accounts, you know how time-consuming it is to open Ads Manager, export campaign data, clean spreadsheets, and send updates to clients. This automation pulls campaign performance directly from the Meta Ads API, writes structured data into Google Sheets (per client), generates a performance summary, and sends a Telegram alert when the report is updated. It transforms manual reporting into a fully automated monitoring system. What it does Reads a list of clients/ad accounts from a Google Sheets “client register” Fetches campaign-level performance data from the Meta Ads API Splits the campaign results into clean, row-ready records Appends each campaign as a new row in the client’s Google Sheets report Calculates aggregated performance metrics Applies campaign diagnostics logic Sends a Telegram notification with summary + alerts Runs automatically on a schedule (daily/weekly) How it works Schedule Trigger starts the workflow on a defined schedule. Google Sheets (Get rows) loads your client register (one row per client). Use this template structure for the client register: 👉 Client Register Template The register should include: ad_account_id access_token report_sheet_url Loop Over Items processes each client individually. Code (ctx) prepares the current client context (account ID, token, report sheet URL). HTTP Request calls the Meta Ads Insights endpoint and retrieves campaign-level metrics. IF checks the response (skip if no data). Merge combines client context + API response. Code (Split campaigns) converts the campaigns array into individual items (one per campaign) and formats metrics for reporting. Code (Extract spreadsheetId) extracts the spreadsheet ID from the report URL. Google Sheets (Append row) writes each campaign row into the client’s report sheet. Example report structure: 👉 Campaign Report Template Code (Summary & Status Logic) aggregates totals and applies campaign diagnostics. Telegram sends a structured performance summary including: Total metrics Campaign-level highlights Status alerts Direct link to the report Data captured (campaign level) Ad account ID Report date (date_start) Campaign name Spend Impressions Clicks CTR CPM CPC Date start / Date stop Summary Generation Logic After writing campaign rows to Google Sheets, the workflow generates a performance overview using a JavaScript node. Aggregated calculations: Total Spend** = sum of all campaign spend values Total Impressions** = sum of impressions Total Clicks** = sum of clicks CTR** = (Total Clicks / Total Impressions) × 100 CPC** = Total Spend / Total Clicks The workflow then: Formats the totals into a readable performance summary Lists campaign highlights Applies status diagnostics Appends the Google Sheets report link Sends everything via Telegram This provides both structured spreadsheet reporting and a quick executive snapshot. Status Logic (Campaign Diagnostics) Each campaign is automatically evaluated based on CTR and CPC thresholds. Status Rules Weak Creative (❌) If CTR < 1.5% → Indicates low engagement. The ad creative may need improvement. Expensive Click (⚠) If CPC > 0.5 → Indicates high cost per click. Audience targeting or bidding strategy may need optimization. Good Candidate to Scale (🔥) If CTR ≥ 2% AND CPC ≤ 0.5 → Strong performance. The campaign may be suitable for scaling. OK (✅) If none of the above conditions are met → Campaign performance is within an acceptable range. The status appears directly in the Telegram notification, allowing marketers to quickly identify which campaigns need attention without logging into Ads Manager. How to set up Estimated setup time: 10–20 minutes. Create a Google Sheets client register with: ad_account_id access_token report_sheet_url Connect Google Sheets credentials in n8n. Add your Meta Ads API access token (do not hardcode API keys in nodes). Connect your Telegram bot and set the destination chat ID. Adjust the schedule (daily/weekly) and run a test execution. Requirements Meta Ads API access token (Facebook Graph API) Google Sheets credentials Telegram bot token + chat ID How to customize Add additional metrics (e.g., conversions, purchases, ROAS) by extending Meta API fields. Modify CTR/CPC thresholds in the Status Logic section. Change the report structure in the “Split campaigns” step. Switch notifications from Telegram to Slack or Email. Add filters (e.g., only active campaigns, only spend > X). Benefits Fully automated reporting Multi-client support Dynamic spreadsheet handling Built-in KPI calculations Automated campaign diagnostics Instant performance alerts Scalable agency-ready structure. An n8n automation workflow template by Amina Doszhan.
Amina Doszhan
web
free
Others in the same category, ranked by how often they are opened.
