LogLens Dashboard · LawList Snap

Offline-first mobile + desktop connector that lets factory floor supervisors photograph or forward daily production log sheets and instantly extracts machine/employee/dept hours, halt reasons, and productivity metrics directly into a pre-templated Google Sheet with hover-style tooltip cards and dynamic filters.

Who pays

Small-to-mid manufacturing or assembly plant owners (10-80 staff) currently paying $151-452 per incident or a recurring VA ($25-50/hr) to manually build these dashboards weekly; the pain is urgent because production halts directly cost output and they already fund humans for this repeatable weekly analysis.

The evidence

Multiple paying-a-human briefs explicitly describe handing over raw Excel production logs and needing dynamic dashboards with machine-wise/employee-wise/department-wise views, shift/date filters, bar charts, and mouse-over tooltips for halt details without extra sheets. Exact quote: "I will give you raw production logs in Excel. From that single workbook I need a dynamic dashboard that lets me analyse production hours... mouse-over tooltips that reveal machine halt details".

Why now

Stocky shutdown and repeated Shopify/ manufacturing data-cleanup threads have merchants and operators actively hunting for anything that removes manual Excel re-entry; on-device OCR+local parsing has finally become reliable enough for one-dev MVP.

Smallest shippable thing

Mobile app using on-device ML Kit + Sheet API that accepts photo or CSV of production logs, applies one-time column mapping, outputs validated rows plus a separate "Dashboard" tab with Pivot-like filters, bar charts via Apps Script, and simple HTML tooltip cards. Ship in <3 weeks.

Competition & the wedge

General tools like Parseur or Sheetgo exist but require cloud upload and don't create the exact halt-tooltip + multi-view dashboard layout; incumbent Excel/QuickBooks won't add on-device mobile-first extraction because it cannibalizes their desktop license model and crosses into computer-vision territory.

Best case against it

Market too small; only factories that still rely on paper or messy Excel logs will care, and most have already moved to purpose-built MES systems or hired full-time data people.

Why it survives that

The paid briefs prove the workflow is still 100% manual and recurring weekly for a non-trivial segment; these owners explicitly reject full MES because of cost and complexity; the wedge is the zero-training photo-to-dashboard flow that no MES vendor will replicate because it commoditizes their high-margin implementation services.

Cheapest test this week

Post in 3 active manufacturing Facebook groups ("Production Managers" or "Factory Owners Network") and Google "manufacturing production dashboard excel VA" Upwork postings from last 30 days; message the 8 most recent poster-owners a one-page PDF mockup of the exact dashboard described in signal [3] plus a $49/mo pre-order link. Green-light if 3+ commit or reply "I'd buy this tomorrow".

Dead-simple offline-first mobile app that lets solo attorneys or small law-firm staff photograph a single web directory page of lawyers and instantly extracts only names into an alphabetically sorted, deduplicated Google Sheet or Excel with one-tap correction flags.

Who pays

Solo practitioners and small law-office managers in Spanish-speaking markets (especially LATAM) who currently pay VAs or data-entry freelancers $33-272 per directory scrape and need this every time they build referral lists or compliance databases; the pain is urgent because directories change monthly.

The evidence

Direct paid brief asking for exactly this workflow: "Extraer lista abogados web... únicamente requiero el nombre y apellido de cada profesional... Entregable Archivo Excel o Google Sheet con todos los nombres ordenados alfabéticamente." The poster is willing to pay $33-272 for a human to do it once, implying it repeats whenever they need updated attorney directories.

Why now

On-device OCR + local LLM correction has matured to the point a single developer can deliver pixel-perfect name extraction without cloud costs, exactly matching the repeatable "every new directory" need proven by paid briefs.

Smallest shippable thing

iOS/Android app that uses on-device OCR, prompts user to confirm column (name only), applies simple alphabetical sort + duplicate removal, writes to linked Google Sheet. One-time URL sharing or photo import. Complete in 2-3 weeks.

Competition & the wedge

General scrapers like ParseHub or Bardeen exist but are overkill, require accounts, and cloud processing; no product targets the ultra-narrow "just lawyer names from one page into sorted Sheet" workflow. Incumbents won't build it because the total addressable market per country is too small for their sales motion and it competes with their enterprise data-enrichment products.

Best case against it

One-off data extraction is a classic consulting gig, not a SaaS; lawyers only need this rarely and will just hire the next Fiverr VA for $50 rather than subscribe.

Why it survives that

The brief explicitly states it is for a recurring need (new directories appear constantly for different practice areas or jurisdictions); the buyer is a non-technical law-office owner who fails test (a) because they cannot build the OCR+dedup app themselves in a weekend; the narrow vertical + local on-device execution creates a moat against general tools.

Cheapest test this week

Search Reddit r/abogados + r/derecho and Facebook groups for "lista de abogados" or "directorio abogados Excel"; DM the 12 most recent posters from the last 60 days a 15-second Loom of the exact flow described in signal [5] and a $19/mo Stripe link. Green-light if 4+ pay or strongly commit within 7 days.

Lightweight paid add-on for Home Assistant that turns any existing Inkscape SVG floorplan into a mobile-first, fully offline-capable interactive dashboard with reliable presence-based icon updates and one-tap device control without mDNS/Thread breakage.

Who pays

HomeAssistant enthusiasts who already pay Nabu Casa $6.50/mo and run villas, STRs, or small property-management operations; they are service-business adjacent (many manage multiple vacation rentals) and currently waste hours or pay for custom help on every HA update.

The evidence

Multiple Home Assistant threads show users struggling to maintain floorplans after updates, with explicit willingness-to-pay statements: "$15 is going to be a 'shut up and take my money' scenario. I'd do it today." and "I would happily pay a one-time fee to unlock this code." Exact pain is time wasted remaking floorplans that break on restarts or device changes.

Why now

Thread/Matter rollout has exploded mDNS and presence-tracking breakage exactly as described in current threads; the community is primed to pay for stability after repeated "So Ready to Walk Away" frustration.

Smallest shippable thing

Browser extension + companion HA add-on that caches the user's existing floorplan SVG locally, injects robust WebSocket updates instead of relying on mDNS, adds offline queue for status changes, and serves a PWA. Ship in under 3 weeks.

Competition & the wedge

Built-in HA floorplan cards and paid apps like Floorplan exist but still require constant manual SVG maintenance and break on network changes; the wedge is the offline-first, auto-healing layer that core HA and existing paid tools structurally cannot ship because it would reduce reliance on their cloud/Nabu Casa subscription.

Best case against it

This is squarely in the Home Assistant hobbyist market, not the target service-business owner who has never heard of Claude; these users will simply self-build or wait for core to improve.

Why it survives that

The target buyer is the property manager or villa-turnover operator already running HA for multiple units; they fail the "could build it themselves in a weekend" test because they explicitly say they gave up after trying Inkscape multiple times; money is already moving to Nabu Casa and paid support requests, proving willingness to pay for stability.

Cheapest test this week

Post a one-page offer in the Home Assistant subreddit and the "Floorplan" Discord channel describing the exact offline mobile floorplan product users asked for in signals [48] and [49]; include a $15 one-time or $4/mo link. Green-light if 12+ purchases or explicit commitments within 5 days.