End to End Ecommerce Automation Engine

A Dutch custom framing DTC brand needed a fully automated operational system to handle customer proposals, order processing, logistics, and CRM lifecycle without manual intervention at every step. I architected and deployed the entire system from scratch across 8 connected platforms.

Custom Admin Tooling (Google Apps Script): Built a Proposal Manager Sidebar embedded directly inside Google Sheets that pulls live Shopify product pricing via REST API, compresses client uploaded artwork images client side, uploads to Google Drive, and enforces packaging type validation before saving, giving the business owner a one click curation workflow with zero developer dependency.

Dynamic Proposal Web App (Netlify + GViz): Engineered a custom single page proposal app hosted on Netlify that reads live data from Google Sheets via the GViz CSV endpoint with cache busting timestamps, bypassing Google's 5 minute CDN delay for instant previews. Customers view framed artwork proposals, request revisions, and submit choices directly from the page.

Automated Shopify Checkout Generation (Draft Order API): Built Make.com webhook listeners that receive customer proposal choices and instantly generate prefilled Shopify checkout URLs via the Draft Order API, passing Artwork Title, Chosen Edit, frame specifications, and discount codes as line item properties visible in both customer checkout and Shopify Admin.

Dual Branch Order Routing Logic: Engineered a state machine in Google Sheets that routes Digital and Physical orders into entirely separate fulfillment branches. Digital orders bypass logistics entirely; Physical orders trigger a full dual label logistics pipeline.

Bi Directional Logistics Automation (Sendcloud API): Automated outbound packaging kit label generation (PostNL Brievenbuspakje+ or Standaard Pakket based on packaging type) and inbound prepaid return label creation simultaneously, with PDF labels uploaded to Google Drive and delivered to customers via Klaviyo automatically upon payment.

15 Flow Klaviyo Email Matrix with Auto Halt Logic: Designed a 15 email transactional and nurture lifecycle in Klaviyo triggered by custom Make.com events. Reminder sequences include 1 click action buttons that fire webhooks to immediately halt follow up flows the moment a customer responds, declines, or places an order.

Automated 10 Day Expiry Engine: Built a daily scheduled Make.com scenario (01:00 AM) that scans all active proposals, automatically expires those inactive beyond 10 days, and resets the expiry timer to zero each time a revised proposal is dispatched.

Result: Reduced operational overhead by ~95% for a solo operated European DTC brand, enabling the business owner to manage the full customer lifecycle, from intake to final delivery, without manual follow up, manual label creation, or manual CRM updates at any stage.