E-commerce automation and reporting
A headless Shopify store in six languages, with n8n syncing orders, ads and site data into one dashboard and an AI-written weekly report.
1 / 10
- Client
- E-commerce brand, Sweden
- Industry
- E-commerce
- My role
- Storefront build, integrations and automation
- Stack
- LovableShopifyn8nAirtableOpenAIGA4Meta AdsGoogle AdsTikTok Ads
The goal
Give the owners one place to see sales, ads and site data across all markets, without pulling reports by hand.
What I built
- A headless Lovable storefront on Shopify Markets: six languages, local currencies, and shipping rules per market
- Shopify webhooks to Airtable for orders, refunds, cancellations, stock and attribution, HMAC-verified with deduplication
- A daily sync of TikTok, Google and Meta Ads data via API
- A daily GA4 sync, total and per country, matched with Shopify orders
- An Airtable dashboard with all-time, 30-day and 7-day views, with old Wix history merged into Shopify data
- A weekly report written by OpenAI and emailed to the owners: revenue, orders, products and countries vs last week, plus next steps
- A returns and complaints flow with up to 5 photos or videos, routed by type
- Low stock alerts by SMS
Walkthrough
Result
The owners get one dashboard and a weekly summary instead of checking five tools. Figures hidden.