# Scrape books from URL in Google Sheets, sort prices, send CSV via email
This automation template automatically collects up-to-date book data from web pages without manual input. Designed for marketers, analysts, and freelancers who need structured pricing and catalog information on demand.
## Who it´s for
- Marketers tracking competitor book pricing
- Analysts automating web scraping tasks
- Product managers monitoring online bookstore inventories
- Freelancers generating regular price reports for clients
## What the automation does
- Triggers when a new URL is added to Google Sheets
- Sends the URL to Dumpling AI for HTML scraping
- Extracts book titles and prices using CSS selectors
- Sorts entries by price in descending order
- Converts structured data into a CSV file
- Attaches the file and sends it via Gmail
## What´s included
- Ready-to-use n8n workflow
- Trigger logic for ´new row in Google Sheets´
- Integrations with Google Sheets, Gmail, Dumpling AI, and Google Drive
- Basic written instructions for setup and adaptation
## Requirements for setup
- n8n account (cloud or self-hosted)
- Google Sheet with a column containing book page URLs
- Enabled Google Sheets and Gmail APIs
- Active Dumpling AI account with API key
- Gmail permissions for sending file attachments
## Benefits and outcomes
- Saves time on manual data collection
- Delivers consistent, structured data regularly
- Enables scalable monitoring of multiple bookstores
- Automatic price sorting for faster analysis
- Easy integration into reports and dashboards
- No coding required to deploy
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet