I opened Excel today to view a spreadsheet and just out of curiosity, I decided to use the Copilot integration for the first time to ask it about a column's content. Copilot was clueless. The spreadsheet was open, the Copilot button is right there in the UI, as a user, the affordance of that button for me is that Copilot should already have the context (which is the spreadsheet content). But it didn't, and it kept asking me for the spreadsheet like it's open in a browser window.
I always find myself recalibrating if copilot understands what I am doing. I get mixed results. cannot seem to come up with a consistent rule of thumb.
I wanted to do something complex in google sheets. We had just gotten Gemini in gsheet. I assumed they'd have used some fancy mcp and enabled us to do a lot of things but all gemini in gsheet could do was summarize
It sounds like that's still a step up from Copilot.
I know Gemini has more advanced features in Docs and they rolled something out for Sheets. I would bet GWorkspace keeps gaining ground on the functionality battle.