私のワークフロー 3

Name: 私のワークフロー 3
Rating: 4.5 (10 reviews)
Author: Abdullah

初級

これはLead Nurturing分野の自動化ワークフローで、4個のノードを含みます。主にGmail, Slack, GoogleContacts, GoogleSheetsTriggerなどのノードを使用。 Googleスプレッドシート、Slack、Gmail、連絡先を使用した自動フォーム返信システム

前提条件

•Googleアカウント + Gmail API認証情報
•Slack Bot Token または Webhook URL
•Google Sheets API認証情報

使用ノード (4)

カテゴリー

リードナーチャリング

ワークフロープレビュー

ノード接続関係を可視化、ズームとパンをサポート

メッセージを送信

メッセージを送信1

Google Sheets Trigger

連絡先を作成

React Flow

ワークフローをエクスポート

以下のJSON設定をn8nにインポートして、このワークフローを使用できます

{
  "id": "Fcfrid6ngpoXepqq",
  "meta": {
    "instanceId": "1b9b471cfc35c494898c60da53fb540b12dc98f14d03ea21d431e8d5b791e453",
    "templateCredsSetupCompleted": true
  },
  "name": "My workflow 3",
  "tags": [],
  "nodes": [
    {
      "id": "0598aff8-ffec-4b53-93fb-3ac7ceb6e526",
      "name": "メッセージを送信",
      "type": "n8n-nodes-base.gmail",
      "position": [
        440,
        -40
      ],
      "webhookId": "3687c0d7-061d-455c-ae4d-4bb359ad7f02",
      "parameters": {
        "sendTo": "={{ $('Google Sheets Trigger').item.json.Email }}",
        "message": "=Hey  {{ $('Google Sheets Trigger').item.json.Name }}!\n\nWe see tha that your Problem is \"{{ $('Google Sheets Trigger').item.json.Description }}\"We got your query and our team is working on it. We assure you that the problem will be solved Really Soon.\n\nReach out to us in case of any help\n\nThank you\nRegards,\nN8n Team",
        "options": {},
        "subject": "Ticket Created.!",
        "emailType": "text"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "ZMzKWeOEZrE9sTaD",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "4c92f186-5abb-469d-bb7a-68acefab039b",
      "name": "メッセージを送信1",
      "type": "n8n-nodes-base.slack",
      "position": [
        220,
        100
      ],
      "webhookId": "ee9e11b2-0985-4109-acde-7d8dd9326c98",
      "parameters": {
        "text": "=> Hello Team,A new entry has been added to the google sheets Node. The details are as follows.\nName : {{ $json.Name }}\nEmail : {{ $json.Email }}\nPhone Number : {{ $json['Phone Number']}}\nProblem Desc : {{ $json.Description }}\n\nPlease handle the client's request as stated in the problem.",
        "select": "channel",
        "channelId": {
          "__rl": true,
          "mode": "id",
          "value": "=C095F7HDKUL"
        },
        "otherOptions": {}
      },
      "credentials": {
        "slackApi": {
          "id": "OdtF4hNnEI1ZoAeW",
          "name": "Slack account"
        }
      },
      "typeVersion": 2.3
    },
    {
      "id": "63e9d67e-4a0f-41f2-9fd5-209abadbdcc3",
      "name": "Google Sheets Trigger",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        -20,
        -40
      ],
      "parameters": {
        "options": {},
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xJn861StZtmTop8c2WBqf4SvGziT0use3zVCjT4n9-o/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1xJn861StZtmTop8c2WBqf4SvGziT0use3zVCjT4n9-o",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xJn861StZtmTop8c2WBqf4SvGziT0use3zVCjT4n9-o/edit?usp=drivesdk",
          "cachedResultName": "Sheet Problem 1"
        }
      },
      "credentials": {
        "googleSheetsTriggerOAuth2Api": {
          "id": "nAgyMUqKLfbGhYao",
          "name": "Google Sheets Trigger account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "81b76d73-f77b-4279-b9ab-a7988a0925ce",
      "name": "連絡先を作成",
      "type": "n8n-nodes-base.googleContacts",
      "position": [
        720,
        80
      ],
      "parameters": {
        "givenName": "={{ $('Google Sheets Trigger').item.json.Name }}",
        "familyName": "={{ $('Google Sheets Trigger').item.json.Name }}",
        "additionalFields": {
          "phoneUi": {
            "phoneValues": [
              {
                "type": "mobile",
                "value": "={{ \"\" + $('Google Sheets Trigger').item.json[\"Phone Number\"] }}\n"
              }
            ]
          }
        }
      },
      "credentials": {
        "googleContactsOAuth2Api": {
          "id": "byyhcVKR8Z9Leibf",
          "name": "Google Contacts account"
        }
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "3236b95c-d19f-43c3-b0fe-25e64a04f84f",
  "connections": {
    "0598aff8-ffec-4b53-93fb-3ac7ceb6e526": {
      "main": [
        [
          {
            "node": "81b76d73-f77b-4279-b9ab-a7988a0925ce",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4c92f186-5abb-469d-bb7a-68acefab039b": {
      "main": [
        [
          {
            "node": "0598aff8-ffec-4b53-93fb-3ac7ceb6e526",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "63e9d67e-4a0f-41f2-9fd5-209abadbdcc3": {
      "main": [
        [
          {
            "node": "4c92f186-5abb-469d-bb7a-68acefab039b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

よくある質問