Hébergement VPS n8n | Automatisation sécurisée et évolutive
Formation n8n en Français : Automatisation & Agents IA
This workflow scrapes structured Amazon product data with Apify and enriches each product with OpenAI (GPT-4o), then appends the results to Google Sheets. Unlike a raw HTML scraper, Apify returns clean structured products (title, ASIN, brand, price, rating, reviews), so the AI is free to do the analysis — category, key feature, buyer verdict and a 1–10 value score.
Flow (build order):
Manual Trigger
→ Configuration (Set)
→ Scrape Amazon products via Apify (HTTP Request)
→ Keep valid products (Filter)
→ Analyze product with AI (Basic LLM Chain)
├─ OpenAI Chat Model (sub-node)
└─ Structured Output Parser (sub-node)
→ Build result row (Set)
→ Save products to Google Sheets (Append)
<aside> 💡
Goal of this page: let you rebuild the workflow manually, node by node, live on camera. Every value below is copy-paste ready.
</aside>
Three credentials are required. None are hard-coded in the workflow — they live in n8n credentials.
| Credential (n8n name) | Type | Where to get the key |
|---|---|---|
| Apify API | Header Auth | Apify Console → Settings → API & Integrations → Personal API token |
| OpenAi account | OpenAI API | platform.openai.com → API keys |
| Google Sheets account | Google Sheets OAuth2 | Connect your Google account in n8n |