I have been inside the Google ecosystem for ten years and Gemini integration is genuinely changing how I use my own files

I want to give a specific account rather than a general review because I think the specific use case matters more than the overall verdict.

I have ten years of files in Google Drive. Docs, Sheets, Slides, notes, old project folders, meeting summaries. Finding something specific in that archive has always been a manual process of remembering roughly when I made something or which folder it might be in and then searching with keywords that may or may not match what I wrote.

Since Gemini integrated properly into Drive and Docs I have been asking it questions about my own files. Not searching, asking. I asked it last week to find everything I had written about a specific client relationship over the past two years and summarise the key decisions. It pulled from twelve separate documents across three folders and gave me a timeline.

That is a different kind of useful from what I expected. The limitation I have found is that it is much better with text documents than with Sheets data. Has anyone else found that and is there a workaround?