\n \n

📚 Book Lookup Tool

Search by Title/Author or ISBN to get comprehensive book information

\n\n \n

\n \n

Search by Title & Author

\n Book Title\n \n

\n Author\n \n

\n \n

\n\n \n

Search by ISBN

\n ISBN\n \n

Enter ISBN with or without hyphens

Example: 9780123456789 or 978-0-123-45678-9

\n \n

\n\n \n

Bulk Input

\n \n Bulk Input - Choose one format:\n \n \n

Format 1: Just ISBNs (one per line)

Format 2: Title, Author (tab-separated, one per line)

• Don't mix formats - use one or the other

\n \n

\n\n \n

Searching for book information...

\n\n \n

\n \n

Results (0 books)

\n \n \n \n

\n\n \n

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

Title	Author	ISBN	Year	Publisher	Pages	Summary	Source
No results yet - try searching for a book!

\n\n \n

⚠️

Error

\n\n \n\n",[],[219,225],[219],{"_106":236,"_98":237,"_154":238,"_156":-5,"_157":139,"_158":239,"_160":161,"_108":240,"_103":31,"_163":164,"_165":-5,"_166":27,"_167":-5,"_168":241,"_101":250},"3aa4c35e-3acd-11f0-a81c-9e149126039e","shared","baf47cf4-e60d-4061-b269-5deb74833310",3,["D",1748331357498],[242],{"_106":243,"_98":244,"_154":245,"_156":238,"_157":139,"_158":239,"_160":161,"_108":246,"_103":31,"_163":175,"_165":247,"_166":27,"_167":-5,"_168":248,"_101":249},"3aa4bb5c-3acd-11f0-a81c-9e149126039e","types.ts","3aa4bc38-3acd-11f0-a81c-9e149126039e",["D",1748331357498],"/**\n * Shared types for the Book Lookup application\n */\n\nexport interface BookMetadata {\n title?: string;\n author?: string;\n isbn?: string;\n yearPublished?: number;\n publisher?: string;\n pageCount?: number;\n description?: string;\n subtitle?: string;\n categories?: string[];\n averageRating?: number;\n ratingsCount?: number;\n language?: string;\n publishedDate?: string;\n previewLink?: string;\n infoLink?: string;\n imageLinks?: any;\n}\n\nexport interface SearchRequest {\n type: 'title-author' | 'isbn';\n title?: string;\n author?: string;\n isbn?: string;\n}\n\nexport interface SearchResponse {\n success: boolean;\n book?: BookMetadata;\n error?: string;\n}\n\nexport interface BulkSearchRequest {\n requests: SearchRequest[];\n}\n\nexport interface BulkSearchResponse {\n success: boolean;\n books: (BookMetadata | null)[];\n errors?: string[];\n}",[],[237,244],[237],{"_106":252,"_98":253,"_154":254,"_156":-5,"_157":139,"_158":138,"_160":161,"_108":255,"_103":185,"_163":230,"_165":256,"_166":27,"_167":-5,"_168":257,"_101":258},"36a26a00-416b-11f0-9dc8-76b3cceeab13","README.md","6d0aa768-60d5-4e1d-a315-add145394d58",["D",1749058918231],"# Book Lookup Web App\n\nA public web application that allows users to search for comprehensive book information using the Google Books API. Users can search by Title/Author or ISBN and export results as CSV or copy them for pasting into spreadsheets.\n\n[Try it here](https://nucky--9ccb0eded286490cb5721a5c352fdf6d.web.val.run/) \n\n## Features\n\n### 🔍 **Multiple Search Methods**\n- **Title + Author Search**: Enter book title and author name\n- **ISBN Search**: Enter ISBN-10 or ISBN-13 (with or without hyphens)\n- **Bulk Input**: Paste tab-separated data from spreadsheets for batch processing\n\n### 📊 **Comprehensive Book Data**\nFor each book found, the app retrieves:\n- **Title** - Book title\n- **Author** - Primary author name\n- **ISBN** - ISBN-13 (preferred) or ISBN-10\n- **Year Published** - Publication year\n- **Publisher** - Publishing company\n- **Page Count** - Number of pages\n- **Summary** - Book description/synopsis\n\n### 📥 **Export Options**\n- **Download CSV**: Get a properly formatted CSV file for Excel/Sheets\n- **Copy to Clipboard**: Copy tab-separated data for direct pasting\n- **No Storage**: All data is temporary - refresh the page to clear\n\n## How to Use\n\n### Single Book Search\n\n1. **By Title & Author**:\n - Enter the book title in the first field\n - Enter the author name in the second field\n - Click \"Search by Title & Author\"\n\n2. **By ISBN**:\n - Enter the ISBN (10 or 13 digits, with or without hyphens)\n - Click \"Search by ISBN\"\n\n### Bulk Processing\n\n1. **Prepare Your Data** (choose one format):\n\n **Format 1 - ISBNs Only:**\n ```\n 150673524X\n 1839767502\n 1613164076\n ```\n\n **Format 2 - Title, Author (tab-separated):**\n ```\n Cosmopolis\tDon DeLillo\n Fire in Paradise\tAlastair Gee\n The Great Gatsby\tF. Scott Fitzgerald\n ```\n\n2. **Paste and Process**:\n - Paste the data into the bulk input textarea\n - Click \"Process Bulk Data\"\n - The app will automatically detect the format and search for each book\n\n### Export Results\n\n- **CSV Download**: Click \"📥 Download CSV\" to get a file named `book-lookup-YYYY-MM-DD.csv`\n- **Copy Data**: Click \"📋 Copy to Clipboard\" to copy tab-separated data for pasting into spreadsheets\n- **Clear Results**: Click \"🗑️ Clear\" to remove all results and start over\n\n## Example Usage\n\n### Individual Search\n```\nTitle: \"The Great Gatsby\"\nAuthor: \"F. Scott Fitzgerald\"\n→ Returns: Title, Author, ISBN, Year (1925), Publisher, Pages, Summary\n```\n\n### Bulk Input Format\n```\nFormat 1 - ISBNs only:\n150673524X\n1839767502\n1613164076\n\nFormat 2 - Title, Author (tab-separated):\nCosmopolis\tDon DeLillo\nFire in Paradise\tAlastair Gee\nThe Great Gatsby\tF. Scott Fitzgerald\n```\n\n## Technical Details\n\n### API Endpoints\n\n- `POST /api/search` - Search by title and author\n- `POST /api/search-isbn` - Search by ISBN \n- `POST /api/bulk-search` - Process multiple search requests\n- `GET /health` - Health check\n- `GET /api` - API documentation\n\n### Data Source\n\nAll book information is retrieved from the **Google Books API**, which provides:\n- Comprehensive metadata for millions of books\n- Multiple ISBN formats and identifiers\n- Publisher information and publication dates\n- Book descriptions and categorization\n- No API key required for basic usage\n\n### Privacy & Storage\n\n- **No Data Storage**: All searches are temporary and not saved\n- **No User Tracking**: No cookies or user data collection\n- **Client-Side Processing**: Results are stored only in browser memory\n- **Fresh Start**: Refresh the page to clear all data\n\n## Files Structure\n\n```\n├── backend/\n│ ├── index.ts # Main HTTP handler and API routes\n│ └── google-books.ts # Google Books API integration\n├── frontend/\n│ └── index.html # Complete web interface\n├── shared/\n│ └── types.ts # TypeScript interfaces\n└── README.md # This documentation\n```\n\n## Benefits\n\n✅ **No Setup Required** - Just visit the URL and start searching \n✅ **Works Offline After Load** - Frontend caching for repeated use \n✅ **Mobile Friendly** - Responsive design works on all devices \n✅ **Fast Bulk Processing** - Handle multiple books at once \n✅ **Export Ready** - CSV and clipboard formats for spreadsheets \n✅ **No Data Lock-in** - Export your data anytime, no accounts needed \n✅ **Comprehensive Results** - Rich metadata from Google Books \n✅ **Smart Matching** - Handles variations in titles and author names\n\n## Use Cases\n\n- **Library Management**: Quickly gather book metadata for cataloging\n- **Book Collection Tracking**: Build spreadsheets of personal libraries\n- **Research Projects**: Compile book lists with publication details\n- **Bookstore Inventory**: Look up books by ISBN for stock management\n- **Academic Work**: Gather publication data for bibliographies\n- **Reading Lists**: Create detailed book lists with summaries",[],[253],{"_106":260,"_98":261,"_154":262,"_156":-5,"_157":139,"_158":263,"_160":161,"_108":264,"_103":31,"_163":175,"_165":265,"_166":27,"_167":-5,"_168":266,"_101":267},"549365d4-4169-11f0-9b01-76b3cceeab13","test-bulk.js","54936688-4169-11f0-9b01-76b3cceeab13",32,["D",1749058109473],"// Test script to verify bulk functionality\nconsole.log(\"Testing bulk search functionality...\");\n\n// Test 1: ISBN-only format\nconst isbnData = `150673524X\n1839767502\n1613164076`;\n\nconsole.log(\"\\n=== Testing ISBN-only format ===\");\nconst isbnLines = isbnData.split('\\n').filter(line => line.trim());\nconst isbnRequests = [];\n\n// Simulate frontend logic\nconst firstLine = isbnLines[0];\nconst hasTab = firstLine.includes('\\t');\n\nif (hasTab) {\n console.log(\"Detected tab-separated format\");\n} else {\n console.log(\"Detected ISBN-only format\");\n for (const line of isbnLines) {\n const isbn = line.trim();\n if (isbn) {\n isbnRequests.push({ type: 'isbn', isbn });\n }\n }\n}\n\nconsole.log(\"Generated requests:\", JSON.stringify(isbnRequests, null, 2));\n\n// Test 2: Title/Author format\nconst titleAuthorData = `Cosmopolis\tDon DeLillo\nFire in Paradise\tAlastair Gee\nWork Without the Worker\tPhilip Jones`;\n\nconsole.log(\"\\n=== Testing Title/Author format ===\");\nconst titleAuthorLines = titleAuthorData.split('\\n').filter(line => line.trim());\nconst titleAuthorRequests = [];\n\nconst firstTALine = titleAuthorLines[0];\nconst hasTATab = firstTALine.includes('\\t');\n\nif (hasTATab) {\n console.log(\"Detected tab-separated format\");\n for (const line of titleAuthorLines) {\n const parts = line.split('\\t').map(p => p.trim());\n const title = parts[0] || '';\n const author = parts[1] || '';\n\n if (title && author) {\n titleAuthorRequests.push({ type: 'title-author', title, author });\n } else {\n console.warn(`Skipping invalid title/author line: \"${line}\"`);\n }\n }\n} else {\n console.log(\"Detected ISBN-only format\");\n}\n\nconsole.log(\"Generated requests:\", JSON.stringify(titleAuthorRequests, null, 2));\n\nconsole.log(\"\\n=== Test completed ===\");",[],[261],"files",[151,170,179,189,200,208,217,223,235,242,251,259],"counts",{"_272":31,"_273":159,"_274":31,"_275":31},"pulls","branches","forks","envVars","contents",[],{"_106":190,"_98":191,"_154":192,"_156":155,"_157":139,"_158":193,"_160":161,"_108":279,"_103":195,"_163":196,"_165":197,"_166":27,"_167":-5,"_101":280},["D",1749058693926],[153,191],"upstreamProject",{"_106":283,"_98":284,"_114":285,"_116":286,"_112":113,"_21":287},"e2a8e384-375b-11f0-b362-9e149126039e","book-lookup-notion","use google book api to look up bibliographic metadata elements","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/b264b89e-466c-4d55-8eb9-e8a9baa1af00/square512",{"_96":97,"_134":135},"upstreamBranch",{"_106":142,"_108":290,"_291":292,"_98":42,"_140":283,"_103":293,"_141":-5,"_143":-5,"_294":295,"_110":-5,"_132":27,"_112":113,"_148":97,"_147":284},["D",1747952823274],"updatedAt",["D",1748332408384],81,"lockfileKey","1748373639899-esm.town_v_nucky_book-lookup-notion@81-main","emptyEnvVars","isNew","routes/_app.x.$handle.$name.code.$",{"_96":97,"_98":99,"_100":42,"_103":-7,"_101":102,"_104":300,"_149":304,"_268":341,"_230":342,"_276":344,"_345":346,"_349":161,"_350":-5,"_351":352,"_353":239,"_354":355},{"_106":107,"_98":99,"_108":301,"_110":-5,"_111":27,"_112":113,"_114":115,"_116":117,"_12":118,"_119":-5,"_120":27,"_121":-5,"_122":31,"_123":124,"_125":124,"_126":127,"_128":127,"_129":127,"_130":124,"_131":124,"_132":27,"_21":302,"_136":303},["D",1748330955065],{"_96":97,"_134":135},{"_103":138,"_98":42,"_106":139,"_140":107,"_141":142,"_143":144,"_145":113,"_146":118,"_147":99,"_148":97},[305,323,329,335,338],{"_106":152,"_98":153,"_154":155,"_156":-5,"_157":139,"_158":159,"_160":161,"_108":162,"_103":31,"_163":164,"_165":-5,"_166":27,"_167":-5,"_168":306,"_101":322},[307,310,313,316,319],{"_106":171,"_98":172,"_154":173,"_156":155,"_157":139,"_158":159,"_160":161,"_108":174,"_103":31,"_163":175,"_165":176,"_166":27,"_167":-5,"_168":308,"_101":309},[],[153,172],{"_106":180,"_98":181,"_154":182,"_156":155,"_157":139,"_158":183,"_160":161,"_108":184,"_103":185,"_163":175,"_165":186,"_166":27,"_167":-5,"_168":311,"_101":312},[],[153,181],{"_106":190,"_98":191,"_154":192,"_156":155,"_157":139,"_158":193,"_160":161,"_108":194,"_103":195,"_163":196,"_165":197,"_166":27,"_167":-5,"_168":314,"_101":315},[],[153,191],{"_106":201,"_98":202,"_154":203,"_156":155,"_157":139,"_158":159,"_160":161,"_108":204,"_103":31,"_163":175,"_165":205,"_166":27,"_167":-5,"_168":317,"_101":318},[],[153,202],{"_106":209,"_98":210,"_154":211,"_156":155,"_157":139,"_158":159,"_160":161,"_108":212,"_103":31,"_163":175,"_165":213,"_166":27,"_167":-5,"_168":320,"_101":321},[],[153,210],[153],{"_106":218,"_98":219,"_154":220,"_156":-5,"_157":139,"_158":159,"_160":161,"_108":221,"_103":31,"_163":164,"_165":-5,"_166":27,"_167":-5,"_168":324,"_101":328},[325],{"_106":224,"_98":225,"_154":226,"_156":220,"_157":139,"_158":227,"_160":161,"_108":228,"_103":229,"_163":230,"_165":231,"_166":27,"_167":-5,"_168":326,"_101":327},[],[219,225],[219],{"_106":236,"_98":237,"_154":238,"_156":-5,"_157":139,"_158":239,"_160":161,"_108":240,"_103":31,"_163":164,"_165":-5,"_166":27,"_167":-5,"_168":330,"_101":334},[331],{"_106":243,"_98":244,"_154":245,"_156":238,"_157":139,"_158":239,"_160":161,"_108":246,"_103":31,"_163":175,"_165":247,"_166":27,"_167":-5,"_168":332,"_101":333},[],[237,244],[237],{"_106":252,"_98":253,"_154":254,"_156":-5,"_157":139,"_158":138,"_160":161,"_108":255,"_103":185,"_163":230,"_165":256,"_166":27,"_167":-5,"_168":336,"_101":337},[],[253],{"_106":260,"_98":261,"_154":262,"_156":-5,"_157":139,"_158":263,"_160":161,"_108":264,"_103":31,"_163":175,"_165":265,"_166":27,"_167":-5,"_168":339,"_101":340},[],[261],[305,307,310,313,316,319,323,325,329,331,335,338],{"_106":190,"_98":191,"_154":192,"_156":155,"_157":139,"_158":193,"_160":161,"_108":279,"_103":195,"_163":196,"_165":197,"_166":27,"_167":-5,"_101":343},[153,191],[],"upstream",{"_106":142,"_108":347,"_291":348,"_98":42,"_140":283,"_103":293,"_141":-5,"_143":-5,"_294":295,"_110":-5,"_132":27,"_112":113,"_148":97,"_147":284},["D",1747952823274],["D",1748332408384],"showCompareCallout","pull","ahead",35,"behind","templates",[],"routes/_app","actionData","errors"]