How to Automatically Track Your Word Count
Learn how to automatically track the number of words you write every day using google docs, google sheets, and google drive. The script automatically runs every day and updates the number of words you've written in the spreadsheet.
If you're serious about tracking writing, this script will save you time AND give you motivation to keep writing (even after NaNoWriMo is over). Every day, you will automatically receive an email that summarizes your writing progress over the last 24 hours.
Once everything is properly installed, you only need to do 2 things:
1. Make sure your working files are in your Sandbox folder.
2. Write.
Automatically tracking my word count made a huge difference for my writing habit! Over the course of a year, tracking my writing kept me focused on my long term goal and gave me satisfaction from little bits of incremental progress. Check out what I learned from the full year of progress here: • One Year of Writing a Novel
Links:
GitHub Documentation: https://github.com/jamietr1/google-do...
Google Writing Tracker Data Spreadsheet: https://docs.google.com/spreadsheets/...
writing_stats.gs file: https://github.com/jamietr1/google-do...
diff.gs file: https://github.com/jamietr1/google-do...
daily_almanac.gs file: https://github.com/jamietr1/google-do...
RescueTime: https://www.rescuetime.com/download-r...
0:00 Introduction
1:36 Step 1 - Create folders
2:21 Step 2 - Copy the spreadsheet
2:59 Step 3 - Configure the spreadsheet
3:54 Step 4 - Install the scripts
8:21 Step 5 - Enable the triggers
10:34 Step 6 - Test if it works
13:17 How the scripts works
14:14 Tag fiction vs non-fiction
15:10 Set Goals
15:56 Track Writing Time
17:03 Conclusion