FOOD BUSINESS AUTOMATION · OWN BUSINESS CASE STUDY

House of Treats AI-Assisted Order Management System

I transformed our dessert business from manually handling customer inquiries and orders through Facebook and Instagram into a website-based order and approval system. I designed and built the House of Treats website, deployed it through Vercel, and connected it to an n8n automation that captures orders, blocks duplicates, uses AI to flag unclear or conflicting details, records structured data, and requests final owner approval through Telegram.

House of Treats website homepage displayed on a laptop Live website preview
House of Treats n8n order automation video demo displayed on a phone Video demo Order intake to owner approval
House of Treats n8n workflow showing order intake, duplicate checking, AI review, database logging, and Telegram owner approval
Workflow visualn8n system map
View Live Website Watch Video Demo View GitHub Repository Back to Selected Work

Founder Story

House of Treats is my own business. Before this project, customer inquiries and orders were handled manually through Instagram and Facebook conversations.

I designed and built a dedicated website with customer-support functionality, then created the backend automation to make order handling more organized, reliable, and easier to review.

Challenge

Orders previously depended on manual social-media conversations. This created repetitive admin work, inconsistent order records, possible duplicate submissions, and no structured approval or error-monitoring process.

System Built

The completed workflow captures structured order details from the website, checks for duplicate submissions within a 15-minute matching window, asks Google Gemini to review the order details for possible issues, saves the record in Google Sheets, and sends the owner a Telegram approval request.

  • Custom House of Treats website designed and built by me
  • Website deployed through Vercel
  • Structured customer order intake
  • Google Sheets order database
  • Duplicate-order protection using a 15-minute matching window
  • AI Order Review Agent powered by Google Gemini
  • Structured JSON AI output
  • Arithmetic and administrative-detail checking
  • Flags for missing, ambiguous, or conflicting information
  • Telegram owner approval with Approve and Reject buttons
  • Human-in-the-loop decision-making
  • Approved and rejected customer-reply-ready messages
  • Order status, owner decision time, and owner notes recorded in Google Sheets
  • Global Telegram workflow error alerts
  • Workflow JSON backups and production testing

Workflow

  1. 01Customer visits website
  2. 02Customer submits order request
  3. 03n8n prepares structured order data
  4. 04Duplicate protection checks recent matching orders
  5. 05Duplicate orders are blocked and reported
  6. 06New orders go to Gemini AI Order Review Agent
  7. 07AI returns structured advisory review
  8. 08Order and AI review are saved in Google Sheets
  9. 09Owner receives order and AI review in Telegram
  10. 10Owner approves or rejects the order
  11. 11Google Sheets records the final decision and customer-reply-ready confirmation is generated
Duplicate match → blocked and reported before approval
New order → AI advisory review, owner approval, database update

Trust Note

The AI is advisory only. It cannot approve or reject orders, change prices, confirm product or schedule availability, or verify payment. The House of Treats owner makes every final decision.

Results and Proof

  • Matching duplicate submissions successfully blocked
  • Blocked duplicates were not added to the database
  • Blocked duplicates were not sent for owner approval
  • Gemini checked arithmetic before owner review
  • Gemini flagged ambiguous time and conflicting product details
  • Owner approval updated order status, decision timestamp, and owner notes
  • Controlled production failure triggered a Telegram workflow error alert
  • Complete order-to-approval flow tested successfully

Actual Project Evidence

Redacted House of Treats order request form with customer fields, product selection, quantity, order method, address, and requested date
Website Order IntakeShows the structured order request flow customers use before the automation starts.
Telegram owner approval message showing AI review, manual review reasons, calculated total, and approve or reject buttons
Owner Approval ReviewShows the Telegram review message with AI advisory notes and owner decision buttons.
Redacted approved House of Treats customer-reply-ready message generated after owner approval
Customer Reply ReadyShows the approved response prepared for the owner to send through official House of Treats channels.
Redacted Google Sheets order database with product, quantity, price, total, order method, requested date, and preferred time columns
Structured Order DatabaseShows order records captured into Google Sheets while customer identifiers are redacted.
Redacted Google Sheets AI review and order status columns showing duplicate check status, manual review flags, calculated totals, and total match results
AI Review and Decision RecordShows duplicate status, owner decision notes, AI review flags, calculated total, and total match outputs.
n8n workflow canvas for House of Treats with order intake, duplicate checking, Gemini AI review, Google Sheets logging, Telegram owner approval, and approval routing
Production-Tested WorkflowShows the full n8n workflow structure for intake, review, owner approval, status updates, and owner-facing replies.