Scrape books from URL with Dumpling AI, clean HTML, save to Sheets, email as CSV
Ready for 3.0What 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).
- Scrape Website Content with Dumpling AI (HTTP Request): calls app.dumplingai.com (POST)
- Extract all books from the page (HTML): parses or builds HTML
- Split HTML Array into Individual Books (Split Out): splits a list into separate items
- Extract individual book price (HTML): parses or builds HTML
- Sort: sorts the items
- Convert to CSV File (Convert to File): converts data to a file
- Send CSV via e-mail (Gmail): uses Gmail
Services it uses
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)
- Convert to File
n8n-nodes-base.convertToFile - HTML
n8n-nodes-base.html - Sort
n8n-nodes-base.sort - Gmail
n8n-nodes-base.gmail - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - HTTP Request
n8n-nodes-base.httpRequest - Split Out
n8n-nodes-base.splitOut
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…