CURRENT VIEW
Showing—
ZoneAll
MarketAll
RoadAll
Brand Database
Click any row → jump to map location
| Brand | Category | Type | Zone | Market | Road / Micro Market | Coords |
|---|
Market Overview
19 mapped micro-markets · click to explore on map
Add Brand
Manual entry · auto-syncs to Google Sheets if configured
Brand Name *
Industry *
Type
Zone *
Market *
Format
Road / Micro Market
Address
Latitude
Longitude
Website
LAT/LONG IN 5 SECONDS ON IPHONE
Maps app → long-press on store → tap the coordinates popup.Or: Google Maps → right-click → first line shows "17.xxx, 78.xxx".
Tap GPS Location if you're physically standing at the store.
Google Sheets Connection
Link this platform to a live Google Sheet for real-time updates
☁ Connect to Google Sheets
Once connected, this platform loads fresh brand data every time it opens. New brands from Claude Vision are pushed directly to the sheet. The sheet auto-refreshes on the 1st of every month.
Apps Script Web App URL
Not connected — using embedded data
📋 One-Time Setup Instructions
- Open your Hyderabad_Market_Brand_Database_v5 in Google Sheets (upload the Excel file to Drive → Open as Sheets)
- Click Extensions → Apps Script
- Delete any existing code. Paste the entire contents of triumph_apps_script.gs (downloaded with this HTML)
- Save the project. Name it Triumph Market API
- Click Deploy → New Deployment → Web App
Execute as: Me | Who has access: Anyone - Copy the Web App URL → paste it above → click Connect
- Back in the Apps Script editor, run setupMonthlyTrigger() once manually to activate the 1st-of-month auto-refresh
🔄 How Updates Flow
ON EVERY OPEN
HTML fetches live data from Google Sheets. Always fresh without manual updates.
1ST OF EVERY MONTH
Apps Script re-compiles all market sheets into Master Brand List. Automatically triggered.
CLAUDE VISION PUSH
Approved detections from field video are posted directly to Google Sheets with lat/lng.
MANUAL ADD BRAND
Add Brand form writes to Google Sheets instantly. Visible on map immediately.