{
  "name": "Analyze Trustpilot & Sitejabber sentiment with Decodo + Gemini to sheets",
  "nodes": [
    {
      "id": "b3967ef3-95ea-4e07-b861-7375b1cb1027",
      "name": "Decodo Review Scraper",
      "type": "@decodo/n8n-nodes-decodo.decodoTool",
      "position": [
        3008,
        592
      ]
    },
    {
      "id": "395d0b28-b2ba-4d3b-bdf1-e0cb35eda325",
      "name": "Parse: Structured JSON Output",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        3248,
        592
      ]
    },
    {
      "id": "8321a7a0-7150-4733-a2bb-ac10034cde3e",
      "name": "LLM: Summarize & Recommendations",
      "type": "@n8n/n8n-nodes-langchain.googleGemini",
      "position": [
        3536,
        288
      ]
    },
    {
      "id": "5dd6eeb6-27a6-483d-a07a-7295544991b4",
      "name": "Merge: Business Data + Review Summary",
      "type": "n8n-nodes-base.merge",
      "position": [
        3888,
        368
      ]
    },
    {
      "id": "e07ad46f-92db-4a5c-adf5-34c52e01ced0",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1312,
        128
      ],
      "parameters": {
        "width": 800,
        "height": 736,
        "content": "## Analyze Trustpilot & Sitejabber sentiment with Decodo + Gemini to Sheets\n\nSign up for Decodo [HERE](https://visit.decodo.com/discount) for Discount\n\nThis template scrapes public reviews from **Trus"
      }
    },
    {
      "id": "ab87b014-b4a0-42a6-82fc-507de7676392",
      "name": "Trigger: Business Review Form",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        2304,
        368
      ]
    },
    {
      "id": "6225118a-a9d8-4cba-93b2-b66e3a063874",
      "name": "Set: Config Variables",
      "type": "n8n-nodes-base.set",
      "position": [
        2608,
        368
      ]
    },
    {
      "id": "75df53bb-75ef-4315-a94f-9c4665eb86bc",
      "name": "Agent: Business Review Scanner",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        2928,
        368
      ]
    },
    {
      "id": "276b185c-d39b-4b04-b590-07cbb6fc0153",
      "name": "Google Sheets: Append Results",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        4192,
        368
      ]
    },
    {
      "id": "cd647de7-742b-4f06-8080-c07aa88381c2",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2224,
        272
      ],
      "parameters": {
        "width": 256,
        "height": 320,
        "content": "Use one required field: Business Name or URL."
      }
    },
    {
      "id": "cfe0365e-9499-4398-ad67-16f3ad509c09",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2512,
        272
      ],
      "parameters": {
        "width": 288,
        "height": 320,
        "content": "Make sure to replace (YOUR_SPREADSHEET_ID) and (YOUR_SHEET_ID) with your own ID."
      }
    },
    {
      "id": "57a50323-5a6d-4ba1-9586-af416018aa6d",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2928,
        576
      ],
      "parameters": {
        "width": null,
        "height": 256,
        "content": "\n\n\n\n\n\n\n\n\n\n\n\nCommunity node; works on self-hosted n8n. Make sure to add your Decodo API credentials."
      }
    },
    {
      "id": "3cfcc791-c731-4c6f-acf9-a295584c013d",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3184,
        576
      ],
      "parameters": {
        "width": 224,
        "height": 256,
        "content": "\n\n\n\n\n\n\n\n\n\n\n\nKeep the provided schema. Output must be strictly flat JSON."
      }
    },
    {
      "id": "0df84067-d98a-44f1-948c-c1628dd0231d",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        4096,
        144
      ],
      "parameters": {
        "width": 304,
        "height": 400,
        "content": "Google Sheets columns for mapping (suggested)\n- business_name, \n- industry_field, \n- company_summary, \n- overall_sentiment,\n- summary_text,\n- trustpilot_url, \n- sitejabber_url"
      }
    },
    {
      "id": "3970e8f3-7873-4691-8ea7-12fb64b1d8eb",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2144,
        0
      ],
      "parameters": {
        "width": 480,
        "height": 96,
        "content": "> **Disclaimer:** This workflow relies on a **community Decodo node** and therefore requires **self-hosted n8n**. Install the node from the community marketplace and configure the Decodo API credentia"
      }
    },
    {
      "id": "4952fed2-fada-4908-b3af-1355eb45f6c2",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2144,
        128
      ],
      "parameters": {
        "width": 2288,
        "height": 736,
        "content": "## Analyze Business Reputation (Trustpilot + Sitejabber) with Gemini and Decodo\n\nSelf-hosted template using a community Decodo node. Scrapes reviews, produces flat JSON, summarizes with Gemini, and ap"
      }
    },
    {
      "id": "d2d1b267-1b21-473b-9ae7-1cda964b9ffc",
      "name": "AI Model: Google Gemini (Agent)",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        2800,
        656
      ]
    },
    {
      "id": "11ecf6e7-11c3-40ce-befa-2ddd98b17774",
      "name": "Set: Output Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        3280,
        368
      ]
    },
    {
      "id": "9069b871-8512-44d8-b5f0-899fc1012564",
      "name": "Sticky Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2752,
        -560
      ],
      "parameters": {
        "width": 1120,
        "height": 656,
        "content": "@[youtube](PDc0MwcicDQ)\n"
      }
    }
  ],
  "connections": {
    "Set: Output Fields": {
      "main": [
        [
          {
            "node": "LLM: Summarize & Recommendations",
            "type": "main",
            "index": 0
          },
          {
            "node": "Merge: Business Data + Review Summary",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Decodo Review Scraper": {
      "ai_tool": [
        [
          {
            "node": "Agent: Business Review Scanner",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Set: Config Variables": {
      "main": [
        [
          {
            "node": "Agent: Business Review Scanner",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Parse: Structured JSON Output": {
      "ai_outputParser": [
        [
          {
            "node": "Agent: Business Review Scanner",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Trigger: Business Review Form": {
      "main": [
        [
          {
            "node": "Set: Config Variables",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Agent: Business Review Scanner": {
      "main": [
        [
          {
            "node": "Set: Output Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Model: Google Gemini (Agent)": {
      "ai_languageModel": [
        [
          {
            "node": "Agent: Business Review Scanner",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "LLM: Summarize & Recommendations": {
      "main": [
        [
          {
            "node": "Merge: Business Data + Review Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge: Business Data + Review Summary": {
      "main": [
        [
          {
            "node": "Google Sheets: Append Results",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}