🏸

Badminton session parser script

tools/session-parser.js — takes OCR text from session roster photo → writes to Google Sheets.

ScriptActiveScript
#badminton#ocr#chermaine

What it does

- Badminton Payments (matched credits + unknowns) - Badminton Unpaid (monthly snapshot)

  1. Receives OCR'd text from a session photo (Chermaine's roster)
  2. Parses: session date, attendees, payment status, court number
  3. Matches attendees against badminton-players roster (canonical names + aliases)
  4. Writes to two Airtable tables:
  5. Also appends to Chermaine's Google Sheet for her view

Trigger

`/ocr session` in Chermaine Avengers chat → Lerby bot takes photo → parser runs.

Files

  • `tele-office/tools/session-parser.js`
  • `tele-office/tools/sheets-mum.js` (Sheets writer)
  • Airtable base `appP46NSafPactfQG`
Last updated 15 Apr 2026