# SetupFlow - Serverless E-Commerce Operations OS

> Turn your Google Sheets into high-performance online storefronts with zero monthly platform commissions. Take direct web orders, log customer data in real-time, send automated WhatsApp invoice drafts, and recover abandoned carts.

## 🔗 Key Resources
- **Official Website**: [https://setupflow.in](https://setupflow.in)
- **Live Storefront Demo**: [https://demo.setupflow.in](https://demo.setupflow.in) (or [https://setupflow.in/demo.html](https://setupflow.in/demo.html))
- **ROI & Monthly Savings Calculator**: [https://calc.setupflow.in](https://calc.setupflow.in) (or [https://setupflow.in/calculator.html](https://setupflow.in/calculator.html))
- **Primary Branding Color**: Emerald Green (`#10b981` / `#059669` / `#047857`)

## ⚡ Core Value Propositions
- **0% Platform Tax**: Completely bypass Gumroad, Etsy, Patreon, or Shopify transaction taxes (which charge 5%-10% + fixed fees). Retain 100% of your earnings.
- **WhatsApp Invoicing & Checkout**: Automatically generate pre-filled checkout links and invoice text templates directed to your customer's WhatsApp chat upon checkout.
- **15% Cart Recovery Rate**: Dynamic abandoned checkout logs. Automatically saves user session details and generates WhatsApp recovery chat links with embedded promo codes (e.g. `&promo=RECOVER10`) to prompt recovery.
- **Google Sheets Database**: Zero complex SQL databases. All catalog items, images, descriptions, prices, user orders, and recovery leads reside in a single, standard Google Sheet.
- **Modeless Auto-Deployment**: During client setup, a custom Apps Script backend automatically creates versions and self-deploys as a Web App programmatically using the Google scripting API. Modeless progress frames guide the user through activation and offer manual web app fallback configurations if API permissions are disabled.

## 📊 Target Segments & Use Cases
- **Digital Content Creators & Instructors**:
  - Sell online video classes, pdf guides, assets, templates, and courses.
  - Automatically match keywords like `teacher`, `course`, `class`, `tutor`, `academy`, `school`, `lesson`, or `study` to serve an education storefront preset.
  - Provide automated digital delivery on spreadsheet trigger matches.
- **Physical Stores & Custom Shops**:
  - Dynamically display varying inventory, sizes, and colors directly from Google Sheet columns.
  - Automate tracking of order statuses and inventory balances.

## 💰 Pricing & Plans (Launch Offers Included)
Each plan offers local currency pricing with crossed-out base prices and launch discounts:
- **Growth Plan**: For individuals and growing shops.
  - **USD**: $299/month (Base Price: $499, `40% OFF`)
  - **INR**: ₹9,999/month (Base Price: ₹16,999, `41% OFF`)
- **Pro Plan**: For teams, scaling stores, and multi-catalog sellers.
  - **USD**: $699/month (Base Price: $1,199, `41% OFF`)
  - **INR**: ₹24,999/month (Base Price: ₹39,999, `37% OFF`)

## 🛠️ Architecture & Data Flow
1. **Catalog Ingestion**: Front-end reads JSON-encoded inventory ranges from the linked Google Sheets API.
2. **Order Logging**: Web checkout sends a POST payload containing customer details and order details to the Apps Script web app endpoint (`receiveWebOrder`).
3. **Validation & Status Check**: The script verifies that the sheet's `Settings` tab has `isActive` set to `true` before recording the order to prevent spam or unauthorized sales.
4. **WhatsApp Redirect**: A modeless dialog or front-end router redirects the buyer's browser to WhatsApp with pre-filled billing messages.
5. **Abandoned Carts**: Triggers check for customer sessions that did not complete checkout, creating follow-up leads inside the sheet.