{
  "name": "Consolidate data from 5 sources for automated reporting with SQL, MongoDB & Google tools",
  "nodes": [
    {
      "id": "b28ea25c-3c5e-44ca-856f-d5f057fce8ab",
      "name": "📄 Google Sheets Source",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -368,
        32
      ]
    },
    {
      "id": "04b2a7c3-f5aa-412c-a764-75a6f26e8c28",
      "name": "🐘 PostgreSQL Source",
      "type": "n8n-nodes-base.postgres",
      "position": [
        -368,
        224
      ]
    },
    {
      "id": "28dd8f01-9a48-473d-926c-ad9eb94ca7b4",
      "name": "🍃 MongoDB Source",
      "type": "n8n-nodes-base.mongoDb",
      "position": [
        -368,
        416
      ]
    },
    {
      "id": "6f84ea01-55ec-4112-a4d4-11fba9f993ec",
      "name": "⚙️ Process Merged Data",
      "type": "n8n-nodes-base.function",
      "position": [
        288,
        416
      ]
    },
    {
      "id": "d7a22005-d249-4a68-a970-b72e59639ea2",
      "name": "📊 Final Google Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        528,
        416
      ]
    },
    {
      "id": "ed6ff028-8eb9-4ba8-8d82-e3f9ba9f129a",
      "name": "Add Sheets Source ID",
      "type": "n8n-nodes-base.function",
      "position": [
        -144,
        32
      ]
    },
    {
      "id": "3a01720f-8434-4a36-b02e-d14d9ab092c5",
      "name": "Add PostgreSQL Source ID",
      "type": "n8n-nodes-base.function",
      "position": [
        -144,
        224
      ]
    },
    {
      "id": "e55e3811-2291-4e40-9b1f-37e7c7fbe5ad",
      "name": "Add SQL Server Source ID",
      "type": "n8n-nodes-base.function",
      "position": [
        -144,
        608
      ]
    },
    {
      "id": "f480146b-4152-4837-a556-d178ea0d33dc",
      "name": "Add MongoDB Source ID",
      "type": "n8n-nodes-base.function",
      "position": [
        -144,
        416
      ]
    },
    {
      "id": "b9c0f9ac-ba41-4162-bcbd-f529d4a49c09",
      "name": "Add Analytics Source ID",
      "type": "n8n-nodes-base.function",
      "position": [
        -144,
        800
      ]
    },
    {
      "id": "e26d6c59-0d46-4abd-a9cc-82ea2894402e",
      "name": "Microsoft SQL Server",
      "type": "n8n-nodes-base.microsoftSql",
      "position": [
        -368,
        608
      ]
    },
    {
      "id": "a8ee48b5-188d-49b8-963f-1570683b3b55",
      "name": "Google Analytics",
      "type": "n8n-nodes-base.googleAnalytics",
      "position": [
        -368,
        800
      ]
    },
    {
      "id": "2a5bdc85-b754-485b-a1fd-435cc07f0ce3",
      "name": "Merge",
      "type": "n8n-nodes-base.merge",
      "position": [
        80,
        368
      ]
    },
    {
      "id": "0dc0d5a7-2a7a-456b-a7e5-f62982d15b9b",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -592,
        416
      ]
    },
    {
      "id": "a3a4a5b8-e80a-4759-9ab3-5a259f619472",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -640,
        -336
      ],
      "parameters": {
        "width": 640,
        "height": 1296,
        "content": "## Objective: \n\n*Consolidate data from 5 sources (Google Sheets, PostgreSQL, MongoDB, MS SQL, Google Analytics) into a master Google Sheet for reporting and visibility.*\n\n## Data Sources: \n\n*Pulls lea"
      }
    },
    {
      "id": "a848bbf0-dcde-4395-b67e-d0b4f60bf7dc",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        16,
        -336
      ],
      "parameters": {
        "width": 432,
        "height": 1296,
        "content": "## Merge Node: \n\n*Combines all datasets into a unified structure.*\n\n## Processing Node: \n\n*Cleans, aligns schemas, and standardizes fields (Name, Email, Title, Company, etc.).*"
      }
    },
    {
      "id": "72ee4227-8bcd-434f-b327-b9fd57e46861",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        464,
        -336
      ],
      "parameters": {
        "width": 256,
        "height": 1296,
        "content": "## Final dataset is written into Google Sheets.\n\n*Configure your output Google Sheets document ID and credentials to save the consolidated data.*"
      }
    }
  ],
  "connections": {
    "Merge": {
      "main": [
        [
          {
            "node": "⚙️ Process Merged Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Analytics": {
      "main": [
        [
          {
            "node": "Add Analytics Source ID",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "📄 Google Sheets Source",
            "type": "main",
            "index": 0
          },
          {
            "node": "🐘 PostgreSQL Source",
            "type": "main",
            "index": 0
          },
          {
            "node": "🍃 MongoDB Source",
            "type": "main",
            "index": 0
          },
          {
            "node": "Microsoft SQL Server",
            "type": "main",
            "index": 0
          },
          {
            "node": "Google Analytics",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🍃 MongoDB Source": {
      "main": [
        [
          {
            "node": "Add MongoDB Source ID",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add Sheets Source ID": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Microsoft SQL Server": {
      "main": [
        [
          {
            "node": "Add SQL Server Source ID",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add MongoDB Source ID": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "🐘 PostgreSQL Source": {
      "main": [
        [
          {
            "node": "Add PostgreSQL Source ID",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add Analytics Source ID": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 4
          }
        ]
      ]
    },
    "Add PostgreSQL Source ID": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Add SQL Server Source ID": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 3
          }
        ]
      ]
    },
    "📄 Google Sheets Source": {
      "main": [
        [
          {
            "node": "Add Sheets Source ID",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "⚙️ Process Merged Data": {
      "main": [
        [
          {
            "node": "📊 Final Google Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}