My WhatsApp Was My Open‑Mic Booking System, So I Gave It to Gemma

说明与用途

通过 WhatsApp 自动化管理开放麦克风排程，将每周工作时间从 3 小时缩短至 15 分钟，使用 Gemma 3 进行消息分类，React PWA 进行排程管理。

问题

Managing open‑mic lineups via WhatsApp DMs was time‑consuming and error‑prone, with requests slipping out of view and manual triage taking ~3 hours weekly.

结果

Reduced weekly workload from ~3 hours to ~15 minutes, saving ~12 hours/month, with minimal cost and running on a repurposed laptop.

工作流

• 1. Comics DM curator via WhatsApp. 2. Node worker with whatsapp-web.js captures chat bursts when quiet. 3. Gemma 3 model classifies messages into request, cancellation, etc., quoting the ask. 4. Evidence check ensures quoted text exists in chat. 5. Classified requests appear in Waiting board. 6. Curator drags comics into Monday/Tuesday columns. 7. Press Confirm & send to generate confirmations, regrets, and group updates. 8. Curator reviews changes before finalizing.

证据

WhatsApp is my daily driver. I use it to ask other rooms for spots, gossip about shows and audience with comics, reply to my family group, talk to my girlfriend and somewhere in all of that, comics message me asking for a spot on the lineups I curate.

来源

It takes me about 3 hours every week. I'd rather spend those 3 hours writing jokes. Or sleeping. Mostly sleeping.

来源

Spot Solutions takes off my plate every week: finding the actual requests in a weekend of DMs, checking who performed last week, messaging every comic, adding and removing people from each show’s group.

来源

Before: about 3 hours a week. Now: about 15 minutes

来源

The model must quote the ask. If its "evidence" isn't actually in the messages, it made it up.

来源