Export Amazon product reviews in bulk to Google Sheets via RapidAPI
Ready for 3.0What this workflow does
This workflow has 10 nodes and runs when someone submits an n8n form (“Amazon Product Reviews Scraper”). Along the way it connects Google Sheets. It also calls real-time-amazon-data.p.rapidapi.com over HTTP.
How it runs
Trigger: When someone submits an n8n form (“Amazon Product Reviews Scraper”).
- Set Constants (Edit Fields (Set)): sets 5 fields: asin, country, brand_name…
- Build Parameter Sets (Code): runs custom JavaScript code
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Wait: waits 3.7 seconds
- HTTP Request: calls real-time-amazon-data.p.rapidapi.com
- If: checks a condition and branches into true / false
- Split Out: splits a list into separate items
- Wait: waits 60 seconds
- Store reviews (Google Sheets): append or update
Services it uses
HTTP calls to: real-time-amazon-data.p.rapidapi.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Wait
n8n-nodes-base.wait - Split Out
n8n-nodes-base.splitOut - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - n8n Form Trigger
n8n-nodes-base.formTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code
From the author
What it does Pulls up to 700 Amazon reviews per product (recent and top-rated) and writes them straight into a Google Sheet tab you choose. Perfect for • Brand and product managers tracking sentiment • Marketplace sellers analysing competitor feedback •…