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",[],[216,223],[216],{"_107":232,"_100":233,"_155":234,"_157":-5,"_158":141,"_159":140,"_161":162,"_109":235,"_104":236,"_164":226,"_166":237,"_167":27,"_168":-5,"_169":238,"_103":239},"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! 📚✨**",[],[233],"files",[152,171,182,193,203,214,221,231],"counts",{"_244":31,"_245":124,"_246":124,"_247":160},"pulls","branches","forks","envVars","contents",[250,253,256],{"_107":153,"_100":154,"_155":156,"_157":-5,"_158":141,"_159":160,"_161":162,"_109":251,"_104":31,"_164":165,"_166":-5,"_167":27,"_168":-5,"_103":252},["D",1747953038469],[154],{"_107":215,"_100":216,"_155":217,"_157":-5,"_158":141,"_159":218,"_161":162,"_109":254,"_104":31,"_164":165,"_166":-5,"_167":27,"_168":-5,"_103":255},["D",1748290903261],[216],{"_107":232,"_100":233,"_155":234,"_157":-5,"_158":141,"_159":140,"_161":162,"_109":257,"_104":236,"_164":226,"_166":237,"_167":27,"_168":-5,"_103":258},["D",1748332408384],[233],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","routes/_app.x.$handle.$name.remixes",{"_98":99,"_100":101,"_105":265,"_246":269,"_277":-5},{"_107":108,"_100":101,"_109":266,"_111":-5,"_112":27,"_113":114,"_115":116,"_117":118,"_12":119,"_120":-5,"_121":27,"_122":-5,"_123":124,"_14":125,"_126":127,"_128":127,"_129":130,"_131":130,"_132":130,"_133":127,"_134":127,"_21":267,"_138":268,"_149":27},["D",1747952823274],{"_98":99,"_136":137},{"_104":140,"_100":42,"_107":141,"_142":108,"_143":-5,"_144":-5,"_145":-5,"_146":-5,"_147":101,"_148":99},[270],{"_107":271,"_100":272,"_115":273,"_117":274,"_113":114,"_12":119,"_149":27,"_21":275,"_120":-5,"_121":27,"_109":276,"_123":31},"4ac6931c-3acc-11f0-96de-9e149126039e","book-lookup-browser","web app that lets you look up books with title+author or ISBN","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/aec0d867-386b-46da-2bf8-34b815d05400/square512",{"_98":99,"_136":137},["D",1748330955065],"upstream","routes/_app","actionData","errors"]