Want product price data without copy paste? Add a page URL to Google Sheets and get a CSV delivered to your inbox. Great for marketers tracking book prices, bestseller lists, or quick product research.

When a new row appears in the sheet, the flow calls a scraping service to pull a clean HTML copy of that page. The HTML parser finds each book block, then a split step handles one item at a time. It captures the title and price, sorts all items from high to low, and turns the list into a CSV file. Gmail sends the CSV with a short note so your team can review and share right away. The system checks the sheet every minute, so new links get processed fast. You can change the sort or add more fields as your needs grow.

Connect Google Sheets and Gmail in n8n, then add your scraping API credentials to finish setup. If the site layout is different, update the CSS selectors to match your page before scaling. Expect to cut manual work from about an hour per page to a few minutes, freeing time for pricing analysis, promo planning, and weekly competitor checks. Test with one URL, confirm the email arrives, then add more rows to scale your reports.

• Google Sheets row added trigger checks for new URLs every minute
• HTTP call pulls cleaned HTML from a scraping API
• HTML extractor finds each book block with a CSS selector
• Split step processes each book as a separate item
• Parser pulls title from the link title attribute and grabs the price text
• Sorter orders items by price in descending order
• Converter builds a CSV file from the sorted list
• Gmail sends the CSV as an email attachment to your chosen address

• Reduce manual work from about 60 minutes to 5 minutes per page
• Automate up to 90 percent of product data collection tasks
• Improve data accuracy by removing copy paste errors
• Connect Google Sheets, Dumpling AI, and Gmail in one flow
• Handle hundreds of items on a page without extra effort

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets, Dumpling AI and Gmail. See the Tools Required section above for links to create accounts with these services.
3. In the n8n credentials manager, create a Google Sheets credential. You can also open the Google Sheets Trigger node, choose 'Credential to connect with', click 'Create new credential', and follow the on screen steps to connect your Google account.
4. In your Google Cloud console, enable the Google Sheets API and Google Drive API for the connected account if they are not already enabled.
5. Open the Google Sheets Trigger node. Select the spreadsheet and sheet that store your URLs. Confirm the polling interval is every minute and that each new row contains one URL.
6. In your Dumpling AI account, create an API key or get your auth details. In n8n, create an HTTP Header Auth credential to add the Authorization header, and create an HTTP Basic Auth credential if your account requires it. Name credentials clearly, for example 'DumplingAI Header' and 'DumplingAI Basic'.
7. Open the HTTP Request node. Confirm the URL is the Dumpling AI scrape endpoint, method is POST, and the body passes the page URL from the Google Sheets row with JSON format and cleaned output enabled. Assign your Dumpling AI credentials in the node.
8. Open the HTML node that extracts all books. Confirm the CSS selector matches your target site. The default is '.row > li'. If your site structure differs, update selectors accordingly.
9. Check the Split Out node to ensure it splits the array of book elements so each book is processed individually.
10. Open the second HTML extractor. Verify it pulls the title from 'h3 > a' title attribute and the price from '.price_color'. Adjust if your site uses different markup.
11. Confirm the Sort node uses the price field and descending order. If your price values include a currency symbol, ensure the sort behaves as expected and adjust formatting if needed.
12. Open the Convert to File node and select CSV output. Set a clear file name pattern such as 'books.csv'.
13. Create a Gmail credential in n8n via the Send Email node. Choose 'Create new credential' and follow the on screen steps to connect your Google account. Then set the To address, subject, and message, and attach the binary CSV from the previous node.
14. Test the flow by adding a sample URL to your Google Sheet. Wait up to one minute, then check the n8n execution log and verify the email arrived with the CSV attached.
15. Troubleshoot: If no run occurs, recheck the selected spreadsheet and sheet. If scraping fails, verify Dumpling AI credentials and that the URL is reachable. If the CSV is empty, inspect the page and update CSS selectors. If email fails, confirm Gmail OAuth and quotas.