{"product_id":"n8n-workflow-clean-library-catalogs-with-google-books-gmail","title":"n8n Workflow: Clean Library Catalogs with Google Books \u0026 Gmail","description":"\u003ch3\u003eClean up messy library catalogs automatically—upload an Excel file and get a verified, deduplicated master Google Sheets catalog (with an emailed import summary).\u003c\/h3\u003e\n\n\u003cp\u003eThis n8n workflow ingests an uploaded \u003cstrong\u003e.xlsx library inventory\u003c\/strong\u003e, validates and normalizes \u003cstrong\u003eISBN-10\/ISBN-13\u003c\/strong\u003e, enriches missing book metadata using \u003cstrong\u003eGoogle Books API\u003c\/strong\u003e, deduplicates against your existing \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e catalog, and routes exceptions for manual review. It then upserts clean records into your “Clean Master DB” sheet and emails a run summary via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives an HTTP POST webhook\u003c\/strong\u003e containing an uploaded .xlsx file.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates and parses\u003c\/strong\u003e the spreadsheet, loads existing entries from Google Sheets, and initializes an in-memory “seen” set for deduplication.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses rows in batches of 50\u003c\/strong\u003e, cleaning ISBNs and flagging invalid or missing ISBNs for manual review.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects duplicates\u003c\/strong\u003e (by ISBN or normalized title\/author) and writes duplicate entries to the \u003cstrong\u003e“Needs Manual Review”\u003c\/strong\u003e tab with the reason.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEnriches non-duplicates\u003c\/strong\u003e by calling the \u003cstrong\u003eGoogle Books API\u003c\/strong\u003e by ISBN, normalizing fields like title, author, publisher, year, and category (falling back to spreadsheet values when metadata is missing).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpserts standardized records\u003c\/strong\u003e into \u003cstrong\u003e“Clean Master DB”\u003c\/strong\u003e and appends metadata lookup failures to \u003cstrong\u003e“Needs Manual Review.”\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends an import summary email\u003c\/strong\u003e via Gmail with run-level counts (updated, duplicates, missing\/invalid ISBN, errors, and manual review).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBulk importing library or collection inventories from spreadsheets into a clean, deduplicated catalog.\u003c\/li\u003e\n  \u003cli\u003eAutomating ISBN validation and Google Books enrichment while keeping exceptions in a review queue.\u003c\/li\u003e\n  \u003cli\u003eReducing manual catalog cleanup work for SaaS operators, librarians, and automation engineers.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWebhook\u003c\/strong\u003e (HTTP POST) for file upload\u003c\/li\u003e\n  \u003cli\u003eNodes: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eno op\u003c\/strong\u003e, \u003cstrong\u003ewait\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003ewebhook\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Books API\u003c\/strong\u003e enrichment by ISBN\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e reads\/writes to “Clean Master DB” and “Needs Manual Review”\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46173013573811,"sku":"N8N-20546","price":2.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/SNXvwaPMY9Gw5Og98-dcQ_yaV9fnQv.png?v=1791365355","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-clean-library-catalogs-with-google-books-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}