Templates / Scrape books from URL with Dumpling AI, clean HTML, save to Sheets, email as CSV

Scrape books from URL with Dumpling AI, clean HTML, save to Sheets, email as CSV

Ready for 3.0

by Yang ✓ · 3,329 views · created 2025-04-24 · Market Research

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 8 nodes and runs on Google Sheets events (row added). Along the way it connects Gmail and Google Sheets. It also calls app.dumplingai.com over HTTP.

How it runs

Trigger: On Google Sheets events (row added).

  1. Scrape Website Content with Dumpling AI (HTTP Request): calls app.dumplingai.com (POST)
  2. Extract all books from the page (HTML): parses or builds HTML
  3. Split HTML Array into Individual Books (Split Out): splits a list into separate items
  4. Extract individual book price (HTML): parses or builds HTML
  5. Sort: sorts the items
  6. Convert to CSV File (Convert to File): converts data to a file
  7. Send CSV via e-mail (Gmail): uses Gmail

Services it uses

GmailGoogle Sheets

HTTP calls to: app.dumplingai.com

Scraping pages by hand? Firecrawl is a simpler option (10% off for new users).

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (7)

From the author

👥 Who is this for? This workflow is ideal for virtual assistants, researchers, developers, automation specialists, and data analysts who need to regularly extract and organize structured product information (like books) from a website. It’s especially useful…

Excerpt from Yang's description on n8n.io.

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

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.