A complete automated order management system for
social media businesses that sell without a website.
Businesses selling through Instagram or Facebook DMs face the same operational wall as they grow — manual payment verification, fake order screenshots, no real-time customer updates, and admin work that scales with order volume instead of staying flat.
Top Flow — Order Intake & Fraud Detection:
- Customer submits order via Airtable form with payment screenshot
- System validates and normalizes order data
- Screenshot uploads automatically to Google Drive
- Duplicate screenshot detection runs against existing records in Google Sheets
- Custom fraud scoring logic evaluates the order
- Clean orders log to Google Sheets and customer receives Gmail + Telegram confirmation
- Flagged orders trigger fraud alerts via Telegram
Bottom Flow — Approval & Fulfillment:
- Owner receives Telegram notification with Approve / Reject / Fraud buttons
- One tap triggers the correct path
- Google Sheets status updates automatically
- Customer receives Gmail + Telegram update within 1.5 seconds
| Metric | Before | After |
|---|---|---|
| Weekly admin hours | 40hrs | 2hrs |
| Fake orders/week | 12 | 0 |
| Orders processed | — | 25,430+ |
| Verification rate | Manual | 99.1% |
| Response time | Hours | <1.5s |
- n8n — workflow automation
- Airtable — order form
- Google Drive — payment screenshot storage
- Google Sheets — order database
- Gmail — customer email notifications
- Telegram Bot — owner approval + customer updates