Weekly reporting automation for Oakhaus
A Monday-morning report compiled automatically from five tools and delivered to Slack. A case study by Omar Farouk, Automation Specialist (Make, Zapier, n8n).
Challenge
A marketing analyst at Oakhaus, a solid-wood furniture brand, spent every Monday morning copying numbers from five tools into a slide deck.
Solution
I automated data collection from ads, analytics, CRM and billing with Google Apps Script and APIs, calculated week-over-week changes and delivered a formatted report to Slack and email.