Home
About
Contact
All projects
E-commerce automation

Mindwell - Webshop Automation

End-to-end order management that runs itself

24 n8n workflows connect the Shoprenter webshop, Airtable, and Cloudflare. Every order is processed automatically, and video products reach the buyer on their own.

24
connected workflows
0 min
manual work per order
65+
automated steps

The challenge#

Mindwell is a fast-growing Hungarian webshop that sells physical products — vitamin courses, health supplements — alongside video content: online courses, workout programs, meditation series. When the daily order count reached several dozen, the team ran into serious problems.

Order management was entirely manual. Orders had to be individually transferred from the Shoprenter webshop to Airtable, payments verified against bank statements, notification emails sent, and video access managed. If a colleague was sick or on vacation, nobody else knew exactly where a given order stood. There was no system, just memorized rules and agreed-upon habits.

The biggest pain point was selling video products. After every single purchase, someone had to manually: upload the video to a streaming platform, generate a unique sharing link, set the expiration date, write and send the email to the buyer with the link, then note in the calendar when the access expires so it could be revoked. A single forgotten expiration or a wrong link caused serious customer dissatisfaction — and word travels fast for a small webshop.

The situation was further complicated by three payment methods (credit card, cash on delivery, bank transfer) and multiple shipping options (courier, parcel locker, in-person pickup) that needed to be combined. Each combination required a different workflow. Credit card payment meant shipping could start immediately, but cash on delivery required waiting for delivery. Bank transfers meant daily bank statement checks. In-person pickup required a different email than parcel locker shipping. That's 12 different routes in total — and the team tried to keep track of which order was at which step in their heads.

iWhy n8n and not Make.com or Zapier?

We chose n8n because it runs on your own server (no vendor lock-in, data stays with the company), has no execution limits (Make and Zapier charge per execution — at Mindwell's volume, this would have been tens of thousands of forints extra per month), and handles webhooks natively — it receives Shoprenter webhooks directly, with no intermediary service needed.

The most important argument: in n8n, any complex branching can be implemented. The 12-combination order routing could be described in a single workflow, which in Make or Zapier would have been numerous separate "zaps."

We wrote about this in detail: How we automated a webshop's entire order management

The solution in detail#

We didn't build one big monolithic system, but rather 24 smaller, well-defined n8n workflows that communicate with each other. This approach has serious advantages: if one workflow errors, the rest continue working; every workflow can be tested and fixed independently; new features can be added one at a time; and the team can see exactly what each automation does.

1

Order routing — the intelligent dispatcher

The heart of the system. When an order arrives on Shoprenter, it immediately notifies n8n via webhook. The first workflow examines three key parameters of the order — payment method, product type, and shipping method — and automatically directs it to the appropriate processing branch.

By payment method:

  • Bank transfer: the order goes to "Awaiting payment" status. The system fetches the bank statement three times daily, and once the transfer arrives, it automatically advances to the next phase
  • Cash on delivery: immediately goes to "Awaiting packaging" status, since payment happens at delivery
  • Online payment: processing starts within moments after Shoprenter's payment confirmation

By product type, the order goes to either the physical shipping branch or the video delivery branch — for mixed orders, both start in parallel.

2

Video sales — the complete digital delivery

This was the heart of the project and the most complex part. When a video product is purchased, the system automatically executes the complete delivery process:

  1. Downloads the video file from Google Drive storage
  2. Uploads it to Cloudflare Stream, which provides fast, global video streaming
  3. Generates a unique, time-limited playback link accessible only to the specific buyer
  4. Sends the access via email through AWS SES, with a personalized message
  5. Sends a reminder email 3 days before expiration, offering an extension option
  6. Automatically revokes access on Cloudflare after expiration

There's only one manual step in the entire process: the Mindwell team uploads new video content to the Google Drive folder. Everything else — from processing to expiration — is fully automatic. The system checks daily whether there's new video in the folder.

3

Customer sync — harmony between systems

Every buyer's data automatically syncs between Shoprenter and Airtable. Airtable is the central CRM: the team sees the complete purchase history, video access status, communication log, and customer value here.

If someone updates their details in the webshop (e.g., new shipping address), Airtable updates within minutes. If the team changes a status in Airtable (e.g., VIP customer tag), it's reflected in Shoprenter as well. The bidirectional sync ensures there is never inconsistent data between the two systems.

The sync extends beyond just data: it also logs purchase events (when they ordered, what they ordered, how much they spent), enabling segmented email campaigns — for example, sending different offers to returning customers than to first-time buyers.

4

Error handling and monitoring — because nothing is perfect

Every workflow includes an error handling branch. If an API call fails (e.g., Shoprenter is temporarily unavailable, or the Cloudflare upload breaks), the system automatically retries — three times, with increasing wait times. If it still fails after three attempts, it notifies the team via Slack message and logs the error in the Airtable error log table.

Since launch, not a single order has been lost, and not a single video link has gone out incorrectly. The error log is transparent: if something happens, the team knows exactly where and why, and can restart the failed step with a single click.

A daily summary email also goes to the team: how many orders were processed, how many video links went out, how many payments came in. This isn't a task — it's information that reassures the team that everything is running smoothly.

Before and after#

Előtte
  • 10-15 minutes of manual work per order
  • 3-5 video link errors per week
  • One sick colleague = the system stops
  • Scattered data: Shoprenter, Excel, email, in people's heads
  • 2-3 hours of daily administration on orders
Utána
  • 0 minutes of manual work — everything is automatic
  • 0 errors — consistent, tested process
  • The system runs 24/7 without human intervention
  • Central Airtable dashboard with all data
  • The team focuses on business development and marketing
mindwell-dashboard.airtable.com

Order dashboard — Airtable view

OrderStatusTypePaymentShipping
#1247✅ DeliveredPhysicalCardGLS courier
#1248📧 Link sentVideoTransfer
#1249📦 PackagingPhysical + VideoCash on deliveryFoxpost
#1250⏳ Awaiting paymentPhysicalTransferIn-person

The team sees the current status of all orders from a single view, filterable by status, date, type, or payment method. Color codes instantly show what needs attention and what's running on its own.

Results in numbers#

MetricBeforeAfter
Manual work per order10-15 min0 min
Video link errors/week3-50
Administration time/day2-3 hours< 10 min (monitoring)
Lost ordersOccasionally0 (since launch)
Cross-system syncManual, 1x/dayReal-time, automatic
Turnaround time (order → delivery)1-2 days (manual steps)Minutes (physical: packaging time)

"We saved hours daily by making order management fully automatic. You don't need to touch anything."

How to apply this in your business#

Tips for starting similar projects

You don't need to automate everything at once. For the Mindwell project, we started with order routing (the single biggest time drain) and gradually expanded with video delivery, then customer sync. This way, we could test and learn at every step, and the team got used to the new system gradually.

Three questions to start with:

  1. Which process consumes the most time? That's where the biggest ROI is. For Mindwell, it was video link generation — automating a single process freed up 1 hour daily.

  2. What systems do you already use? Automation connects your existing tools, it doesn't replace them. If you have Shoprenter, it stays. If you use Airtable, it stays. We just connect them.

  3. What happens when someone is sick? If the answer is "the system stops" or "nobody else knows how to do it," that's where you need to automate. The key: daily operations shouldn't depend on a person.

For most webshops, order routing is the first step: automatically deciding what should happen with the order based on payment method, product type, and shipping method. That's a single n8n workflow that can be set up in a few days, with immediately noticeable results.

If you run a webshop and face similar challenges, book a free consultation — we'll show you where you can save time right away.

Tech stack#

ToolRole
n8n24 workflows: order routing, video delivery, sync, error handling
ShoprenterWebshop platform, communicates via webhooks
AirtableCentral CRM, order dashboard, error log
Cloudflare StreamVideo hosting, unique playback link generation
AWS SESTransactional emails: order confirmation, video link, reminders
Technologies used
n8n
Shoprenter
Airtable
Cloudflare
AWS SES