Integración de datos
Avanzado
Este es unContent Creation, Multimodal AIflujo de automatización del dominio deautomatización que contiene 17 nodos.Utiliza principalmente nodos como Merge, MongoDb, Function, Postgres, GoogleSheets. Integrar 5 fuentes de datos utilizando SQL, MongoDB y herramientas de Google para informes automatizados
Requisitos previos
- •Cadena de conexión de MongoDB
- •Información de conexión de la base de datos PostgreSQL
- •Credenciales de API de Google Sheets
Nodos utilizados (17)
Categoría
Vista previa del flujo de trabajo
Visualización de las conexiones entre nodos, con soporte para zoom y panorámica
Exportar flujo de trabajo
Copie la siguiente configuración JSON en n8n para importar y usar este flujo de trabajo
{
"name": "Integrated Data Consolidation",
"nodes": [
{
"id": "b28ea25c-3c5e-44ca-856f-d5f057fce8ab",
"name": "📄 Fuente 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": "🐘 Fuente 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": "🍃 Fuente 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": "⚙️ Procesar Datos Combinados",
"type": "n8n-nodes-base.function",
"position": [
288,
416
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d7a22005-d249-4a68-a970-b72e59639ea2",
"name": "📊 Hoja Google Final",
"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": "Agregar ID de Fuente Sheets",
"type": "n8n-nodes-base.function",
"position": [
-144,
32
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3a01720f-8434-4a36-b02e-d14d9ab092c5",
"name": "Agregar ID de Fuente PostgreSQL",
"type": "n8n-nodes-base.function",
"position": [
-144,
224
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e55e3811-2291-4e40-9b1f-37e7c7fbe5ad",
"name": "Agregar ID de Fuente Servidor SQL",
"type": "n8n-nodes-base.function",
"position": [
-144,
608
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f480146b-4152-4837-a556-d178ea0d33dc",
"name": "Agregar ID de Fuente MongoDB",
"type": "n8n-nodes-base.function",
"position": [
-144,
416
],
"parameters": {},
"typeVersion": 1
},
{
"id": "b9c0f9ac-ba41-4162-bcbd-f529d4a49c09",
"name": "Agregar ID de Fuente 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": "Combinar",
"type": "n8n-nodes-base.merge",
"position": [
80,
368
],
"parameters": {
"numberInputs": 5
},
"typeVersion": 3.2
},
{
"id": "0dc0d5a7-2a7a-456b-a7e5-f62982d15b9b",
"name": "Activador Programado",
"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": "Nota Adhesiva",
"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": "Nota Adhesiva1",
"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": "Nota Adhesiva2",
"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
}
]
]
}
}
}Preguntas frecuentes
¿Cómo usar este flujo de trabajo?
Copie el código de configuración JSON de arriba, cree un nuevo flujo de trabajo en su instancia de n8n y seleccione "Importar desde JSON", pegue la configuración y luego modifique la configuración de credenciales según sea necesario.
¿En qué escenarios es adecuado este flujo de trabajo?
Avanzado - Creación de contenido, IA Multimodal
¿Es de pago?
Este flujo de trabajo es completamente gratuito, puede importarlo y usarlo directamente. Sin embargo, tenga en cuenta que los servicios de terceros utilizados en el flujo de trabajo (como la API de OpenAI) pueden requerir un pago por su cuenta.
Flujos de trabajo relacionados recomendados
Flujo de trabajo de contenido de WordPress impulsado por IA
Usar OpenAI GPT para automatizar la publicación de blogs de PostgreSQL a WordPress
If
Code
Postgres
+
If
Code
Postgres
12 NodosAvkash Kakdiya
Creación de contenido
Generador de imágenes de productos de IA - plantilla pública
Creación automatizada de imágenes publicitarias de productos usando OpenAI, Gemini y Google Workspace
Code
Google Drive
Http Request
+
Code
Google Drive
Http Request
15 NodosAvkash Kakdiya
Creación de contenido
Flujo de trabajo de cierre de ventas para prospectos fríos
Cierre automático de deals de fríos de HubSpot basado en retroalimentación de Gmail y notificaciones de Slack
Code
Gmail
Slack
+
Code
Gmail
Slack
15 NodosAvkash Kakdiya
Creación de contenido
Sincronización de FTP a la nube
Transferir automáticamente archivos de FTP a Google Drive por lotes
Ftp
Google Drive
Split In Batches
+
Ftp
Google Drive
Split In Batches
9 NodosAvkash Kakdiya
Creación de contenido
Puente Freshdesk-Linear
Sincronización bidireccional de tickets entre Freshdesk y Linear, con registro de errores
If
Webhook
Function
+
If
Webhook
Function
22 NodosAvkash Kakdiya
Creación de contenido
08 - Generación de video con IA
Crear videos cortos para cualquier tema usando OpenAI, Veo 3 y Gmail
If
Wait
Gmail
+
If
Wait
Gmail
14 NodosAvkash Kakdiya
Creación de contenido
Información del flujo de trabajo
Nivel de dificultad
Avanzado
Número de nodos17
Categoría2
Tipos de nodos9
Descripción de la dificultad
Autor
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.
Enlaces externos
Ver en n8n.io →
Compartir este flujo de trabajo