Mon workflow 3

• •Compte Google et informations d'identification Gmail API
• •Token Bot Slack ou URL Webhook
• •Informations d'identification Google Sheets API

{
  "id": "Fcfrid6ngpoXepqq",
  "meta": {
    "instanceId": "1b9b471cfc35c494898c60da53fb540b12dc98f14d03ea21d431e8d5b791e453",
    "templateCredsSetupCompleted": true
  },
  "name": "My workflow 3",
  "tags": [],
  "nodes": [
    {
      "id": "0598aff8-ffec-4b53-93fb-3ac7ceb6e526",
      "name": "Envoyer un message",
      "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": "Envoyer un message1",
      "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": "Créer un contact",
      "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
          }
        ]
      ]
    }
  }
}