8
n8n 中文网amn8n.com

使用 BrowserAct 和 Gemini 查找并筛选有资金支持的线索

高级

这是一个Lead Generation, AI Chatbot领域的自动化工作流,包含 29 个节点。主要使用 If, Code, Merge, Slack, GoogleSheets 等节点。 通过 BrowserAct 和 Gemini 查找并筛选有资金支持的潜在客户

前置要求
  • Slack Bot Token 或 Webhook URL
  • Google Sheets API 凭证
  • Google Gemini API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "fYXLwI3aVDFdE0wC",
  "meta": {
    "instanceId": "88804d8e264d231c18413147cc92e4245b20ae7b97d774bad847556f645c8192",
    "templateCredsSetupCompleted": true
  },
  "name": "使用 BrowserAct 和 Gemini 查找并筛选有资金支持的线索",
  "tags": [],
  "nodes": [
    {
      "id": "bb4a70a6-7f90-4bc5-9987-cb61ce23eeb4",
      "name": "当点击“执行工作流”时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -1216,
        -160
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "7f473184-db91-4a3d-b95a-a8a7f5709464",
      "name": "AI 代理",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        16,
        -192
      ],
      "parameters": {
        "text": "=inside the \n{{ $json.output.string }}\nyou can find list of map each map contains \n{\n\"Url\" : \"<String>\",\n\"Article\" : \"<String>\",\n}\n\nfrom the \"Article\" 'Key',\nAnalyze the 'value' text. The goal is to identify the companies that has just announced a new round of funding. return list of maps add the company name as \"Company\" and the obeject or field they funding on as \"InvestedOn\" and url as \"Url\" for each map, nothing else. If no company is found, return {\n\"Url\" : \"No Company\",\n\"InvestedOn\" : \"No Company\",\n\"Article\" : \"No Company\",\n}.",
        "options": {},
        "promptType": "define",
        "hasOutputParser": true
      },
      "typeVersion": 2.2
    },
    {
      "id": "9b74c5e1-a08f-460d-9b10-ab16f3249e97",
      "name": "JavaScript 代码",
      "type": "n8n-nodes-base.code",
      "position": [
        416,
        -176
      ],
      "parameters": {
        "jsCode": "// Get the original list from the 'Request' key in the incoming data.\nconst originalList = $input.first().json.output\n\n// Create a new array to store the formatted output.\nconst outputItems = [];\n\n// Loop through each item in the original list.\nfor (const item of originalList) {\n  // For each item, create a new object in the desired format.\n  outputItems.push({\n    json: {\n      \"text\": item\n    }\n  });\n}\n\n// Return the new list of formatted objects.\nreturn outputItems;"
      },
      "typeVersion": 2
    },
    {
      "id": "73a62b5c-a427-49de-845f-e47caaf209fc",
      "name": "在表格中追加或更新行",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        864,
        -160
      ],
      "parameters": {
        "columns": {
          "value": {
            "Url": "={{ $json.text.Url }}",
            "Company": "={{ $json.text.Company }}",
            "InvestedOn": "={{ $json.text.InvestedOn }}"
          },
          "schema": [
            {
              "id": "Company",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Company",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "InvestedOn",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "InvestedOn",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Url",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Url",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Company"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/18sw7io0yJOTDzvcknGmjBBqtK154CLk3k0FoWJZbfI0/edit#gid=0",
          "cachedResultName": "Funding Announcement to Lead List (TechCrunch)"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "18sw7io0yJOTDzvcknGmjBBqtK154CLk3k0FoWJZbfI0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/18sw7io0yJOTDzvcknGmjBBqtK154CLk3k0FoWJZbfI0/edit?usp=drivesdk",
          "cachedResultName": "Test For BrowserAct"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "wAMAqU43zjVjlpuA",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "e5d22fa9-4427-4fe4-be39-332a4dfb6a65",
      "name": "结构化输出",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        160,
        -16
      ],
      "parameters": {
        "jsonSchemaExample": "[\n{\n\"Company\" : \"<String>\",\n\"InvestedOn\" : \"<String>\",\n\"Url\" : \"<String>\"\n}\n]"
      },
      "typeVersion": 1.3
    },
    {
      "id": "38d75f68-ff2c-4a7e-b303-82fc9bf72c96",
      "name": "如果",
      "type": "n8n-nodes-base.if",
      "position": [
        608,
        -176
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "or",
          "conditions": [
            {
              "id": "8ed8fa5e-b99d-413b-8ebf-9e6889dff048",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json.text.Company }}",
              "rightValue": "No Company"
            },
            {
              "id": "9f2b2289-a395-4b37-acab-0de3e5d69dc9",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json.text.Url }}",
              "rightValue": "No Company"
            },
            {
              "id": "144bcc7a-0c4b-43f5-a08a-1758208ff915",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json.text.InvestedOn }}",
              "rightValue": "No Company"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "22543947-09a6-4368-860a-3775743e3445",
      "name": "便签 - 介绍",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -752,
        112
      ],
      "parameters": {
        "width": 592,
        "height": 434,
        "content": "## 试试看!"
      },
      "typeVersion": 1
    },
    {
      "id": "87bc8c36-7466-48a2-b8b6-a33bc4e031c6",
      "name": "便签 - 如何使用",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -144,
        112
      ],
      "parameters": {
        "width": 496,
        "height": 216,
        "content": "## 使用方法"
      },
      "typeVersion": 1
    },
    {
      "id": "f75b58a0-ba8c-46bf-9d61-f90cbf9024e6",
      "name": "便签 - 需要帮助",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -144,
        336
      ],
      "parameters": {
        "width": 496,
        "height": 200,
        "content": "## 需要帮助?"
      },
      "typeVersion": 1
    },
    {
      "id": "024ba7a1-8ff1-4815-b4c5-65fb8f0245f3",
      "name": "便签 - 输出阶段",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        784,
        -400
      ],
      "parameters": {
        "color": 3,
        "width": 448,
        "height": 176,
        "content": "### 💾 4. 保存到 Google Sheets 并发送通知"
      },
      "typeVersion": 1
    },
    {
      "id": "05473d4d-938c-4e27-b615-35b7202f4f66",
      "name": "便签 - 处理阶段",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        368,
        -400
      ],
      "parameters": {
        "color": 6,
        "width": 400,
        "height": 180,
        "content": "### 🧹 3. 转换与筛选"
      },
      "typeVersion": 1
    },
    {
      "id": "2df834d8-32e4-46d9-a854-3239df83c9a6",
      "name": "便签 - AI 阶段",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -144,
        -400
      ],
      "parameters": {
        "color": 4,
        "width": 496,
        "height": 172,
        "content": "### 🧠 2. AI 分析核心"
      },
      "typeVersion": 1
    },
    {
      "id": "79581880-83f3-4686-b327-83ddf5315205",
      "name": "便签 - 抓取阶段",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -752,
        -496
      ],
      "parameters": {
        "color": 5,
        "width": 480,
        "height": 196,
        "content": "### 🌐 1. 抓取与等待"
      },
      "typeVersion": 1
    },
    {
      "id": "38e99a9b-927f-46b4-8050-3b0e387f59db",
      "name": "Gemini l",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        16,
        -16
      ],
      "parameters": {
        "options": {}
      },
      "credentials": {
        "googlePalmApi": {
          "id": "U1olizkBYhp4g9AB",
          "name": "Google Gemini(PaLM) Api account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "24440061-f540-4e26-af91-a13d950ab1b7",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        784,
        -208
      ],
      "parameters": {
        "color": 3,
        "width": 448,
        "height": 192,
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "2139aa00-a434-4760-807a-00abf300b0f8",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        368,
        -208
      ],
      "parameters": {
        "color": 6,
        "width": 400,
        "height": 192,
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "eb9c03d6-56f5-401a-8408-77712d051f0d",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -752,
        -80
      ],
      "parameters": {
        "color": 5,
        "width": 480,
        "height": 176,
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "bc1c9245-2d9a-4bf8-9973-27207218a744",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -144,
        -208
      ],
      "parameters": {
        "color": 4,
        "width": 496,
        "height": 304,
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "b4c28f6b-c618-4514-80f7-136963f37afa",
      "name": "发送消息",
      "type": "n8n-nodes-base.slack",
      "position": [
        1072,
        -160
      ],
      "webhookId": "3ebad1e3-67ce-4981-9fba-7d5bc60d2ae4",
      "parameters": {
        "text": "The data for the lead announcement has been updated",
        "select": "channel",
        "channelId": {
          "__rl": true,
          "mode": "list",
          "value": "C09KLV9DJSX",
          "cachedResultName": "all-browseract-workflow-test"
        },
        "otherOptions": {},
        "authentication": "oAuth2"
      },
      "credentials": {
        "slackOAuth2Api": {
          "id": "5rQCkyObBqbHIbZA",
          "name": "Slack account"
        }
      },
      "typeVersion": 2.3
    },
    {
      "id": "ff0919c6-2c38-4c11-aba8-4d3afe0e5bf6",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -752,
        -288
      ],
      "parameters": {
        "color": 5,
        "width": 480,
        "height": 192,
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c289a817-c7e7-4bef-9a6b-20c4854acdd5",
      "name": "合并",
      "type": "n8n-nodes-base.merge",
      "position": [
        -256,
        -160
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "07c0a4e8-0cda-4015-9375-525e5afeed37",
      "name": "获取工作表中的行",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1072,
        -160
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1170369249,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/18sw7io0yJOTDzvcknGmjBBqtK154CLk3k0FoWJZbfI0/edit#gid=1170369249",
          "cachedResultName": "Keywords For Funding Announcement to Lead List (TechCrunch) "
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "18sw7io0yJOTDzvcknGmjBBqtK154CLk3k0FoWJZbfI0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/18sw7io0yJOTDzvcknGmjBBqtK154CLk3k0FoWJZbfI0/edit?usp=drivesdk",
          "cachedResultName": "Test For BrowserAct"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "wAMAqU43zjVjlpuA",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "135d1765-f6d4-47b5-8904-fe3ee2625ea0",
      "name": "遍历项目",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -896,
        -160
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "efef17c0-4be1-4fed-903c-d98784e55b88",
      "name": "运行工作流 Series 2",
      "type": "n8n-nodes-browseract-workflows.browserAct",
      "position": [
        -672,
        -256
      ],
      "parameters": {
        "workflowId": "56655803760865399",
        "inputParameters": {
          "parameters": [
            {
              "name": "KeyWord",
              "value": "={{ $json[\"keyword Series B\"] }}"
            },
            {
              "name": "Location",
              "value": "={{ $json.Geo }}"
            }
          ]
        },
        "additionalFields": {
          "saveBrowserData": false
        }
      },
      "credentials": {
        "browserActApi": {
          "id": "AzKMhR2eAlOjzDiJ",
          "name": "BrowserAct account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "fbc96d3b-e6e3-4c78-aaee-954c50f59c6d",
      "name": "运行工作流 Series 1",
      "type": "n8n-nodes-browseract-workflows.browserAct",
      "position": [
        -672,
        -64
      ],
      "parameters": {
        "workflowId": "56655803760865399",
        "inputParameters": {
          "parameters": [
            {
              "name": "KeyWord",
              "value": "={{ $json[\"keyword Series A\"] }}"
            },
            {
              "name": "Location",
              "value": "={{ $json.Geo }}"
            }
          ]
        },
        "additionalFields": {
          "saveBrowserData": false
        }
      },
      "credentials": {
        "browserActApi": {
          "id": "AzKMhR2eAlOjzDiJ",
          "name": "BrowserAct account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "acb20c51-7d76-43af-838b-40dea11c9449",
      "name": "获取工作流 Series 2",
      "type": "n8n-nodes-browseract-workflows.browserAct",
      "position": [
        -480,
        -256
      ],
      "parameters": {
        "taskId": "={{ $json.id }}",
        "operation": "getTask",
        "maxWaitTime": 900,
        "waitForFinish": true,
        "pollingInterval": 30
      },
      "credentials": {
        "browserActApi": {
          "id": "AzKMhR2eAlOjzDiJ",
          "name": "BrowserAct account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "6d1c8952-55b2-4e83-bd18-b1f6fc9e1d29",
      "name": "获取工作流 Series1",
      "type": "n8n-nodes-browseract-workflows.browserAct",
      "position": [
        -480,
        -64
      ],
      "parameters": {
        "taskId": "={{ $json.id }}",
        "operation": "getTask",
        "maxWaitTime": 900,
        "waitForFinish": true,
        "pollingInterval": 30
      },
      "credentials": {
        "browserActApi": {
          "id": "AzKMhR2eAlOjzDiJ",
          "name": "BrowserAct account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "ae207264-ad23-481a-9012-13962cb28e3a",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1088,
        -288
      ],
      "parameters": {
        "color": 7,
        "width": 320,
        "height": 96,
        "content": "### 👆🏻 0. 获取输入数据"
      },
      "typeVersion": 1
    },
    {
      "id": "e09458f1-4d37-4049-8bec-47003dd7b0be",
      "name": "### 需要帮助?",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1088,
        -176
      ],
      "parameters": {
        "color": 7,
        "width": 320,
        "height": 208,
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "c70fd885-47d1-4746-9349-ce2bb6386127",
  "connections": {
    "If": {
      "main": [
        [],
        [
          {
            "node": "Append or update row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Agent": {
      "main": [
        [
          {
            "node": "Code in JavaScript",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Gemini l": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Send a message": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "Run a workflow Series 1",
            "type": "main",
            "index": 0
          },
          {
            "node": "Run a workflow Series 2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output": {
      "ai_outputParser": [
        [
          {
            "node": "AI Agent",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Code in JavaScript": {
      "main": [
        [
          {
            "node": "If",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get workflow Series1": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Get workflow Series 2": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Run a workflow Series 1": {
      "main": [
        [
          {
            "node": "Get workflow Series1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Run a workflow Series 2": {
      "main": [
        [
          {
            "node": "Get workflow Series 2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Append or update row in sheet": {
      "main": [
        [
          {
            "node": "Send a message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Get row(s) in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景?

高级 - 潜在客户开发, AI 聊天机器人

需要付费吗?

本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。

工作流信息
难度等级
高级
节点数量29
分类2
节点类型12
难度说明

适合高级用户,包含 16+ 个节点的复杂工作流

作者
Madame AI Team | Kai

Madame AI Team | Kai

@madame-ai

I’m a PhD in Physics turned AI enthusiast, passionate about uncovering how AI is transforming content creation, business, and daily life.

外部链接
在 n8n.io 查看

分享此工作流