Streamlining Content & Communications for a Marketing Agency
Client: Marketing Agency (confidential)
The Challenge
The agency managed social content for 12+ clients across Instagram, LinkedIn, and Twitter. Posts were being scheduled manually from a spreadsheet, team communication was scattered across email and WhatsApp, and performance reports took half a day to compile every Monday.
What I Built
- 01
Built an n8n workflow that reads from a shared Notion content calendar and automatically schedules posts via Buffer — triggered on publish-ready status change, no manual intervention.
- 02
Connected Slack as the central comms hub: all client feedback, approvals, and internal task updates now route through structured Slack channels. Eliminated back-and-forth email threads.
- 03
Automated weekly performance reporting: n8n pulls engagement data from each platform API, formats it into a Notion table and a Slack digest, and sends it every Monday at 8 AM.
- 04
Built a content approval loop: drafted posts are shared to clients via a lightweight web form (n8n webhook), clients approve or request changes, and the status in Notion updates automatically.
In Practice
The agency came to me with a problem I see constantly: workflows that worked fine at 3 clients don't scale to 12. Each new client added linear overhead — another spreadsheet tab, another WhatsApp group, another manual export on Monday morning.
The first thing I did was map every touchpoint: where does content originate, who approves it, where does it go, and what feedback loop exists? The bottlenecks were obvious once drawn out. The Notion calendar was already there and everyone trusted it. I just needed to make it the source of truth for everything downstream.
The n8n workflow architecture has three main branches: publish triggers (watches Notion for status changes), comms routing (translates Notion comments into structured Slack messages), and reporting (runs on schedule, aggregates API data, formats and delivers). Each branch is isolated so a failure in one doesn't affect the others.
The client approval form was the most-used feature after deployment. Clients stopped emailing round-robin feedback threads and just clicked a button. The agency team could see approval status in real time from Notion. Three months in, the Monday morning scramble is gone.
Stack Used
Have a similar problem?
Let's talk about automating it.