My new discovered superpower for Google sheet is using Gemini, not the integrated functionality, but using Gemini to spit out some very specific use case into app script which I plug into my sheet. Majority of the time the code works without any issue on first try with Gemini Pro.