The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
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.
Thanks, that was the part I cared about getting right.
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
Rope Street Tattoo, Brașov (fictional)
Problem solved: a solo tattoo artist loses tourist leads to midnight DM replies and a day's pay to every no-show. Now any message becomes a priced, deposit-paid booking in under a minute, and confirmations, reschedules and waitlist refills run on their own.
The client: Mara, one chair, around the corner from Strada Sforii. Gloves on 7 hours a day, so DMs wait until midnight. Every quote needs size, placement and colour: about 7 messages per booking. Tourists leave before she replies, and 1 client in 7 doesn't show up.
What I built in Lovable:
→ Front door: describe the idea in English, German or Romanian. AI reads it, but Mara's own rules set duration, price and deposit. Only times that fit the job and the customer's days in town. Stripe deposit, booked. Cover-ups and hands go to Mara instead.
→ Autopilot: confirm or move at 72 h, a second nudge at 48 h, unconfirmed slots released 24 h ahead and offered to the waitlist, prep reminders, online consent forms, aftercare and touch-ups.
→ Owner area: Today, Week, Needs you with drafted replies, paste-a-DM replies, and the numbers: in four weeks of demo data, 304 messages not written and 38 h 53 min saved.
→ A demo clock to fast-forward and watch it work.
Try it: https://rope-street-tattoo.lovable.app
Owner view: footer → Studio → Try the owner view → Demo clock
Case study: https://rope-street-tattoo.lovable.app/story
A tourist who books two days ahead lands inside the 72-hour confirmation step. Does that booking skip the confirm-or-move message, or does it get the 48-hour nudge straight away?
Just wrapped up an AI voice agent for a residential cleaning business 🎙️ It handles the full call end to end — checks service area, gives a live quote, checks real calendar availability, and books the appointment straight onto Google Calendar. Built with Vapi + n8n + Google Calendar API. Portfolio build, but fully working — swipe through the n8n workflow in the video 👀
#aiworkflow #automation #voiceai
GrowMint AI - AI Marketing Automation Website
An AI marketing automation experience designed around the needs of marketing teams, growth marketers, and digital businesses.
The interface brings campaign management, customer journeys, analytics, and AI-driven optimization into a focused SaaS product experience, making complex automation easier to understand and navigate.
Nice design