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)

---