Team Portal
"
User Expense Tracker
⚙️ One-Time Setup — Paste your Apps Script Web App URL
- In your Google Sheet → Extensions → Apps Script
- Delete all existing code → paste the contents of Code.gs
- Click Deploy → New Deployment → Web App
- Execute as: Me | Who has access: Anyone
- Click Deploy → copy the URL → paste below → Save
⚠
Query Parameters
Frequency B7
—
Awaiting fetch
Amount E7
—
Awaiting fetch
Category Breakdown
Others J2
—
Fuel J3
—
Mechanical J4
—
Electrical J5
—
Travel J6
—
Food J7
—
Table Data
B10 : H
📊
No data loaded
Select a user, pick a date range, and tap Fetch Data