使用Decodo和Gemini分析Trustpilot和Sitejabber情感并保存到Sheets

• •Google Sheets API 凭证
• •Google Gemini API Key

{
  "meta": {
    "instanceId": "689fa22e68cd4198e4ae37f3cc44f498087edd235a867e22515be823bab694c7",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "f5101b6f-36d6-480e-9463-bda69f3d7c57",
      "name": "Decodo 评论抓取器",
      "type": "@decodo/n8n-nodes-decodo.decodoTool",
      "position": [
        864,
        592
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "22fe7960-a78f-4180-884c-3e48c2d07b1c",
      "name": "解析：结构化 JSON 输出",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        1104,
        592
      ],
      "parameters": {
        "jsonSchemaExample": "{\n  \"business_name\": \"Shein\",\n  \"industry_field\": \"Online Fast Fashion Retail\",\n  \"company_summary\": \"Shein is a global e-commerce fashion brand offering low-cost clothing and accessories, primarily targeting young consumers worldwide.\",\n  \"trustpilot_reviews\": [\n    { \"rating\": \"4/5\", \"summary\": \"Customers like the variety and prices but complain about slow shipping.\" },\n    { \"rating\": \"3/5\", \"summary\": \"Quality can be inconsistent but returns are easy.\" }\n  ],\n  \"sitejabber_reviews\": [\n    { \"rating\": \"3.5/5\", \"summary\": \"Affordable fashion but poor customer service response times.\" },\n    { \"rating\": \"4/5\", \"summary\": \"Trendy products and frequent restocks are appreciated.\" }\n  ],\n  \"overall_sentiment\": \"Positive\",\n  \"source_links\": {\n    \"trustpilot\": \"https://www.trustpilot.com/review/shein.com\",\n    \"sitejabber\": \"https://www.sitejabber.com/reviews/shein.com\"\n  }\n}"
      },
      "typeVersion": 1.3
    },
    {
      "id": "9afa03aa-e1a3-4e94-8f59-293864618877",
      "name": "LLM：总结与建议",
      "type": "@n8n/n8n-nodes-langchain.googleGemini",
      "position": [
        1392,
        288
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "models/gemini-2.5-flash",
          "cachedResultName": "models/gemini-2.5-flash"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "content": "=Analyze this business reviews, if there is no review from one of the website, add a message \"There's no data in this website\"\nTrustpilot: {{ $json.output.trustpilot_reviews.toJsonString() }}\nSitejabber: {{ $json.output.sitejabber_reviews.toJsonString() }}\nResellerratings: {{ $json.output.resellerratings_reviews.toJsonString() }}\n\nGive conclusion, what to improve and overall aspect."
            }
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "cf73f7df-2221-46cd-9645-15f830794ba3",
      "name": "合并：业务数据 + 评论总结",
      "type": "n8n-nodes-base.merge",
      "position": [
        1744,
        368
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "combineBy": "combineByPosition"
      },
      "typeVersion": 3.2
    },
    {
      "id": "63733be1-ccb2-45ea-b2b4-8d2e71bbf994",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -832,
        128
      ],
      "parameters": {
        "width": 800,
        "height": 736,
        "content": "## 使用 Decodo + Gemini 分析 Trustpilot 和 Sitejabber 情感并导入 Sheets"
      },
      "typeVersion": 1
    },
    {
      "id": "1d45e9cc-5f15-4743-a08c-70853e0ef3de",
      "name": "触发器：企业评论表单",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        160,
        368
      ],
      "webhookId": "f8b58317-b57a-4db3-ab23-7304f9b64883",
      "parameters": {
        "options": {},
        "formTitle": "Business Review Lookup",
        "formFields": {
          "values": [
            {
              "fieldLabel": "Business Name or URL",
              "requiredField": true
            }
          ]
        }
      },
      "typeVersion": 2.3
    },
    {
      "id": "df9d8bb9-5c30-4ab6-905c-2b14c7e28f06",
      "name": "设置：配置变量",
      "type": "n8n-nodes-base.set",
      "position": [
        464,
        368
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "b9f1e501-0234-4d32-a7ba-8287c5d3f80e",
              "name": "business_name",
              "type": "string",
              "value": "={{ $json['Business Name or URL'] }}"
            },
            {
              "id": "5f681a78-395f-4ff8-b56a-2d31d425ee15",
              "name": "=chatInput",
              "type": "string",
              "value": "=I’d like to know more about the business reputation of {{ $json['Business Name'] }}. Please summarize the company profile and collect recent customer reviews"
            },
            {
              "id": "30674f1c-a98f-4af8-b560-f8ac00fcf345",
              "name": "spreadsheet_id",
              "type": "string",
              "value": "(YOUR_SPREADSHEET_ID)"
            },
            {
              "id": "5e34efe2-8eff-4f67-a516-83ddc89c79e1",
              "name": "sheet_id",
              "type": "string",
              "value": "(YOUR_SHEET_ID)"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "cf8384fd-1f4d-4d95-b421-bca4786e7dbb",
      "name": "代理：企业评论扫描器",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        784,
        368
      ],
      "parameters": {
        "options": {
          "systemMessage": "=# System Message — Business Review Scanner Agent (Structured JSON Version)\n\nYou are a Business Review Scanner Agent, an intelligent assistant specialized in analyzing and summarizing customer reviews for a specific business.\n\nYour goal is to collect data and generate structured JSON output that can be directly stored in spreadsheets or databases.\n\n---\n\n## Tools\n\nDecodo Tool — used for scraping and extracting reviews only from:\n\n- Trustpilot\n- Sitejabber\n\n---\n\n## Task Description\n\nWhen the user provides a business name, you must:\n\n1. Scrape and extract available company details and reviews from the sources above.\n2. Analyze the company profile, recent customer sentiment, and summarize the key points.\n3. Return a clean, valid JSON object using the format described below.\n\n---\n\n## Output Rules\n\n1. The output must be strictly JSON (no markdown, no text outside `{}`).\n2. JSON must be flat and machine-readable, ideal for spreadsheets or database import.\n3. If a source (Trustpilot, Sitejabber, or ResellerRatings) is missing, leave the corresponding field with \"Data not found\".\n4. Include no more than 10 summarized reviews per source.\n5. Do not include raw HTML, emojis, or extra text.\n6. All fields are required — if unavailable, set the value as `null` or empty string.\n\n## Required JSON Structure\n{\n  \"business_name\": \"string\",\n  \"industry_field\": \"string\",\n  \"company_summary\": \"string\",\n  \"trustpilot_reviews\": [\n    {\n      \"rating\": \"number or string\",\n      \"summary\": \"string\"\n    }\n  ],\n  \"sitejabber_reviews\": [\n    {\n      \"rating\": \"number or string\",\n      \"summary\": \"string\"\n    }\n  ],\n  \"overall_sentiment\": \"Positive | Negative\",\n  \"source_links\": {\n    \"trustpilot\": \"string\",\n    \"sitejabber\": \"string\",\n    \"resellerratings\": \"string\"\n  }\n}\n"
        },
        "hasOutputParser": true
      },
      "typeVersion": 2.2
    },
    {
      "id": "14ed0056-9c18-41af-a42b-286ad88f1b9f",
      "name": "Google Sheets：附加结果",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2048,
        368
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "id",
          "value": "={{ $('Set: Config Variables').item.json.sheet_id }}"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "={{ $('Set: Config Variables').item.json.spreadsheet_id }}"
        }
      },
      "executeOnce": false,
      "typeVersion": 4.7
    },
    {
      "id": "a9747161-faff-481c-9f77-d2e3da185da0",
      "name": "便签 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        80,
        272
      ],
      "parameters": {
        "color": 5,
        "width": 256,
        "height": 320,
        "content": "使用一个必需字段：企业名称或 URL。"
      },
      "typeVersion": 1
    },
    {
      "id": "462eaf9a-ae9e-4034-a3c2-69ff37464f59",
      "name": "便签 3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        368,
        272
      ],
      "parameters": {
        "color": 5,
        "width": 288,
        "height": 320,
        "content": "确保将 (YOUR_SPREADSHEET_ID) 和 (YOUR_SHEET_ID) 替换为您自己的 ID。"
      },
      "typeVersion": 1
    },
    {
      "id": "b3d9e8bb-2807-4002-a4db-4081ea2b15a0",
      "name": "便签 4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        784,
        576
      ],
      "parameters": {
        "color": 3,
        "height": 256,
        "content": "社区节点；适用于自托管 n8n。确保添加您的 Decodo API 凭证。"
      },
      "typeVersion": 1
    },
    {
      "id": "bf88c1e3-4eaa-4cd5-8d87-4ef2bcef8cc5",
      "name": "便签 5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1040,
        576
      ],
      "parameters": {
        "color": 3,
        "width": 224,
        "height": 256,
        "content": "保持提供的架构。输出必须是严格的扁平 JSON。"
      },
      "typeVersion": 1
    },
    {
      "id": "642453e8-354f-4bc8-9653-0e1d6958579f",
      "name": "便签6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1952,
        144
      ],
      "parameters": {
        "color": 5,
        "width": 304,
        "height": 400,
        "content": "Google Sheets 列映射建议"
      },
      "typeVersion": 1
    },
    {
      "id": "de54cc4b-1674-4642-94d0-7d1633d6437f",
      "name": "便签 1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "color": 3,
        "width": 480,
        "height": 96,
        "content": "> **免责声明：** 此工作流依赖**社区 Decodo 节点**，因此需要**自托管 n8n**。从社区市场安装节点并配置 Decodo API 凭证。"
      },
      "typeVersion": 1
    },
    {
      "id": "3bf1fcb6-d7fc-4535-8bad-623f6c94b29c",
      "name": "便签7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        128
      ],
      "parameters": {
        "color": 4,
        "width": 2288,
        "height": 736,
        "content": "## 使用 Gemini 和 Decodo 分析企业声誉（Trustpilot + Sitejabber）"
      },
      "typeVersion": 1
    },
    {
      "id": "f242c6fd-079b-41f0-9797-1b153f9a6671",
      "name": "AI 模型：Google Gemini（代理）",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        656,
        656
      ],
      "parameters": {
        "options": {},
        "modelName": "models/gemini-2.5-pro"
      },
      "typeVersion": 1
    },
    {
      "id": "4490602f-a6be-4f8e-b60c-54d263093af4",
      "name": "设置：输出字段",
      "type": "n8n-nodes-base.set",
      "position": [
        1136,
        368
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "5fd2f317-d25e-478c-a013-37cf49f68170",
              "name": "output.business_name",
              "type": "string",
              "value": "={{ $json.output.business_name }}"
            },
            {
              "id": "b643e944-69f2-4a30-b5ed-4cd21d225d14",
              "name": "output.industry_field",
              "type": "string",
              "value": "={{ $json.output.industry_field }}"
            },
            {
              "id": "767fa26e-2227-4a2f-92fd-ee5946c9ef75",
              "name": "output.company_summary",
              "type": "string",
              "value": "={{ $json.output.company_summary }}"
            },
            {
              "id": "c4b6165b-c697-41d1-a0e2-7980d1ce1d66",
              "name": "output.trustpilot_reviews",
              "type": "array",
              "value": "={{ $json.output.trustpilot_reviews }}"
            },
            {
              "id": "5ce03ddd-cfc2-4c1e-9f63-17af186e654e",
              "name": "output.sitejabber_reviews",
              "type": "array",
              "value": "={{ $json.output.sitejabber_reviews }}"
            },
            {
              "id": "17713d7e-4434-4897-8fc5-d6fdaf0acf13",
              "name": "output.overall_sentiment",
              "type": "string",
              "value": "={{ $json.output.overall_sentiment }}"
            },
            {
              "id": "0e570aa8-b046-48f1-a1c1-28cb598a136b",
              "name": "output.source_links",
              "type": "object",
              "value": "={{ $json.output.source_links }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    }
  ],
  "pinData": {},
  "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
          }
        ]
      ]
    }
  }
}