Agüita / the owner's reporting job, killed
Problem: Agüita, the stainless-steel bottle brand I acquired, ran, and later sold in Tenerife (physical stock, B2B wholesale, in-house laser engraving), had me as its reporting department. Every week I pulled Shopify and GA4 numbers by hand to see what was selling and where the store stood: two to three hours of it, every week. First job I fired myself from.
System: Make scenario pulls Shopify + GA4 data nightly → writes to a Google Sheets master → digest lands in Slack every morning, summary every Monday at 7am. Error alerts on failure.
Result: Reporting ran itself from launch until the day I sold the brand. The same brand also ran an automated revenue-split report for a collab: tagged-SKU sales, extracted and delivered to the partner, another three to four hours a month I stopped spending. I was the test bench.