8
n8n Françaisamn8n.com

Intégration de la consolidation des données

Avancé

Ceci est unContent Creation, Multimodal AIworkflow d'automatisation du domainecontenant 17 nœuds.Utilise principalement des nœuds comme Merge, MongoDb, Function, Postgres, GoogleSheets. Intégrer 5 sources de données pour des rapports automatisés avec SQL, MongoDB et des outils Google

Prérequis
  • •Chaîne de connexion MongoDB
  • •Informations de connexion à la base de données PostgreSQL
  • •Informations d'identification Google Sheets API

Nœuds utilisés (17)

Merge
MongoDb
Function
Postgres
StickyNote
GoogleSheets
MicrosoftSql
GoogleAnalytics
ScheduleTrigger

Catégorie

Création de contenu
IA Multimodale
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
React Flow
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
  "name": "Integrated Data Consolidation",
  "nodes": [
    {
      "id": "b28ea25c-3c5e-44ca-856f-d5f057fce8ab",
      "name": "📄 Source Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -368,
        32
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_SHEETS_ID/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "YOUR_GOOGLE_SHEETS_ID",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_SHEETS_ID/edit",
          "cachedResultName": "Data"
        }
      },
      "typeVersion": 4
    },
    {
      "id": "04b2a7c3-f5aa-412c-a764-75a6f26e8c28",
      "name": "🐘 Source PostgreSQL",
      "type": "n8n-nodes-base.postgres",
      "position": [
        -368,
        224
      ],
      "parameters": {
        "table": {
          "__rl": true,
          "mode": "list",
          "value": "customers",
          "cachedResultName": "customers"
        },
        "schema": {
          "__rl": true,
          "mode": "list",
          "value": "public"
        },
        "options": {},
        "operation": "select",
        "returnAll": true
      },
      "typeVersion": 2.4
    },
    {
      "id": "28dd8f01-9a48-473d-926c-ad9eb94ca7b4",
      "name": "🍃 Source MongoDB",
      "type": "n8n-nodes-base.mongoDb",
      "position": [
        -368,
        416
      ],
      "parameters": {
        "options": {
          "limit": 1000
        },
        "collection": "your_collection_name"
      },
      "typeVersion": 1.1
    },
    {
      "id": "6f84ea01-55ec-4112-a4d4-11fba9f993ec",
      "name": "⚙️ Traiter les Données Fusionnées",
      "type": "n8n-nodes-base.function",
      "position": [
        288,
        416
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "d7a22005-d249-4a68-a970-b72e59639ea2",
      "name": "📊 Feuille Google Finale",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        528,
        416
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Title",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Title",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Company",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Phone",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Phone",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "LinkedIn",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "LinkedIn",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Notes",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Notes",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Function",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Function",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Seniority",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Seniority",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Confidence Score",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Confidence Score",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Status",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_OUTPUT_SHEETS_ID/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "YOUR_OUTPUT_GOOGLE_SHEETS_ID",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_OUTPUT_SHEETS_ID/edit",
          "cachedResultName": "Data"
        }
      },
      "typeVersion": 4
    },
    {
      "id": "ed6ff028-8eb9-4ba8-8d82-e3f9ba9f129a",
      "name": "Ajouter l'ID Source Sheets",
      "type": "n8n-nodes-base.function",
      "position": [
        -144,
        32
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "3a01720f-8434-4a36-b02e-d14d9ab092c5",
      "name": "Ajouter l'ID Source PostgreSQL",
      "type": "n8n-nodes-base.function",
      "position": [
        -144,
        224
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "e55e3811-2291-4e40-9b1f-37e7c7fbe5ad",
      "name": "Ajouter l'ID Source Serveur SQL",
      "type": "n8n-nodes-base.function",
      "position": [
        -144,
        608
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "f480146b-4152-4837-a556-d178ea0d33dc",
      "name": "Ajouter l'ID Source MongoDB",
      "type": "n8n-nodes-base.function",
      "position": [
        -144,
        416
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "b9c0f9ac-ba41-4162-bcbd-f529d4a49c09",
      "name": "Ajouter l'ID Source Analytics",
      "type": "n8n-nodes-base.function",
      "position": [
        -144,
        800
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "e26d6c59-0d46-4abd-a9cc-82ea2894402e",
      "name": "Microsoft SQL Server",
      "type": "n8n-nodes-base.microsoftSql",
      "position": [
        -368,
        608
      ],
      "parameters": {
        "query": "SELECT * FROM your_table;",
        "operation": "executeQuery"
      },
      "typeVersion": 1.1
    },
    {
      "id": "a8ee48b5-188d-49b8-963f-1570683b3b55",
      "name": "Google Analytics",
      "type": "n8n-nodes-base.googleAnalytics",
      "position": [
        -368,
        800
      ],
      "parameters": {
        "userId": "YOUR_USER_ID",
        "viewId": "YOUR_GA_VIEW_ID",
        "resource": "userActivity",
        "additionalFields": {}
      },
      "typeVersion": 2
    },
    {
      "id": "2a5bdc85-b754-485b-a1fd-435cc07f0ce3",
      "name": "Fusionner",
      "type": "n8n-nodes-base.merge",
      "position": [
        80,
        368
      ],
      "parameters": {
        "numberInputs": 5
      },
      "typeVersion": 3.2
    },
    {
      "id": "0dc0d5a7-2a7a-456b-a7e5-f62982d15b9b",
      "name": "Déclencheur Planifié",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -592,
        416
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "weeks",
              "triggerAtDay": [
                1,
                3,
                5
              ]
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "a3a4a5b8-e80a-4759-9ab3-5a259f619472",
      "name": "Note Adhésive",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -640,
        -336
      ],
      "parameters": {
        "color": 4,
        "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 leads, customer records, documents, SQL query results, and engagement metrics.*\n\n## Pre-Processing: \n\n*Each dataset tagged with a unique source identifier to maintain traceability and avoid confusion during merging.*"
      },
      "typeVersion": 1
    },
    {
      "id": "a848bbf0-dcde-4395-b67e-d0b4f60bf7dc",
      "name": "Note Adhésive1",
      "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.).*"
      },
      "typeVersion": 1
    },
    {
      "id": "72ee4227-8bcd-434f-b327-b9fd57e46861",
      "name": "Note Adhésive2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        464,
        -336
      ],
      "parameters": {
        "color": 3,
        "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.*"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "connections": {
    "2a5bdc85-b754-485b-a1fd-435cc07f0ce3": {
      "main": [
        [
          {
            "node": "6f84ea01-55ec-4112-a4d4-11fba9f993ec",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a8ee48b5-188d-49b8-963f-1570683b3b55": {
      "main": [
        [
          {
            "node": "b9c0f9ac-ba41-4162-bcbd-f529d4a49c09",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0dc0d5a7-2a7a-456b-a7e5-f62982d15b9b": {
      "main": [
        [
          {
            "node": "b28ea25c-3c5e-44ca-856f-d5f057fce8ab",
            "type": "main",
            "index": 0
          },
          {
            "node": "04b2a7c3-f5aa-412c-a764-75a6f26e8c28",
            "type": "main",
            "index": 0
          },
          {
            "node": "28dd8f01-9a48-473d-926c-ad9eb94ca7b4",
            "type": "main",
            "index": 0
          },
          {
            "node": "e26d6c59-0d46-4abd-a9cc-82ea2894402e",
            "type": "main",
            "index": 0
          },
          {
            "node": "a8ee48b5-188d-49b8-963f-1570683b3b55",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "28dd8f01-9a48-473d-926c-ad9eb94ca7b4": {
      "main": [
        [
          {
            "node": "f480146b-4152-4837-a556-d178ea0d33dc",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ed6ff028-8eb9-4ba8-8d82-e3f9ba9f129a": {
      "main": [
        [
          {
            "node": "2a5bdc85-b754-485b-a1fd-435cc07f0ce3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e26d6c59-0d46-4abd-a9cc-82ea2894402e": {
      "main": [
        [
          {
            "node": "e55e3811-2291-4e40-9b1f-37e7c7fbe5ad",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f480146b-4152-4837-a556-d178ea0d33dc": {
      "main": [
        [
          {
            "node": "2a5bdc85-b754-485b-a1fd-435cc07f0ce3",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "04b2a7c3-f5aa-412c-a764-75a6f26e8c28": {
      "main": [
        [
          {
            "node": "3a01720f-8434-4a36-b02e-d14d9ab092c5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b9c0f9ac-ba41-4162-bcbd-f529d4a49c09": {
      "main": [
        [
          {
            "node": "2a5bdc85-b754-485b-a1fd-435cc07f0ce3",
            "type": "main",
            "index": 4
          }
        ]
      ]
    },
    "3a01720f-8434-4a36-b02e-d14d9ab092c5": {
      "main": [
        [
          {
            "node": "2a5bdc85-b754-485b-a1fd-435cc07f0ce3",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "e55e3811-2291-4e40-9b1f-37e7c7fbe5ad": {
      "main": [
        [
          {
            "node": "2a5bdc85-b754-485b-a1fd-435cc07f0ce3",
            "type": "main",
            "index": 3
          }
        ]
      ]
    },
    "b28ea25c-3c5e-44ca-856f-d5f057fce8ab": {
      "main": [
        [
          {
            "node": "ed6ff028-8eb9-4ba8-8d82-e3f9ba9f129a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6f84ea01-55ec-4112-a4d4-11fba9f993ec": {
      "main": [
        [
          {
            "node": "d7a22005-d249-4a68-a970-b72e59639ea2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Foire aux questions

Comment utiliser ce workflow ?

Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.

Dans quelles scénarios ce workflow est-il adapté ?

Avancé - Création de contenu, IA Multimodale

Est-ce payant ?

Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.

Workflows recommandés

Workflow de contenu WordPress piloté par l'IA
Utiliser OpenAI GPT pour automatiser la publication de blog de PostgreSQL à WordPress
If
Code
Postgres
+
If
Code
Postgres
12 NœudsAvkash Kakdiya
Création de contenu
Générateur d'images de produits IA - Modèles publics
Création automatisée d'images publicitaires pour produits avec OpenAI, Gemini et Google Workspace
Code
Google Drive
Http Request
+
Code
Google Drive
Http Request
15 NœudsAvkash Kakdiya
Création de contenu
Flux de travail de clôture des pistes froides
Fermeture automatique des pistes froides HubSpot basée sur les retours Gmail et les notifications Slack
Code
Gmail
Slack
+
Code
Gmail
Slack
15 NœudsAvkash Kakdiya
Création de contenu
Synchronisation FTP vers le cloud
Transférer automatiquement des fichiers FTP vers Google Drive par lots
Ftp
Google Drive
Split In Batches
+
Ftp
Google Drive
Split In Batches
9 NœudsAvkash Kakdiya
Création de contenu
Freshdesk-Linear Bridge
Synchronisation bidirectionnelle des tickets entre Freshdesk et Linear avec journalisation des erreurs
If
Webhook
Function
+
If
Webhook
Function
22 NœudsAvkash Kakdiya
Création de contenu
08 - Génération de vidéos IA
Créer des vidéos courtes sur n'importe quel sujet avec OpenAI, Veo 3 et Gmail
If
Wait
Gmail
+
If
Wait
Gmail
14 NœudsAvkash Kakdiya
Création de contenu
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds17
Catégorie2
Types de nœuds9
Description de la difficulté

Adapté aux utilisateurs avancés, avec des workflows complexes contenant 16+ nœuds

Auteur
Avkash Kakdiya

Avkash Kakdiya

@itechnotion

🚀 Founder of iTechNotion — we build custom AI-powered automation workflows for startups, agencies, and founders. 💡 Specializing in agentic AI systems, content automation, sales funnels, and digital workers. 🔧 14+ years in tech | Building scalable no-code/low-code solutions using n8n, OpenAI, and other API-first tools. 📬 Let’s automate what slows you down.

Liens externes
Voir sur n8n.io →

Partager ce workflow

Catégories

IA Multimodale
1540
Intelligence Artificielle
1108
Création de contenu
695
Résumé IA
516
Marketing
419
Chatbot IA
251
Ingénierie
241
Étude de marché
203
Divers
193
Autres
176
Ventes
162
Opérations IT
156
Extraction de documents
147
RAG IA
146
Blocs de construction
144
Réseaux sociaux
137
Génération de leads
125
Productivité personnelle
117
DevOps
111
Ressources Humaines
101
Support
97
Nurturing de leads
87
CRM
82
Finance
81
Produit
77
Chatbot de support
76
Design
70
Gestion des tickets
67
Opérations de sécurité
57
Traitement des factures
53
Trading crypto
49
Gestion de fichiers
39
Gestion de projet
35
Wiki interne
32

Catégories: 34