Dropshipping Order Transmission
Online Shop — Paint by Numbers
The Challenge
A personalised paint-by-numbers online shop received orders via Shopify — with varying motifs, sizes and colours. Each order had to be manually extracted from the shop email, entered into the dropshipper's Google Sheet, and size/colour combinations had to be translated into supplier-specific codes. For orders with a customer's own uploaded photo, there was the additional manual effort of file transfer. An error-prone, time-consuming process — especially at scale.
Process Transformation
Process Before
Process After
Automation Diagram
BPMN 2.0 — Make.com workflow architecture
My Approach
Fully automated pipeline with Make.com: an incoming Shopify order triggers a webhook. An AI handles the conversion of colour and size combinations into supplier codes — defined directly inside the Make.com prompt. The order automatically lands as a new row in the dropshipper's Google Sheet. If a customer uploads their own image, a second parallel workflow starts: the image is saved to Google Drive, and the link is automatically added to the Sheet. Finally, a WhatsApp message notifies the dropshipper.
Assessment
The Result
Every order — standard motif or custom photo — is processed fully automatically. No manual intervention, no transcription errors, no missed notifications. The dropshipper receives all the information they need immediately after the order is placed.
Similar project at your company?
Let's find out in 30 minutes how much time and money you can save through automation.
Book a free call