Automate Amazon Review to Notion: n8n + ScraperAPI + GPT-5

Revolutionize Your Review Management: Automate Amazon Reviews to Notion

Enhance your e-commerce strategy with the "Automate Amazon Review to Notion" workflow, designed to streamline and organize your product feedback seamlessly. By integrating n8n with ScraperAPI and GPT-5, this automation allows you to effortlessly gather, analyze, and store Amazon reviews directly into your Notion database every Monday.

What This Workflow Does

• Every Monday at 8am, the workflow activates and loads a pre-configured watchlist of Amazon ASINs along with specified Notion and locale settings.
• Utilizes ScraperAPI to retrieve product data, including the most recent reviews for each ASIN listed.
• Extracts and filters new reviews that haven't been captured in previous cycles, ensuring fresh insights are continuously added.
• Leverages OpenAI to classify each review's sentiment, assign up to four feature tags, and generate a concise one-sentence summary in JSON format.
• Normalizes AI output, adjusts lengthy texts to meet Notion’s character limits, and standardizes review dates into ISO format.
• Creates a new, structured page in your selected Notion database, detailing properties like sentiment, star rating, feature tags, product identifiers, review date, and additional metadata.

Use Cases

• Business owners can conveniently monitor product performance across market platforms by analyzing sentiments and key features highlighted in customer feedback.
• Product managers and marketing teams can utilize the organized Notion database entries for strategic planning and product improvement initiatives.
• Automates the tedious process of manually categorizing and inputting Amazon reviews, allowing teams to focus on customer-centric growth strategies.

Technical Details

• Integration Tools: n8n automation platform, ScraperAPI for data extraction, OpenAI's GPT-5 for sentiment analysis.
• Node Integration: Set, Code, Notion, Split Out, Sticky Note, HTTP Request.
• Initial Setup: Configure ScraperAPI and Notion API credentials, execute 'Run once — set up Notion columns' path to ensure database properties match.