AutomationFlowsData & Sheets › External Integrations Workflow

External Integrations Workflow

External Integrations Workflow. Uses start, httpRequest, mongoDb, postgres. Manual trigger; 9 nodes.

Manual trigger★★★★☆ complexity9 nodesStartHTTP RequestMongoDBPostgresSlackEmail SendAWS S3
Data & Sheets Trigger: Manual Nodes: 9 Complexity: ★★★★☆ Added:

This workflow follows the Emailsend → 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": "External Integrations Workflow",
  "nodes": [
    {
      "parameters": {},
      "name": "Start",
      "type": "n8n-nodes-base.start",
      "typeVersion": 1,
      "position": [
        250,
        500
      ],
      "id": "start"
    },
    {
      "parameters": {
        "url": "https://api.github.com/users/{{$json[\"username\"]}}",
        "options": {
          "headers": {
            "header": [
              {
                "name": "User-Agent",
                "value": "n8n-test"
              }
            ]
          }
        }
      },
      "name": "Fetch GitHub User",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 3,
      "position": [
        450,
        300
      ],
      "id": "fetch-github"
    },
    {
      "parameters": {
        "operation": "find",
        "collection": "users",
        "query": "={\"email\": \"{{$json[\"email\"]}}\"}",
        "options": {}
      },
      "name": "Query MongoDB",
      "type": "n8n-nodes-base.mongoDb",
      "typeVersion": 1,
      "position": [
        450,
        500
      ],
      "id": "query-mongo"
    },
    {
      "parameters": {
        "operation": "executeQuery",
        "query": "SELECT * FROM customers WHERE created_at > '{{$json[\"startDate\"]}}'",
        "options": {}
      },
      "name": "Query PostgreSQL",
      "type": "n8n-nodes-base.postgres",
      "typeVersion": 1,
      "position": [
        450,
        700
      ],
      "id": "query-postgres"
    },
    {
      "parameters": {
        "functionCode": "// Combine data from multiple sources\nconst github = $item(0)?.json || {};\nconst mongo = $item(1)?.json || {};\nconst postgres = $item(2)?.json || {};\n\nreturn [{\n  json: {\n    github: {\n      login: github.login,\n      name: github.name,\n      public_repos: github.public_repos\n    },\n    database: {\n      mongoRecords: mongo.length || 0,\n      postgresRecords: postgres.length || 0\n    },\n    timestamp: new Date().toISOString()\n  }\n}];"
      },
      "name": "Combine Results",
      "type": "n8n-nodes-base.function",
      "typeVersion": 1,
      "position": [
        650,
        500
      ],
      "id": "combine-results"
    },
    {
      "parameters": {
        "channel": "#notifications",
        "text": "New user data processed:\n- GitHub: {{$json[\"github\"][\"name\"]}}\n- Repos: {{$json[\"github\"][\"public_repos\"]}}\n- DB Records: {{$json[\"database\"][\"mongoRecords\"]}}",
        "options": {
          "attachments": [
            {
              "color": "#36a64f",
              "title": "Processing Complete",
              "text": "All external data fetched successfully"
            }
          ]
        }
      },
      "name": "Send to Slack",
      "type": "n8n-nodes-base.slack",
      "typeVersion": 1,
      "position": [
        850,
        300
      ],
      "id": "send-slack"
    },
    {
      "parameters": {
        "fromEmail": "noreply@example.com",
        "toEmail": "{{$json[\"email\"]}}",
        "subject": "Data Processing Report",
        "text": "Your data has been processed.\n\nGitHub Profile: {{$json[\"github\"][\"name\"]}}\nPublic Repos: {{$json[\"github\"][\"public_repos\"]}}\n\nDatabase Records Found:\n- MongoDB: {{$json[\"database\"][\"mongoRecords\"]}}\n- PostgreSQL: {{$json[\"database\"][\"postgresRecords\"]}}",
        "options": {}
      },
      "name": "Send Email",
      "type": "n8n-nodes-base.emailSend",
      "typeVersion": 2,
      "position": [
        850,
        500
      ],
      "id": "send-email"
    },
    {
      "parameters": {
        "bucketName": "n8n-test-bucket",
        "fileName": "reports/{{$json[\"github\"][\"login\"]}}-{{$now}}.json",
        "binaryPropertyName": "data",
        "options": {
          "acl": "private"
        }
      },
      "name": "Upload to S3",
      "type": "n8n-nodes-base.awsS3",
      "typeVersion": 1,
      "position": [
        850,
        700
      ],
      "id": "upload-s3"
    },
    {
      "parameters": {
        "functionCode": "// Final summary\nreturn [{\n  json: {\n    success: true,\n    notifications: {\n      slack: true,\n      email: true,\n      s3Upload: true\n    },\n    processedAt: new Date().toISOString()\n  }\n}];"
      },
      "name": "Final Summary",
      "type": "n8n-nodes-base.function",
      "typeVersion": 1,
      "position": [
        1050,
        500
      ],
      "id": "final-summary"
    }
  ],
  "connections": {
    "Start": {
      "main": [
        [
          {
            "node": "Fetch GitHub User",
            "type": "main",
            "index": 0
          },
          {
            "node": "Query MongoDB",
            "type": "main",
            "index": 0
          },
          {
            "node": "Query PostgreSQL",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch GitHub User": {
      "main": [
        [
          {
            "node": "Combine Results",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Query MongoDB": {
      "main": [
        [
          {
            "node": "Combine Results",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Query PostgreSQL": {
      "main": [
        [
          {
            "node": "Combine Results",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Combine Results": {
      "main": [
        [
          {
            "node": "Send to Slack",
            "type": "main",
            "index": 0
          },
          {
            "node": "Send Email",
            "type": "main",
            "index": 0
          },
          {
            "node": "Upload to S3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send to Slack": {
      "main": [
        [
          {
            "node": "Final Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Email": {
      "main": [
        [
          {
            "node": "Final Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Upload to S3": {
      "main": [
        [
          {
            "node": "Final Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "active": false,
  "settings": {}
}
Pro

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

About this workflow

External Integrations Workflow. Uses start, httpRequest, mongoDb, postgres. Manual trigger; 9 nodes.

Source: https://github.com/pvdyck/n8n-test-framework/blob/dabf65c294eba226a14b439ef672584f48315473/examples/workflows/external-integrations.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

Scheduled processes retrieve customer feedback from multiple channels. The system performs sentiment analysis to classify tone, then uses OpenAI models to extract themes, topics, and urgency indicator

HTTP Request, Lm Chat Azure Open Ai, Sentiment Analysis +5
Data & Sheets

This workflow acts as a junior finance research analyst for a UK boutique M&A or corporate finance team. It listens for Slack messages, classifies the request, gathers company or market data, and prod

HTTP Request, Google Drive, Google Docs +5
Data & Sheets

Disparador 1.8. Uses itemLists, postgres, emailSend, httpRequest. Scheduled trigger; 85 nodes.

Item Lists, Postgres, Email Send +1
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