Amazon Product Comments Exporter
Easily collect product reviews from Amazon and export the data to Google Sheets.
Overview
This app allows you to collect detailed reviews of specific products on Amazon by providing their ASINs. You can enter a batch of ASINs, and the app will gather the associated product reviews, including ratings, titles, and reviewer details. The collected data is then saved to your designated Google Sheets document, making it easy to analyze product feedback.
How to Use
Download the app from Octoparse AI app store.
Launch the app in your list.
Parameter description
GoogleClientId: The ClientId for your target Google spreadsheet.
GoogleClientKey: The ClientKey for your target Google spreadsheet.
GoogleSheetUrl: The link to the Google Sheets document where the collected reviews will be saved.
GoogleSheetName: The name of the sheet within the Google Sheets document where the reviews will be stored.
ASINs: The Amazon Standard Identification Numbers (ASINs) of the products you want to collect reviews for. You can provide a list of ASINs, one per line.
Click "Run application"
Output
This app will collect and export the following details for each product to the specified Google Sheets document:
ASIN: Amazon Standard Identification Number of the product.
ProductName: The name of the product.
AvgStars: The average rating given to the product.
TotalRating: The total number of reviews the product has received.
ReviewTitle: The title of each review.
Reviewer: The name of the reviewer.
Comment: The content of the review.
ProductInfo: Additional product information provided in the review.
IsVerified: Indicates whether the review is from a verified purchase.
IsHelpful: Indicates whether the review has been marked as helpful by other users.
Location: The location of the reviewer (if available).
Date: The date the review was posted.
Note
Please create the Google Sheets document to save the collected results in advance, and set the headers in the first row of the Google Sheets document to match the format of the sample data.
Ensure you have installed and enabled the Octoparse AI Chrome extension.
Create the Google Sheets document in advance, and set the headers in the first row to match the required format.
How to get ClientId and ClientKey: Google Developers Guide
Troubleshooting
Encounter obstacles but don't know how to resolve them when executing the app?
Please contact our support team at [email protected] to find the way out!
To help us better understand your issue, follow the steps below to export your running logs:
Version
version 2
2025-02-11
version 1
2024-06-29