The problem
The client’s operations team was running a 50-person agency on a stack of disconnected tools. Every new client onboarding required a person to manually copy data between Shopify, HubSpot, Notion, and Slack. Mistakes were normal. The error rate on cross-system data sync was around 12%.
The client had tried Zapier and outgrown it inside six months. Workflows had become brittle, were undocumented, and only one person knew which ones still worked.
What we built
A self-hosted n8n instance running a documented automation backbone.
- Client onboarding: A single trigger (deal closed in HubSpot) provisions the Shopify customer record, the Notion project workspace, the Slack channel, the shared drive folder, and the kickoff email, in order, with retries and rollback.
- Order lifecycle: Shopify order events flow into HubSpot deal updates, Notion project status, and a daily ops digest in Slack with AI-summarized highlights.
- Renewal pipeline: Cron-driven workflow that pulls upcoming renewals from HubSpot, generates a personalized outreach draft via OpenAI, and queues it for human approval.
- Observability: Every workflow logs to a central dashboard. Failures trigger a Slack alert with the failed payload and a one-click retry.
- Documentation: Each workflow has a one-page README in Notion with what it does, who owns it, and how to extend it.
How we approached it
Two days mapping the existing workflows on a whiteboard. We measured the time cost and error rate of each. Then we prioritized: replace the four most expensive workflows in the first sprint, and only build new ones once the existing ones were stable.
We deliberately built the workflows so the ops team could read and modify them themselves. No “magic” Code nodes where it wasn’t necessary.
The outcome
After three months:
- 14 manual workflows replaced with n8n automations
- 24 hours per week of ops time recovered (verified via time tracking before/after)
- Cross-system sync error rate fell from 12% to under 1%
- The ops lead now extends workflows without needing us
- The client renewed for a Phase 2 covering finance and reporting automation