Scrape Product Info from Website URLs in Google Sheets using Dumpling AI

📄 What this workflow does

This workflow automatically scrapes product information from any website URL entered into a Google Sheet and stores the extracted product details into another sheet. It uses Dumpling AI to extract product data such as name, price, description, and reviews.

👤 Who is this for

This is ideal for:

• Lead generation specialists capturing product info from prospect websites
• eCommerce researchers collecting data on competitor product listings
• Sales teams building enriched product databases from lead URLs
• Anyone who needs to automate product scraping from multiple websites

✅ Requirements

• A Google Sheet with a column labeled Website where URLs will be added
• A second sheet (e.g., product details) where extracted data will be saved
• Dumpling AI API access to perform the extraction
• Connected Google Sheets credentials in n8n

⚙️ How to set up

1. Replace the Google Sheet and tab IDs in the workflow with your own.
2. Make sure your source sheet includes a Website column.
3. Connect your Dumpling AI and Google Sheets credentials.
4. Make sure the output sheet has the following headers:
   • productName
   • price
   • productDescription
     (The workflow supportsreview, but it’s optional.)
5. Activate the workflow to start processing new rows.

🔁 How it works (Workflow Steps)

1. Watch New Website URL in Google Sheets : Triggers when a new row is added with a website URL.
2. Extract Product Info with Dumpling AI : Sends the URL to Dumpling AI’s extract endpoint using a defined schema for product details.
3. Split Extracted Products : Separates multiple products into individual items if the page contains more than one.
4. Append Product Info to Google Sheets : Adds the structured results to the specified product details sheet.

🛠️ Customization Ideas

• Add a column to store the original source URL alongside each product
• Use OpenAI to generate short SEO summaries for each product
• Add filters to ignore pages without valid product details
• Send Slack or email notifications when new products are added to the sheet