Skip to main content
Post

Build a Google Sheets Reading Journal with ISBN Lookup

Quickchat published a walkthrough for building a private reading journal in Google Sheets, with ISBN lookup through Open Library. It's a tutorial for setting up Quickchat AI Agent Actions, not a new feature release.

You build a journal called Shelf Notes. Type an ISBN into the chat and the Agent calls Open Library for the author, the edition's publisher and year, and the language. Those details matter because they describe your copy and not just the book. In the guide's example, ISBN 9780141439518 is the 2003 Penguin paperback of Pride and Prejudice, which first appeared in 1813. The Agent then proposes a journal entry with that edition, your reading date, and your own note. Nothing is saved until you confirm in a separate message.

After you confirm, an append Action writes one row to the Events tab of a Google Sheet. The columns are reading ID, ISBN, title, edition link, status (reading, finished, paused or abandoned), date, your note, and a link back to the conversation. A second Action reads the sheet, so a fresh chat can find what you wrote. In the example, it returns "I kept noticing who misunderstood whom" for the finished Pride and Prejudice entry.

The guide also covers privacy. You turn off widget and embed access, set Chat Page Access to Nobody, keep the sheet's sharing on Restricted, and test in AI Preview. You need a Google account and AI credits to try a conversation. A downloadable starter kit has the example workbook, two TSV files, the Action settings, and the Main Prompt.

Build and customize AI assistants for customer support, sales, and internal use — no coding required.

Profile
Loading replies