claudedwithlove
explore/my-balance-api

my-balance-api

Cherished

A REST API backend that enables users to manage their finances by storing and querying transaction data directly in their personal Google Sheets. Built with Node.js and TypeScript, it handles account management, transaction tracking, and category organization while using PostgreSQL to manage authentication and session state, all deployable serverlessly on Vercel.

·0··submitted April 17, 2026
View on GitHub
Clauded With Love Rating
7.5 / 10

MyBalance API is a personal finance REST backend that stores transaction data in users' Google Sheets while using PostgreSQL for authentication and metadata. It provides comprehensive financial management with accounts, transactions, categories, and aggregations, deployable serverlessly on Vercel.

Code Quality6.5
Usefulness8.0
Claude Usage7.0
Documentation8.5
Originality7.5
Highlights
  • Innovative data architecture using Google Sheets as primary storage with PostgreSQL for metadata creates user data ownership
  • Comprehensive API design with proper rate limiting, batch operations, and iOS Shortcuts integration for mobile workflows
  • Detailed Google Sheets schema specification with proper column mapping and data formatting requirements
To Improve
  • Add test coverage and error handling patterns since none are visible in the documentation or apparent project structure
  • Include API response examples and error codes in documentation to improve developer experience and integration
Stack
Type