Is there a tool I can use to reconstruct my personal access/edit history across all of the Google documents I have access to? I would prefer an option that already exists within Google Workspace above some kind of external tool, but am open to either. The ideal format would be something like:
- opened doc X at Feb 10, 10:00
- edited spreadsheet Y at Feb 10, 13:30
- commented on slide deck Z at Feb 10, 15:30
- opened doc X at Feb 11, 10:30
- etc
The best option I have found is the “Recent” tab at drive.google.com/drive/recent. This is already useful, but it only shows the most recent interaction with each doc, rather than each interaction. (For example, if I opened doc X on Feb 10 and Feb 11, it would only show up under Feb 11 in this view.) The “Activity” tab isn’t what I’m looking for either, because it only shows the activity of other people that are relevant for me in some way (comments on docs owned by me, or tagging me, etc).
Is this possible?
Context:
I often want to reconstruct the work I have done in the past couple of weeks. A lot of my work involves writing code, and I can easily reconstruct these activities by inspecting git commits and using various git-based tools. But my company also uses Google Docs (and sheets, slides, etc) heavily for internal work, and I find myself interacting with these more and more as part of my daily work. (Yes, I could just write down everything I do, but that requires a level of constant meta-organization that I would like to avoid.)
There are many, many documents that I have access to and in theory might interact with each day, so I’m not looking for a tool where the documents in question have to be registered in advance for tracking purposes, or where I have to go check each document manually. I’m not looking for interactions of other people with these docs, only my own interactions. And I don’t actually care about the content of any edits, “worked on doc X” is enough.
