Skip to main content

Export Amazon product reviews in bulk to Google Sheets via RapidAPI

n8n Cloud
$20/month : Unlimited workflows
2500 executions/month
Try free
Bright Data
THE #1 IN WEB SCRAPING
Scrape any website without limits
Try free
HOSTINGER 🎉 Early Black Friday Deal
DISCOUNT 20%
Self-hosted n8n
Unlimited workflows - from $4.99/mo
Try free
Apify
#1 hub for scraping, AI & automation
6000+ actors - $5 credits/mo
Try free

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 • Agencies building product-review dashboards

Apps used RapidAPI Real-Time Amazon Data, Google Sheets, n8n Form Trigger

How it works

  1. Form Trigger collects brand, product and sheet info.
  2. Code node extracts the ASIN and builds 70 API requests (10 pages × star ratings).
  3. Split-in-batches loops through the request list, throttled by two Wait nodes.
  4. HTTP Request fetches reviews from RapidAPI.
  5. IF node drops empty or error responses.
  6. Split Out breaks arrays into single reviews.
  7. Google Sheets appends every review to the target tab.
  8. Loop continues until all pages finish.

Setup

  1. Fill in Brand name, Product / Model Name, Amazon Product URL, Tab URL to insert reviews in the form.
  2. Grab your X-RapidAPI-Key from RapidAPI → Add as httpHeaderAuth credential.
  3. Connect Google Sheets OAuth2 and make the spreadsheet Anyone with the link can edit.
  4. Open Workflow Settings → set timezone if you plan to schedule runs.
  5. Hit Execute workflow or share the form link.

Credentials • Real-Time Amazon Data (RapidAPI HTTP Header Auth) • Google Sheets OAuth2

Limits and notes • ~100 RapidAPI calls for the free plan. Plan quota accordingly. • Assumes Amazon returns 10 pages per star rating; fewer pages skip silently. • Large sheets may hit Google API write quotas.

If you have any questions in running the workflow, feel free to reach out to me at my youtube channel: https://www.youtube.com/@hunyaochong