Book Metadata Lookup Tool

\n Paste your book data into the table below. You can include Author/Title or ISBNs, then click \"Process Records\" to fetch metadata from Google Books API.\n

\n \n \n

How to use:

• Paste from spreadsheet: Copy cells from Excel/Google Sheets and paste directly into the table
• Manual entry: Click any cell to edit directly
• Add rows: Use the \"Add Row\" button to create more entries
• Two lookup methods: Provide either (Author + Title) OR just ISBN for each book

\n \n \n

\n \n \n \n

\n Processing...\n

\n \n \n

Processing Results:

\n \n \n

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

Author	Title	ISBN	Year	Pages	Publisher	Description	Status

\n \n \n

\n\n \n\n",[],[215,222],[215],{"_102":231,"_95":232,"_154":233,"_156":-5,"_157":139,"_158":138,"_160":161,"_104":234,"_99":235,"_163":225,"_165":236,"_166":22,"_167":-5,"_168":237,"_98":238},"ad07fb6c-3acf-11f0-9cf6-9e149126039e","README.md","58f49894-375c-11f0-a0b7-9e149126039e",["D",1748332408384],15,"# 📚 Notion Book Database Auto-Populator\n\n**Automatically enrich your Notion book database with comprehensive metadata from Google Books API!**\n\nSimply add a book title + author (or just an ISBN) to your Notion database, click a button, and watch as all the missing details get filled in automatically - including ISBN, publication year, page count, publisher, description, ratings, and more.\n\n## 🚀 Quick Start\n\n### Step 1: Create Your Notion Database\n\nCreate a new Notion database with these **required columns**:\n\n| Column Name | Type | Description |\n|-------------|------|-------------|\n| **Title** | Title | The book's title |\n| **Author** | Rich Text | The book's author |\n| **ISBN** | Rich Text | Book's ISBN (auto-filled) |\n| **Year Published** | Number | Publication year (auto-filled) |\n| **Page Count** | Number | Number of pages (auto-filled) |\n| **Publisher** | Rich Text | Publisher name (auto-filled) |\n\n**Optional columns** you can add for even more data:\n- **Description** (Rich Text) - Book summary\n- **Categories** (Multi-select) - Genres/subjects \n- **Average Rating** (Number) - Google Books rating\n- **Ratings Count** (Number) - Number of ratings\n- **Language** (Rich Text) - Book language\n- **Subtitle** (Rich Text) - Book subtitle\n\n### Step 2: Set Up Notion Integration\n\n1. **Create a Notion Integration:**\n - Go to [https://www.notion.so/my-integrations](https://www.notion.so/my-integrations)\n - Click \"New integration\"\n - Give it a name like \"Book Auto-Populator\"\n - Copy the **Integration Token** (starts with `secret_`)\n\n2. **Share Your Database:**\n - Open your book database in Notion\n - Click the \"...\" menu → \"Add connections\"\n - Select your integration\n\n3. **Get Your Database ID:**\n - Copy the URL of your database page\n - Extract the database ID (the long string of letters/numbers after the last `/` and before any `?`)\n - Example: `https://notion.so/myworkspace/a8aec43384f447ed84390e8e42c2e089?v=...`\n - Database ID: `a8aec43384f447ed84390e8e42c2e089`\n\n### Step 3: Configure This Val\n\n1. **Fork this Val** to your account\n2. **Set Environment Variables:**\n - `NOTION_API_TOKEN` = Your integration token from Step 2\n - `NOTION_DATABASE_ID` = Your database ID from Step 2\n\n### Step 4: Test It!\n\n1. **Add a test book** to your Notion database:\n - Enter just the **Title** and **Author** (like \"The Great Gatsby\" and \"F. Scott Fitzgerald\")\n - OR just enter an **ISBN** (like \"9780743273565\")\n\n2. **Run the enrichment:**\n - Visit your Val URL: `https://your-val-name.web.val.run/`\n - Watch as the missing fields get automatically filled in!\n\n## 📖 How to Use\n\n### Adding Books (Two Methods)\n\n**Method 1: Title + Author**\n- Add the book title and author to a new row\n- The script will find and fill in ISBN, year, page count, publisher, etc.\n\n**Method 2: ISBN Only** \n- Add just the ISBN to a new row\n- The script will find and fill in title, author, year, page count, publisher, etc.\n- Perfect when you have a book in hand but don't want to type details!\n\n### Running the Enrichment\n\n**Process all incomplete books:**\n```\nGET https://your-val-name.web.val.run/\n```\n\n**Check if everything is set up correctly:**\n```\nGET https://your-val-name.web.val.run/status\n```\n\n**Process just one specific book:**\n```\nGET https://your-val-name.web.val.run/process/NOTION_RECORD_ID\n```\n\n**See all available commands:**\n```\nGET https://your-val-name.web.val.run/help\n```\n\n## 🔗 Linking to Your Main Reading Database\n\nWant to connect this lookup database to your main reading tracker? Here's how:\n\n1. **In your main reading database**, add a new property:\n - **Name:** \"Book Info\"\n - **Type:** Relation \n - **Related database:** Your book lookup database\n\n2. **Add rollup properties** to display the metadata:\n - **ISBN:** Rollup → Book Info → ISBN\n - **Year:** Rollup → Book Info → Year Published\n - **Pages:** Rollup → Book Info → Page Count\n - **Publisher:** Rollup → Book Info → Publisher\n\nNow when you add a book to your reading list, just link it to the enriched record!\n\n## ✨ What Gets Auto-Filled\n\nThis tool pulls comprehensive metadata from Google Books API:\n\n**Always Filled:**\n- ✅ ISBN (prefers ISBN-13, falls back to ISBN-10)\n- ✅ Publication Year\n- ✅ Page Count \n- ✅ Publisher\n\n**Often Available:**\n- 📝 Description/Summary\n- 🏷️ Categories/Genres\n- ⭐ Average Rating\n- 📊 Number of Ratings\n- 🌍 Language\n- 📅 Full Publication Date\n- 🔗 Google Books Preview Link\n\n## 🛠️ Troubleshooting\n\n**\"System not properly configured\" error:**\n- Check that both environment variables are set correctly\n- Verify your Notion integration has access to the database\n\n**No books getting processed:**\n- Make sure you have books with Title+Author OR ISBN but missing other fields\n- Check that your database column names match exactly (case-sensitive)\n\n**Books not found:**\n- Try adding more specific author information\n- Some books may not be in Google Books database\n- Check that Title and Author are spelled correctly\n\n## 🔧 Advanced Usage\n\n**Manual Processing:** The system only processes books when you visit the URL - no automatic background processing\n\n**Smart Matching:** Uses both exact and relaxed search algorithms to find the best matches\n\n**Data Preservation:** Only fills in empty fields - never overwrites your existing data\n\n**Expandable:** Add any of the optional columns to capture even more book metadata\n\n## 📁 Project Structure\n\n- `backend/index.ts` - Main HTTP endpoints and API\n- `backend/notion.ts` - Notion database integration \n- `backend/books.ts` - Google Books API integration\n- `backend/processor.ts` - Core processing logic\n\n---\n\n**Ready to automatically enrich your book collection? Fork this Val and start building your ultimate book database! 📚✨**",[],[232],"files",[151,170,181,192,202,213,220,230],"counts",{"_243":32,"_244":119,"_245":119,"_246":247},"pulls","branches","forks","envVars",{"_248":159,"_249":32},"count","emptyCount","contents",[252,255,258],{"_102":152,"_95":153,"_154":155,"_156":-5,"_157":139,"_158":159,"_160":161,"_104":253,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":254},["D",1747953038469],[153],{"_102":214,"_95":215,"_154":216,"_156":-5,"_157":139,"_158":217,"_160":161,"_104":256,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":257},["D",1748290903261],[215],{"_102":231,"_95":232,"_154":233,"_156":-5,"_157":139,"_158":138,"_160":161,"_104":259,"_99":235,"_163":225,"_165":236,"_166":22,"_167":-5,"_98":260},["D",1748332408384],[232],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.environment-variables",{"_93":94,"_95":96,"_100":269,"_246":274},{"_102":103,"_95":96,"_104":270,"_106":-5,"_107":22,"_108":109,"_110":111,"_112":113,"_14":114,"_115":-5,"_116":22,"_117":-5,"_118":119,"_16":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":271,"_133":272,"_136":273,"_148":22},["D",1747952823274],{"_93":94,"_131":132},{"_93":94,"_135":132,"_14":114},{"_99":138,"_95":43,"_102":139,"_140":103,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":96,"_147":94},[275,282],{"_276":277,"_104":278,"_279":280,"_110":72,"_281":22},"key","NOTION_DATABASE_ID",["D",1747954449229],"updatedAt",["D",1747955460120],"isEmpty",{"_276":283,"_104":284,"_279":285,"_110":72,"_281":22},"NOTION_API_TOKEN",["D",1747954438611],["D",1747955247013],"actionData","errors"]

Key	Description
NOTION_DATABASE_ID
NOTION_API_TOKEN

nucky

book-lookup-notion

Environment variables