AutomationFlowsAI & RAG › Automated MySQL Data to Teams Channel

Automated MySQL Data to Teams Channel

Original n8n title: Sample

sample. Uses mySql, httpRequest, agent, microsoftTeams. Scheduled trigger; 7 nodes.

Cron / scheduled trigger★★★★☆ complexityAI-powered7 nodesMySQLHTTP RequestAgentMicrosoft Teams
AI & RAG Trigger: Cron / scheduled Nodes: 7 Complexity: ★★★★☆ AI nodes: yes Added:

This workflow follows the Agent → HTTP Request 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": "sample",
  "description": null,
  "active": false,
  "isArchived": false,
  "nodes": [
    {
      "parameters": {
        "rule": {
          "interval": [
            {}
          ]
        }
      },
      "type": "n8n-nodes-base.scheduleTrigger",
      "typeVersion": 1.2,
      "position": [
        0,
        0
      ],
      "id": "40cad11c-fa68-4da3-89f4-955986092907",
      "name": "Schedule Trigger"
    },
    {
      "parameters": {
        "operation": "select",
        "table": {
          "__rl": true,
          "mode": "list",
          "value": ""
        }
      },
      "type": "n8n-nodes-base.mySql",
      "typeVersion": 2.5,
      "position": [
        208,
        0
      ],
      "id": "1e3e4e9f-fa32-4aae-b454-6862f06c3b82",
      "name": "Select rows from a table"
    },
    {
      "parameters": {
        "options": {}
      },
      "type": "n8n-nodes-base.set",
      "typeVersion": 3.4,
      "position": [
        416,
        0
      ],
      "id": "982cfb42-0e4b-42d7-9b10-7b888094c860",
      "name": "Edit Fields"
    },
    {
      "parameters": {
        "url": "https://dev295914.service-now.com/api/now/table/alm_asset",
        "authentication": "[PLACEHOLDER_SECRET]",
        "sendQuery": true,
        "queryParameters": {
          "parameters": [
            {
              "name": "sysparm_fields",
              "value": "due_in,model"
            },
            {
              "name": "sysparm_limit",
              "value": "1"
            }
          ]
        },
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "Accept",
              "value": "application/json"
            },
            {
              "name": "authorization",
              "value": "Basic YWRtaW46YWRtaW4="
            }
          ]
        },
        "options": {}
      },
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.3,
      "position": [
        608,
        0
      ],
      "id": "16a87731-e0c8-4f09-b4c9-ab50dc3d25f4",
      "name": "HTTP Request"
    },
    {
      "parameters": {
        "options": {}
      },
      "type": "@n8n/n8n-nodes-langchain.agent",
      "typeVersion": 3,
      "position": [
        736,
        0
      ],
      "id": "5af3302a-2e79-42f4-bcd8-8fe843216c88",
      "name": "AI Agent"
    },
    {
      "parameters": {
        "resource": "chatMessage",
        "operation": "sendAndWait",
        "chatId": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "responseType": "customForm",
        "options": {}
      },
      "type": "n8n-nodes-base.microsoftTeams",
      "typeVersion": 2,
      "position": [
        1024,
        0
      ],
      "id": "f09168df-a749-44ca-9ca1-317983364842",
      "name": "Create channel"
    },
    {
      "parameters": {
        "workflowId": {
          "__rl": true,
          "value": "DknlIskkKHT26g5x",
          "mode": "list",
          "cachedResultUrl": "/workflow/DknlIskkKHT26g5x",
          "cachedResultName": "nexusPostMsgTestAuth"
        },
        "workflowInputs": {
          "mappingMode": "defineBelow",
          "value": {}
        },
        "options": {}
      },
      "type": "n8n-nodes-base.executeWorkflow",
      "typeVersion": 1.3,
      "position": [
        1200,
        0
      ],
      "id": "1370bf45-8f35-4d4f-9e4c-bd5c3c5eac49",
      "name": "Call 'nexusPostMsgTestAuth'"
    }
  ],
  "connections": {
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Select rows from a table",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Select rows from a table": {
      "main": [
        [
          {
            "node": "Edit Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields": {
      "main": [
        [
          {
            "node": "HTTP Request",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Agent": {
      "main": [
        [
          {
            "node": "Create channel",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create channel": {
      "main": [
        [
          {
            "node": "Call 'nexusPostMsgTestAuth'",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "settings": {
    "executionOrder": "v1"
  },
  "staticData": null,
  "meta": null,
  "versionId": "9d31f707-036c-4481-8088-c22e3dc5f36e",
  "activeVersionId": null,
  "versionCounter": 2,
  "triggerCount": 0,
  "shared": [
    {
      "updatedAt": "2025-12-09T22:28:32.731Z",
      "createdAt": "2025-12-09T22:28:32.731Z",
      "role": "workflow:owner",
      "workflowId": "vjQEtiuDjqTLgcMF",
      "projectId": "rbmFyQ0fPfUjlaVB",
      "project": {
        "updatedAt": "2025-10-28T16:01:24.976Z",
        "createdAt": "2025-10-28T15:59:42.193Z",
        "id": "rbmFyQ0fPfUjlaVB",
        "name": "sean keery <sean.keery@rmscorp.com>",
        "type": "personal",
        "icon": null,
        "description": null,
        "creatorId": "0bf0b226-8ea5-4163-8cc1-8ca9663cae74"
      }
    }
  ],
  "tags": [],
  "activeVersion": null
}
Pro

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

About this workflow

sample. Uses mySql, httpRequest, agent, microsoftTeams. Scheduled trigger; 7 nodes.

Source: https://github.com/skibum55/workflowsascode/blob/ca3aa731d0f77926299b2226c42853d903022682/workflows/sample.json — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

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

AI & RAG

An end-to-end Cyber Threat Intelligence pipeline that turns raw DNS traffic into actionable security verdicts — without manual triage, without leaking credentials, and without alert fatigue.

MySQL, HTTP Request, N8N Nodes Hashi Vault +4
AI & RAG

This n8n workflow is designed for content creators, digital marketers, and social media managers who want to automate their entire content creation and publishing process across multiple platforms. It

Google Sheets, WordPress, Edit Image +13
AI & RAG

This workflow is designed for Google Ads advertisers, PPC managers, and marketing teams who want to automatically monitor and optimize their search term performance. It's particularly valuable for tho

Slack, HTTP Request, Agent +11
AI & RAG

Aggregates communication data from Slack, Microsoft Teams, Gmail, GitHub, and Confluence into a single, unified AI-powered analysis workflow designed for quality review and automated documentation upd

Slack, Microsoft Teams, Gmail +6
AI & RAG

Complete PostgreSQL-backed system: Keyword scoring → AI research → Multi-part content generation → fal.ai Nano Banana image generation → WordPress publishing

WordPress, OpenAI, Perplexity +8