Scrape and score Amazon products with Apify, OpenAI, and Google Sheets

Description

Quick overview
This workflow manually scrapes product results from an Amazon search URL via the Apify Amazon Crawler actor, uses OpenAI to generate a structured product analysis (category, key feature, verdict, value score), and appends the enriched results to a Google Sheets spreadsheet.

How it works
Runs when you manually click “Test workflow” in n8n.
Sends the configured Amazon search URL and scraping limits to the apify Amazon Crawler actor and retrieves the dataset items.
Filters out any scraper items that are missing a title or contain an error.
Uses OpenAI to analyze each product’s title, brand, price, rating, and review count and returns a structured category, key feature, buyer verdict, and 1–10 value score.
Combines the scraped fields and AI analysis into a single row format and adds a timestamp.
Appends each enriched product as a new row in Google Sheets.

Setup
Create an apify API token and add it as an HTTP Header Auth credential used by the Apify request.
Add an OpenAI API key as an OpenAI credential and choose the model to use in the configuration.
Connect a Google Sheets OAuth2 account and select the target spreadsheet, sheet tab, and columns for appending rows.
Update the configuration values (Amazon search URL, max products, proxy country, analysis language, and actor ID if needed) before running the workflow.

Additional info
Scrape Amazon products with Apify and enrich them with AI in Google Sheets

📥 Open full documentation on Notion

Need help customizing?
Contact me for consulting and support : Linkedin

MY NEW YOUTUBE CHANNEL
👉 Subscribe to my new YouTube channel. Here I'll share videos and Shorts with practical tutorials and FREE templates for n8n.