This n8n workflow automates the process of scraping book data from a website, organizing it, and emailing the information as a CSV file. The workflow starts with a Google Sheets trigger that monitors for new URLs added to a spreadsheet. When a new URL is detected, it sends a request to Dumpling AI to fetch the webpage content in HTML format. The HTML content is then parsed to extract all book entries using CSS selectors, specifically targeting list items containing book details.
Each book’s data, including title and price, is extracted from the HTML blocks. The extracted books are then sorted by price in descending order to prioritize expensive titles. Next, this sorted data is converted into a CSV file, which is automatically attached to an email sent through Gmail. This setup is practical for automating the collection of book data from multiple online sources, organizing the information efficiently, and receiving updates directly in an email.
Overall, this workflow simplifies monitoring and analyzing online book listings, making it ideal for market research, blog content gathering, or inventory tracking.
Reviews
There are no reviews yet.