E-commerce Project

Workflow Preview

Description

1. Order Pipeline Customer fills out an online shopping form (name, email, product, quantity, price, SKU) Data is cleaned and saved to a Google Sheets "Order Table" Inventory is checked by SKU — if stock is available, it's deducted and the order status is updated to "Confirmed" A confirmation email is sent to the customer via Gmail If out of stock → waits 5 hours, then sends a "Stock Not Available" message 📦 2. Shipping & Tracking Pipeline A webhook receives the tracking ID from the post office A tracking ID email is sent to the customer After a 3-day wait, a review request email is automatically sent 💬 3. Customer Support Pipeline A separate form collects customer queries Queries are passed to a Google Gemini AI agent for automated responses The AI reply is sent back to the customer via email 💸 4. Refund Pipeline A webhook receives refund requests Eligibility is checked against the database If eligible → database is updated + "Successfully Refunded" email is sent If not eligible → a rejection email is sent

What's Included