Automated weekly ad performance reporting with n8n and the Meta Marketing API The problem: 🔥 Agencies running paid ads for clients usually report performance manually: logging into Meta and Google dashboards, pulling numbers, writing a summary, and emailing it out every week. It's repetitive, easy to forget, and gets inconsistent the busier the agency gets.

What I built🧠 A scheduled n8n workflow that runs every Monday morning and handles the full reporting cycle without manual input.

How it works🚀

A schedule trigger fires early Monday morning

An HTTP Request node authenticates with the Meta Marketing API and pulls the latest ad account insights (spend, impressions, clicks, CTR, CPC)

The response is cleaned and mapped into a consistent format

An IF node checks whether there's real data to report

If there is, the data is handed to an AI step that writes a short, plain English summary of the week's changes, which is then logged and emailed

If there isn't, the system sends a clear "no activity this week" notice instead of a blank or broken report

Why the no-data path matters👍 A lot of automations only handle the happy path and break or go silent when something unexpected happens, like a week with no ad spend. I built this one to handle that case explicitly, so the client always gets a message, even if the message is just "nothing to report."

Tools used: n8n, the Meta Marketing API, an AI model for the summary writing, Google Sheets for the data log, and Gmail for delivery.

What I'm adding next GA4 data alongside the Meta Ads data, and a Looker Studio dashboard reading from the same sheet, so one template can be reused across multiple client accounts.

Nice that the IF branch catches empty weeks, so clients get a clear note instead of a broken email.

I built an AI-powered lead qualification workflow in n8n that turns every form submission into a fast, personalised follow-up. An AI agent qualifies each lead as hot, warm, or cold. Hot leads get a custom email written by a second AI agent, and the owner is notified right away. Warm leads get a professional template email, and the owner is notified too. Cold leads get a friendly, low-pressure reply. Every lead is logged to Google Sheets for easy tracking.

Result: every lead gets an instant reply, and the business owner only spends time on the leads that matter.

Tools: n8n, AI agents, Gmail, Google Sheets.

The AI drafted email for hot leads cuts the response time to seconds. Having every lead auto logged to Google Sheets gives a tidy view for the owner.