Google Sheets + Dumpling AI: competitor data, ready
Competitor research falls apart the second you start copy-pasting product pages into a spreadsheet. Prices change, formatting breaks, someone misses a variant, and your “quick scan” turns into a messy half-day.
This competitor data automation hits eCommerce researchers hardest, but growth marketers and sales ops folks feel it too. You end up spending about 2 hours a week just turning URLs into usable rows, and the errors are the real killer.
This n8n workflow takes a simple list of competitor URLs in Google Sheets and turns them into structured product details using Dumpling AI. You will see what it automates, what you get out the other side, and how to set it up without turning it into a “developer project.”
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: Google Sheets + Dumpling AI: competitor data, ready
flowchart LR
subgraph sg0["Monitor Sheet URL Entries Flow"]
direction LR
n0@{ icon: "mdi:play-circle", form: "rounded", label: "Monitor Sheet URL Entries", pos: "b", h: 48 }
n1["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Fetch Product Details via AI"]
n2@{ icon: "mdi:swap-vertical", form: "rounded", label: "Divide Extracted Items", pos: "b", h: 48 }
n3@{ icon: "mdi:database", form: "rounded", label: "Append Details to Sheet", pos: "b", h: 48 }
n2 --> n3
n1 --> n2
n0 --> n1
end
%% Styling
classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
classDef disabled stroke-dasharray: 5 5,opacity: 0.5
class n0 trigger
class n3 database
class n1 api
classDef customIcon fill:none,stroke:none
class n1 customIcon
The Problem: Competitor product data is painfully manual
When your source of truth is “a bunch of competitor URLs,” you are basically signing up for busywork. You open a page, hunt for the product name, find the price (which may be formatted differently than yesterday), grab a description, then try to jam it into a sheet cell without losing line breaks. Do that for 20 URLs and it becomes the kind of task everyone avoids until the last minute. And when you finally need the data for a pricing review or a landing page rewrite, it is incomplete, inconsistent, or already outdated.
It adds up fast. Here’s where it breaks down in real life.
- Copy-pasting product details from web pages usually turns into formatting cleanup and “what did this price actually mean?” debates.
- One page can contain multiple products, so your spreadsheet ends up with half the items missing unless someone remembers to split them out.
- People don’t use the same naming conventions, which means sorting and filtering becomes unreliable when you need it most.
- Manual entry leads to quiet errors, like swapping a price and a variant or copying the wrong description block.
The Solution: Google Sheets to Dumpling AI extraction, automatically
This workflow watches a Google Sheet for new rows where you paste competitor product URLs into a column labeled “Website.” The moment a new URL shows up, n8n sends that page to Dumpling AI’s extraction endpoint through an HTTP request, using a defined schema for the product details you care about (product name, price, and product description, plus reviews if you want them). If the page contains multiple products, the workflow splits those results into separate items so each product becomes its own clean row. Finally, it appends the structured output into a second “product details” sheet, ready for analysis, filtering, or reporting. No “open 30 tabs and suffer” required.
The workflow starts when a new URL is added in Google Sheets. Dumpling AI extracts the product data and returns structured fields. Then n8n separates each extracted product (if needed) and writes the final rows into your output sheet.
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say you track 30 competitor product pages each week. Manually, even a “fast” process is maybe 6 minutes per URL to copy name, price, and a usable description, so you’re at about 3 hours (plus cleanup). With this workflow, you paste the 30 URLs into the Sheet in about 10 minutes total, then n8n and Dumpling AI do the extraction and write clean rows to your output tab while you work on something else. You still spot-check a few rows, but the heavy lifting is gone.
What You’ll Need
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Google Sheets for the URL input and output tables
- Dumpling AI to extract structured product fields from URLs
- Dumpling AI API key (get it from your Dumpling AI dashboard)
Skill level: Beginner. You’ll connect accounts, paste in your Sheet IDs, and confirm your column headers match.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
A new URL is added in Google Sheets. The workflow triggers when a new row appears, as long as your source sheet has a column labeled “Website.”
The URL is sent to Dumpling AI for extraction. n8n uses an HTTP Request to pass the page to Dumpling AI and asks for a predictable structure like productName, price, and productDescription (reviews can be included too).
Multi-product pages are handled cleanly. If a category page returns multiple products, n8n splits the results so you don’t get a single cell full of mixed data.
Structured rows are appended to your output sheet. Each product becomes a row in your “product details” tab, which means you can filter by price, compare descriptions, or build reports without reformatting.
You can easily modify the extracted fields to include reviews or the original source URL based on your needs. See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Google Sheets Trigger
Set up the workflow to watch your input sheet for newly added URLs.
- Add the Monitor Sheet URL Entries node as your trigger.
- Set Event to
rowAdded. - Select the input spreadsheet in Document and choose the worksheet matching Sheet Name
Sheet1(gid=0). - Credential Required: Connect your googleSheetsTriggerOAuth2Api credentials.
⚠️ Common Pitfall: Make sure your input sheet contains a Website column, since the next node references {{$json.Website}}.
Step 2: Connect Google Sheets
Prepare the output Google Sheet that will store the extracted product data.
- Add the Append Details to Sheet node.
- Set Operation to
append. - Select the destination spreadsheet in Document and set Sheet Name to
product details. - Map the columns: productName to
{{ $json.productName }}, price to{{ $json.price }}, and productDescription to{{ $json.productDescription }}. - Credential Required: Connect your googleSheetsOAuth2Api credentials.
⚠️ Common Pitfall: Replace the placeholder [YOUR_ID] in Document with your actual spreadsheet ID.
Step 3: Set Up the AI Extraction Request
Configure the AI extraction request that pulls product data from each URL.
- Add the Fetch Product Details via AI node and connect it after Monitor Sheet URL Entries.
- Set URL to
https://app.dumplingai.com/api/v1/extract. - Set Method to
POSTand enable Send Body. - Set Specify Body to
jsonand paste the JSON body:{ "url": "{{ $json.Website }}", "schema": { "productName": "string", "price": "string", "review": "string?", "productDescription": "string" } } - Set Authentication to
genericCredentialTypeand Generic Auth Type tohttpHeaderAuth. - Credential Required: Connect your httpHeaderAuth credentials.
Execution Flow: Monitor Sheet URL Entries → Fetch Product Details via AI.
Step 4: Split and Append Extracted Results
Split the AI response into individual items and append them to your output sheet.
- Add the Divide Extracted Items node and connect it after Fetch Product Details via AI.
- Set Field To Split Out to
results. - Connect Divide Extracted Items to Append Details to Sheet.
Execution Flow: Fetch Product Details via AI → Divide Extracted Items → Append Details to Sheet.
Step 5: Test and Activate Your Workflow
Validate the workflow end-to-end before turning it on.
- Click Execute Workflow and add a new row with a valid URL in the input sheet watched by Monitor Sheet URL Entries.
- Confirm that Fetch Product Details via AI returns data and Divide Extracted Items outputs individual items.
- Verify that Append Details to Sheet writes
productName,price, andproductDescriptioninto the output sheet. - Toggle the workflow to Active to run continuously.
Common Gotchas
- Google Sheets credentials can expire or need specific permissions. If things break, check the credential status inside n8n and confirm the connected Google account can edit the target spreadsheet first.
- If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
- Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.
Frequently Asked Questions
About 30 minutes if your Sheets are ready.
No. You’ll mainly connect Google Sheets and paste in the right spreadsheet/tab IDs. Then you’ll test with a couple URLs to confirm the extracted columns match your headers.
Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in Dumpling AI API usage costs based on how many pages you extract.
Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.
Yes, but you need to do it in two places. Update the extraction schema sent in the “Fetch Product Details via AI” HTTP Request so Dumpling AI returns a review field, then add a matching column header in your output Google Sheet. If you want the original source URL saved on every row, add a field in the Set/Edit Fields step (or map the incoming URL directly) before the append happens. Most people also tweak the output sheet to include a timestamp, so you can tell how fresh each snapshot is.
Usually it’s expired Google authorization inside n8n, or the connected account doesn’t have edit access to the spreadsheet. Reconnect the Google Sheets credential and verify you can manually edit both the source tab and the output “product details” tab. If it fails only on the append step, check that your output headers match what the workflow is trying to write (productName, price, productDescription).
Plenty for small teams. On n8n Cloud, your limit is mostly about monthly executions on your plan, while self-hosting depends on your server. In practice, the bottleneck is the external extraction request, so if you paste hundreds of URLs at once you may want to run in batches and spot-check results.
Often, yes. This workflow needs clean handling for things like “one URL returns multiple products,” and n8n is comfortable with that kind of logic without turning into a fragile chain of zaps. You also get the self-hosting option, which is nice when your research volume spikes for a launch or a quarterly pricing review. Zapier or Make can still work if you only need a simple “new row in Sheet → call API → write row,” but people tend to hit complexity walls once splitting and mapping gets involved. If you’re torn, Talk to an automation expert and get a quick recommendation.
Once this is running, competitor research becomes a simple habit: paste URLs, get clean rows. Honestly, that alone makes pricing reviews and positioning work less chaotic.
Need Help Setting This Up?
Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.
