Finding product

find problem

online

reddit: r/[niche] look for vents / questions / feedback
app store / g2.com reviews: look for 2/3 star reviews. customers like concept but missing/broken/unoptimised features
product hunt: for inspiration

irl

spreadsheet: whatever ppl use spreadsheets for, it can be done more efficiently
shadow: follow someone and find areas for improvement