{
  "name": "Scrape and analyze Amazon product info with Decodo + OpenAI",
  "nodes": [
    {
      "id": "9acc7180-abec-4d04-abd0-2505ec667a80",
      "name": "When clicking ‘Execute workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -1152,
        656
      ]
    },
    {
      "id": "11b5855c-64a2-48be-9ee7-f4245554c13a",
      "name": "Set the Input Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        -960,
        656
      ]
    },
    {
      "id": "657db23a-996b-43aa-b3cf-8148e1e6aaa5",
      "name": "Decodo Web scrape for Amazon Products",
      "type": "@decodo/n8n-nodes-decodo.decodo",
      "position": [
        -768,
        656
      ]
    },
    {
      "id": "33ee2b31-cb2e-45a5-8cee-b404ac83faca",
      "name": "Extract Product Details",
      "type": "n8n-nodes-base.code",
      "position": [
        -464,
        704
      ]
    },
    {
      "id": "19bb1c74-3200-437e-abd8-6cd2f76e06f6",
      "name": "Extract Ads",
      "type": "n8n-nodes-base.code",
      "position": [
        -464,
        272
      ]
    },
    {
      "id": "5578b6bc-9b76-43f6-a7c4-3f16648a29c1",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -32,
        656
      ]
    },
    {
      "id": "ecd8d612-ba33-4098-ab15-d42b916606bb",
      "name": "Structured Output Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        176,
        656
      ]
    },
    {
      "id": "1170e95d-5995-4f7f-8abe-4a528b7780d9",
      "name": "OpenAI Chat Model for Amazon Product Mining",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        16,
        272
      ]
    },
    {
      "id": "dddc5c80-7161-4b0e-bc4a-146d207550a7",
      "name": "Product Insights",
      "type": "@n8n/n8n-nodes-langchain.informationExtractor",
      "position": [
        16,
        96
      ]
    },
    {
      "id": "a09fa319-7cae-4c50-8082-896fb2112634",
      "name": "Product Descriptive Summarizer",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        0,
        464
      ]
    },
    {
      "id": "de650da3-dd97-46d1-8942-7e197d6ec700",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1120,
        864
      ],
      "parameters": {
        "width": 448,
        "height": 320,
        "content": "### Processing Steps\n\n1. **Scraping Phase**: Decodo fetches all product data from Amazon\n2. **Extraction Phase**: Four parallel extractions occur:\n   - Product details\n   - Customer reviews\n   - AI su"
      }
    },
    {
      "id": "d05add22-08e0-4deb-8373-d5367210e2f2",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1664,
        240
      ],
      "parameters": {
        "width": 464,
        "height": 736,
        "content": "## **How It Works**\n\nThis workflow automates the end-to-end processing of Amazon product data by extracting structured information, enriching it with AI-powered insights, and exporting the finalized r"
      }
    },
    {
      "id": "248c3649-c919-46f2-822d-90d2d0f7c569",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -176,
        -208
      ],
      "parameters": {
        "width": 576,
        "height": 144,
        "content": "### Multi-stage AI evaluation using OpenAI\nThis step generates product insights, produces descriptive summaries, and conducts competitive analysis based on the extracted data. Each model call refines "
      }
    },
    {
      "id": "ba3af54b-71b9-40fe-bf3a-34fe3d020be2",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1664,
        -64
      ],
      "parameters": {
        "width": 464,
        "height": 288,
        "content": "## Disclaimer\n\n![Logo](https://cdn.brandfetch.io/idIeG9_eXK/w/100/h/100/theme/dark/icon.jpeg?c=1bxid64Mup7aczewSAYMX&t=1756483136894)\n\nThis workflow is only available on n8n self-hosted as it's making"
      }
    },
    {
      "id": "e8492c0a-3fce-4477-b1c6-e5138952026e",
      "name": "Competitive Analysis",
      "type": "@n8n/n8n-nodes-langchain.informationExtractor",
      "position": [
        0,
        832
      ]
    },
    {
      "id": "0ef2f0ba-04da-4553-a81e-1db94d32b09d",
      "name": "OpenAI Chat Model for Competitive Analysis",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        0,
        1008
      ]
    },
    {
      "id": "6b9b801b-5e6c-4e56-81cd-c590cb6d8f57",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -576,
        32
      ],
      "parameters": {
        "width": 336,
        "height": 1152,
        "content": "## 1. Custom Data Extract\n\n\n"
      }
    },
    {
      "id": "463e0813-badb-45b0-bc98-523fb0b8f907",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -176,
        -64
      ],
      "parameters": {
        "width": 576,
        "height": 1248,
        "content": "## 2. OpenAI Insight Analyzer"
      }
    },
    {
      "id": "2d285795-4baf-4052-8169-9e438e195c0a",
      "name": "Append or update row in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        976,
        464
      ]
    },
    {
      "id": "08bc5f8e-29ec-4cdb-a722-28e3628380eb",
      "name": "Merge",
      "type": "n8n-nodes-base.merge",
      "position": [
        528,
        448
      ]
    },
    {
      "id": "e53ba49c-aa57-46d3-9355-f9db4935e51f",
      "name": "Aggregate",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        752,
        464
      ]
    },
    {
      "id": "45ec1fe6-7461-445e-9236-0a8b29961883",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        464,
        224
      ],
      "parameters": {
        "width": 784,
        "height": 576,
        "content": "## 3. Export Data Handling\n"
      }
    },
    {
      "id": "0e8e7966-580f-45ff-bef8-c2550daa9245",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        464,
        96
      ],
      "parameters": {
        "width": 784,
        "height": 128,
        "content": "### Export Data \nThis stage combines all processed outputs, aggregates them into a single structured record, and writes the finalized dataset to Google Sheets. It ensures no duplicates, preserves hist"
      }
    },
    {
      "id": "fb05f3bf-bfbf-4776-89c8-45cd4d3455fc",
      "name": "Sticky Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -576,
        -80
      ],
      "parameters": {
        "width": 336,
        "height": 112,
        "content": "### Custom Data Extract\nExtract Ads, Product Details, Reviews and AI Summary from the Decodo Response"
      }
    }
  ],
  "connections": {
    "Merge": {
      "main": [
        [
          {
            "node": "Aggregate",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate": {
      "main": [
        [
          {
            "node": "Append or update row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Ads": {
      "main": [
        [
          {
            "node": "Product Insights",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Product Insights": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Product Descriptive Summarizer",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Competitive Analysis": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "Set the Input Fields": {
      "main": [
        [
          {
            "node": "Decodo Web scrape for Amazon Products",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Product Details": {
      "main": [
        [
          {
            "node": "Product Descriptive Summarizer",
            "type": "main",
            "index": 0
          },
          {
            "node": "Competitive Analysis",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "Product Descriptive Summarizer",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Append or update row in sheet": {
      "main": [
        []
      ]
    },
    "Product Descriptive Summarizer": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Set the Input Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Decodo Web scrape for Amazon Products": {
      "main": [
        [
          {
            "node": "Extract Product Details",
            "type": "main",
            "index": 0
          },
          {
            "node": "Extract Ads",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model for Competitive Analysis": {
      "ai_languageModel": [
        [
          {
            "node": "Competitive Analysis",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model for Amazon Product Mining": {
      "ai_languageModel": [
        [
          {
            "node": "Product Insights",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    }
  }
}