I have access to this now and I want it to work so bad and it's just proper shit. Absolute rubbish.

They really, truly need to fix this integration. Gemini in Google Docs is barely acceptable, it doesn't work at all (for me) in Gmail, and I've not yet had it do anything other than error in Google Sheets.