TrackLah!

#devchallenge #postmarkchallenge #webdev #api

This is a submission for the Postmark Challenge: Inbox Innovators.

🧾 TrackLah!

Freelancers and small businesses in Singapore often receive payments through peer-to-peer apps like PayLah! or PayNow, and clients typically confirm these transactions by emailing or messaging a screenshot. Manually checking each payment notification, extracting details, and updating a financial record or spreadsheet can be time-consuming and error-prone — especially with different formats, currencies, and inconsistent communication.

TrackLah! solves the problem by automatically parsing incoming emails (using Postmark's inbound email parsing feature), extracting payment information using OCR, and updating a Google Sheet to track each transaction. It ensures freelancers get real-time updates, avoid missed payments, and maintain a centralized record of all incoming funds — without lifting a finger.

📦 Features

✅ Extracts text from payment screenshots (e.g., PayLah!, PayNow)
🔤 Uses OCR.space API to parse text from image attachments
💸 Identifies amount and currency from text
📋 Appends or updates rows in a Google Sheet
⚙️ Health check endpoint

📦 Upcoming Features

📋 Generate invoices to clients
🛡️ Ignores duplicate MessageIDs

🧱 Tech Stack

Frontend: React 18
Backend: Node.js, Express
Email: Postmark (Transactional API)
Deployment: Fly.io
Secrets: .env / environment variables
Version Control: Git & GitHub

📊 Sequence Diagram

📦 Live Demo

How It Works

1. Send an Email
Compose an email to b5fec6c3607a2f29c77a448e01fedcf6@inbound.postmarkapp.com using any email client.
See /examples/ for payment screenshots you can attach to the email.

2. Trigger the Automation
The system receives and processes the email via Postmark inbound webhook.

3. Observe the Result
Updates will appear automatically in the connected Google Spreadsheet (you'll see a new row added).
https://docs.google.com/spreadsheets/d/19cZqjmo9-ZA1uyiAFQNiCbnNKZoQ0O-hrkYDSPclysI