Web Automation
Extract book data with AI and save to sheets with email distribution
11 nodes
137
80
Automatic trigger
Workflow Description
This automation extracts book information from web pages using artificial intelligence, organizes it by configured criteria, stores the data in Google Sheets, and automatically sends copies via Gmail to designated recipients.
How it works
- 1.Fetch and analyze web content to extract book data using AI
- 2.Sort and organize extracted information according to defined parameters
- 3.Save processed data to Google Sheets and distribute via email
Use cases
- Collect recommended books from multiple websites and organize them automatically
- Monitor new book releases and distribute updates to team members
Requirements
- Active Google Workspace account
- Gmail access for automated sending
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Sort
Gmail
Google Sheets
Details
Trigger
Automatic trigger
Nodes
11
Apps
3
Views
137
Downloads
80
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (11)
/
Convert to CSV File
Convert To File
Extract all books from the page
HTML Page
Sort by price
Sort
Extract individual book price
HTML Page
Send CSV via e-mail
Gmail
Sticky Note3
Sticky Note
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Trigger- Watches For new URL in Spreadsheet
Google Sheets Trigger
Scrape Website Content with Dumpling AI
HTTP Request
Split HTML Array into Individual Books
Split Out