Copy/Paste this Script into Any Google Spreadsheet Scipt to Utilize the added Functions.
-
Changes to sheet to be formatted like Gmail. If you type the newest book in row #1, a new row will automatically propagate.
-
Sheet will query Google books API to auto update the book info.
-
Colour Codes Rows for Finished/Reading/Not Started/Reference
- Finished - Green
- Reading - Yellow
- On Deck - Orange
- Unfinished - Red
Enter the ISBN number in the ISBN column. In the top menu of Google Spreadsheet select "Custom Menu >> Get Book Data". The book feilds will populate.