How do you actually decide on a product niche — gut feeling or spreadsheet?

Curious how people here actually approach this. Do you lean more toward spreadsheet/data-driven research (search volume, competition, margin math), or is there a point where it comes down to gut feeling from experience?

And on the flip side — what’s a niche-picking mistake you’ve seen sellers make that looked good on paper but didn’t work out in practice?