Clean library book catalogs with Google Books, Google Sheets, and Gmail

by AYLA BATOOL ✓ · 1 views · created 2026-10-06 · Document Extraction, AI Summarization

What this workflow does

This workflow has 27 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets and Gmail. It also calls googleapis.com over HTTP.

How it runs

Trigger: When an HTTP POST request hits its webhook URL.

1. Validate Uploaded File (Code): runs custom JavaScript code
2. Parse Uploaded Spreadsheet (Spreadsheet File): reads or writes a spreadsheet file (legacy node)
3. Get Existing Catalog Rows (Google Sheets): uses Google Sheets
4. Seed Existing Catalog Keys (Code): runs custom JavaScript code
5. Process Books in Batches of (Loop Over Items (Split in Batches)): loops over the items in batches
6. Compile Import Summary (Code): runs custom JavaScript code
7. Validate ISBN (Code): runs custom JavaScript code
8. Email Import Summary (Gmail): uses Gmail
9. Is ISBN Valid (If): checks a condition and branches into true / false
10. Check Duplicate Book (Code): runs custom JavaScript code

…plus 15 more steps. See the full node list below.

Services it uses

Google SheetsGmail

HTTP calls to: googleapis.com

Before you upgrade to n8n 3.0

Nodes used (10)

• Webhookn8n-nodes-base.webhook
• Spreadsheet Filen8n-nodes-base.spreadsheetFile
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• Coden8n-nodes-base.code
• Ifn8n-nodes-base.if
• Google Sheetsn8n-nodes-base.googleSheets
• No Operation, do nothingn8n-nodes-base.noOp
• Gmailn8n-nodes-base.gmail
• HTTP Requestn8n-nodes-base.httpRequest
• Waitn8n-nodes-base.wait

From the author

Quick overview This workflow receives an uploaded .xlsx library inventory, validates and normalizes ISBNs, enriches book details via the Google Books API, deduplicates against an existing Google Sheets catalog, writes clean records to a master sheet, routes…

View the original on n8n.io → Check your own copy