我的工作流 3

• •Google 账号和 Gmail API 凭证
• •Slack Bot Token 或 Webhook URL
• •Google Sheets API 凭证

{
  "id": "Fcfrid6ngpoXepqq",
  "meta": {
    "instanceId": "1b9b471cfc35c494898c60da53fb540b12dc98f14d03ea21d431e8d5b791e453",
    "templateCredsSetupCompleted": true
  },
  "name": "我的工作流 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触发器",
      "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": {
    "Send a message": {
      "main": [
        [
          {
            "node": "Create a contact",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send a message1": {
      "main": [
        [
          {
            "node": "Send a message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets Trigger": {
      "main": [
        [
          {
            "node": "Send a message1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}