AutomationFlowsData & Sheets › Zaad9 Teams Dane

Zaad9 Teams Dane

zaad9_teams_dane. Uses emailSend, airtable, slack, microsoftTeams. Webhook trigger; 7 nodes.

Webhook trigger★★★★☆ complexity7 nodesEmail SendAirtableSlackMicrosoft TeamsPostgres
Data & Sheets Trigger: Webhook Nodes: 7 Complexity: ★★★★☆ Added:

This workflow follows the Airtable → Slack recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "name": "zaad9_teams_dane",
  "nodes": [
    {
      "parameters": {
        "httpMethod": "POST",
        "path": "fff541c3-d6e0-46ed-861a-ffc3f0891528",
        "authentication": "basicAuth",
        "options": {}
      },
      "type": "n8n-nodes-base.webhook",
      "typeVersion": 2.1,
      "position": [
        -400,
        96
      ],
      "id": "8414e9df-8392-48a4-8ebb-241e02e3846a",
      "name": "Webhook",
      "credentials": {
        "httpBasicAuth": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "fromEmail": "automat@rajkonkret.pl",
        "toEmail": "rajkonkret660@gmail.com",
        "subject": "=Dane z formularza {{ $json.body.data.formName }}",
        "html": "=Dane u\u017cytkownika:<br>\n{{ $json.body.data.fields[0].label }}<br>\n{{ $json.body.data.fields[0].value }}<br>\n<br>\n{{ $json.body.data.fields[1].label }}<br>\n{{ $json.body.data.fields[1].value }}<br>\n<br>\nWiadomo\u015b\u0107:\n{{ $json.body.data.fields[4].value }}\n",
        "options": {}
      },
      "type": "n8n-nodes-base.emailSend",
      "typeVersion": 2.1,
      "position": [
        -304,
        -128
      ],
      "id": "d584ed71-5b56-4da6-aee3-6c26d5751aa9",
      "name": "Send email",
      "credentials": {
        "smtp": {
          "name": "<your credential>"
        }
      },
      "disabled": true
    },
    {
      "parameters": {
        "operation": "create",
        "base": {
          "__rl": true,
          "value": "appubR6JXFrMXXSRs",
          "mode": "list",
          "cachedResultName": "airtable_contact_form.xlsx",
          "cachedResultUrl": "https://airtable.com/appubR6JXFrMXXSRs"
        },
        "table": {
          "__rl": true,
          "value": "tblYK7RlagT7OsKEm",
          "mode": "list",
          "cachedResultName": "Sheet1",
          "cachedResultUrl": "https://airtable.com/appubR6JXFrMXXSRs/tblYK7RlagT7OsKEm"
        },
        "columns": {
          "mappingMode": "defineBelow",
          "value": {
            "First Name": "={{ $('Webhook').item.json.body.data.fields[0].value }}",
            "Last Name": "={{ $('Webhook').item.json.body.data.fields[1].value }}",
            "Phone Number": "={{ $('Webhook').item.json.body.data.fields[2].value }}",
            "Email": "={{ $('Webhook').item.json.body.data.fields[3].value }}",
            "Your Question": "={{ $('Webhook').item.json.body.data.fields[4].value }}"
          },
          "matchingColumns": [],
          "schema": [
            {
              "id": "First Name",
              "displayName": "First Name",
              "required": false,
              "defaultMatch": false,
              "canBeUsedToMatch": true,
              "display": true,
              "type": "string",
              "readOnly": false,
              "removed": false
            },
            {
              "id": "Last Name",
              "displayName": "Last Name",
              "required": false,
              "defaultMatch": false,
              "canBeUsedToMatch": true,
              "display": true,
              "type": "string",
              "readOnly": false,
              "removed": false
            },
            {
              "id": "Phone Number",
              "displayName": "Phone Number",
              "required": false,
              "defaultMatch": false,
              "canBeUsedToMatch": true,
              "display": true,
              "type": "string",
              "readOnly": false,
              "removed": false
            },
            {
              "id": "Email",
              "displayName": "Email",
              "required": false,
              "defaultMatch": false,
              "canBeUsedToMatch": true,
              "display": true,
              "type": "string",
              "readOnly": false,
              "removed": false
            },
            {
              "id": "Your Question",
              "displayName": "Your Question",
              "required": false,
              "defaultMatch": false,
              "canBeUsedToMatch": true,
              "display": true,
              "type": "string",
              "readOnly": false,
              "removed": false
            }
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {}
      },
      "type": "n8n-nodes-base.airtable",
      "typeVersion": 2.1,
      "position": [
        -96,
        -112
      ],
      "id": "9196f777-03e4-4503-8c34-2cff7d658bc4",
      "name": "Create a record",
      "credentials": {
        "airtableTokenApi": {
          "name": "<your credential>"
        }
      },
      "disabled": true
    },
    {
      "parameters": {
        "authentication": "oAuth2",
        "select": "user",
        "user": {
          "__rl": true,
          "value": "UPFR9GC0H",
          "mode": "list",
          "cachedResultName": "rajkonkret660"
        },
        "text": "=Wiadomo\u015b\u0107 wys\u0142ana z automatu:\n {{ $json.fields['Your Question'] }}",
        "otherOptions": {}
      },
      "type": "n8n-nodes-base.slack",
      "typeVersion": 2.3,
      "position": [
        128,
        -96
      ],
      "id": "acb27aab-12ed-4aaa-b8db-5c7e46f5066d",
      "name": "Send a message",
      "credentials": {
        "slackOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "disabled": true
    },
    {
      "parameters": {
        "resource": "chatMessage",
        "chatId": {
          "__rl": true,
          "value": "19:meeting_NzY3ZDEyZjQtOTk1YS00MTc4LTk5MGEtZmM4ZmEwYjU0YzMw@thread.v2",
          "mode": "list",
          "cachedResultName": "Automatyzacja workflow z n8n (meeting)",
          "cachedResultUrl": "https://teams.microsoft.com/l/chat/19%3Ameeting_NzY3ZDEyZjQtOTk1YS00MTc4LTk5MGEtZmM4ZmEwYjU0YzMw%40thread.v2/0?tenantId=f2320f09-c352-4af9-9056-f37ac205532c"
        },
        "message": "=test\n{{ $json.body.data.fields[0].value }}<br>\n{{ $json.body.data.fields[1].value }}<br<\n{{ $json.body.data.fields[4].value }}",
        "options": {}
      },
      "type": "n8n-nodes-base.microsoftTeams",
      "typeVersion": 2,
      "position": [
        -112,
        96
      ],
      "id": "2838f9ad-b953-4222-b5a3-ef1d02e2391b",
      "name": "Create chat message",
      "credentials": {
        "microsoftTeamsOAuth2Api": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "schema": {
          "__rl": true,
          "value": "public",
          "mode": "list",
          "cachedResultName": "public"
        },
        "table": {
          "__rl": true,
          "value": "users_n8n",
          "mode": "list",
          "cachedResultName": "users_n8n"
        },
        "columns": {
          "mappingMode": "defineBelow",
          "value": {
            "id": "=",
            "name_nowe": "={{ $('Webhook').item.json.body.data.fields[0].value }}",
            "uuid": "={{ $json.id }}"
          },
          "matchingColumns": [
            "id"
          ],
          "schema": [
            {
              "id": "name",
              "displayName": "name",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "array",
              "canBeUsedToMatch": true,
              "removed": false
            },
            {
              "id": "id",
              "displayName": "id",
              "required": false,
              "defaultMatch": true,
              "display": true,
              "type": "number",
              "canBeUsedToMatch": true,
              "removed": false
            },
            {
              "id": "name_nowe",
              "displayName": "name_nowe",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true,
              "removed": false
            },
            {
              "id": "uuid",
              "displayName": "uuid",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true,
              "removed": false
            }
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {}
      },
      "type": "n8n-nodes-base.postgres",
      "typeVersion": 2.6,
      "position": [
        304,
        96
      ],
      "id": "bf00263b-310e-448c-af50-ba137adc96f9",
      "name": "Insert rows in a table",
      "credentials": {
        "postgres": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "jsCode": "return [\n  {\n    json: {\n      id: $json.id ?? crypto.randomUUID(),\n      name: $json.name\n    }\n  }\n];"
      },
      "type": "n8n-nodes-base.code",
      "typeVersion": 2,
      "position": [
        64,
        96
      ],
      "id": "a00fd62b-f619-4dc5-86a8-1f85d68e0371",
      "name": "Code in JavaScript"
    }
  ],
  "connections": {
    "Webhook": {
      "main": [
        [
          {
            "node": "Create chat message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send email": {
      "main": [
        []
      ]
    },
    "Create a record": {
      "main": [
        []
      ]
    },
    "Send a message": {
      "main": [
        []
      ]
    },
    "Create chat message": {
      "main": [
        [
          {
            "node": "Code in JavaScript",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code in JavaScript": {
      "main": [
        [
          {
            "node": "Insert rows in a table",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "e9225f90-50f4-4611-b9d2-7e8b0ac1e88a",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "id": "5Eb7P4OwKelsdUZx",
  "tags": []
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

zaad9_teams_dane. Uses emailSend, airtable, slack, microsoftTeams. Webhook trigger; 7 nodes.

Source: https://github.com/rajkonkret/n8n_podstawy/blob/4378d24d98e032d5f613911ea69084f36d7edf96/zaad9_teams_dane.json — original creator credit. Request a take-down →

More Data & Sheets workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Data & Sheets

PURPOSE: Automatically send professional appointment reminders via email and SMS to reduce no-shows and improve patient experience.

Google Sheets, Airtable, Email Send +2
Data & Sheets

How it works

Postgres, Email Send
Data & Sheets

This workflow automates data maturity evaluation to measure how well an organization uses data to create value by capturing assessment data through forms or APIs, processing and scoring responses usin

Email Send, Postgres
Data & Sheets

This n8n workflow automates the transformation of raw text ideas into structured visual diagrams and content assets using NapkinAI.

HTTP Request, Email Send, Postgres
Data & Sheets

Receive request via webhook with customer question Analyze sentiment and detect urgency using JavaScript Send urgent alerts to Slack for critical cases Search knowledge base and fetch conversation his

HTTP Request, Postgres, Email Send +1