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",[18,64],"pulls","branches","forks","envVars",{"_164":166,"_167":26},"connections",{"_164":26,"_165":26},"count","unfilledCount",2,"emptyCount",{"_33":230,"_13":202,"_62":194,"_43":-5,"_35":36,"_146":166,"_147":24,"_37":231,"_39":26,"_65":71,"_149":-5,"_66":30,"_150":-5,"_182":232,"_17":233},{"_33":221,"_13":222,"_62":223,"_43":194,"_35":36,"_146":224,"_147":24,"_37":225,"_39":226,"_65":198,"_149":227,"_66":30,"_150":-5,"_182":228,"_17":229},{"_33":212,"_13":213,"_62":85,"_43":194,"_35":36,"_146":214,"_147":24,"_37":215,"_39":216,"_65":217,"_149":218,"_66":30,"_150":-5,"_182":219,"_17":220},{"_33":203,"_13":204,"_62":205,"_43":194,"_35":36,"_146":206,"_147":24,"_37":207,"_39":208,"_65":198,"_149":209,"_66":30,"_150":-5,"_182":210,"_17":211},{"_33":191,"_13":192,"_62":193,"_43":194,"_35":36,"_146":195,"_147":24,"_37":196,"_39":197,"_65":198,"_149":199,"_66":30,"_150":-5,"_182":200,"_17":201},{"_33":145,"_13":18,"_62":70,"_43":-5,"_35":36,"_146":40,"_147":24,"_37":188,"_39":26,"_65":71,"_149":-5,"_66":30,"_150":-5,"_182":189,"_17":190},{"_33":153,"_13":64,"_62":63,"_43":70,"_35":36,"_146":40,"_147":24,"_37":185,"_39":26,"_65":21,"_149":155,"_66":30,"_150":-5,"_182":186,"_17":187},{"_33":176,"_13":177,"_62":178,"_43":-5,"_35":36,"_146":110,"_147":24,"_37":179,"_39":180,"_65":21,"_149":181,"_66":30,"_150":-5,"_182":183,"_17":184},"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! 📚✨**","children",[],[177],["D",1748290903261],[],[18,64],["D",1748290903261],[174],[18],"0b2d3cc4-3775-11f0-bb35-9e149126039e","processor.ts","7ba8aaa6-375c-11f0-9948-9e149126039e","ba931684-cf88-4b01-bc83-bc2015e23f85",77,["D",1747963628664],3,"script","/**\n * Main processing logic for enriching book records\n */\n\nimport { getIncompleteRecords, updateBookRecord, NotionBookRecord, BookMetadata } from './notion.ts';\nimport { searchBookMetadata, searchBookMetadataRelaxed, searchBookMetadataByISBN } from './books.ts';\n\nexport interface ProcessingResult {\n totalProcessed: number;\n successful: number;\n failed: number;\n skipped: number;\n details: Array<{\n id: string;\n title: string;\n author: string;\n status: 'success' | 'failed' | 'skipped';\n metadata?: BookMetadata;\n error?: string;\n }>;\n}\n\n/**\n * Process all incomplete book records\n */\nexport async function processIncompleteRecords(): Promise {\n const result: ProcessingResult = {\n totalProcessed: 0,\n successful: 0,\n failed: 0,\n skipped: 0,\n details: []\n };\n\n try {\n console.log('Fetching incomplete records from Notion...');\n const records = await getIncompleteRecords();\n \n console.log(`Found ${records.length} records to process`);\n result.totalProcessed = records.length;\n\n for (const record of records) {\n // Determine search strategy based on available data\n const hasTitle = record.title && record.title.trim();\n const hasAuthor = record.author && record.author.trim();\n const hasISBN = record.isbn && record.isbn.trim();\n\n if (!hasTitle && !hasAuthor && !hasISBN) {\n result.skipped++;\n result.details.push({\n id: record.id,\n title: record.title || 'Unknown',\n author: record.author || 'Unknown',\n status: 'skipped',\n error: 'Missing title, author, and ISBN - need at least one'\n });\n continue;\n }\n\n try {\n let metadata: BookMetadata | null = null;\n\n // Strategy 1: If we have title and author, search by those\n if (hasTitle && hasAuthor) {\n console.log(`Processing: \"${record.title}\" by \"${record.author}\"`);\n \n // Try exact search first\n metadata = await searchBookMetadata(record.title, record.author);\n \n // If no results, try relaxed search\n if (!metadata) {\n console.log('Exact search failed, trying relaxed search...');\n metadata = await searchBookMetadataRelaxed(record.title, record.author);\n }\n }\n // Strategy 2: If we have ISBN but missing title/author, search by ISBN\n else if (hasISBN && (!hasTitle || !hasAuthor)) {\n console.log(`Processing by ISBN: ${record.isbn} (missing title/author)`);\n metadata = await searchBookMetadataByISBN(record.isbn);\n }\n // Strategy 3: If we only have ISBN and already have title/author, still try ISBN search for missing metadata\n else if (hasISBN) {\n console.log(`Processing by ISBN: ${record.isbn} for additional metadata`);\n metadata = await searchBookMetadataByISBN(record.isbn);\n }\n\n if (!metadata) {\n result.failed++;\n result.details.push({\n id: record.id,\n title: record.title || 'Unknown',\n author: record.author || 'Unknown',\n status: 'failed',\n error: 'No metadata found'\n });\n continue;\n }\n\n // Only update fields that are currently empty\n const updateMetadata: BookMetadata = {};\n \n // Update title if missing and found\n if (!record.title && metadata.title) {\n updateMetadata.title = metadata.title;\n }\n \n // Update author if missing and found\n if (!record.author && metadata.author) {\n updateMetadata.author = metadata.author;\n }\n \n if (!record.isbn && metadata.isbn) {\n updateMetadata.isbn = metadata.isbn;\n }\n \n if (!record.yearPublished && metadata.yearPublished) {\n updateMetadata.yearPublished = metadata.yearPublished;\n }\n \n if (!record.pageCount && metadata.pageCount) {\n updateMetadata.pageCount = metadata.pageCount;\n }\n \n if (!record.publisher && metadata.publisher) {\n updateMetadata.publisher = metadata.publisher;\n }\n\n // Include additional metadata for the update function to handle\n // (it will try to update these separately and skip if properties don't exist)\n if (metadata.subtitle) {\n updateMetadata.subtitle = metadata.subtitle;\n }\n \n if (metadata.description) {\n updateMetadata.description = metadata.description;\n }\n \n if (metadata.categories) {\n updateMetadata.categories = metadata.categories;\n }\n \n if (metadata.averageRating) {\n updateMetadata.averageRating = metadata.averageRating;\n }\n \n if (metadata.ratingsCount) {\n updateMetadata.ratingsCount = metadata.ratingsCount;\n }\n \n if (metadata.language) {\n updateMetadata.language = metadata.language;\n }\n \n if (metadata.publishedDate) {\n updateMetadata.publishedDate = metadata.publishedDate;\n }\n \n if (metadata.previewLink) {\n updateMetadata.previewLink = metadata.previewLink;\n }\n \n if (metadata.infoLink) {\n updateMetadata.infoLink = metadata.infoLink;\n }\n \n if (metadata.imageLinks) {\n updateMetadata.imageLinks = metadata.imageLinks;\n }\n\n // Only update if we have something to update\n if (Object.keys(updateMetadata).length > 0) {\n await updateBookRecord(record.id, updateMetadata);\n console.log(`Successfully updated: \"${record.title || metadata.title || 'Unknown'}\"`);\n \n result.successful++;\n result.details.push({\n id: record.id,\n title: record.title || metadata.title || 'Unknown',\n author: record.author || metadata.author || 'Unknown',\n status: 'success',\n metadata: updateMetadata\n });\n } else {\n result.skipped++;\n result.details.push({\n id: record.id,\n title: record.title || 'Unknown',\n author: record.author || 'Unknown',\n status: 'skipped',\n error: 'All fields already populated'\n });\n }\n\n // Add a small delay to be respectful to APIs\n await new Promise(resolve => setTimeout(resolve, 500));\n\n } catch (error) {\n console.error(`Error processing \"${record.title || record.isbn || 'Unknown'}\":`, error);\n result.failed++;\n result.details.push({\n id: record.id,\n title: record.title || 'Unknown',\n author: record.author || 'Unknown',\n status: 'failed',\n error: error instanceof Error ? error.message : 'Unknown error'\n });\n }\n }\n\n console.log(`Processing complete: ${result.successful} successful, ${result.failed} failed, ${result.skipped} skipped`);\n return result;\n\n } catch (error) {\n console.error('Error in processIncompleteRecords:', error);\n throw error;\n }\n}\n\n/**\n * Process a single book record by ID\n */\nexport async function processSingleRecord(recordId: string): Promise {\n // This would require fetching a single record from Notion\n // For now, we'll process all and filter, but this could be optimized\n const allResults = await processIncompleteRecords();\n \n const singleResult = allResults.details.find(detail => detail.id === recordId);\n \n if (!singleResult) {\n return {\n totalProcessed: 0,\n successful: 0,\n failed: 1,\n skipped: 0,\n details: [{\n id: recordId,\n title: 'Unknown',\n author: 'Unknown',\n status: 'failed',\n error: 'Record not found or already complete'\n }]\n };\n }\n\n return {\n totalProcessed: 1,\n successful: singleResult.status === 'success' ? 1 : 0,\n failed: singleResult.status === 'failed' ? 1 : 0,\n skipped: singleResult.status === 'skipped' ? 1 : 0,\n details: [singleResult]\n };\n}",[],[202,192],"backend","01cf3a92-3775-11f0-9e89-9e149126039e","notion.ts","62edf002-375c-11f0-8c16-9e149126039e",76,["D",1747963612945],34,"/**\n * Notion API integration for book database\n */\n\nexport interface NotionBookRecord {\n id: string;\n title?: string;\n author?: string;\n isbn?: string;\n yearPublished?: number;\n pageCount?: number;\n publisher?: string;\n // Additional Google Books metadata\n subtitle?: string;\n description?: string;\n categories?: string[];\n averageRating?: number;\n ratingsCount?: number;\n language?: string;\n publishedDate?: string;\n previewLink?: string;\n infoLink?: string;\n imageLinks?: string; // Store as JSON string\n // Status tracking\n processed?: boolean;\n lastUpdated?: string;\n}\n\nexport interface BookMetadata {\n // Core fields (mapped to Notion database)\n title?: string;\n author?: string;\n isbn?: string;\n yearPublished?: number;\n pageCount?: number;\n publisher?: string;\n \n // Additional Google Books fields (available for future use)\n subtitle?: string;\n description?: string;\n categories?: string[];\n averageRating?: number;\n ratingsCount?: number;\n language?: string;\n publishedDate?: string;\n previewLink?: string;\n infoLink?: string;\n imageLinks?: {\n smallThumbnail?: string;\n thumbnail?: string;\n small?: string;\n medium?: string;\n large?: string;\n extraLarge?: string;\n };\n}\n\nconst NOTION_API_BASE = 'https://api.notion.com/v1';\n\n/**\n * Get records from Notion database that need metadata enrichment\n * This includes:\n * 1. Records with Title + Author but missing other metadata\n * 2. Records with ISBN but missing Title + Author\n */\nexport async function getIncompleteRecords(): Promise {\n const token = Deno.env.get('NOTION_API_TOKEN');\n const databaseId = Deno.env.get('NOTION_DATABASE_ID');\n \n if (!token || !databaseId) {\n throw new Error('Missing NOTION_API_TOKEN or NOTION_DATABASE_ID environment variables');\n }\n\n console.log('Debug info:', {\n tokenPrefix: token.substring(0, 10) + '...',\n databaseIdLength: databaseId.length,\n databaseIdPrefix: databaseId.substring(0, 8) + '...'\n });\n\n const response = await fetch(`${NOTION_API_BASE}/databases/${databaseId}/query`, {\n method: 'POST',\n headers: {\n 'Authorization': `Bearer ${token}`,\n 'Content-Type': 'application/json',\n 'Notion-Version': '2022-06-28',\n },\n body: JSON.stringify({\n filter: {\n or: [\n // Records with Title + Author but missing ISBN\n {\n and: [\n {\n property: 'Title',\n title: {\n is_not_empty: true\n }\n },\n {\n property: 'Author',\n rich_text: {\n is_not_empty: true\n }\n },\n {\n property: 'ISBN',\n rich_text: {\n is_empty: true\n }\n }\n ]\n },\n // Records with Title + Author but missing Year Published\n {\n and: [\n {\n property: 'Title',\n title: {\n is_not_empty: true\n }\n },\n {\n property: 'Author',\n rich_text: {\n is_not_empty: true\n }\n },\n {\n property: 'Year Published',\n number: {\n is_empty: true\n }\n }\n ]\n },\n // Records with Title + Author but missing Page Count\n {\n and: [\n {\n property: 'Title',\n title: {\n is_not_empty: true\n }\n },\n {\n property: 'Author',\n rich_text: {\n is_not_empty: true\n }\n },\n {\n property: 'Page Count',\n number: {\n is_empty: true\n }\n }\n ]\n },\n // Records with Title + Author but missing Publisher\n {\n and: [\n {\n property: 'Title',\n title: {\n is_not_empty: true\n }\n },\n {\n property: 'Author',\n rich_text: {\n is_not_empty: true\n }\n },\n {\n property: 'Publisher',\n rich_text: {\n is_empty: true\n }\n }\n ]\n },\n // Records with ISBN but missing Title\n {\n and: [\n {\n property: 'ISBN',\n rich_text: {\n is_not_empty: true\n }\n },\n {\n property: 'Title',\n title: {\n is_empty: true\n }\n }\n ]\n },\n // Records with ISBN but missing Author\n {\n and: [\n {\n property: 'ISBN',\n rich_text: {\n is_not_empty: true\n }\n },\n {\n property: 'Author',\n rich_text: {\n is_empty: true\n }\n }\n ]\n }\n ]\n }\n })\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n console.error('Notion API Error Details:', {\n status: response.status,\n statusText: response.statusText,\n errorText,\n headers: Object.fromEntries(response.headers.entries())\n });\n throw new Error(`Notion API error: ${response.status} ${response.statusText} - ${errorText}`);\n }\n\n const data = await response.json();\n \n return data.results.map((page: any) => ({\n id: page.id,\n title: page.properties.Title?.title?.[0]?.text?.content,\n author: page.properties.Author?.rich_text?.[0]?.text?.content,\n isbn: page.properties.ISBN?.rich_text?.[0]?.text?.content,\n yearPublished: page.properties['Year Published']?.number,\n pageCount: page.properties['Page Count']?.number,\n publisher: page.properties.Publisher?.rich_text?.[0]?.text?.content,\n // Optional additional fields (if they exist)\n subtitle: page.properties.Subtitle?.rich_text?.[0]?.text?.content,\n description: page.properties.Description?.rich_text?.[0]?.text?.content,\n categories: page.properties.Categories?.multi_select?.map((cat: any) => cat.name),\n averageRating: page.properties['Average Rating']?.number,\n ratingsCount: page.properties['Ratings Count']?.number,\n language: page.properties.Language?.rich_text?.[0]?.text?.content,\n publishedDate: page.properties['Published Date']?.rich_text?.[0]?.text?.content,\n previewLink: page.properties['Preview Link']?.url,\n infoLink: page.properties['Info Link']?.url,\n imageLinks: page.properties['Image Links']?.rich_text?.[0]?.text?.content,\n processed: page.properties.Processed?.checkbox,\n lastUpdated: page.properties['Last Updated']?.last_edited_time,\n }));\n}\n\n/**\n * Update a Notion record with book metadata\n */\nexport async function updateBookRecord(recordId: string, metadata: BookMetadata): Promise {\n const token = Deno.env.get('NOTION_API_TOKEN');\n \n if (!token) {\n throw new Error('Missing NOTION_API_TOKEN environment variable');\n }\n\n const properties: any = {};\n\n // Core metadata fields (always try to update these)\n if (metadata.title) {\n properties.Title = {\n title: [\n {\n text: {\n content: metadata.title\n }\n }\n ]\n };\n }\n\n if (metadata.author) {\n properties.Author = {\n rich_text: [\n {\n text: {\n content: metadata.author\n }\n }\n ]\n };\n }\n\n if (metadata.isbn) {\n properties.ISBN = {\n rich_text: [\n {\n text: {\n content: metadata.isbn\n }\n }\n ]\n };\n }\n\n if (metadata.yearPublished) {\n properties['Year Published'] = {\n number: metadata.yearPublished\n };\n }\n\n if (metadata.pageCount) {\n properties['Page Count'] = {\n number: metadata.pageCount\n };\n }\n\n if (metadata.publisher) {\n properties.Publisher = {\n rich_text: [\n {\n text: {\n content: metadata.publisher\n }\n }\n ]\n };\n }\n\n // Additional Google Books metadata (only if columns exist)\n // We'll try to update these separately to avoid failing the core update\n const additionalProperties: any = {};\n \n if (metadata.subtitle) {\n additionalProperties.Subtitle = {\n rich_text: [\n {\n text: {\n content: metadata.subtitle\n }\n }\n ]\n };\n }\n\n if (metadata.description) {\n const truncatedDescription = metadata.description.length > 2000 \n ? metadata.description.substring(0, 1997) + \"...\"\n : metadata.description;\n \n additionalProperties.Description = {\n rich_text: [\n {\n text: {\n content: truncatedDescription\n }\n }\n ]\n };\n }\n\n if (metadata.categories && metadata.categories.length > 0) {\n additionalProperties.Categories = {\n multi_select: metadata.categories.slice(0, 10).map(cat => ({ name: cat }))\n };\n }\n\n if (metadata.averageRating) {\n additionalProperties['Average Rating'] = {\n number: metadata.averageRating\n };\n }\n\n if (metadata.ratingsCount) {\n additionalProperties['Ratings Count'] = {\n number: metadata.ratingsCount\n };\n }\n\n if (metadata.language) {\n additionalProperties.Language = {\n rich_text: [\n {\n text: {\n content: metadata.language\n }\n }\n ]\n };\n }\n\n if (metadata.publishedDate) {\n additionalProperties['Published Date'] = {\n rich_text: [\n {\n text: {\n content: metadata.publishedDate\n }\n }\n ]\n };\n }\n\n if (metadata.previewLink) {\n additionalProperties['Preview Link'] = {\n url: metadata.previewLink\n };\n }\n\n if (metadata.infoLink) {\n additionalProperties['Info Link'] = {\n url: metadata.infoLink\n };\n }\n\n if (metadata.imageLinks) {\n additionalProperties['Image Links'] = {\n rich_text: [\n {\n text: {\n content: JSON.stringify(metadata.imageLinks)\n }\n }\n ]\n };\n }\n\n // First, update core properties only\n const response = await fetch(`${NOTION_API_BASE}/pages/${recordId}`, {\n method: 'PATCH',\n headers: {\n 'Authorization': `Bearer ${token}`,\n 'Content-Type': 'application/json',\n 'Notion-Version': '2022-06-28',\n },\n body: JSON.stringify({\n properties\n })\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n throw new Error(`Failed to update Notion record: ${response.status} ${response.statusText} - ${errorText}`);\n }\n\n // Then try to update additional properties one by one\n // This way if some properties don't exist, others can still be updated\n for (const [propName, propValue] of Object.entries(additionalProperties)) {\n try {\n const additionalResponse = await fetch(`${NOTION_API_BASE}/pages/${recordId}`, {\n method: 'PATCH',\n headers: {\n 'Authorization': `Bearer ${token}`,\n 'Content-Type': 'application/json',\n 'Notion-Version': '2022-06-28',\n },\n body: JSON.stringify({\n properties: {\n [propName]: propValue\n }\n })\n });\n \n if (!additionalResponse.ok) {\n console.log(`Property \"${propName}\" doesn't exist in database, skipping...`);\n }\n } catch (error) {\n console.log(`Failed to update property \"${propName}\", skipping...`);\n }\n }\n}",[],[202,204],"1f6ae754-3770-11f0-888c-9e149126039e","index.ts",60,["D",1747961515134],5,"http","/**\n * Notion Book Database Auto-Populator\n * Main HTTP handler and API endpoints\n */\n\nimport { Hono } from 'https://esm.sh/hono@3.11.7';\nimport { processIncompleteRecords, processSingleRecord } from './processor.ts';\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n/**\n * Main endpoint - process all incomplete records\n */\napp.get('/', async (c) => {\n try {\n console.log('Starting book metadata enrichment process...');\n const result = await processIncompleteRecords();\n \n return c.json({\n success: true,\n message: 'Processing completed',\n result,\n timestamp: new Date().toISOString()\n });\n } catch (error) {\n console.error('Error in main process:', error);\n \n return c.json({\n success: false,\n error: error instanceof Error ? error.message : 'Unknown error',\n timestamp: new Date().toISOString()\n }, 500);\n }\n});\n\n/**\n * Status endpoint - check configuration and system status\n */\napp.get('/status', async (c) => {\n const hasNotionToken = !!Deno.env.get('NOTION_API_TOKEN');\n const hasNotionDatabase = !!Deno.env.get('NOTION_DATABASE_ID');\n \n const status = {\n configured: hasNotionToken && hasNotionDatabase,\n notion_token: hasNotionToken ? 'Set' : 'Missing',\n notion_database: hasNotionDatabase ? 'Set' : 'Missing',\n timestamp: new Date().toISOString()\n };\n\n if (!status.configured) {\n return c.json({\n success: false,\n message: 'System not properly configured',\n status,\n setup_instructions: {\n notion_token: 'Set NOTION_API_TOKEN environment variable with your Notion integration token',\n notion_database: 'Set NOTION_DATABASE_ID environment variable with your book database ID'\n }\n }, 400);\n }\n\n return c.json({\n success: true,\n message: 'System ready',\n status\n });\n});\n\n/**\n * Process a specific record by ID\n */\napp.get('/process/:recordId', async (c) => {\n const recordId = c.req.param('recordId');\n \n if (!recordId) {\n return c.json({\n success: false,\n error: 'Record ID is required'\n }, 400);\n }\n\n try {\n const result = await processSingleRecord(recordId);\n \n return c.json({\n success: true,\n message: 'Record processing completed',\n result,\n timestamp: new Date().toISOString()\n });\n } catch (error) {\n console.error(`Error processing record ${recordId}:`, error);\n \n return c.json({\n success: false,\n error: error instanceof Error ? error.message : 'Unknown error',\n timestamp: new Date().toISOString()\n }, 500);\n }\n});\n\n/**\n * Debug endpoint - check environment variables (remove in production)\n */\napp.get('/debug', (c) => {\n const token = Deno.env.get('NOTION_API_TOKEN');\n const databaseId = Deno.env.get('NOTION_DATABASE_ID');\n \n return c.json({\n token_info: {\n exists: !!token,\n length: token?.length || 0,\n prefix: token?.substring(0, 10) + '...' || 'N/A'\n },\n database_info: {\n exists: !!databaseId,\n length: databaseId?.length || 0,\n prefix: databaseId?.substring(0, 8) + '...' || 'N/A'\n }\n });\n});\n\n/**\n * Test Open Library endpoint for debugging\n */\napp.get('/test-worldcat/:title/:author', async (c) => {\n const title = c.req.param('title');\n const author = c.req.param('author');\n \n try {\n const query = `title:\"${title.trim()}\" author:\"${author.trim()}\"`;\n const encodedQuery = encodeURIComponent(query);\n \n const response = await fetch(\n `https://openlibrary.org/search.json?q=${encodedQuery}&limit=5`\n );\n\n const data = await response.json();\n \n return c.json({\n query,\n status: response.status,\n resultCount: data.docs?.length || 0,\n firstResult: data.docs?.[0] || null\n });\n } catch (error) {\n return c.json({\n error: error instanceof Error ? error.message : 'Unknown error'\n }, 500);\n }\n});\n\n/**\n * Health check endpoint\n */\napp.get('/health', (c) => {\n return c.json({\n status: 'healthy',\n timestamp: new Date().toISOString()\n });\n});\n\n/**\n * Help endpoint with usage instructions\n */\napp.get('/help', (c) => {\n return c.json({\n title: 'Notion Book Database Auto-Populator',\n description: 'Automatically enriches your Notion book database with metadata from Google Books API',\n endpoints: {\n 'GET /': 'Process all incomplete records',\n 'GET /status': 'Check system configuration and status',\n 'GET /process/:recordId': 'Process a specific record by ID',\n 'GET /health': 'Health check',\n 'GET /help': 'This help message'\n },\n setup: {\n step1: 'Create a Notion integration at https://www.notion.so/my-integrations',\n step2: 'Copy the integration token and set it as NOTION_API_TOKEN environment variable',\n step3: 'Share your book database with the integration',\n step4: 'Copy the database ID from the URL and set it as NOTION_DATABASE_ID environment variable',\n step5: 'Ensure your database has these properties: Title (title), Author (rich text), ISBN (rich text), Year Published (number), Page Count (number), Publisher (rich text)'\n },\n database_properties: {\n required: ['Title (title)', 'Author (rich text)'],\n populated: ['ISBN (rich text)', 'Year Published (number)', 'Page Count (number)', 'Publisher (rich text)'],\n optional: ['Rating (number)', 'Progress (select)', 'Start Date (date)', 'Finish Date (date)', 'Notes (rich text)']\n }\n });\n});\n\n// This is the entry point for HTTP vals\nexport default app.fetch;",[],[202,213],"558cdee2-3774-11f0-94c7-9e149126039e","books.ts","70297fca-375c-11f0-b228-9e149126039e",66,["D",1747963323943],12,"/**\n * Google Books API integration for comprehensive book metadata\n */\n\nimport { BookMetadata } from './notion.ts';\n\n/**\n * Search for book metadata using Google Books API\n */\nexport async function searchBookMetadata(title: string, author: string): Promise {\n return await searchGoogleBooks(title, author);\n}\n\n/**\n * Search for book metadata using ISBN\n */\nexport async function searchBookMetadataByISBN(isbn: string): Promise {\n try {\n console.log(`Searching Google Books by ISBN: ${isbn}`);\n \n // Clean the ISBN (remove hyphens, spaces)\n const cleanISBN = isbn.replace(/[-\\s]/g, '');\n \n const response = await fetch(\n `https://www.googleapis.com/books/v1/volumes?q=isbn:${cleanISBN}`\n );\n\n if (!response.ok) {\n console.error(`Google Books API error: ${response.status} ${response.statusText}`);\n return null;\n }\n\n const data = await response.json();\n console.log(`Google Books found ${data.totalItems || 0} results for ISBN ${isbn}`);\n \n if (!data.items || data.items.length === 0) {\n console.log(`No books found for ISBN: ${isbn}`);\n return null;\n }\n\n // ISBN search should return exact match, so take the first result\n const item = data.items[0];\n const volumeInfo = item.volumeInfo;\n \n if (!volumeInfo) {\n return null;\n }\n\n console.log(`Found: \"${volumeInfo.title}\" by ${volumeInfo.authors?.[0]}`);\n\n // Extract all available metadata\n const publishedDate = volumeInfo.publishedDate;\n let year = null;\n if (publishedDate) {\n const yearMatch = publishedDate.match(/^\\d{4}/);\n if (yearMatch) {\n year = parseInt(yearMatch[0]);\n }\n }\n\n // Get ISBN (prefer ISBN-13, fallback to ISBN-10)\n let foundISBN = null;\n if (volumeInfo.industryIdentifiers) {\n const isbn13 = volumeInfo.industryIdentifiers.find((id: any) => id.type === 'ISBN_13');\n const isbn10 = volumeInfo.industryIdentifiers.find((id: any) => id.type === 'ISBN_10');\n foundISBN = isbn13?.identifier || isbn10?.identifier;\n }\n\n // Return comprehensive metadata object\n const metadata: BookMetadata = {};\n \n // Include title and author since they might be missing from the record\n if (volumeInfo.title) {\n metadata.title = volumeInfo.title;\n }\n \n if (volumeInfo.authors && volumeInfo.authors.length > 0) {\n metadata.author = volumeInfo.authors[0]; // Take first author\n }\n \n if (year) {\n metadata.yearPublished = year;\n }\n \n if (volumeInfo.publisher) {\n metadata.publisher = volumeInfo.publisher;\n }\n\n if (volumeInfo.pageCount) {\n metadata.pageCount = volumeInfo.pageCount;\n }\n\n if (foundISBN) {\n metadata.isbn = foundISBN;\n }\n\n // Additional fields\n if (volumeInfo.subtitle) {\n metadata.subtitle = volumeInfo.subtitle;\n }\n\n if (volumeInfo.description) {\n metadata.description = volumeInfo.description;\n }\n\n if (volumeInfo.categories && volumeInfo.categories.length > 0) {\n metadata.categories = volumeInfo.categories;\n }\n\n if (volumeInfo.averageRating) {\n metadata.averageRating = volumeInfo.averageRating;\n }\n\n if (volumeInfo.ratingsCount) {\n metadata.ratingsCount = volumeInfo.ratingsCount;\n }\n\n if (volumeInfo.language) {\n metadata.language = volumeInfo.language;\n }\n\n if (volumeInfo.publishedDate) {\n metadata.publishedDate = volumeInfo.publishedDate;\n }\n\n if (volumeInfo.previewLink) {\n metadata.previewLink = volumeInfo.previewLink;\n }\n\n if (volumeInfo.infoLink) {\n metadata.infoLink = volumeInfo.infoLink;\n }\n\n if (volumeInfo.imageLinks) {\n metadata.imageLinks = volumeInfo.imageLinks;\n }\n\n return metadata;\n } catch (error) {\n console.error('Error searching Google Books by ISBN:', error);\n return null;\n }\n}\n\n/**\n * Search Google Books API for comprehensive book data\n */\nasync function searchGoogleBooks(title: string, author: string): Promise {\n try {\n console.log(`Searching Google Books for: \"${title}\" by \"${author}\"`);\n \n // Google Books API search with title and author\n const query = `intitle:\"${title.trim()}\" inauthor:\"${author.trim()}\"`;\n const encodedQuery = encodeURIComponent(query);\n \n const response = await fetch(\n `https://www.googleapis.com/books/v1/volumes?q=${encodedQuery}&maxResults=20&printType=books`\n );\n\n if (!response.ok) {\n console.error(`Google Books API error: ${response.status} ${response.statusText}`);\n return null;\n }\n\n const data = await response.json();\n console.log(`Google Books found ${data.totalItems || 0} results`);\n \n if (!data.items || data.items.length === 0) {\n console.log(`No books found for: \"${title}\" by \"${author}\"`);\n return null;\n }\n\n return findBestGoogleBooksMatch(data.items, title, author);\n } catch (error) {\n console.error('Error searching Google Books:', error);\n return null;\n }\n}\n\n/**\n * Find the best matching book from Google Books results\n */\nfunction findBestGoogleBooksMatch(items: any[], targetTitle: string, targetAuthor: string): BookMetadata | null {\n const normalize = (s: string) => s.toLowerCase().replace(/[^\\w\\s]/g, '').trim();\n const normalizedTargetTitle = normalize(targetTitle);\n const normalizedTargetAuthor = normalize(targetAuthor);\n\n const candidates = [];\n\n for (const item of items) {\n const volumeInfo = item.volumeInfo;\n if (!volumeInfo.title || !volumeInfo.authors) continue;\n\n const bookTitle = normalize(volumeInfo.title);\n const bookAuthors = volumeInfo.authors.map((author: string) => normalize(author));\n\n // Check for title and author match\n const titleMatch = bookTitle.includes(normalizedTargetTitle) || normalizedTargetTitle.includes(bookTitle);\n const authorMatch = bookAuthors.some((author: string) => \n author.includes(normalizedTargetAuthor) || normalizedTargetAuthor.includes(author)\n );\n\n if (titleMatch && authorMatch) {\n // Extract all available metadata\n const publishedDate = volumeInfo.publishedDate;\n let year = null;\n if (publishedDate) {\n const yearMatch = publishedDate.match(/^\\d{4}/);\n if (yearMatch) {\n year = parseInt(yearMatch[0]);\n }\n }\n\n // Get ISBN (prefer ISBN-13, fallback to ISBN-10)\n let isbn = null;\n if (volumeInfo.industryIdentifiers) {\n const isbn13 = volumeInfo.industryIdentifiers.find((id: any) => id.type === 'ISBN_13');\n const isbn10 = volumeInfo.industryIdentifiers.find((id: any) => id.type === 'ISBN_10');\n isbn = isbn13?.identifier || isbn10?.identifier;\n }\n\n candidates.push({\n title: volumeInfo.title,\n subtitle: volumeInfo.subtitle,\n authors: volumeInfo.authors,\n publisher: volumeInfo.publisher,\n publishedDate: volumeInfo.publishedDate,\n year: year,\n description: volumeInfo.description,\n pageCount: volumeInfo.pageCount,\n categories: volumeInfo.categories,\n averageRating: volumeInfo.averageRating,\n ratingsCount: volumeInfo.ratingsCount,\n maturityRating: volumeInfo.maturityRating,\n language: volumeInfo.language,\n previewLink: volumeInfo.previewLink,\n infoLink: volumeInfo.infoLink,\n canonicalVolumeLink: volumeInfo.canonicalVolumeLink,\n isbn: isbn,\n imageLinks: volumeInfo.imageLinks,\n score: (titleMatch ? 2 : 0) + (authorMatch ? 2 : 0)\n });\n\n console.log(`Candidate: \"${volumeInfo.title}\" by ${volumeInfo.authors?.[0]} (${year}, ${volumeInfo.publisher})`);\n }\n }\n\n if (candidates.length === 0) {\n return null;\n }\n\n // Sort by score first, then by publication year (prefer earlier for classics)\n candidates.sort((a, b) => {\n if (a.score !== b.score) return b.score - a.score;\n if (!a.year && !b.year) return 0;\n if (!a.year) return 1;\n if (!b.year) return -1;\n return a.year - b.year;\n });\n\n const best = candidates[0];\n console.log(`Selected: \"${best.title}\" by ${best.authors?.[0]} (${best.year}, ${best.publisher})`);\n\n // Return comprehensive metadata object\n const metadata: BookMetadata = {};\n \n if (best.year) {\n metadata.yearPublished = best.year;\n }\n \n if (best.publisher) {\n metadata.publisher = best.publisher;\n }\n\n if (best.pageCount) {\n metadata.pageCount = best.pageCount;\n }\n\n if (best.isbn) {\n metadata.isbn = best.isbn;\n }\n\n // Additional fields that might be useful\n if (best.subtitle) {\n metadata.subtitle = best.subtitle;\n }\n\n if (best.description) {\n metadata.description = best.description;\n }\n\n if (best.categories && best.categories.length > 0) {\n metadata.categories = best.categories;\n }\n\n if (best.averageRating) {\n metadata.averageRating = best.averageRating;\n }\n\n if (best.ratingsCount) {\n metadata.ratingsCount = best.ratingsCount;\n }\n\n if (best.language) {\n metadata.language = best.language;\n }\n\n if (best.publishedDate) {\n metadata.publishedDate = best.publishedDate;\n }\n\n if (best.previewLink) {\n metadata.previewLink = best.previewLink;\n }\n\n if (best.infoLink) {\n metadata.infoLink = best.infoLink;\n }\n\n if (best.imageLinks) {\n metadata.imageLinks = best.imageLinks;\n }\n\n return metadata;\n}\n\n/**\n * Alternative search with relaxed criteria if exact search fails\n */\nexport async function searchBookMetadataRelaxed(title: string, author: string): Promise {\n try {\n console.log(`Relaxed Google Books search for: \"${title}\"`);\n \n // Try with just the title\n const query = `intitle:\"${title.trim()}\"`;\n const encodedQuery = encodeURIComponent(query);\n \n const response = await fetch(\n `https://www.googleapis.com/books/v1/volumes?q=${encodedQuery}&maxResults=30&printType=books`\n );\n\n if (!response.ok) {\n return null;\n }\n\n const data = await response.json();\n \n if (!data.items || data.items.length === 0) {\n return null;\n }\n\n return findBestGoogleBooksMatch(data.items, title, author);\n } catch (error) {\n console.error('Error in relaxed Google Books search:', error);\n return null;\n }\n}",[],[202,222],"62ee15c8-375c-11f0-8c16-9e149126039e",["D",1747953038469],[169,170,171,172],[202],["D",1747952823274],{"_11":12,"_123":69},{"_11":12,"_119":-5,"_68":69,"_31":67,"_120":121,"_122":30},{"_39":110,"_13":16,"_33":36,"_111":73,"_112":-5,"_113":-5,"_114":-5,"_115":-5,"_116":-5,"_117":14,"_118":12},"ctx",{"_52":-5,"_142":271,"_272":273,"_274":275,"_276":30,"_277":30,"_278":30,"_279":24,"_280":-5,"_281":-7,"_282":-7,"_283":26,"_284":30,"_285":30,"_286":-5,"_287":30,"_288":30,"_289":30,"_290":-5},"ENV",{"_242":243,"_244":245,"_246":16,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258,"_259":260,"_261":262,"_263":264,"_265":266,"_267":268,"_269":270},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","c73f21da490985bff19c279eb0e09db24d688e4f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

History · frontend