Project
A complete, end-to-end automation that captures incoming orders by email, parses them with AI extraction, tracks cost and profit in real time, and runs a full feedback and retention loop — built on Zapier, AI, Google Sheets, and Tally.
This system was built to remove manual order processing entirely. The moment an order email arrives, AI extraction reads the message the way a human would, pulling out the customer's name, email, ordered items, quantities, and order details with no fixed format required. Each item is matched against a pricing database, a subtotal, total payment, cost, and profit are calculated, and a unique Order ID is generated — with a duplicate-order check in place before anything is processed twice.
Every order is logged into Google Sheets with its Order ID, customer name, customer email, order details, date, total payment, cost, and profit, and the sheet continuously updates a running profit total as orders come in. Gmail then sends an order confirmation with personalized upsell recommendations. Three hours later, the system follows up for feedback through a Tally form — collecting a 1–5 star rating, suggestions, and comments — with duplicate submissions filtered out before the verified response is logged. The rating drives a tiered reply, and a personalized reorder invitation goes out 24 hours after that, its tone matched to how the customer originally rated the experience, closing the loop into repeat business.
| # | Step | Tool | Status |
|---|---|---|---|
| 1 | Detects new order email as it arrives | Gmail Trigger | ✓ Working |
| 2 | Extracts customer name, email, ordered items, quantities, and order details from natural language | AI by Zapier | ✓ Working |
| 3 | Matches items against the pricing database | Code by Zapier | ✓ Working |
| 4 | Calculates subtotal, total payment, cost, and profit | Code by Zapier | ✓ Working |
| 5 | Generates a unique Order ID for the order | Code by Zapier | ✓ Working |
| 6 | Checks for duplicate orders before processing | Zapier Filter | ✓ Working |
| 7 | Logs Order ID, customer name, customer email, order details, date, total payment, cost, and profit | Google Sheets | ✓ Working |
| 8 | Automatically updates the accumulated/running profit total | Google Sheets | ✓ Working |
| 9 | Sends the order confirmation email | Gmail | ✓ Working |
| 10 | Includes personalized upsell recommendations in the confirmation | Gmail | ✓ Working |
| 11 | Triggers when a new order row is logged | Google Sheets Trigger | ✓ Working |
| 12 | Waits 3 hours before requesting feedback | Zapier Delay | ✓ Working |
| 13 | Sends the feedback request email | Gmail | ✓ Working |
| 14 | Includes the Tally survey link in the email | Gmail · Tally | ✓ Working |
| 15 | Customer submits a 1–5 star rating, suggestions, and comments | Tally | ✓ Working |
| 16 | Checks for duplicate feedback submissions | Zapier Filter | ✓ Working |
| 17 | Logs the verified feedback into Google Sheets | Google Sheets | ✓ Working |
| 18 | Splits into 5★, 4★, 3★, 2★, and 1★ response paths | Zapier Paths | ✓ Working |
| 19 | Waits 24 hours after the feedback response is sent | Zapier Delay | ✓ Working |
| 20 | Sends a personalized reorder invitation | Gmail | ✓ Working |
| 21 | Matches reorder email tone to the customer's original star rating | Gmail | ✓ Working |
| 22 | Closes the retention loop and encourages repeat business | Zapier | ✓ Working |
Live walkthrough of order detection, AI extraction, profit logging, feedback collection, and the retention follow-up.
At full capacity, this system runs a complete order-to-retention loop with zero manual intervention. The moment an email lands, AI reads it the way a human would — no rigid format required — and the pipeline handles everything from there: pricing, profit tracking, confirmation, feedback, and repeat business, all happening automatically in the background while the business owner focuses on what matters.
The same architecture — detect → extract → process → confirm → collect feedback → respond → retain — is a fully transferable loop. It can be adapted for service bookings, lead intake, appointment follow-ups, or any business that depends on repeat customers and wants retention to happen automatically, every single time, without anyone having to remember to follow up.
This system replaces what used to be manual reading, calculating, logging, and following up on every single order. Work that once took minutes per order — copying details into a sheet, doing the math by hand, writing a confirmation, remembering to check back in — now happens the instant the email lands, freeing up hours every week that used to go into repetitive admin.
The running profit total updates automatically with every order, giving a live, always-current read on the business's bottom line instead of a number that's only accurate after someone sits down to reconcile it. On the customer side, a tiered, rating-matched reply and a personalized reorder invitation turn customer retention from something that has to be remembered into something that happens automatically, every time.