Hunyao This workflow corresponds to n8n.io template #7050 — we link there as the canonical source.
This workflow follows the Form Trigger → Google Sheets recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": "UXqw9glm6hQ45Yxz",
"name": "My workflow 11",
"tags": [],
"nodes": [
{
"id": "85865a9c-c8db-48fc-be37-e44b9488ca83",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1392,
640
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "7bf88274-96e0-47fe-830b-81b894fce53a",
"name": "Wait1",
"type": "n8n-nodes-base.wait",
"position": [
1616,
400
],
"parameters": {
"amount": 3.7
},
"typeVersion": 1.1
},
{
"id": "b98f4bf4-1a89-4e3e-bab1-b27730797d43",
"name": "Wait2",
"type": "n8n-nodes-base.wait",
"position": [
2288,
496
],
"parameters": {
"amount": 60
},
"typeVersion": 1.1
},
{
"id": "875c965f-fcbb-476f-9d53-3ff0a7a2dcdb",
"name": "Split Out Reviews",
"type": "n8n-nodes-base.splitOut",
"position": [
2288,
304
],
"parameters": {
"options": {},
"fieldToSplitOut": "data.reviews"
},
"typeVersion": 1
},
{
"id": "482ca5b2-a96a-49b3-bf8b-656b1973dcfc",
"name": "If status \"OK\" and contains reviews",
"type": "n8n-nodes-base.if",
"position": [
2064,
400
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "264bc7f0-0b3a-412c-b7fd-de676e20442b",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{$json.status == 'OK'}}",
"rightValue": "="
},
{
"id": "5827107b-d356-4672-9adf-505c86c09989",
"operator": {
"type": "array",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.data.reviews }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "ca6e3a19-8678-4fcd-9af3-bd730b827735",
"name": "Store reviews",
"type": "n8n-nodes-base.googleSheets",
"position": [
2512,
464
],
"parameters": {
"columns": {
"value": {},
"schema": [],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "url",
"value": "={{ $('On form submission').item.json[\"Tab URL to insert reviews\"] }}"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1XsPm7V9cf9jufJ6flUXTVO2Kzaj_KOyl1_h7AZTomCM",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1XsPm7V9cf9jufJ6flUXTVO2Kzaj_KOyl1_h7AZTomCM/edit?usp=drivesdk",
"cachedResultName": "Amazon Reviews Database"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.6
},
{
"id": "f92603d0-4224-4cab-9740-903edd0f0189",
"name": "HTTP Request",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
1840,
400
],
"parameters": {
"url": "https://real-time-amazon-data.p.rapidapi.com/product-reviews",
"options": {},
"sendQuery": true,
"sendHeaders": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "country",
"value": "={{ $json.country }}"
},
{
"name": "asin",
"value": "={{ $json.asin }}"
},
{
"name": "page",
"value": "={{ $json.page }}"
},
{
"name": "sort_by",
"value": "={{ $json.sort_by }}"
},
{
"name": "star_rating",
"value": "={{ $json.star_rating }}"
},
{
"name": "verified_purchases_only",
"value": "true"
},
{
"name": "images_or_videos_only",
"value": "false"
},
{
"name": "current_format_only",
"value": "false"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "x-rapidapi-host",
"value": "real-time-amazon-data.p.rapidapi.com"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"name": "<your credential>"
}
},
"retryOnFail": true,
"typeVersion": 4.2
},
{
"id": "b14a05fb-024d-4209-a779-9621e5f61172",
"name": "On form submission",
"type": "n8n-nodes-base.formTrigger",
"position": [
720,
640
],
"parameters": {
"options": {},
"formTitle": "Amazon Product Reviews Scraper",
"formFields": {
"values": [
{
"fieldLabel": "Brand name",
"placeholder": "MANSCAPED",
"requiredField": true
},
{
"fieldLabel": "Product / Model Name",
"placeholder": "The Lawn Mower\u00ae 3.0 Plus ",
"requiredField": true
},
{
"fieldLabel": "Amazon Product URL",
"placeholder": "https://www.amazon.com/MANSCAPED%C2%AE-Lawn-Mower%C2%AE-Groin-Trimmer/dp/B0CQB9Y9LR?th=1",
"requiredField": true
},
{
"fieldLabel": "Tab URL to insert reviews",
"placeholder": "https://docs.google.com/spreadsheets/d/1XsPm7V9cf9jufJ6flUXTVO2Kzaj_KOyl1_h7AZTomCM/edit?gid=1804331607#gid=1804331607",
"requiredField": true
}
]
},
"formDescription": "Which brand's feedback would you like to research on?"
},
"typeVersion": 2.2
},
{
"id": "1d5e0f0e-6bfc-44ed-98b9-41f9f942e283",
"name": "Set Constants",
"type": "n8n-nodes-base.set",
"position": [
944,
640
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "76a26d62-f4ef-4e23-9b38-6d48a857b6a4",
"name": "asin",
"type": "string",
"value": "={{ $json[\"Amazon Product URL\"].match(/\\/dp\\/([A-Z0-9]{10})/)[1] }}"
},
{
"id": "3eaff8f4-2c95-4571-b55f-724c2a65dd5c",
"name": "country",
"type": "string",
"value": "US"
},
{
"id": "1f7c745d-cbcd-4cc0-9135-82d8b1579108",
"name": "brand_name",
"type": "string",
"value": "={{ $json['Brand name'] }}"
},
{
"id": "9a106cd5-b43a-4015-8237-ecb7ce4f9e3d",
"name": "product_name",
"type": "string",
"value": "={{ $json['Product / Model Name'] }}"
},
{
"id": "50fbc48b-6485-44a1-b486-fad58c2783d1",
"name": "last_scraped",
"type": "string",
"value": "={{ $json.submittedAt }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "7ff1aa7b-a2f2-49a0-932f-8a828199b249",
"name": "Build Parameter Sets",
"type": "n8n-nodes-base.code",
"onError": "continueErrorOutput",
"position": [
1168,
640
],
"parameters": {
"jsCode": "const asin = $input.first().json.asin;\nconst country = $input.first().json.country;\n\nconst items = [];\n\n// 1. Core harvest (50 calls)\n['1_STARS','2_STARS','3_STARS','4_STARS','5_STARS'].forEach(rating => {\n for (let page=1; page<=10; page++) {\n items.push({ asin, country, star_rating: rating,\n sort_by: 'MOST_RECENT', page });\n }\n});\n\n// 3. Spotlight extremes (20 calls)\n['1_STARS','5_STARS'].forEach(rating => {\n for (let page=1; page<=10; page++) {\n items.push({ asin, country, star_rating: rating,\n sort_by: 'TOP_REVIEWS', page });\n }\n});\n\nreturn items.map(i => ({json: i}));\n"
},
"typeVersion": 2
},
{
"id": "222653cb-0c94-4b9e-885b-ef3003790fa9",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
0
],
"parameters": {
"width": 576,
"height": 1472,
"content": "## \ud83e\uddfe Amazon Product Reviews Scraper \u2013 User Manual\n\n### \ud83d\udce5 1. On Form Submission\n\n* When filling in the form, ensure that the **Tab URL** entered matches the **exact URL** of the corresponding tab in the Google Sheet you want to populate.\n* If there's a mismatch, the data **will not be stored** in the correct sheet.\n\n---\n\n### \ud83d\udd0d 2. What This Workflow Does\n\n* For each ASIN, the scraper pulls:\n\n * **MOST RECENT** reviews \u2192 100 per star rating (1\u2b50 to 5\u2b50)\n * **TOP REVIEWS** \u2192 100 for only 1\u2b50 and 5\u2b50\n* This means:\n\n * 50 API calls for MOST RECENT (5 ratings \u00d7 10 pages each)\n * 20 API calls for TOP REVIEWS (2 ratings \u00d7 10 pages each)\n * **Total: 70 API calls per product**\n\n---\n\n### \ud83d\udd11 3. How to Get Your RapidAPI Key\n\n1. Go to: [RapidAPI Playground](https://rapidapi.com/letscrape-6bRBa3QguO5/api/real-time-amazon-data/playground/endpoint_1e42cec2-07bd-49bf-bde6-563c03f27bb3)\n2. Log in or sign up for a RapidAPI account.\n3. Click **\"Test Endpoint\"** \u2192 this auto-generates your API Key.\n4. Click the **\u201cCode Snippet\u201d** tab \u2192 copy your `X-RapidAPI-Key`.\n5. Paste this into your n8n HTTP Request credentials under `httpHeaderAuth`.\n\n---\n\nHere\u2019s the updated section with the correct error message:\n\n---\n\n### \u26a0\ufe0f 4. Known Failure Cases\n\n#### \ud83d\udd38 *Fails at* \u2192 `If status \"OK\" and contains reviews`\n\nTwo main causes:\n\n1. **Not enough reviews available**\n The workflow assumes **10 pages** of reviews exist for each star rating.\n If Amazon doesn't have that many, the step will fail silently at the conditional check.\n\n2. **RapidAPI quota limit exceeded**\n If you've hit your monthly quota, the API will return an error like:\n\n ```\n The service is receiving too many requests from you \n You have exceeded the MONTHLY quota for Requests on your current plan, BASIC. \n Error 429\n ```\n\n You can verify this by checking the logs for an `Error 429` and reviewing your quota at [RapidAPI Dashboard](https://rapidapi.com/developer/dashboard).\n"
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "3b3852dc-5ca6-4ac2-81c1-0a128538416e",
"connections": {
"Wait1": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"Wait2": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "If status \"OK\" and contains reviews",
"type": "main",
"index": 0
}
]
]
},
"Set Constants": {
"main": [
[
{
"node": "Build Parameter Sets",
"type": "main",
"index": 0
}
]
]
},
"Store reviews": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Wait1",
"type": "main",
"index": 0
}
]
]
},
"Split Out Reviews": {
"main": [
[
{
"node": "Store reviews",
"type": "main",
"index": 0
}
]
]
},
"On form submission": {
"main": [
[
{
"node": "Set Constants",
"type": "main",
"index": 0
}
]
]
},
"Build Parameter Sets": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"If status \"OK\" and contains reviews": {
"main": [
[
{
"node": "Split Out Reviews",
"type": "main",
"index": 0
}
],
[
{
"node": "Wait2",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleSheetsOAuth2ApihttpHeaderAuth
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
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.
Source: https://n8n.io/workflows/7050/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Overview 🌐
Form Trigger, HTTP Request, Google Sheets
Splitout Code. Uses splitOut, httpRequest, googleSheets, stickyNote. Event-driven trigger; 36 nodes.
HTTP Request, Google Sheets, Form Trigger +1
This n8n workflow is designed for Customer Success Managers (CSM), marketers, sales teams, and data administrators who need to automate the process of uploading and processing CSV data in HubSpot. It
HTTP Request, Google Sheets, Form Trigger +1
The SEO On Page API is a powerful tool for keyword research, competitor analysis, backlink insights, and overall SEO optimization. With multiple endpoints, you can instantly gather actionable SEO data
Form Trigger, HTTP Request, Google Sheets
Demonstration video
Form Trigger, HTTP Request, Google Sheets