{
  "name": "Automated product review monitoring with sentiment analysis via Decodo, Gemini & Telegram",
  "nodes": [
    {
      "id": "877584c6-ca5f-418e-bfa3-4dbf9eba9ea7",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -320,
        0
      ]
    },
    {
      "id": "7bf5bbc7-65cd-445e-9075-457945ec5bfd",
      "name": "Decodo",
      "type": "@decodo/n8n-nodes-decodo.decodo",
      "position": [
        384,
        16
      ]
    },
    {
      "id": "00a28249-c90d-4532-866c-0e1eaf23784f",
      "name": "Get row(s) in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -80,
        0
      ]
    },
    {
      "id": "9e5e3fdd-0e01-43ce-a576-9ad31f817355",
      "name": "Google Gemini Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        720,
        272
      ]
    },
    {
      "id": "93845a3b-96ef-4f77-8456-1ef88d868fb8",
      "name": "Code in JavaScript",
      "type": "n8n-nodes-base.code",
      "position": [
        592,
        16
      ]
    },
    {
      "id": "3ad0d98e-1e81-410c-a821-448bd4ecac45",
      "name": "Summarize Reviews",
      "type": "@n8n/n8n-nodes-langchain.chainSummarization",
      "position": [
        1168,
        80
      ]
    },
    {
      "id": "07a0197d-94e2-4016-ab72-d51b9e15414f",
      "name": "Alert Group",
      "type": "n8n-nodes-base.telegram",
      "position": [
        1504,
        96
      ]
    },
    {
      "id": "f027e9fa-8bf9-4f4a-a702-abecf6f472f2",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        144,
        0
      ]
    },
    {
      "id": "802c3000-3e37-40a5-b7a6-cffefaa4600c",
      "name": "Store to Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1456,
        -272
      ]
    },
    {
      "id": "6a4a0040-617d-45e4-ad41-2152343eab93",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -608,
        -640
      ],
      "parameters": {
        "width": 624,
        "height": 608,
        "content": "## Automated Review Monitoring with Decodo, Google Sheets, Gemini AI & Telegram Alerts\n\nGreat For:\n• E-commerce owners\n• Product managers\n• Reputation & CX teams\n• Amazon/Marketplace sellers\n• Anyone "
      }
    },
    {
      "id": "1cf7d274-422d-4b0b-bfe3-7d8c7fda7361",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -192,
        208
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": "## Google Sheets\n\n• Keep one URL per row\n• Ensure Sheet permissions allow n8n access"
      }
    },
    {
      "id": "3e2de6e1-0de2-4d49-a234-eb116671c452",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        256,
        -400
      ],
      "parameters": {
        "width": 304,
        "height": 240,
        "content": "### Decodo \n\nWhat it does:\nScrapes Amazon product reviews based on the given URL.\n\nOutput:\nStructured JSON with reviewer name, rating, and review content."
      }
    },
    {
      "id": "69ba32f1-844e-4dc2-ab59-4795df6d1219",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        640,
        -400
      ],
      "parameters": {
        "width": 304,
        "height": 240,
        "content": "### Javascript\n\ntransforms Decodo’s raw JSON into simple text blocks of:\n<author> – <rating> – <content>\n\nResult:\nA clean, multi-line text string ready for sentiment + summarization."
      }
    },
    {
      "id": "5742938e-b6ad-4d65-8d4d-4bacfb144be7",
      "name": "Sentiment Analyzer",
      "type": "@n8n/n8n-nodes-langchain.sentimentAnalysis",
      "position": [
        800,
        -16
      ]
    },
    {
      "id": "323a388b-a7f8-40a5-b99a-d46690a6dd79",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1408,
        -544
      ],
      "parameters": {
        "width": 304,
        "height": 240,
        "content": "Saves a new record into the “user review aggregations” sheet.\n\nStored fields:\n• Cleaned review text\n• Sentiment\n• Product URL\n\nPurpose:\nCreates a historical review database you can analyze anytime."
      }
    }
  ],
  "connections": {
    "Decodo": {
      "main": [
        [
          {
            "node": "Code in JavaScript",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Alert Group": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Store to Sheet": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "Decodo",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get row(s) in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Summarize Reviews": {
      "main": [
        [
          {
            "node": "Alert Group",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code in JavaScript": {
      "main": [
        [
          {
            "node": "Sentiment Analyzer",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sentiment Analyzer": {
      "main": [
        [
          {
            "node": "Store to Sheet",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Summarize Reviews",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Summarize Reviews",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Gemini Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Sentiment Analyzer",
            "type": "ai_languageModel",
            "index": 0
          },
          {
            "node": "Summarize Reviews",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    }
  }
}