This n8n workflow automates the process of collecting Amazon product reviews through a user-initiated form and stores the data in a Google Sheet. Designed for market research and review analysis, it pulls comprehensive reviews by rating and category, ensuring detailed feedback collection for products.
The workflow begins with a form trigger where users input product details, including the Amazon URL, brand, and the target Google Sheet URL for storing reviews. Once submitted, it extracts the ASIN from the URL, sets constants like country and product info, and generates multiple API call parameters to fetch reviews.
Using a series of API requests to RapidAPI’s real-time Amazon data service, it gathers reviews based on ratings (1 to 5 stars), sorting them by recent or top reviews, across multiple pages. It implements wait nodes to manage API rate limits, combining batch processing with delay to avoid exceeding quotas.
The responses are filtered to ensure successful retrieval and reviews’ existence before splitting review data. Finally, reviews are appended to the specified Google Sheets document, enabling streamlined review collection and analysis for market insights or product feedback.
This workflow is ideal for eCommerce sellers, market researchers, or review analysts who want automated, scalable review harvesting directly from Amazon, with data automatically organized in cloud spreadsheets for further analysis.
Reviews
There are no reviews yet.