A super lightweight personal expense tracker that logs data to Google Sheets, secured by a password prompt. Designed for solo use, hosted online but accessible only to me.
π Open App
- π§Ύ Log Debit or Credit entries with name, amount, and optional notes
- π Stores data directly in a Google Sheet
- π Password protected with backend verification
- π Can be deployed on any Node.js-friendly platform (Render, Vercel, etc.)
- Frontend: HTML + CSS + Vanilla JS
- Backend: Node.js + Express
- Storage: Google Sheets via
google-spreadsheet - Auth: Custom password validation via backend and
.env
- Password is checked only on the server
- Never exposed in dev tools
- Perfect for private use (not multi-user or enterprise-grade security)
Install dependencies
npm installCreate a .env file
PASSWORD=your-secret-password
SCRIPT_URL=your-google-script-url
SHEET_URL=your-sheet-url
Run locally
node server.js- Log expenses to Google Sheets
- Password-protected access
- Monthly total summary
- Add spending categories and filters
- Export to CSV
Made with β£οΈ by Samarpan π Portfolio π GitHub πΌ LinkedIn