FM
FlowMarket
Ecommerce & Sales Intermediate ⚡ 11 n8n Nodes

Extract product info from webpage screenshots using Dumpling AI

Who is this for? This workflow is perfect for eCommerce teams, market researchers, and product analysts who want to track or extract product information from...

🔌 Nodes & Integrations Used (5)

Google Sheets Trigger HTTP Request Google Drive Google Sheets OpenAI

📖 Implementation & Setup Guide

Who is this for?

This workflow is perfect for eCommerce teams, market researchers, and product analysts who want to track or extract product information from websites that restrict scraping tools. It’s also useful for virtual assistants handling product comparison tasks.

---

What problem is this workflow solving?

Many eCommerce and retail sites use dynamic content or anti-bot protections that make traditional scraping methods unreliable. This workflow bypasses those issues by taking a screenshot of the full page, using OCR to extract visible text, and summarizing product information with GPT-4o—all fully automated.

---

What this workflow does

This workflow monitors a Google Sheet for new URLs. Once a new link is added, it performs the following steps:

  1. **Trigger on New URL in Sheet** – Watches for new rows added to a Google Sheet.
  2. **Screenshot URL via Dumpling AI** – Sends the URL to Dumpling AI’s screenshot endpoint to capture a full-page image of the product webpage.
  3. **Save Screenshot to Drive Folder** – Uploads the screenshot to a specific Google Drive folder for reference or logging.
  4. **Extract Text from Screenshot with Dumpling AI** – Uses Dumpling AI’s image-to-text endpoint to pull all visible content from the screenshot.
  5. **Extract Product Info from Screenshot Text with GPT-4o** – Sends the extracted raw text to GPT-4o, prompting it to identify structured product information such as product name, price, ratings, deals, and purchase options.
  6. **Split Each Product Entry** – Splits the GPT response (an array of product objects) so each product becomes an individual item for saving.
  7. **Save Products info to Google Sheet** – Appends each product’s structured details to a separate sheet in the same spreadsheet.

---

Setup

  1. **Google Sheet**
  2. - Create a Google Sheet with at least two sheets:
  3. - `Sheet1` should contain a header row with a column labeled `URL`.
  4. - `Sheet2` should contain headers: `Product Name`, `price`, `purchased`, `ratings`, `deal`, `buyingOptions`.
  5. - Connect your Google account in both the trigger and final write-back node.

2. **Dumpling AI** - Sign up at [Dumpling AI](https://app.dumplingai.com) - Create an API key and use it for both HTTP modules: - **Screenshot URL via Dumpling AI** - **Extract Text from Screenshot with Dumpling AI** - The screenshot endpoint used is `https://app.dumplingai.com/api/v1/screenshot`.

3. **Google Drive** - Create a folder for storing screenshots. - In the `Save Screenshot to Drive Folder` node, select the correct folder or provide the folder ID. - Make sure permissions allow uploading from n8n.

4. **OpenAI** - Provide an API key for GPT-4o in the `Extract Product Info from Screenshot Text with GPT-4o` node. - The prompt is structured to return structured product listings in JSON format.

5. **Split & Save** - `Split Each Product Entry` takes the array of product objects from GPT and makes each one a separate execution. - `Save Products info to Google Sheet` writes structured fields into `Sheet2` under: `Product Name`, `price`, `purchased`, `ratings`, `deal`, `buyingOptions`.

---

How to customize this workflow

  • Adjust the GPT prompt to return different product fields (e.g., shipping info, product categories).
  • Use a filter node to limit which types of products get written to the final sheet.
  • Add sentiment analysis to analyze review content if available.
  • Replace Google Drive with Dropbox or another file storage app.

---

Notes

  • Make sure you monitor your API usage on both Dumpling AI and OpenAI to avoid rate limits.
  • This setup is great for snapshot-based extraction where scraping is blocked or unreliable.

⚡ How to import this workflow into n8n:

  1. Click the Direct Download JSON button above to save Extract_product_info_from_webpage_screenshots_using_Dumpling_AI.json.
  2. Log in to your n8n Cloud or self-hosted n8n instance.
  3. In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
  4. Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
  5. Click Execute Workflow to test and switch to Active!

Related Ecommerce & Sales Workflows

View All in Ecommerce & Sales →