{
  "name": "Amazon price drop analysis with Decodo, GPT-4.1-mini & Google Sheets integration",
  "nodes": [
    {
      "id": "2b808791-791d-4c97-969d-d1671564230e",
      "name": "When clicking ‘Test workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -304,
        -688
      ]
    },
    {
      "id": "4876fb18-7db4-4062-9f66-2dc17a251851",
      "name": "Set input fields",
      "type": "n8n-nodes-base.set",
      "position": [
        -112,
        -688
      ]
    },
    {
      "id": "67595908-efad-4799-ab32-c5030ca8cdb8",
      "name": "Split Out",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        736,
        -688
      ]
    },
    {
      "id": "9a4c555a-45ae-4126-8aa0-dec77c515e9d",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        960,
        -688
      ]
    },
    {
      "id": "a47aedbc-e23a-483d-a0ad-cbe84a5f0f08",
      "name": "Sentiment Analysis",
      "type": "@n8n/n8n-nodes-langchain.informationExtractor",
      "position": [
        1536,
        -512
      ]
    },
    {
      "id": "c10604a6-868a-49b7-a4f2-eafe32686eaa",
      "name": "Merge",
      "type": "n8n-nodes-base.merge",
      "position": [
        1904,
        -608
      ]
    },
    {
      "id": "4ee0392f-7f59-4d1f-8c64-b8a090e57c91",
      "name": "Update Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2384,
        -448
      ]
    },
    {
      "id": "4e71b068-a290-4334-8e73-cc62668d366c",
      "name": "Structured Output Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        528,
        -464
      ]
    },
    {
      "id": "f2d73087-0763-4c18-9d38-576d40b31449",
      "name": "Structure Data Extract Using LLM",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        336,
        -688
      ]
    },
    {
      "id": "54baaa48-901d-4b26-934c-c5accbd2718b",
      "name": "Aggregate",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        2096,
        -608
      ]
    },
    {
      "id": "c3feeb14-e1cc-49ff-a5bc-a39ea37fdefe",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1872,
        -1040
      ],
      "parameters": {
        "width": 736,
        "height": 848,
        "content": ""
      }
    },
    {
      "id": "b6835025-d8a3-4e73-9475-4f267bdf1022",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        720,
        -1040
      ],
      "parameters": {
        "width": 1128,
        "height": 852,
        "content": "\n"
      }
    },
    {
      "id": "a8ed3842-b93a-4129-855b-2d87c5c9e24b",
      "name": "Decodo",
      "type": "@decodo/n8n-nodes-decodo.decodo",
      "position": [
        80,
        -688
      ]
    },
    {
      "id": "ba4495df-dfe5-4ccb-9b06-08dcfa7f5fc4",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        288,
        -448
      ]
    },
    {
      "id": "d07b1d82-1793-49c5-b4f4-c87f45452200",
      "name": "Decodo Loop Web Scraper",
      "type": "@decodo/n8n-nodes-decodo.decodo",
      "position": [
        1328,
        -672
      ]
    },
    {
      "id": "92b5cea7-6a8a-43c4-a19d-a1aaf75cea33",
      "name": "OpenAI Chat Model for Sentiment Analysis",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        1552,
        -336
      ]
    },
    {
      "id": "50b80423-6a9f-4030-9a67-e3ce7b150ec7",
      "name": "Summarize Content",
      "type": "@n8n/n8n-nodes-langchain.informationExtractor",
      "position": [
        1536,
        -880
      ]
    },
    {
      "id": "305690dc-1997-4281-8821-3a61ddc8c95f",
      "name": "OpenAI Chat Model for Summarize Content",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        1600,
        -704
      ]
    },
    {
      "id": "2a6a5cb8-44b1-450b-9f05-79c088f86b1b",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        48,
        -1040
      ],
      "parameters": {
        "width": 656,
        "height": 848,
        "content": "\n\n"
      }
    },
    {
      "id": "56251a77-b7ba-404c-833f-c4f888a84734",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -992,
        -1248
      ],
      "parameters": {
        "width": 640,
        "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": "103c8fe6-8438-4a63-b3b0-55beaec93ce6",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -992,
        -944
      ],
      "parameters": {
        "width": 640,
        "height": 752,
        "content": "## **How It Works**\n\nThis workflow pulls daily Amazon price-drop data from a Decodo-scraped source, extracts structured product information, and then loops through each product to scrape its correspon"
      }
    },
    {
      "id": "6bb72b4f-2d2b-44cb-8ae8-1401067e0e8a",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        48,
        -1280
      ],
      "parameters": {
        "width": 656,
        "height": 224,
        "content": "## 1. Structured Data Extraction\n\nPerform a structured data extraction using the OpenAI gpt-4.1-mini. \n\n- Analyze and extract the structured data as per the Decodo Web Scraped Content. \n\n- Decodo’s ra"
      }
    },
    {
      "id": "b5361706-de8a-42d9-a96e-e8ac32c65b91",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        720,
        -1280
      ],
      "parameters": {
        "width": 1136,
        "height": 224,
        "content": "\n## 2.  Loop and Extract Data\n\nPerform Summarization & Sentiment Analysis with Decodo and OpenAI LLM. \n\n- Each product is processed individually using SplitOut + Batches. \n\n- For every item, the workf"
      }
    },
    {
      "id": "472decee-f819-4d84-9b0a-3caa01525c1a",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1872,
        -1280
      ],
      "parameters": {
        "width": 736,
        "height": 224,
        "content": "## 3. Output Data Handling \n\nMerge, Aggregate and output content to Google Speadsheet. \n\n- Results from summarization and sentiment analysis are merged and aggregated into a single dataset.\n- The work"
      }
    }
  ],
  "connections": {
    "Merge": {
      "main": [
        [
          {
            "node": "Aggregate",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Decodo": {
      "main": [
        [
          {
            "node": "Structure Data Extract Using LLM",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate": {
      "main": [
        [
          {
            "node": "Update Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "Decodo Loop Web Scraper",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set input fields": {
      "main": [
        [
          {
            "node": "Decodo",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Structure Data Extract Using LLM",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Summarize Content": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sentiment Analysis": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Update Google Sheets": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Decodo Loop Web Scraper": {
      "main": [
        [
          {
            "node": "Sentiment Analysis",
            "type": "main",
            "index": 0
          },
          {
            "node": "Summarize Content",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "Structure Data Extract Using LLM",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Structure Data Extract Using LLM": {
      "main": [
        [
          {
            "node": "Split Out",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Test workflow’": {
      "main": [
        [
          {
            "node": "Set input fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model for Summarize Content": {
      "ai_languageModel": [
        [
          {
            "node": "Summarize Content",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model for Sentiment Analysis": {
      "ai_languageModel": [
        [
          {
            "node": "Sentiment Analysis",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    }
  }
}