8
n8n 中文网amn8n.com

个性化IJSHI

中级

这是一个Lead Nurturing, Multimodal AI领域的自动化工作流，包含 6 个节点。主要使用 GoogleSheets, ManualTrigger, OpenAi 等节点。 使用GPT-4和来自谷歌表格的Indeed数据生成求职破冰语

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

使用的节点 (6)

StickyNote
GoogleSheets
ManualTrigger
OpenAi

分类

客户培育
多模态 AI
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "CsAeAdjSA8YRn8rh",
  "meta": {
    "instanceId": "b9a4810a9a51f2cd27d6d88b2b57f7ecf9f947c4f003311c8382943a4b6c6dc4",
    "templateCredsSetupCompleted": true
  },
  "name": "个性化 IJSHI",
  "tags": [],
  "nodes": [
    {
      "id": "d50c5e29-8a78-4453-b0e2-d7d4f557c759",
      "name": "当点击\"执行工作流\"时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -380,
        -60
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "11a807b9-b215-4167-8839-cd4151ce7caf",
      "name": "获取表格中的行",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -160,
        -60
      ],
      "parameters": {
        "options": {},
        "filtersUI": {
          "values": [
            {
              "lookupColumn": "icebreaker"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1558745101,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1pQVwVFZ99hCjktMy-YDF3nYmZLL4yheF10OR5-7Apbw/edit#gid=1558745101",
          "cachedResultName": "Copy of Indeed JSHI"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1pQVwVFZ99hCjktMy-YDF3nYmZLL4yheF10OR5-7Apbw",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1pQVwVFZ99hCjktMy-YDF3nYmZLL4yheF10OR5-7Apbw/edit?usp=drivesdk",
          "cachedResultName": "Leads Gen DB i1"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "ZNhzq0SNfiyKVdwv",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "836d33ad-9455-4d92-b9b7-7eb49c1b6e80",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -440,
        -160
      ],
      "parameters": {
        "width": 1160,
        "height": 300,
        "content": "## AI 个性化破冰开场白生成"
      },
      "typeVersion": 1
    },
    {
      "id": "67b2cce9-9289-426f-8cd3-89b7e65aad85",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        720,
        -300
      ],
      "parameters": {
        "color": 3,
        "width": 440,
        "height": 240,
        "content": "## 说明"
      },
      "typeVersion": 1
    },
    {
      "id": "8c36adcd-c521-4f0e-a184-1075ca8695d8",
      "name": "个性化",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        60,
        -60
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-mini",
          "cachedResultName": "GPT-4.1-MINI"
        },
        "options": {
          "temperature": 0.8
        },
        "messages": {
          "values": [
            {
              "role": "system",
              "content": "You're a helpful, intelligent writing assistant."
            },
            {
              "content": "=Your task is to take, as input, a bunch of information about a job posting and company, and then generate a customized, five-line email icebreaker to imply that the rest of your comunique is personalized.\n\nYou'll return your icebreakers in the following JSON format:\n\n{\"icebreaker\":\"Hey {Name}, Love {thingaboutcompany}--also a fan of {otherinterestingthingaboutjobdescription}. Wanted to run something by you.\n\nI put something interesting together a few months ago that works well. To make a long story short, it’s {solutiontojob} that uses AI to {dowhatjobdescriptionwants}. Costs just a few cents to run.\"}\n\nRules:\n- Write in a Spartan/laconic tone of voice.\n- Keep things short\n- Try to imply familiarity slightly--i.e if you see an opportunity to imply that I like the same things, believe the same things, or want the same things they do, don't go overboard, keep it light and subtle.\n- Make sure to use the above formula when constructing your icebreakers.\n- Make use of acronyms, shorten the company name, locations, etc, where possible (say, \"XYZ\" instead of \"XYZ Agency\", \"AMS\" instead of \"AMS Professional Services\", \"Wellington\" instead of \"The Wellington Agency\", \"San Fran\" instead of \"San Francisco\", \"BC\" instead of \"British Columbia\"). Do so whenever possible.\n- After \"Hey {firstName},\" always insert \"\\n\\n\"."
            },
            {
              "content": "={\n“firstName”:“{{ $json['companyCeo/name'] }}”,\n“jobTitle”:“{{ $json.title }}”,\n“jobdescription”:“{{ $json.descriptionText }}”,\n“companyName”:“{{ $json.companyName }}”,\n“companyDescription”:“{{ $json.companyDescription }}”\n}"
            }
          ]
        },
        "jsonOutput": true
      },
      "credentials": {
        "openAiApi": {
          "id": "MtyWU7dmmlnc6YXW",
          "name": "OpenAi account"
        }
      },
      "notesInFlow": false,
      "typeVersion": 1.8
    },
    {
      "id": "eff4a4a2-958a-4d39-a4d0-dfed7ea76140",
      "name": "在表格中更新行",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        460,
        -60
      ],
      "parameters": {
        "columns": {
          "value": {
            "email": "={{ $('Get row(s) in sheet').item.json.email }}",
            "title": "={{ $('Get row(s) in sheet').item.json.title }}",
            "jobUrl": "={{ $('Get row(s) in sheet').item.json.jobUrl }}",
            "isRemote": "={{ $('Get row(s) in sheet').item.json.isRemote }}",
            "jobType/0": "={{ $('Get row(s) in sheet').item.json['jobType/0'] }}",
            "icebreaker": "={{ $json.message.content.icebreaker }}",
            "row_number": "={{ $('Get row(s) in sheet').item.json.row_number }}",
            "scrapedCeo": "={{ $('Get row(s) in sheet').item.json.scrapedCeo }}",
            "companyName": "={{ $('Get row(s) in sheet').item.json.companyName }}",
            "companyCeo/name": "={{ $('Get row(s) in sheet').item.json['companyCeo/name'] }}",
            "descriptionText": "={{ $('Get row(s) in sheet').item.json.descriptionText }}",
            "location/country": "={{ $('Get row(s) in sheet').item.json['location/country'] }}",
            "salary/salaryText": "={{ $('Get row(s) in sheet').item.json['salary/salaryText'] }}",
            "companyDescription": "={{ $('Get row(s) in sheet').item.json.companyDescription }}",
            "companyNumEmployees": "={{ $('Get row(s) in sheet').item.json.companyNumEmployees }}",
            "hiringDemand/isUrgentHire": "={{ $('Get row(s) in sheet').item.json['hiringDemand/isHighVolumeHiring'] }}",
            "companyLinks/corporateWebsite": "={{ $('Get row(s) in sheet').item.json['companyLinks/corporateWebsite'] }}",
            "hiringDemand/isHighVolumeHiring": "={{ $('Get row(s) in sheet').item.json['hiringDemand/isHighVolumeHiring'] }}"
          },
          "schema": [
            {
              "id": "jobUrl",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "jobUrl",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "title",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "title",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "descriptionText",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "descriptionText",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "hiringDemand/isHighVolumeHiring",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "hiringDemand/isHighVolumeHiring",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "hiringDemand/isUrgentHire",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "hiringDemand/isUrgentHire",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "isRemote",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "isRemote",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "jobType/0",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "jobType/0",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "companyCeo/name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "companyCeo/name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "icebreaker",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "icebreaker",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "scrapedCeo",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "scrapedCeo",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "email",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "companyName",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "companyName",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "companyDescription",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "companyDescription",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "companyLinks/corporateWebsite",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "companyLinks/corporateWebsite",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "companyNumEmployees",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "companyNumEmployees",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "location/country",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "location/country",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "salary/salaryText",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "salary/salaryText",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "row_number"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1558745101,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1pQVwVFZ99hCjktMy-YDF3nYmZLL4yheF10OR5-7Apbw/edit#gid=1558745101",
          "cachedResultName": "Copy of Indeed JSHI"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1pQVwVFZ99hCjktMy-YDF3nYmZLL4yheF10OR5-7Apbw",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1pQVwVFZ99hCjktMy-YDF3nYmZLL4yheF10OR5-7Apbw/edit?usp=drivesdk",
          "cachedResultName": "Leads Gen DB i1"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "ZNhzq0SNfiyKVdwv",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "b70ebe04-1243-46d8-9267-e014dbc3c088",
  "connections": {
    "Personalization": {
      "main": [
        [
          {
            "node": "Update row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet": {
      "main": [
        [
          {
            "node": "Personalization",
            "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）可能需要您自行付费。

相关工作流推荐

自动化高级潜在客户触达与培育活动系统（含AI）
通过GPT-4、LinkedIn和Hunter.io自动化个性化B2B触达
If
Code
Wait
+9
30 节点Marth
客户培育
我的冷邮件生成器
使用Anthropic、GPT-4和谷歌表格生成个性化冷邮件
If
Set
Code
+10
24 节点Bhuvanesh R
客户培育
谷歌邮件开场白
使用GPT-4o-mini和谷歌表格生成个性化冷邮件
Code
Google Sheets
Manual Trigger
+3
9 节点rana tamure
客户培育
使用 AI、Gmail 和 Google Sheets 进行超个性化邮件推广
利用 AI、Gmail 和 Google Sheets 实现超个性化邮件推广
Gmail
Http Request
Google Sheets
+3
12 节点Intuz
客户培育
Instagram 私信生成模板
使用 Apify、OpenAI 和 Google Sheets 编写个性化 Instagram 私信
Http Request
Google Sheets
Apify
+4
10 节点Michael Muenzer
客户培育
基于AI的潜在客户研究与个性化邮件生成（Groq和Google Sheets）
基于AI的潜在客户研究与个性化邮件生成：使用Groq和Google Sheets
If
Code
Google Sheets
+7
22 节点ainabler
客户培育
工作流信息
难度等级
中级
节点数量6
分类2
节点类型4
难度说明

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

作者
Adrian Bent

Adrian Bent

@adrian-bent

Hey I'm Adrian. I got into automation to help me better understand and build systems. If you have any questions about my n8n templates/builds, feel free to ask, and I'll be happy to respond via email at terrflix45@gmail.com. Thanks for the time!

外部链接
在 n8n.io 查看 →

分享此工作流