パーソナライズされたIJSHI
中級
これはLead Nurturing, Multimodal AI分野の自動化ワークフローで、6個のノードを含みます。主にGoogleSheets, ManualTrigger, OpenAiなどのノードを使用。 GPT-4とIndeedデータをGoogleスプレッドシートから使用して仕事探しの開始メッセージを生成
前提条件
- •Google Sheets API認証情報
- •OpenAI API Key
カテゴリー
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "CsAeAdjSA8YRn8rh",
"meta": {
"instanceId": "b9a4810a9a51f2cd27d6d88b2b57f7ecf9f947c4f003311c8382943a4b6c6dc4",
"templateCredsSetupCompleted": true
},
"name": "Personalize 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 Personal Icebreaker generation"
},
"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": "## Note \nPart two of the Indeed Job Scraper, Filter and Enrichment workflow, this workflow takes information about the scraped and filtered job listings on Indeed via Apify, which is stored in Google Sheets to generate a customized, five-line email icebreaker to imply that the rest of the icebreaker is personalized. Personalized IJSFE (Indeed Job Scraper For Enrichment).\n\n"
},
"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": {
"8c36adcd-c521-4f0e-a184-1075ca8695d8": {
"main": [
[
{
"node": "eff4a4a2-958a-4d39-a4d0-dfed7ea76140",
"type": "main",
"index": 0
}
]
]
},
"11a807b9-b215-4167-8839-cd4151ce7caf": {
"main": [
[
{
"node": "8c36adcd-c521-4f0e-a184-1075ca8695d8",
"type": "main",
"index": 0
}
]
]
},
"d50c5e29-8a78-4453-b0e2-d7d4f557c759": {
"main": [
[
{
"node": "11a807b9-b215-4167-8839-cd4151ce7caf",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
中級 - リードナーチャリング, マルチモーダルAI
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
AIを備えた高度なリード獲得と育成自動化システム
GPT-4、LinkedIn、Hunter.ioを使ってパーソナライズされたB2Bタッチを自動化
If
Code
Wait
+
If
Code
Wait
30 ノードMarth
リードナーチャリング
私の冷蔵郵送メールジェネレーター
Anthropic、GPT-4、そしてGoogleシートを使ってパーソナライズされたアイスのメールを生成する
If
Set
Code
+
If
Set
Code
24 ノードBhuvanesh R
リードナーチャリング
Googleメールの挨拶
GPT-4o-miniとGoogleスプレッドシートを使ってパーソナライズされたカールドメールを生成する
Code
Google Sheets
Manual Trigger
+
Code
Google Sheets
Manual Trigger
9 ノードrana tamure
リードナーチャリング
AI、Gmail、Google Sheetsを使用した超パーソナライズメールプロモーション
AI、Gmail、Google Sheetsを活用した超パーソナライズされたメールマーケティングの実現
Gmail
Http Request
Google Sheets
+
Gmail
Http Request
Google Sheets
12 ノードIntuz
リードナーチャリング
AIを活用した見込み客リサーチとパーソナライズドメール生成（GroqとGoogle Sheets）
AIを活用した見込み客リサーチとパーソナライズドメール生成：GroqとGoogle Sheetsを使用
If
Code
Google Sheets
+
If
Code
Google Sheets
22 ノードainabler
リードナーチャリング
リランキング #1
ウェブスクレイピング、GPT-4o、WhatsAppを使用した电话営業の自動化
Set
Code
Webhook
+
Set
Code
Webhook
48 ノードKhaisa Studio
リードナーチャリング
ワークフロー情報
難易度
中級
ノード数6
カテゴリー2
ノードタイプ4
作成者
Adrian Bent
@adrian-bentHey 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で表示 →
このワークフローを共有