My Automated Writing Dashboard

23 Nov 2013 » 1 min read » Filed under: personal automation

A little something I have been playing around with in the tiny scraps of free time I have is some Google App Scripts that allow me to automate the presentation of some of my writing metrics. Or, in simpler terms: automatically create charts based on my writing data. This is still a work-in-progress, but here is how my automated dashboard is looking as of this morning:

Click to enlarge
Click to enlarge

The biggest benefit of these scripts is that they save me the time of having to create the charts manually from the data. I can open my spreadsheet, click on a menu option, and the charts update automatically. This means that not only is my data collected automatically, while I write, but the charts are now created automatically. And I can spend my time writing instead of manually collecting data and building charts.

By the way, the data for the “Writing Minutes/Day” chart comes from the new scripts I’ve written to track the time I spend writing, in addition to the words.


Get new posts by email

One response to “My Automated Writing Dashboard”

  1. I would love for you to teach me how to do this! Very cool 🙂

Leave a Reply to Bonnie ZinkCancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Discover more from Jamie Todd Rubin

Subscribe now to keep reading and get access to the full archive.

Continue reading