Usar GPT-4.1-mini para generar descripciones de IA para nuevas entradas de Google Sheets
Intermedio
Este es unContent Creation, Multimodal AIflujo de automatización del dominio deautomatización que contiene 9 nodos.Utiliza principalmente nodos como GoogleSheets, Agent, GoogleSheetsTrigger, LmChatOpenAi, OutputParserStructured. Usar GPT-4.1-mini para generar descripciones de AI para nuevas entradas de Google Sheets
Requisitos previos
- •Credenciales de API de Google Sheets
- •Clave de API de OpenAI
Nodos utilizados (9)
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
{
"meta": {
"instanceId": "ad0113c344ee237399e44e9f11798b05baeb83a6196d514a9ae9d2ad71c3b5c9",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "0ad754e7-e05a-4935-a792-f3178248099a",
"name": "OpenAI Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-1024,
160
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "4l6TDfLZVFS24g3X",
"name": "OpenAi account 4"
}
},
"typeVersion": 1.2
},
{
"id": "7f83e0b2-5561-480f-b3c6-9bba76158752",
"name": "Structured Output Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
-832,
128
],
"parameters": {
"jsonSchemaExample": "{\n\t\"description\": \"description\"\n}"
},
"typeVersion": 1.3
},
{
"id": "d88108ee-e1a0-43d2-948a-37bd706a33b5",
"name": "Actualizar fila en hoja",
"type": "n8n-nodes-base.googleSheets",
"position": [
-672,
-336
],
"parameters": {
"columns": {
"value": {
"topic": "={{ $('Row added - Google Sheet').item.json.topic }}",
"description": "={{ $json.output.description }}"
},
"schema": [
{
"id": "topic",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "topic",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "description",
"type": "string",
"display": true,
"required": false,
"displayName": "description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"topic"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs/edit#gid=0",
"cachedResultName": "data"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs/edit?usp=drivesdk",
"cachedResultName": "Sheets Triggers"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "HlBW2puZbuCCq8jJ",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.7
},
{
"id": "bfa0fde3-6ddb-4e69-a1d5-b6d86ef89672",
"name": "Agregar fila en hoja",
"type": "n8n-nodes-base.googleSheets",
"position": [
-656,
-32
],
"parameters": {
"columns": {
"value": {
"Update": "={{ $('Row added - Google Sheet').item.json.topic }} was added"
},
"schema": [
{
"id": "Update",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Update",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"topic"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 196803262,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs/edit#gid=196803262",
"cachedResultName": "actions"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs/edit?usp=drivesdk",
"cachedResultName": "Sheets Triggers"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "HlBW2puZbuCCq8jJ",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.7
},
{
"id": "ae9c19db-71eb-4b38-adba-ca5d7468bdc2",
"name": "Sticky Note16",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2432,
-656
],
"parameters": {
"width": 2016,
"content": "## 📬 Need Help or Want to Customize This?\n📧 [robert@ynteractive.com](mailto:robert@ynteractive.com) \n🔗 [LinkedIn](https://www.linkedin.com/in/robert-breen-29429625/)"
},
"typeVersion": 1
},
{
"id": "6196c4fc-679c-4b5e-bbcc-685917d4fa5a",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2432,
-480
],
"parameters": {
"color": 5,
"width": 904,
"height": 860,
"content": "### Step 1: Set Up Your Google Sheets\n\n**Option 1: Use Our Pre-Made Template (Recommended)**\n1. Copy our template: [AI Description Generator Template](https://docs.google.com/spreadsheets/d/1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs/edit?usp=sharing)\n2. Click \"File\" → \"Make a copy\" to create your own version\n3. Rename it as desired (e.g., \"My AI Content Generator\")\n4. Note your new sheet's URL - you'll need this for the workflow\n\n**Option 2: Create From Scratch**\n1. Go to [Google Sheets](https://sheets.google.com/)\n2. Create a new spreadsheet\n3. **Set up the main \"data\" tab:**\n - Rename \"Sheet1\" to \"data\"\n - Set up column headers in row 1:\n - A1: `topic`\n - B1: `description`\n4. **Create an \"actions\" tab:**\n - Add a new sheet and name it \"actions\"\n - Set up column headers:\n - A1: `Update`\n5. Copy your sheet's URL\n\n### Step 2: Configure Google API Access\n\n1. **Enable Google Sheets API**\n - Go to [Google Cloud Console](https://console.cloud.google.com/)\n - Create a new project or select existing one\n - Enable \"Google Sheets API\"\n - Enable \"Google Drive API\"\n\n"
},
"typeVersion": 1
},
{
"id": "ab630ed2-52a0-42ac-9e3d-3d9826ceb7e4",
"name": "Fila añadida - Google Sheet",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-1376,
96
],
"parameters": {
"event": "rowAdded",
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs/edit#gid=0",
"cachedResultName": "data"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs/edit?usp=drivesdk",
"cachedResultName": "Sheets Triggers"
}
},
"credentials": {
"googleSheetsTriggerOAuth2Api": {
"id": "5qZk3IRejGCu9qrm",
"name": "Google Sheets Trigger account"
}
},
"typeVersion": 1
},
{
"id": "5b4d1f11-89c8-4b38-89f1-2e353eaa9b40",
"name": "Description Writer",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
-992,
-112
],
"parameters": {
"text": "={{ $json.topic }}",
"options": {
"systemMessage": "write a description of the topic. \n\noutput like this. \n\n{\n\t\"description\": \"description\"\n}"
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 2.2
},
{
"id": "8150251e-63e2-43a0-8952-85b86c796df0",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1504,
-480
],
"parameters": {
"color": 4,
"width": 1096,
"height": 860,
"content": "\n### Step 4: Import and Configure the N8N Workflow\n\n1. **Import the Workflow**\n - Copy the workflow JSON from the template\n - In your N8N instance, go to Workflows → Import from JSON\n - Paste the JSON and import\n\n2. **Configure OpenAI Credentials**\n - Click on the \"OpenAI Chat Model\" node\n - Set up credentials using your OpenAI API key\n - Test the connection to ensure it works\n\n3. **Configure Google Sheets Integration**\n \n **For the Trigger Node:**\n - Click on \"Row added - Google Sheet\" node\n - Set up Google Sheets Trigger OAuth2 credentials\n - Select your spreadsheet from the dropdown\n - Choose the \"data\" sheet\n - Set polling to \"Every Minute\" (already configured)\n\n"
},
"typeVersion": 1
}
],
"pinData": {
"Row added - Google Sheet": [
{
"topic": "n8n",
"description": ""
}
]
},
"connections": {
"0ad754e7-e05a-4935-a792-f3178248099a": {
"ai_languageModel": [
[
{
"node": "5b4d1f11-89c8-4b38-89f1-2e353eaa9b40",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"5b4d1f11-89c8-4b38-89f1-2e353eaa9b40": {
"main": [
[
{
"node": "d88108ee-e1a0-43d2-948a-37bd706a33b5",
"type": "main",
"index": 0
},
{
"node": "bfa0fde3-6ddb-4e69-a1d5-b6d86ef89672",
"type": "main",
"index": 0
}
]
]
},
"ab630ed2-52a0-42ac-9e3d-3d9826ceb7e4": {
"main": [
[
{
"node": "5b4d1f11-89c8-4b38-89f1-2e353eaa9b40",
"type": "main",
"index": 0
}
]
]
},
"7f83e0b2-5561-480f-b3c6-9bba76158752": {
"ai_outputParser": [
[
{
"node": "5b4d1f11-89c8-4b38-89f1-2e353eaa9b40",
"type": "ai_outputParser",
"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?
Intermedio - 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
Escritor y editor de blogs
Editor de escritura y edición de blogs con memoria basada en Google Sheets (GPT-4)
If
Code
Filter
+
If
Code
Filter
18 NodosRobert Breen
Creación de contenido
Grabador de notas de podcast
Crear guiones de anuncios de Meta de alta tasa de conversión utilizando datos de rendimiento combinados de GPT y Gemini
Set
Google Sheets
Manual Trigger
+
Set
Google Sheets
Manual Trigger
12 NodosRobert Breen
Creación de contenido
Traducción automática multilingüe de contenido de blog
Traducir automáticamente contenido de blog a múltiples idiomas usando GPT-4o y Markdown
Set
Merge
Split Out
+
Set
Merge
Split Out
12 NodosRobert Breen
Creación de contenido
Extracción de datos estructurados de Dun & Bradstreet (GPT-4o)
Usar GPT-4o para extraer datos estructurados de informes de Dun & Bradstreet
Http Request
Convert To File
Agent
+
Http Request
Convert To File
Agent
11 NodosRobert Breen
Creación de contenido
Generar títulos de Instagram a partir del análisis de etiquetas con Apify + GPT-4o-mini
Usar Apify + GPT-4o-mini para generar títulos de Instagram a partir del análisis de etiquetas
Set
Code
Merge
+
Set
Code
Merge
17 NodosRobert Breen
Creación de contenido
Chatbot de Sitio Web con IA - Recopilación de Leads CRM con GPT y Hojas de Google
Sistema de recopilación de leads CRM integrando un chatbot de sitio web con IA, GPT y Hojas de Google
Code
Google Sheets
Agent
+
Code
Google Sheets
Agent
14 NodosRobert Breen
Generación de leads
Información del flujo de trabajo
Nivel de dificultad
Intermedio
Número de nodos9
Categoría2
Tipos de nodos6
Descripción de la dificultad
Autor
Robert Breen
@rbreenProfessional services consultant with over 10 years of experience solving complex business problems across industries. I specialize in n8n and process automation—designing custom workflows that integrate tools like Google Calendar, Airtable, GPT, and internal systems. Whether you need to automate scheduling, sync data, or streamline operations, I build solutions that save time and drive results.
Enlaces externos
Ver en n8n.io →
Compartir este flujo de trabajo