Opportunity Discovery: A Field Guide for When You’re Stuck Staring at a Blank Page
The Problem in Concrete Terms
You have the capacity to build, write, code, or sell. You have time blocked out. You have coffee. But when you sit down to answer "What should I work on next?", the signal turns to noise.
This isn't "writer's block." It’s a specific mechanical failure: you cannot distinguish a viable opportunity from a vague interest.
The symptoms look like this:
- The Spreadsheet Graveyard: You have a Notion database or Google Sheet with 47 ideas. Three are half-built MVPs. Forty-four are one-line bullets like "Uber for dog walking" or "AI newsletter summarizer." You haven't touched the sheet in three weeks because opening it induces guilt, not clarity.
- The "Passion" Trap: You wait for a lightning bolt of conviction. You tell yourself, "I'll know it when I see it." You don't. You just see more options.
- The Validation Theater: You post a poll on Twitter/LinkedIn: "Would you use a tool that does X?" Five friends say "Yes!" You build for two months. Zero of them buy.
- The Competitor Paralysis: You find a competitor doing exactly what you thought of. You immediately discard the idea, assuming the market is "saturated," without checking if they are actually good, profitable, or serving the specific niche you saw.
You are stuck because you are treating opportunity discovery as a creative brainstorming exercise. It is not. It is a filtering process applied to raw market signal. You don't need more ideas; you need a ruthless mechanism to kill the bad ones and stress-test the survivors.
Why the Usual Fixes Fail
1. "Scratch your own itch."
This works if your itch is shared by thousands of people with budget and urgency. Most itches are idiosyncratic (e.g., "I want a better way to organize my specific collection of vintage screws"). Building for an audience of one is a hobby, not a business. Unless you systematically verify that others bleed the same way, this is a trap.
2. "Look at trending topics on Product Hunt / Hacker News / Reddit."
You are looking at winners, not openings. By the time a category is trending, the low-hanging fruit is gone. You are entering a knife fight with funded teams who started 18 months ago. Signal comes from the fringes—boring industries, complaints in support tickets, manual workarounds—not the front page.
3. "Keyword research / SEO volume."
High volume keywords usually indicate high competition and low intent (informational queries). Low volume keywords indicate intent but require massive scale to matter. SEO data tells you what people search for, not what they pay for. People search for "free invoice template"; they pay for "automated late-fee collection for net-30 contracts."
4. "Customer interviews" (done wrong).
Asking "Would you use X?" gets you polite lies. Asking "What's your biggest problem?" gets you vague complaints ("communication is hard"). You need to observe behavior and spend, not collect opinions.
Step-by-Step Solution: The Signal-to-Noise Pipeline
This process takes 2–3 weeks if you treat it like a part-time job (10–15 hrs/week). It produces a shortlist of 1–3 opportunities worth a 2-week MVP sprint.
Phase 1: Harvest Raw Signal (Days 1–3)
Goal: Collect 100+ raw observations without judgment. No filtering. No "is this a good idea?" Just data entry.
Sources you can access today:
- Review Mining (High Yield): Go to G2, Capterra, TrustRadius, Chrome Web Store, Shopify App Store, App Store/Play Store. Filter for 2-star and 3-star reviews of established tools in categories you understand (CRM, project management, accounting, dev tools, marketing automation).
- Action: Copy-paste verbatim complaints into a spreadsheet. Column A: Quote. Column B: Tool Name. Column C: Category. Tag the workaround mentioned (e.g., "export to CSV then manually fix in Excel," "use Zapier to sync contacts").
- Target: 50 quotes minimum.
- Community "How do I..." Threads: Search Reddit, IndieHackers, Slack/Discord communities, specialized forums (e.g., r/accounting, r/freelance, specific trade forums).
-
Search operators:
"how do you handle","workaround for","spreadsheet to track","manual process","hate that I have to". - Action: Capture the specific workflow described. Note the tools they currently stitch together.
- Target: 30 threads.
-
Search operators:
- Your Own Network (The "Boring" Audit): Message 10–15 people you know who work in distinct industries (not tech founders). Ask: "What is the most annoying spreadsheet you maintain? What task do you do every Friday afternoon that makes you want to quit?"
- Action: Record the answer. Ask for a screenshot of the spreadsheet (blur sensitive data). The spreadsheet is the product spec.
- Target: 10 screenshots/workflows.
- Government/Regulatory Filings (Niche Gold): Search
site:gov "request for proposal" [industry]orsite:gov "notice of proposed rulemaking" [industry]. New compliance requirements create immediate, budgeted demand.- Target: 5–10 relevant triggers.
Output: A master sheet with 100+ rows of observed friction, not ideas.
Phase 2: Structural Filtering (Days 4–6)
Goal: Kill 90% of the list using hard constraints. Apply these filters mechanically. Do not argue with the filter.
Filter 1: Budget Authority (Must Pass)
- Does the person feeling the pain have a company card or sign-off authority?
- Kill: "Students want cheaper textbooks," "Junior devs want better debugging," "Employees want better expense reporting" (unless selling to the controller).
- Keep: "Agency owners spending 10hrs/week on client reporting," "Clinic managers failing HIPAA audits," "E-comm ops leads paying $2k/mo for manual order routing."
Filter 2: Frequency & Urgency (Must Pass)
- Does this happen daily/weekly? Is there a deadline (tax day, sprint end, client deliverable, compliance date)?
- Kill: "Annual strategic planning," "Quarterly board deck prep," "Onboarding new hires" (low frequency).
- Keep: "Daily bank reconciliation," "Weekly inventory sync across 3 channels," "Real-time SLA breach alerts."
Filter 3: Existing Spend / Workaround Cost (Must Pass)
- Are they already paying money (tools, contractors, overtime) or burning significant hours (>5 hrs/week) on a hacky workaround?
- Kill: "I wish there was an app for..." (no current cost).
- Keep: "We pay a VA $1,200/mo to copy-paste leads from Facebook to HubSpot," "We use 4 Zaps and a Google Sheet that breaks weekly."
Filter 4: Technical Feasibility (Your Constraint)
- Can you build a V1 in 2–3 weeks with your current stack/skills?
- Kill: Requires ML training, hardware, complex regulatory certification (HIPAA/SOC2 from scratch), two-sided marketplace liquidity.
- Keep: CRUD apps, automation/integration layers, reporting dashboards, document generation, specialized calculators, Chrome extensions, Shopify/WP plugins.
Action: Add columns for each filter (Y/N). Filter for YYYY. You should have 5–15 survivors.
Phase 3: The "Pre-Sale" Stress Test (Days 7–14)
Goal: Prove someone will pay before you write code. You are selling a mockup and a timeline.
Step 3.1: Create the "One-Pager" (Not a Landing Page)
- One Google Doc / Notion page / PDF.
- Headline: [Specific Role] + [Painful Outcome Avoided] + [Time/Money Saved].
- Bad: "Automated Reporting Tool."
- Good: "Cut Client Reporting from 4 Hours to 15 Minutes for Marketing Agencies."
- The "Before" State: Screenshot of the messy spreadsheet
Top comments (0)