Core Business Metrics
Loading…
Unit Economics
Cash & Runway
Recent Sales
| Date | Product | Revenue | Status |
|---|---|---|---|
| Loading… | |||
Low Stock Alerts
Loading…
🏦
Investor-Ready Dashboard — All key metrics an investor or accelerator will ask about. Do a Ratta 😁 and you're pitch-ready anytime.
Revenue & Profitability
Unit Economics
Customer Metrics
Cost Structure
Cash, Working Capital & Runway
Discount Impact
Cap Table & Funding
📖 KPI Glossary — Know Before You Pitch
New Sale Entry
e.g. 10 means 10% off each unit
Discount Given
—
Sale Price/Unit
—
Total Revenue
—
Gross Profit
—
Gross Margin
—
🩸 BLEEDING ALERT — Selling at a loss!
All Sales
—
| Date | Customer | Product | Qty | Orig Price | Discount | Sale Price | Revenue | Gross Profit | Status |
|---|---|---|---|---|---|---|---|---|---|
| Loading… | |||||||||
Add / Update Raw Material
Raw Material Stock
—
| Material | Unit | Stock | Reorder At | Cost/Unit | Total Value | Supplier | Status |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Log Expense
Expense Ledger
—
| Date | Category | Description | Amount | Vendor | Type | Marketing? |
|---|---|---|---|---|---|---|
| Loading… | ||||||
Log Funding Round
Funding History & Cap Table
| Date | Round | Investor | Amount | Equity % | Valuation | Notes |
|---|---|---|---|---|---|---|
| Loading… | ||||||
Financial Reports & PDF Export
⚠ PDFs are generated via Google Drive. Ensure your GAS deployment has Drive access authorized.
Expense Breakdown (This Month)
Loading…
💎 What Is Euphoric Glam Worth?
This calculator uses 4 real-world valuation methods used by investors, accelerators, and acquisition firms. Enter your numbers below and see your estimated valuation range instantly. The more data you have in your sheets, the more accurate this becomes.
Enter Your Numbers
Used across all 4 methods
💡 Tip: If your data is connected to Google Sheets, click "Auto-fill from Sheets" to pull live numbers automatically.
🔒 Is Your Data Safe?
Short answer: Yes — your data lives in Google Sheets, not in this app. This page explains exactly how the architecture works and what to do to make your data 100% bulletproof.
✅ What IS Protected
🗄️
Google Sheets = Your Database
All sales, expenses, inventory, customers and funding data is written directly to Google Sheets. The HTML file is just a display layer — it holds zero data.
🌐
Google's Infrastructure
Your Sheets file is stored on Google's servers with 99.9% uptime, redundant backups, and enterprise-grade security. Even if Google goes down (it almost never does), your data comes back.
📜
Revision History
Google Sheets auto-saves every change with a timestamp. You can go to File → Version History and restore any previous version, even from months ago.
🔑
Only You Have Access
Your Sheet is private to your Google account. The frontend password adds a second layer. Nobody can access your data without both your Google account and the app password.
⚠️ What Could Go Wrong
🌐
Hosting Goes Down
DATA IS SAFE. If Hostinger or your domain goes down, you simply lose access to the UI temporarily. All data remains in Google Sheets — open it directly at sheets.google.com.
🔧
Code Bug or Error
DATA IS SAFE. A broken frontend can't delete Sheets data. In the worst case you'd temporarily be unable to add new records via the app — but everything already recorded stays intact.
❌
You Accidentally Delete in Sheets
RECOVERABLE. Use Version History to restore. Also: protect your sheet rows. See the backup checklist below.
🔐
Google Account Hacked
SERIOUS. Enable 2-Factor Authentication (2FA) on your Google account. This is the single most important thing you can do for data safety.
🏗️ How the Architecture Works
🖥️
Your Browser
Index.html
(No data stored here)
(No data stored here)
⟷
⚙️
Google Apps Script
Code.gs
(Logic & routing)
(Logic & routing)
⟷
📊
Google Sheets
Your actual database
(All data lives here)
(All data lives here)
If hosting breaks → data is still in Sheets ✓ | If code breaks → data is still in Sheets ✓ | If domain expires → data is still in Sheets ✓
✅ 5-Minute Data Safety Checklist
Do these once, sleep soundly forever
1️⃣Enable Google 2FA
Go to myaccount.google.com → Security → 2-Step Verification. This protects your entire Google account including Sheets.
2️⃣Bookmark Your Sheet
Bookmark the direct Google Sheets URL. If the app ever goes down, you can still view and edit all data directly in Sheets.
3️⃣Monthly Excel Export
In Google Sheets: File → Download → Excel (.xlsx). Do this once a month and save to your phone/computer. You now have an offline copy.
4️⃣Protect Header Rows
In Sheets: right-click row 1 → Protect Range. This prevents accidental deletion of the column headers that the code depends on.
5️⃣Share with Backup Email
Share your Sheet as "Viewer" with a second email you own (e.g. a Gmail backup account). If you ever lose access to your main account, you can still read all data.
6️⃣Save Code Files
Save copies of Code.gs and Index.html on your Google Drive, phone, and/or email them to yourself. If the domain expires, you can redeploy in 10 minutes.
✓ Bottom line: Your data is in Google's hands, which is far safer than any custom server. The app is just a pretty interface. Losing the app = losing nothing.
💬 WhatsApp Integration Guide
Yes, WhatsApp integration is possible — and there are free options. Here's every method, ranked from easiest to most powerful, with honest pros and cons for a small business like Euphoric Glam.
FREE · EASIEST
Option 1: wa.me Click-to-Chat Links
Add WhatsApp buttons anywhere — no API, no signup
How it works:
Create a link like
https://wa.me/923001234567?text=Hi+Euphoric+Glam! — clicking it opens WhatsApp with a pre-filled message to your number. You can embed this as a button on your website or in order confirmation emails.✓ Pros
100% free forever · Zero setup · Works on any website · Customers love it
✗ Cons
Manual replies · No automation · Not integrated with your dashboard
YOUR LINK (edit phone number):
https://wa.me/92XXXXXXXXXX?text=Hi%20Euphoric%20Glam!%20I%27d%20like%20to%20order.
Replace 92XXXXXXXXXX with your number (country code + number, no +)
Add to your site:
<a href="https://wa.me/92XXXXXXXXXX"
target="_blank" style="background:#25d366;
color:#fff;padding:12px 24px;
border-radius:8px;text-decoration:none">
💬 Order on WhatsApp
</a>
FREE TIER · MODERATE
Option 2: WhatsApp Business App (Manual CRM)
The most practical free solution for a small brand
Download WhatsApp Business (free app, separate from personal WhatsApp). It gives you: a business profile with logo, catalog of your products with prices and photos, quick reply templates, away messages, and basic customer labels. This covers 90% of what a small skincare brand needs — for free.
✓ Product catalog with prices
✓ Quick replies (save time)
✓ Labels: New Order, Paid, Shipped
✓ Business hours auto-reply
✓ Broadcast lists (256 contacts)
✗ Not connected to this dashboard
FREE · ADVANCED
Option 3: CallMeBot — Free WhatsApp Notifications via GAS
Get automatic WhatsApp alerts when a sale is recorded — completely free
CallMeBot is a free service that lets Google Apps Script send WhatsApp messages to your own phone number. You can trigger a WhatsApp notification every time a new sale is recorded, a bleeding alert fires, or inventory runs low.
ADD TO Code.gs — sendWhatsAppAlert() function
function sendWhatsAppAlert(message) {
// Step 1: Register at https://www.callmebot.com/blog/free-api-whatsapp-messages/
// Step 2: Replace with your number and API key
const phone = '923XXXXXXXXX'; // your WhatsApp number
const apiKey = 'YOUR_CALLMEBOT_APIKEY';
const url = 'https://api.callmebot.com/whatsapp.php'
+ '?phone=' + phone
+ '&text=' + encodeURIComponent(message)
+ '&apikey=' + apiKey;
UrlFetchApp.fetch(url);
}
// Call this inside addSale() after writing to sheet:
// sendWhatsAppAlert('🛍 New sale! ' + data.productName + ' x' + data.quantity + ' — PKR ' + revenue);
// If bleeding: sendWhatsAppAlert('🩸 BLEEDING ALERT on sale for ' + data.productName);
Setup in 3 steps:
1. Send "I allow callmebot to send me messages" to +34 644 597 098 on WhatsApp
2. You'll receive an API key back
3. Paste your phone number and API key into the function above — done.
1. Send "I allow callmebot to send me messages" to +34 644 597 098 on WhatsApp
2. You'll receive an API key back
3. Paste your phone number and API key into the function above — done.
PAID · POWERFUL
Option 4: Official WhatsApp Business API (When You Scale)
For when you're doing 50+ orders/month and need automation
Once Euphoric Glam grows, the official WhatsApp Business API (through providers like WATI, Interakt, or AiSensy) lets you send order confirmations, shipping updates, and promotional messages automatically. Prices start at ~$15–30/month. Not needed yet, but worth knowing about.
WATI
~$49/mo
Most popular in PK
~$49/mo
Most popular in PK
Interakt
~$15/mo
Good for DTC brands
~$15/mo
Good for DTC brands
AiSensy
~$20/mo
Easy setup
~$20/mo
Easy setup
💡 My Recommendation for Euphoric Glam Right Now:
1. Download WhatsApp Business app (free) — set up your product catalog, quick replies, and business profile today.
2. Add CallMeBot to your Code.gs — get instant WhatsApp pings every time a sale is recorded or a bleeding alert fires. Takes 10 minutes, costs nothing.
3. Add a wa.me link to your website and Instagram bio so customers can order directly.
4. When you hit 50+ orders/month, upgrade to WATI or Interakt for full automation.
2. Add CallMeBot to your Code.gs — get instant WhatsApp pings every time a sale is recorded or a bleeding alert fires. Takes 10 minutes, costs nothing.
3. Add a wa.me link to your website and Instagram bio so customers can order directly.
4. When you hit 50+ orders/month, upgrade to WATI or Interakt for full automation.