{
  "name": "Analyze & summarize Amazon product reviews with Decodo, OpenAI and Google Sheets",
  "nodes": [
    {
      "id": "a29b7fb0-3ed7-44c2-b11b-7a17d69537db",
      "name": "When clicking ‘Execute workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -720,
        -64
      ]
    },
    {
      "id": "5d2e9f86-bd81-4313-aa7b-0bf6b9f01d32",
      "name": "Set the Input Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        -512,
        -64
      ]
    },
    {
      "id": "28371bb1-f1f6-4bd1-b424-708882d083ac",
      "name": "Decodo Amazon Scraper",
      "type": "@decodo/n8n-nodes-decodo.decodo",
      "position": [
        -208,
        -64
      ]
    },
    {
      "id": "7752d0a8-39bd-4746-ac4f-08d5985f74e8",
      "name": "Extract the Reviews",
      "type": "n8n-nodes-base.code",
      "position": [
        128,
        -64
      ]
    },
    {
      "id": "396506b9-28af-41e6-86ac-d43ed1b37867",
      "name": "Perform Review Analysis",
      "type": "@n8n/n8n-nodes-langchain.informationExtractor",
      "position": [
        336,
        -64
      ]
    },
    {
      "id": "36603325-e772-4fec-8bc4-89cc87a1e27d",
      "name": "Create a Binary Response",
      "type": "n8n-nodes-base.function",
      "position": [
        128,
        -352
      ]
    },
    {
      "id": "17f5028f-66af-48c8-8274-624e3135fa36",
      "name": "Write the Structured JSON to Disk",
      "type": "n8n-nodes-base.readWriteFile",
      "position": [
        304,
        -352
      ]
    },
    {
      "id": "9115fd05-7d8a-468a-8ef0-9d14cf6b8a32",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        80,
        -464
      ],
      "parameters": {
        "width": 832,
        "height": 288,
        "content": "## 2. Export Data Handling\n\nPersist the Amazon Scraped Response to Disk"
      }
    },
    {
      "id": "e03e2a33-1049-4cf7-9258-33d43396368a",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        80,
        -160
      ],
      "parameters": {
        "width": 832,
        "height": 400,
        "content": "## 3. Amazon Review Analysis\n\nComprehensive and Abstract Review Analysis of the Amazon Scraped Content\n"
      }
    },
    {
      "id": "b2666d86-2fe3-4412-abf8-7a101461b972",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -336,
        -176
      ],
      "parameters": {
        "width": 352,
        "height": 304,
        "content": "## 1. Amazon URL Scraper\n\nWeb Scrape the Amazon URL via the Decode"
      }
    },
    {
      "id": "2ef973af-687a-44f8-98cb-fdea180d489c",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1600,
        -768
      ],
      "parameters": {
        "width": 768,
        "height": 1072,
        "content": "## How It Works\n\nThis workflow automates **Amazon product review analysis** using **Decodo**, **OpenAI GPT-4.1-mini**, and **Google Sheets**.\n\n* **Trigger & Input:** Manually start with `amazon_url`, "
      }
    },
    {
      "id": "3a9941dc-3e5b-4651-8c8b-3ef5f640c031",
      "name": "Append or update row in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        688,
        -64
      ]
    },
    {
      "id": "c7b744bd-5f42-499a-8fab-c052b195d765",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        80,
        -768
      ],
      "parameters": {
        "width": 448,
        "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": "fc1080c8-e4b4-42ef-879b-7e0d075a2f82",
      "name": "OpenAI Chat Model for Review Analysis",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        336,
        96
      ]
    }
  ],
  "connections": {
    "Extract the Reviews": {
      "main": [
        [
          {
            "node": "Perform Review Analysis",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set the Input Fields": {
      "main": [
        [
          {
            "node": "Decodo Amazon Scraper",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Decodo Amazon Scraper": {
      "main": [
        [
          {
            "node": "Extract the Reviews",
            "type": "main",
            "index": 0
          },
          {
            "node": "Create a Binary Response",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Perform Review Analysis": {
      "main": [
        [
          {
            "node": "Append or update row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create a Binary Response": {
      "main": [
        [
          {
            "node": "Write the Structured JSON to Disk",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Set the Input Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model for Review Analysis": {
      "ai_languageModel": [
        [
          {
            "node": "Perform Review Analysis",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    }
  }
}