Unipile と Google Sheets を使って LinkedIn 連絡依頼とアイシングメッセージを自動送信

上級

これはOther分野の自動化ワークフローで、44個のノードを含みます。主にIf, Set, Code, Form, Webhookなどのノードを使用。 Unipile と Google Sheets を使って LinkedIn 連絡先へのリクエストとフリーマーキングメッセージを自動送信

前提条件
  • HTTP Webhookエンドポイント(n8nが自動生成)
  • ターゲットAPIの認証情報が必要な場合あり
  • Google Sheets API認証情報

カテゴリー

ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
  "nodes": [
    {
      "id": "8bf19219-e4c1-4c79-a099-7e6668c4ae93",
      "name": "When Executed by Another Workflow",
      "type": "n8n-nodes-base.executeWorkflowTrigger",
      "position": [
        -60,
        500
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "4b41d0fd-dab3-45ef-ae61-0009cc6d375c",
      "name": "Create Webhook トリガー",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        800,
        -220
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "90098842-5bbc-45cf-adc9-84ca9be2c9b7",
      "name": "付箋",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        740,
        -340
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "e2c28135-b7ee-40a0-9b14-a8147dd273da",
      "name": "開始 HERE",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        -40,
        -220
      ],
      "webhookId": "806a9dba-c405-4fdd-98db-99883acb0362",
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "51ae0f60-af6d-4ed3-a988-2a59a179589c",
      "name": "Webhook トリガー status response",
      "type": "n8n-nodes-base.form",
      "position": [
        1020,
        -220
      ],
      "webhookId": "3df5cbfb-3228-43da-b4c0-a300c279b7ae",
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "914e854b-dc8b-4425-a275-2ce262c4482c",
      "name": "Send contact request",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1660,
        -20
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "2a03efc1-7bc1-443e-9777-448b549f367a",
      "name": "if not is_relationship",
      "type": "n8n-nodes-base.if",
      "position": [
        1440,
        120
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "87a675d8-b169-4aa7-8666-437aca5d5c46",
      "name": "Get linkedin profiles",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        600,
        120
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "4d56dff8-824f-4bef-87d9-78f499473dc1",
      "name": "Populate profiles",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1220,
        120
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "bf9b3704-8e6b-45e3-a63b-82b72b4929cc",
      "name": "Response Webhook トリガー",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -60,
        740
      ],
      "webhookId": "5544529c-10ba-4626-b554-84daec00dcb4",
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "3a6bc6ea-ca8a-411e-b913-3643c4350bff",
      "name": "付箋2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        520,
        420
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "cd6c9157-144b-45d9-8f57-ffce9c8da931",
      "name": "Get chat participants",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        740,
        500
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "bd49f5cc-9b84-42c7-8320-70c5b0802291",
      "name": "ファイルに変換",
      "type": "n8n-nodes-base.convertToFile",
      "position": [
        380,
        -220
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "47e7ebc7-3aed-4564-a5b3-bf3d39215590",
      "name": "付箋3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -660,
        -340
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "3c86a4c8-dfa1-4d0b-8133-6c0d14544faa",
      "name": "付箋4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -660,
        920
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "65211596-9813-4419-b7bd-078c85cf9bb6",
      "name": "ファイルから抽出",
      "type": "n8n-nodes-base.extractFromFile",
      "position": [
        360,
        120
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "0dc99232-ec2b-4f4e-b635-e73bd13046f4",
      "name": "ファイルから抽出1",
      "type": "n8n-nodes-base.extractFromFile",
      "position": [
        340,
        740
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "724ad61b-00f9-4576-ae09-3e48d24cca33",
      "name": "Read file",
      "type": "n8n-nodes-base.readWriteFile",
      "position": [
        160,
        120
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "65902c49-a150-441d-847f-578209ce15a5",
      "name": "Write file",
      "type": "n8n-nodes-base.readWriteFile",
      "position": [
        600,
        -220
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "82ac3288-b7b1-491f-9d5f-f5f9e6fa9a0c",
      "name": "Read file1",
      "type": "n8n-nodes-base.readWriteFile",
      "position": [
        140,
        740
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "e627e203-931e-4b6a-bdc5-73e5d1bdb007",
      "name": "ファイルから抽出2",
      "type": "n8n-nodes-base.extractFromFile",
      "position": [
        340,
        500
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "3040098d-c1bf-457e-a5bb-6a424066fbd2",
      "name": "Read file2",
      "type": "n8n-nodes-base.readWriteFile",
      "position": [
        140,
        500
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "bc55190b-cbb6-4e42-b144-13a94cf80530",
      "name": "Get linkedin profiles1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        520,
        740
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "37e9feba-9c79-472f-acbd-088bc0186912",
      "name": "If status is invited",
      "type": "n8n-nodes-base.if",
      "position": [
        700,
        740
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "117cd9cf-6c29-4efa-8040-65613f58db0a",
      "name": "Send Icebreaker",
      "type": "n8n-nodes-base.executeWorkflow",
      "position": [
        920,
        720
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "e1f89ba6-9ce2-46b8-b175-6662deb5e115",
      "name": "Send Icebreaker1",
      "type": "n8n-nodes-base.executeWorkflow",
      "position": [
        1660,
        240
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "bdfe75d4-06e6-4b47-b905-34176eaaf374",
      "name": "付箋5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -100,
        -340
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "ab62101f-a901-47e5-b725-a7fb6eab24f3",
      "name": "Split the DSN",
      "type": "n8n-nodes-base.set",
      "position": [
        180,
        -220
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "2a2b045a-c064-4014-838c-1474cf673d00",
      "name": "付箋6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        100,
        -40
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c5005820-b07c-4572-ad84-25e7154c36c3",
      "name": "Update status",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1840,
        -20
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "497b6d4b-2ce0-4b63-927d-41a022a81a8c",
      "name": "付箋7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1600,
        -100
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "a149e351-9f6b-47bf-830c-935e6b9aca3e",
      "name": "付箋8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1600,
        160
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "e9d38497-9deb-4a9c-8e60-997e7f8f64f8",
      "name": "付箋9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        980,
        -40
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "18f44b02-b7dc-4efc-a28d-0587c6259a20",
      "name": "Get user Linkedin data",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1020,
        120
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "e6df2a30-70d7-48ce-9313-e0180038e263",
      "name": "付箋10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        520,
        -40
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "9f571656-fa9f-41d0-b23a-0273d842ff7e",
      "name": "Use this worflow to start the whole pocess",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -60,
        120
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "a7586e81-72e5-48eb-a57e-49c3ae1d9814",
      "name": "付箋12",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -100,
        680
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "89a35cf2-c3fc-4f06-b3a6-d2420bcfa862",
      "name": "付箋11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -100,
        -40
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "00fb7683-f732-483a-a6f7-1e90aad7a6c3",
      "name": "Extract username from Linkedin Link",
      "type": "n8n-nodes-base.code",
      "position": [
        820,
        120
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "ad6b7246-85e1-4ec1-b683-9d498305c5d0",
      "name": "Update status1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1100,
        720
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "ffebd20a-99f5-4ce6-8ad1-2b7a47b4a92d",
      "name": "開始 chat",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        540,
        500
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "e67649c3-8803-42a0-88b8-c463c1f16c04",
      "name": "Return attendee ID and Chat ID",
      "type": "n8n-nodes-base.set",
      "position": [
        920,
        500
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "8e1198a0-550e-45b5-8438-36ebb37f431a",
      "name": "Update status2",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1840,
        240
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "6282e3ce-03da-4b37-81c0-2abdc34ac04e",
      "name": "付箋13",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        100,
        420
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "connections": {
    "724ad61b-00f9-4576-ae09-3e48d24cca33": {
      "main": [
        [
          {
            "node": "Extract from File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "82ac3288-b7b1-491f-9d5f-f5f9e6fa9a0c": {
      "main": [
        [
          {
            "node": "Extract from File1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3040098d-c1bf-457e-a5bb-6a424066fbd2": {
      "main": [
        [
          {
            "node": "Extract from File2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Start HERE": {
      "main": [
        [
          {
            "node": "ab62101f-a901-47e5-b725-a7fb6eab24f3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Start chat": {
      "main": [
        [
          {
            "node": "cd6c9157-144b-45d9-8f57-ffce9c8da931",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "65902c49-a150-441d-847f-578209ce15a5": {
      "main": [
        [
          {
            "node": "Create Webhook",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ab62101f-a901-47e5-b725-a7fb6eab24f3": {
      "main": [
        [
          {
            "node": "Convert to File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Webhook": {
      "main": [
        [
          {
            "node": "Webhook status response",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert to File": {
      "main": [
        [
          {
            "node": "65902c49-a150-441d-847f-578209ce15a5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "117cd9cf-6c29-4efa-8040-65613f58db0a": {
      "main": [
        [
          {
            "node": "ad6b7246-85e1-4ec1-b683-9d498305c5d0",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Response Webhook": {
      "main": [
        [
          {
            "node": "82ac3288-b7b1-491f-9d5f-f5f9e6fa9a0c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e1f89ba6-9ce2-46b8-b175-6662deb5e115": {
      "main": [
        [
          {
            "node": "8e1198a0-550e-45b5-8438-36ebb37f431a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract from File": {
      "main": [
        [
          {
            "node": "87a675d8-b169-4aa7-8666-437aca5d5c46",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4d56dff8-824f-4bef-87d9-78f499473dc1": {
      "main": [
        [
          {
            "node": "2a03efc1-7bc1-443e-9777-448b549f367a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract from File1": {
      "main": [
        [
          {
            "node": "bc55190b-cbb6-4e42-b144-13a94cf80530",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract from File2": {
      "main": [
        [
          {
            "node": "Start chat",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "37e9feba-9c79-472f-acbd-088bc0186912": {
      "main": [
        [
          {
            "node": "117cd9cf-6c29-4efa-8040-65613f58db0a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "914e854b-dc8b-4425-a275-2ce262c4482c": {
      "main": [
        [
          {
            "node": "c5005820-b07c-4572-ad84-25e7154c36c3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "cd6c9157-144b-45d9-8f57-ffce9c8da931": {
      "main": [
        [
          {
            "node": "e67649c3-8803-42a0-88b8-c463c1f16c04",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "87a675d8-b169-4aa7-8666-437aca5d5c46": {
      "main": [
        [
          {
            "node": "00fb7683-f732-483a-a6f7-1e90aad7a6c3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "bc55190b-cbb6-4e42-b144-13a94cf80530": {
      "main": [
        [
          {
            "node": "37e9feba-9c79-472f-acbd-088bc0186912",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "18f44b02-b7dc-4efc-a28d-0587c6259a20": {
      "main": [
        [
          {
            "node": "4d56dff8-824f-4bef-87d9-78f499473dc1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2a03efc1-7bc1-443e-9777-448b549f367a": {
      "main": [
        [
          {
            "node": "914e854b-dc8b-4425-a275-2ce262c4482c",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "e1f89ba6-9ce2-46b8-b175-6662deb5e115",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Webhook status response": {
      "main": [
        []
      ]
    },
    "8bf19219-e4c1-4c79-a099-7e6668c4ae93": {
      "main": [
        [
          {
            "node": "3040098d-c1bf-457e-a5bb-6a424066fbd2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "00fb7683-f732-483a-a6f7-1e90aad7a6c3": {
      "main": [
        [
          {
            "node": "18f44b02-b7dc-4efc-a28d-0587c6259a20",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "9f571656-fa9f-41d0-b23a-0273d842ff7e": {
      "main": [
        [
          {
            "node": "724ad61b-00f9-4576-ae09-3e48d24cca33",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
よくある質問

このワークフローの使い方は?

上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。

このワークフローはどんな場面に適していますか?

上級 - その他

有料ですか?

このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス(OpenAI APIなど)は別途料金が発生する場合があります。

ワークフロー情報
難易度
上級
ノード数44
カテゴリー1
ノードタイプ15
難易度説明

上級者向け、16ノード以上の複雑なワークフロー

作成者
PollupAI

PollupAI

@zeerobug

We create bespoke AI solutions, automations and agents that help your business as it scales.

外部リンク
n8n.ioで表示

このワークフローを共有

カテゴリー

カテゴリー: 34