8
n8n 中文网amn8n.com

通过 Decodo + Google Gemini 实现自动化 LinkedIn 人才分析与摘要

中级

这是一个自动化工作流,包含 13 个节点。主要使用 Set, Code, Merge, GoogleSheets, ManualTrigger 等节点。 使用 Decodo、Gemini 和 Google Sheets 自动化 LinkedIn 人才画像与摘要

前置要求
  • Google Sheets API 凭证
  • Google Gemini API Key

分类

-
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "xJoEWpZRp13AAMki",
  "meta": {
    "instanceId": "885b4fb4a6a9c2cb5621429a7b972df0d05bb724c20ac7dac7171b62f1c7ef40",
    "templateCredsSetupCompleted": true
  },
  "name": "通过 Decodo + Google Gemini 实现自动化 LinkedIn 人才分析与摘要",
  "tags": [
    {
      "id": "ddPkw7Hg5dZhQu2w",
      "name": "AI",
      "createdAt": "2025-04-13T05:38:08.053Z",
      "updatedAt": "2025-04-13T05:38:08.053Z"
    },
    {
      "id": "ZOwtAMLepQaGW76t",
      "name": "Building Blocks",
      "createdAt": "2025-04-13T15:23:40.462Z",
      "updatedAt": "2025-04-13T15:23:40.462Z"
    },
    {
      "id": "Kujft2FOjmOVQAmJ",
      "name": "Engineering",
      "createdAt": "2025-04-09T01:31:00.558Z",
      "updatedAt": "2025-04-09T01:31:00.558Z"
    },
    {
      "id": "rKOa98eAi3IETrLu",
      "name": "HR",
      "createdAt": "2025-04-13T04:59:30.580Z",
      "updatedAt": "2025-04-13T04:59:30.580Z"
    }
  ],
  "nodes": [
    {
      "id": "4034ac8c-2f0b-492b-a59d-be1019d722f5",
      "name": "当点击\"执行工作流\"时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -800,
        -64
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "ce250b96-1d0f-45d6-941b-3ab1fcb5c533",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -800,
        112
      ],
      "parameters": {
        "width": 496,
        "height": 496,
        "content": "## 目的"
      },
      "typeVersion": 1
    },
    {
      "id": "98e14b64-f6c3-44cf-837f-8f220c282f47",
      "name": "Decodo",
      "type": "@decodo/n8n-nodes-decodo.decodo",
      "position": [
        -304,
        -64
      ],
      "parameters": {
        "geo": "={{ $json.geo }}",
        "url": "={{ $json.url }}"
      },
      "credentials": {
        "decodoApi": {
          "id": "7xLvINFuwxDiyBde",
          "name": "Decodo Credentials account"
        }
      },
      "retryOnFail": true,
      "typeVersion": 1
    },
    {
      "id": "3db7159a-dad0-43ab-bd29-2e08191a3457",
      "name": "设置输入字段",
      "type": "n8n-nodes-base.set",
      "position": [
        -544,
        -64
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "01a2dade-6674-4158-8303-97a1151d3965",
              "name": "url",
              "type": "string",
              "value": "https://www.linkedin.com/in/ranjan-dailata/"
            },
            {
              "id": "82a8ccde-dc3c-4ed1-b81e-bbcf44a2cf11",
              "name": "geo",
              "type": "string",
              "value": "India"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "5b443a66-7913-49f4-89c9-8a58ef762372",
      "name": "结构化数据提取器",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        80,
        -224
      ],
      "parameters": {
        "text": "=Parse and Extract the following content  {{ $json.data.results[0].content }} in JSON Resume Schema",
        "batching": {},
        "messages": {
          "messageValues": [
            {
              "message": "You are an expert resume parser"
            }
          ]
        },
        "promptType": "define"
      },
      "retryOnFail": true,
      "typeVersion": 1.7,
      "alwaysOutputData": true
    },
    {
      "id": "5ed28ee3-0cbf-42c4-be64-d9aecb8314d6",
      "name": "提取 JSON",
      "type": "n8n-nodes-base.code",
      "position": [
        528,
        -224
      ],
      "parameters": {
        "jsCode": "let text =  $input.first().json.text;\nconst output = [];\n\n// Remove ```json ... ``` or ``` ... ``` wrappers\ntext = text\n      .replace(/```json\\s*/gi, '')\n      .replace(/```/g, '')\n      .trim();\n\n// Parse the cleaned JSON text\nconst parsed = JSON.parse(text);\noutput.push({ json: parsed });\n\nreturn output;"
      },
      "typeVersion": 2
    },
    {
      "id": "1cf7ad6b-473b-44b8-9fd7-f1107039c68e",
      "name": "总结内容",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        80,
        112
      ],
      "parameters": {
        "text": "=Analyze and Summarize the {{ $json.data.results[0].content }}\n\nDo not output your own thoughts or suggestions or recommendations. Instead, just output the summary.",
        "batching": {},
        "messages": {
          "messageValues": [
            {
              "message": "You are an expert summarizer"
            }
          ]
        },
        "promptType": "define"
      },
      "retryOnFail": true,
      "typeVersion": 1.7,
      "alwaysOutputData": true
    },
    {
      "id": "65825d65-86d5-42c5-818f-747b35407d58",
      "name": "用于摘要的 Google Gemini 聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        80,
        272
      ],
      "parameters": {
        "options": {},
        "modelName": "models/gemini-2.0-flash-exp"
      },
      "credentials": {
        "googlePalmApi": {
          "id": "YeO7dHZnuGBVQKVZ",
          "name": "Google Gemini(PaLM) Api account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "3a39ce1a-9f66-425b-8c49-b22e4aae1afe",
      "name": "用于结构化数据的 Google Gemini 聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        80,
        -64
      ],
      "parameters": {
        "options": {},
        "modelName": "models/gemini-2.0-flash-exp"
      },
      "credentials": {
        "googlePalmApi": {
          "id": "YeO7dHZnuGBVQKVZ",
          "name": "Google Gemini(PaLM) Api account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "420ca142-d1a2-4196-acab-1780b893c385",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -800,
        -336
      ],
      "parameters": {
        "color": 7,
        "width": 384,
        "height": 208,
        "content": "![Logo](https://cdn.brandfetch.io/idIeG9_eXK/w/100/h/100/theme/dark/icon.jpeg?c=1bxid64Mup7aczewSAYMX&t=1756483136894)"
      },
      "typeVersion": 1
    },
    {
      "id": "f3c5a8d9-9f11-4f4c-936d-d3327cda88b0",
      "name": "便签 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -128,
        -304
      ],
      "parameters": {
        "color": 6,
        "width": 608,
        "height": 736,
        "content": "## 数据丰富"
      },
      "typeVersion": 1
    },
    {
      "id": "e86ebfd4-5e9e-4883-92c4-979af93d4455",
      "name": "合并",
      "type": "n8n-nodes-base.merge",
      "position": [
        736,
        0
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "f767e615-77a1-43dc-967f-a9a74c0289e4",
      "name": "在表格中追加或更新行",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        992,
        0
      ],
      "parameters": {
        "columns": {
          "value": {
            "profile": "={{ $json.toJsonString()}}"
          },
          "schema": [
            {
              "id": "profile",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "profile",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "summary",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "summary",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "profile"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nopL6tWWBydiGqRz4HuyTjbp4D_1to75QNGzLszUV-g/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1nopL6tWWBydiGqRz4HuyTjbp4D_1to75QNGzLszUV-g",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nopL6tWWBydiGqRz4HuyTjbp4D_1to75QNGzLszUV-g/edit?usp=drivesdk",
          "cachedResultName": "LinkedIn Profiling"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "Zjoxh2BUZ6VXGQhA",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "cd2f9ee6-a590-4bef-8562-0bb39b5db19e",
  "connections": {
    "Merge": {
      "main": [
        [
          {
            "node": "Append or update row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Decodo": {
      "main": [
        [
          {
            "node": "Structured Data Extractor",
            "type": "main",
            "index": 0
          },
          {
            "node": "Summarize Content",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract the JSON": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Summarize Content": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Set the Input Fields": {
      "main": [
        [
          {
            "node": "Decodo",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Data Extractor": {
      "main": [
        [
          {
            "node": "Extract the JSON",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Append or update row in sheet": {
      "main": [
        []
      ]
    },
    "Google Gemini Chat Model for Summary": {
      "ai_languageModel": [
        [
          {
            "node": "Summarize Content",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Set the Input Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Gemini Chat Model for Structured Data": {
      "ai_languageModel": [
        [
          {
            "node": "Structured Data Extractor",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

中级

需要付费吗?

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

工作流信息
难度等级
中级
节点数量13
分类-
节点类型9
难度说明

适合有一定经验的用户,包含 6-15 个节点的中等复杂度工作流

作者
Ranjan Dailata

Ranjan Dailata

@ranjancse

A Professional based out of India specialized in handling AI-powered automations. Contact me at ranjancse@gmail.com

外部链接
在 n8n.io 查看

分享此工作流