Generate Meta Ads campaign reports in Google Sheets and send Telegram alerts

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 1. Schedule Trigger starts the workflow on a defined schedule. 2. 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: - adaccountid - accesstoken - reportsheeturl 3. Loop Over Items processes each client individually. 4. Code (ctx) prepares the current client context (account ID, token, report sheet URL). 5. HTTP Request calls the Meta Ads Insights endpoint and retrieves campaign-level metrics. 6. IF checks the response (skip if no data). 7. Merge combines client context + API response. 8. Code (Split campaigns) converts the campaigns array into individual items (one per campaign) and formats metrics for reporting. 9. Code (Extract spreadsheetId) extracts the spreadsheet ID from the report URL. 10. Google Sheets (Append row) writes each campaign row into the client’s report sheet. Example report structure: 👉 Campaign Report Template 11. Code (Summary & Status Logic) aggregates totals and applies campaign diagnostics. 12. 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 (datestart) - 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. 1. Create a Google Sheets client register with: - adaccountid - accesstoken - reportsheeturl 2. Connect Google Sheets credent