This video instructs you on how to setup your Books spreadsheet from the template: https://docs.google.com/spreadsheets/d/12Kd3YOWM0XlPQKQV-NqXtLXItwEFIqPqc5t7Ae3uR3k/edit?usp=sharing
This is the first video like this I've ever made and I might be great at spreadsheets but I'm terrible at editing videos, so apologies it's quite 'raw'.
The spreadsheet is designed to run from data you download from Goodreads, you still use goodreads to log all your activity just occasionally re-download your data to the spreadsheet and add additional detail as you desire to get lots of great graphics and usable data.
Buy me a coffee: http://buymeacoffee.com/tpayne89
1:15 - Export data from Goodreads
2:00 - Resizing columns
2:30 - Importing Goodreads data
4:20 - Copy Ids into Data worksheet
6:45 - Choosing thumbnails
8:40 - Manual thumbnail
10:46 - Adding book start dates
13:39 - Adding book series info
14:13 - Adding rank + genre info
15:20 - Editing genres
16:15 - Adding 'own' information
17:25 - Adding Libby/Audible etc. info
19:00 - Adding prices + shops
20:35 - Exploring the dashboard
22:34 - Exploring TBR worksheet
23:55 - Exploring Read worksheet
24:37 - Exploring Library worksheet
25:01 - Digital bookshelves worksheet
26:35 - Updating the spreadsheet
