How to Automate Review Summarization with n8n

import os
import requests

API_KEY = os.environ.get('SCAVIO_API_KEY', 'your_scavio_api_key')
ENDPOINT = 'https://api.scavio.dev/api/v1/search'

def fetch_reviews(asin: str) -> list[dict]:
    response = requests.post(
        ENDPOINT,
        headers={'x-api-key': API_KEY},
        json={'platform': 'amazon', 'query': asin, 'marketplace': 'US', 'action': 'reviews'}
    )
    response.raise_for_status()
    return response.json().get('reviews', [])

def format_reviews(reviews: list[dict]) -> str:
    lines = []
    for i, r in enumerate(reviews, 1):
        lines.append(f'Review {i} ({r.get("rating", "N/A")} stars): {r.get("text", r.get("body", ""))}')
    return '\n\n'.join(lines)

def summarize_with_llm(product_name: str, formatted_reviews: str, review_count: int) -> str:
    prompt = f'''Summarize the following {review_count} customer reviews for {product_name}.

Provide:
1. Top 3 praise points
2. Top 3 complaint points
3. Overall sentiment
4. One-paragraph executive summary

Reviews:
{formatted_reviews}'''
    # Replace with your preferred LLM API call
    import anthropic
    client = anthropic.Anthropic()
    message = client.messages.create(
        model='claude-sonnet-4-20250514',
        max_tokens=1024,
        messages=[{'role': 'user', 'content': prompt}]
    )
    return message.content[0].text

def main():
    asin = 'B09G9FPHY6'
    reviews = fetch_reviews(asin)
    formatted = format_reviews(reviews)
    summary = summarize_with_llm('Echo Dot 5th Gen', formatted, len(reviews))
    print(f'Review Summary ({len(reviews)} reviews):')
    print(summary)

if __name__ == '__main__':
    main()

const API_KEY = process.env.SCAVIO_API_KEY || 'your_scavio_api_key';
const ENDPOINT = 'https://api.scavio.dev/api/v1/search';

async function fetchReviews(asin) {
  const response = await fetch(ENDPOINT, {
    method: 'POST',
    headers: { 'x-api-key': API_KEY, 'Content-Type': 'application/json' },
    body: JSON.stringify({ platform: 'amazon', query: asin, marketplace: 'US', action: 'reviews' })
  });
  if (!response.ok) throw new Error('HTTP ' + response.status);
  const data = await response.json();
  return data.reviews || [];
}

function formatReviews(reviews) {
  return reviews.map((r, i) =>
    'Review ' + (i + 1) + ' (' + (r.rating || 'N/A') + ' stars): ' + (r.text || r.body || '')
  ).join('\n\n');
}

async function summarizeWithLLM(productName, formatted, count) {
  // Replace with your preferred LLM API call
  const Anthropic = require('@anthropic-ai/sdk');
  const client = new Anthropic();
  const message = await client.messages.create({
    model: 'claude-sonnet-4-20250514',
    max_tokens: 1024,
    messages: [{
      role: 'user',
      content: 'Summarize the following ' + count + ' customer reviews for ' + productName + '.\n\nProvide:\n1. Top 3 praise points\n2. Top 3 complaint points\n3. Overall sentiment\n4. One-paragraph executive summary\n\nReviews:\n' + formatted
    }]
  });
  return message.content[0].text;
}

async function main() {
  const reviews = await fetchReviews('B09G9FPHY6');
  const formatted = formatReviews(reviews);
  const summary = await summarizeWithLLM('Echo Dot 5th Gen', formatted, reviews.length);
  console.log('Review Summary (' + reviews.length + ' reviews):');
  console.log(summary);
}

main().catch(console.error);

Review Summary (47 reviews):

Top 3 praise points:
1. Excellent sound quality for the price point
2. Seamless smart home integration with Alexa routines
3. Compact design fits any room

Top 3 complaint points:
1. Bluetooth connection drops intermittently
2. Privacy concerns with always-on microphone
3. Power adapter is bulkier than previous generation

Overall sentiment: Positive

The Echo Dot 5th Gen receives broadly positive feedback with customers praising its audio quality and smart home capabilities relative to its price. Recurring complaints center on Bluetooth stability and the physical size of the power adapter.