Skip to content

steventango/timecard

Repository files navigation

Timecard

Timecard generates a Gantt chart to visualize the Google Docs/Slides/Sheet revision history of multiple users over time.

Timecard uses the unofficial revisions:tiles API to get access to detailed revision history data.

To use without "https://www.googleapis.com/auth/drive.metadata.readonly" scope, open Google Doc, open Chrome Developer Tools, open Network Panel, click on see revision history, look for xhr request that matches the one below, modify to remove start and end parameters. Upload the json.txt file to timecard to generate a Gantt chart of time spent in the Google Doc.

https://docs.google.com/document/d/{ID}/revisions/tiles?id={ID}&start=1&end={END}&showDetailedRevisions=true&filterNamed=false&token={TOKEN}&includes_info_params=true

Note: the code quality here is lower than my other projects, as this entire project was completed in 7 hours due to the lack of a reliable official API (https://issuetracker.google.com/u/0/issues/36761246).

Example

Screenshot