Automated Book Data Scraping, Sorting, and CSV Emailing - n8n Workflow
Use this n8n workflow to automatically scrape website data via Dumpling AI, extract book details, sort by price, and email the resulting CSV file using a Google Sheets n8n trigger.
Workflow Preview
Ready to automate?
Download this n8n workflow template and start using it instantly.
Who is this best for?
- Data Analysts needing timely and structured web data extracts.
- E-commerce Researchers tracking competitive pricing information.
- Automation Engineers looking for robust n8n templates for web scraping and data processing.
- Users who need a reliable, scheduled mechanism to turn website content into actionable CSV reports.
Overview
This powerful n8n workflow solves the challenge of turning unstructured website HTML into clean, organized, and shareable data reports. By utilizing a Google Sheets n8n trigger, the automation starts immediately upon a new URL being added. The core scraping task is handled by a third-party AI scraping service (Dumpling AI), which fetches a clean version of the target page. The n8n node structure then meticulously extracts key data points (like book titles and prices), sorts them (by price, descending), converts the resulting JSON array into a standard CSV file, and finally delivers the complete report directly to an inbox using a Gmail n8n node. This makes this n8n workflow an essential tool for repeatable data gathering tasks.
How it Works
The entire process is initiated by an n8n trigger.
- Trigger (Google Sheets): The n8n trigger monitors a specified Google Sheet for newly added URLs. When a new row is detected, the workflow begins, passing the URL to the next step.
- Scraping (HTTP Request): A specialized HTTP Request n8n node forwards the URL to the Dumpling AI service for scraping, ensuring the received HTML is cleaned.
- Initial Extraction (HTML n8n node): The incoming HTML is processed to extract large blocks corresponding to individual books using CSS selectors (
.row > li). - Splitting (Split Out n8n node): The array of book HTML blocks is split so that each individual book can be processed separately.
- Detail Parsing (HTML n8n node): For each item, another HTML n8n node extracts specific fields—the book title (from the link's title attribute) and the price (from the price CSS class).
- Sorting (Sort n8n node): All extracted data items are consolidated and sorted by the 'price' field in descending order.
- Conversion (Convert to File n8n node): The structured, sorted data is converted into a standard CSV binary file.
- Delivery (Gmail n8n node): The final step sends an email containing the subject 'bookstore csv' and attaches the newly generated CSV file, completing the execution of this comprehensive n8n workflow.
Installation Guide
To deploy this efficient n8n workflow template, follow these steps:
- Import: Copy the provided JSON data and import it directly into your n8n instance.
- Google Sheets Credential Setup: Configure the
Trigger- Watches For new URL in Spreadsheetn8n node with a valid Google Sheets OAuth2 API credential, pointing it to the specific spreadsheet and sheet name where URLs will be entered. - Dumpling AI Credential Setup: The
Scrape Website Content with Dumpling AIn8n node uses generic HTTP Header Authentication. You will need to set up the credential containing your Dumpling AI API key. - Gmail Credential Setup: Configure the
Send CSV via e-mailn8n node with your Gmail OAuth2 credentials and specify the recipient email address in the 'Send To' parameter. - Activation: Once all credentials are set up and the target URL structure is verified against the selectors, activate the n8n workflow.
Node Details
- Trigger- Watches For new URL in Spreadsheet (Google Sheets Trigger n8n node):
- Key Configuration:
Event: rowAdded; Poll Times: every minute.- Scrape Website Content with Dumpling AI (HTTP Request n8n node):
- Key Configuration:
URL: https://app.dumplingai.com/api/v1/scrape; JSON Body: Dynamic URL input, requesting format: "html" and cleaned: "True".- Extract all books from the page (HTML n8n node):
- Key Configuration:
CSS Selector: .row > li; extracts content as an array named books.- Split HTML Array into Individual Books (Split Out n8n node):
books array into multiple output items, one for each book.- Key Configuration:
Field To Split Out: books.- Extract individual book price (HTML n8n node):
- Key Configuration: Extracts
title (attribute from h3 > a) and price (content from .price_color).- Sort by price (Sort n8n node):
- Key Configuration: Sort Field:
price; Order: descending.- Convert to CSV File (Convert to File n8n node):
- Send CSV via e-mail (Gmail n8n node):
- Key Configuration:
Subject: bookstore csv; Attaches the binary file output from the previous n8n node.Related n8n Workflows
AI Content Drafting for LinkedIn with Human Review and Blog Scraping
Automate blog scraping using this sophisticated n8n workflow. Generate LinkedIn posts with GPT-4o, enforce quality control via human review, and auto-publish. Leverage n8n templates for efficient content marketing.
Amazon Product Data Scraping using AI to Google Sheets
Use this powerful n8n workflow to automatically scrape Amazon product listings using AI (ScrapeGraphAI) and save structured data directly to Google Sheets. Find more powerful n8n templates for retail analysis and monitoring.
Airbnb Listing Scraper with Pagination and Google Sheets Storage
Automate web scraping of Airbnb listings using this n8n workflow. Fetch pagigated search results, extract property details, and save structured data directly to Google Sheets for analysis.
Google Maps Business Data Extraction and Reporting
Automate lead generation by scraping Google Maps results via the SerpAPI n8n node. Export structured business data to Google Sheets and XLSX files using this comprehensive n8n workflow.
Google Maps Business Email Extractor to Sheets
Automate lead generation and contact gathering by scraping business website URLs directly from Google Maps search results, extracting valid emails, and exporting the clean list directly to Google Sheets using a robust n8n workflow.
Google Maps Lead Generation and Decision Maker Enrichment
This powerful n8n workflow automates lead generation by scraping Google Maps using the Olostep n8n node. Extract business details, find decision-maker contact info, and save enriched data directly to Google Sheets. Ideal for sales and marketing teams utilizing n8n templates.
Featured*
