Ledger Lens

ON ICE

Extracts invoice payee, bank account, and IFSC from spreadsheet Drive links or Gmail attachments with confidence-scored vision AI.

date
tags
automation, finance
stack
Next.jsn8nTypeScript
context
Finance ops — bulk invoice processing from spreadsheets and email
links
liverepo

Test access only. Ledger Lens is in private beta. Sign-in at ledgerlens.piyushtater.com is for approved testers. If you are not on the list yet, apply below.

Apply for test access

Use the Request beta access link (also on the project card in the graph). Your email app will open with a short template — fill in:

  • Your full name
  • Your company or organization name
  • Your position / role in that organization
  • What you want to know or try, and why you need access
  • Any details relevant to evaluating your request
  • The Google account email access should be granted on (used for sign-in)

I review applications manually and reply within a few business days. If approved, I email you when your account can sign in.

Prefer a form? A Google Form intake is being set up; until then, the email link above is the application path. Fallback: piyushtater158@gmail.com with subject Ledger Lens beta access request.

What it does

Ledger Lens automates payee extraction from invoices. Upload a spreadsheet of Google Drive links, or scan Gmail for invoice attachments in a date range — either path runs each document through the same vision extraction pipeline and returns confidence-scored payee, account number, IFSC, and amount fields.

How it works

  1. Sign in with Google (drive.readonly + gmail.readonly) — approved testers only during beta.
  2. Spreadsheet path — upload .xlsx, auto-detect columns, process all rows, download the filled file.
  3. Gmail path — pick a date range and optional keyword; discover attachments, extract fields per row on the live dashboard.
  4. Backend — four n8n webhook workflows proxy to OpenRouter vision (google/gemini-2.5-flash). The user’s Google token is forwarded per request and never stored in n8n.

What I built

  • Next.js 15 frontend on Vercel (OAuth, upload UI, live status table, single-row re-run)
  • n8n workflow suite (bulk extract, row re-run, Gmail discover, Gmail extract)
  • Smart column detection for common payee / IFSC / Drive link header patterns
  • Idempotent runs — rows already filled are skipped on re-upload

Stack

Next.js · React · NextAuth · Tailwind · n8n · OpenRouter vision · Google Drive & Gmail APIs · Vercel