This n8n workflow automates the process of scraping book data from an online bookstore, organizing the information, and distributing it via email. Starting with a manual trigger, it fetches the website content and extracts details about books, including titles and prices. The workflow can sort books by price, save the data into Google Sheets and Microsoft Excel online, and generate a CSV file. Finally, it sends the CSV as an email attachment.
Key nodes include ‘HTTP Request’ for website content retrieval, ‘HTML Extraction’ nodes for parsing book data, ‘Sort’ for ranking books by price, and integration nodes for Google Sheets, Microsoft Excel, and Gmail. Sticky notes provide setup instructions for API permissions and credentials.
This workflow is ideal for eCommerce managers, data analysts, or marketing teams that need to regularly monitor book prices, compile reports, and automatically distribute updates without manual effort.
Reviews
There are no reviews yet.