What's your experience with the competition? I have never tried gemini in sheets, but don't you think google will get there soon if they're not already?
But if I ask Gemini to build be formulas and than just paste them into Google Sheets the results are pretty darn good.