Google Sheets + Gmail: product picks, neatly compared
Product research gets messy fast. One tab for Amazon, another for “maybe” options, screenshots in a random folder, and a half-finished spreadsheet that no one trusts.
This Google Sheets automation hits affiliate marketers hardest, but eCommerce researchers and small team operators feel it too. You want the best-value picks without spending your afternoon copy-pasting prices, reviews, and delivery dates into a sheet.
This workflow turns any product listing URL into up to three clean “best value” recommendations, saves them into Google Sheets, and emails you the sheet link in Gmail. You’ll see exactly what it does, what you need, and where teams usually trip up.
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: Google Sheets + Gmail: product picks, neatly compared
flowchart LR
subgraph sg0["Receive Website URL Flow"]
direction LR
n0["<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/form.svg' width='40' height='40' /></div><br/>Receive Website URL"]
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/>Crawl Website with Dumpling AI"]
n2@{ icon: "mdi:swap-vertical", form: "rounded", label: "Split Crawled Pages", pos: "b", h: 48 }
n3["<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/>Take Screenshot of Page"]
n4@{ icon: "mdi:robot", form: "rounded", label: "Analyze Screenshot with GPT-4o", pos: "b", h: 48 }
n5["<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/code.svg' width='40' height='40' /></div><br/>Parse and Extract Product Data"]
n6@{ icon: "mdi:database", form: "rounded", label: "Save Products to Google Sheet", pos: "b", h: 48 }
n7@{ icon: "mdi:message-outline", form: "rounded", label: "Send Email with Product Link", pos: "b", h: 48 }
n0 --> n1
n2 --> n3
n3 --> n4
n6 --> n7
n4 --> n5
n1 --> n2
n5 --> n6
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 n4 ai
class n6 database
class n1,n3 api
class n5 code
classDef customIcon fill:none,stroke:none
class n0,n1,n3,n5 customIcon
The Problem: Product comparisons take too long (and still feel shaky)
If you’ve ever tried to compare products across a listing page, you know the routine. You open 10 items, skim reviews, check delivery and free shipping, then try to remember which one looked “best” when you’re back in your spreadsheet. Details slip. Prices change. Delivery dates vary by location. And once you’re juggling more than one website, “quick research” becomes an hour of tab chaos. Even worse, you end up with a sheet that looks complete but is missing the context that made you pick those items in the first place.
The friction compounds. Here’s where it breaks down.
- Copying product names, prices, and review counts into a sheet takes about 5 minutes per product, and that’s on a good day.
- Delivery dates and “free shipping” labels are easy to misread or miss entirely, so your “best pick” can turn into a bad surprise.
- Teams end up relying on screenshots in chat threads, which makes decisions hard to audit later.
- When you’re doing this for multiple niches or clients, the mental load becomes the bottleneck, not the actual writing or publishing.
The Solution: Turn any listing URL into best-value picks in Sheets
This workflow starts with one simple input: a product listing URL (for example, an Amazon results page or a category listing on another store). n8n hands that URL to Dumpling AI, which crawls the page and captures screenshots of the product listings. Then GPT‑4o analyzes those images visually, so you’re not relying on fragile HTML scraping that breaks whenever the site layout changes. The model extracts up to three best-value picks and pulls the details you actually need for comparison: product name, price, review count, and a free delivery date when it’s shown. Finally, n8n cleans the output into a tidy structure and saves it to Google Sheets, then sends you the spreadsheet link through Gmail so you can review, share, or hand off instantly.
The workflow kicks off when you submit a URL (via a web form, webhook, or a Telegram trigger, depending on how you prefer to work). Dumpling AI gathers the visual “evidence,” GPT‑4o turns those screenshots into structured picks, and Google Sheets becomes the single place your comparisons live. Gmail closes the loop with a clean link in your inbox.
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say you research products for two posts per week, and each post needs a quick comparison from one big listing page. Manually, picking three products usually means checking around 10 listings at maybe 5 minutes each, then adding the winners into Sheets, so you’re at roughly an hour per page. With this workflow, you drop in the URL (about a minute), wait for the crawl and screenshot analysis (often 5–10 minutes), then open the Sheet link from Gmail. That’s close to an hour saved per page, which adds up quickly across a month.
What You’ll Need
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Google Sheets for storing and sharing product comparisons
- Gmail to send the finished spreadsheet link
- Dumpling AI token (get it from your Dumpling AI dashboard)
- OpenAI API key (get it from the OpenAI dashboard)
Skill level: Intermediate. You’ll connect a few accounts, add keys securely, and map columns in a Sheet.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
A URL comes in. You submit a product listing link via a web form/webhook, or trigger it from Telegram if you like working from your phone. Some setups also use a Gmail trigger, so an emailed URL can kick things off.
The page gets captured visually. n8n calls Dumpling AI through an HTTP request, then waits while the crawl finishes and screenshots are generated. This is the “don’t touch anything” part, because timing can vary by site speed and page size.
GPT‑4o selects the best-value picks. An AI Agent (using the OpenAI Chat Model) reviews the screenshots and extracts up to three products, pulling out price, review count, and delivery details when they appear. A small parsing step flattens that output so it behaves like normal rows in a spreadsheet.
Your sheet updates and an email goes out. Google Sheets receives the rows in consistent columns (product name, price, reviews, free delivery date), then Gmail sends you a neat message with the spreadsheet link so you can share it immediately.
You can easily modify the prompt fields to capture extra attributes like star rating, color options, or warranty terms based on your needs. See the full implementation guide below for customization options.
Common Gotchas
- Google Sheets credentials can expire or need specific permissions. If things break, check the connected Google account inside n8n’s Credentials screen first.
- If you’re using Wait nodes or external crawling, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
- OpenAI prompts that are too generic lead to “meh” picks. Add your definition of “best value” (delivery speed, free shipping, minimum review count) early or you will be re-checking everything anyway.
Frequently Asked Questions
About 30 minutes if you already have your keys and a Sheet ready.
No. You’ll mostly connect accounts and map a few fields into your Google Sheet columns.
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 OpenAI API costs and Dumpling AI usage, which depend on how many pages you analyze.
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, and it’s one of the best tweaks. Update the AI Agent prompt so it also returns fields like star rating, key specs, or “ships from” details, then add matching columns in Google Sheets. If you want different behavior per site (Amazon vs. other stores), route URLs through a Switch node and use slightly different prompts. Keep the output format consistent so the parsing step doesn’t break.
Most of the time it’s expired Google authorization or the wrong Google account connected. Reconnect the Google Sheets credential in n8n, then confirm the Sheet is shared with that account and the document ID matches the one in the node. If it only fails sometimes, you may be hitting Google API limits when you run a lot of URLs back-to-back. Waiting a minute between batches usually fixes it.
It can handle a lot, but large listing pages take longer to crawl and cost more in AI usage.
Often, yes, because this workflow benefits from branching, waits, and richer data handling, and n8n is comfortable with that. Zapier is great for straight lines like “new row → send email,” but it can get awkward when you need to pause for an external crawl, merge results, and normalize arrays into spreadsheet rows. Make can do it too, but the scenario can become harder to debug once you have multiple routes for different sites. n8n also gives you a self-host option, which matters if you’ll run this at volume. If you’re unsure, Talk to an automation expert and you’ll get an honest recommendation based on how often you run research.
Once this is running, product research stops feeling like busywork. You send a link, get a clean comparison sheet back, and move on.
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.
