My Workflow 3

• •Google-Konto + Gmail API-Anmeldedaten
• •Slack Bot Token oder Webhook URL
• •Google Sheets API-Anmeldedaten

{
  "id": "Fcfrid6ngpoXepqq",
  "meta": {
    "instanceId": "1b9b471cfc35c494898c60da53fb540b12dc98f14d03ea21d431e8d5b791e453",
    "templateCredsSetupCompleted": true
  },
  "name": "My workflow 3",
  "tags": [],
  "nodes": [
    {
      "id": "0598aff8-ffec-4b53-93fb-3ac7ceb6e526",
      "name": "Nachricht senden",
      "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": "Nachricht senden1",
      "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 Tabellen 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": "Kontakt erstellen",
      "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
          }
        ]
      ]
    },
    "Google Sheets Trigger": {
      "main": [
        [
          {
            "node": "4c92f186-5abb-469d-bb7a-68acefab039b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}