Extraer y organizar publicaciones académicas usando GPT-4 Mini, Google Sheets y Gmail
Avanzado
Este es unautomatización que contiene 26 nodos.Utiliza principalmente nodos como Html, Sort, Gmail, Switch, SplitOut. Extraer y organizar publicaciones académicas usando GPT-4 Mini, Google Sheets y Gmail
Requisitos previos
- •Cuenta de Google y credenciales de API de Gmail
- •Pueden requerirse credenciales de autenticación para la API de destino
- •Credenciales de API de Google Sheets
- •Clave de API de OpenAI
Nodos utilizados (26)
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
{
"id": "RNryWSC0apJGzqyR",
"meta": {
"instanceId": "b91e510ebae4127f953fd2f5f8d40d58ca1e71c746d4500c12ae86aad04c1502",
"templateCredsSetupCompleted": true
},
"name": "Extract & Organize Academic Publications with GPT-4 Mini, Google Sheets & Gmail",
"tags": [
{
"id": "6j6b2V0RliqC08cJ",
"name": "web-scraping",
"createdAt": "2025-09-20T08:49:15.037Z",
"updatedAt": "2025-09-20T08:49:15.037Z"
},
{
"id": "cXtzhMFhVn8afG5q",
"name": "ai-extraction",
"createdAt": "2025-09-20T08:49:15.072Z",
"updatedAt": "2025-09-20T08:49:15.072Z"
},
{
"id": "gZQUGdjmN7e6kMwE",
"name": "academic-research",
"createdAt": "2025-09-20T08:49:15.090Z",
"updatedAt": "2025-09-20T08:49:15.090Z"
},
{
"id": "pG7av0aT43P2zPBn",
"name": "customizable",
"createdAt": "2025-09-20T10:09:47.065Z",
"updatedAt": "2025-09-20T10:09:47.065Z"
}
],
"nodes": [
{
"id": "db9e10d9-1c6b-4029-bd36-2f4251c45170",
"name": "Obtener contenido del sitio web",
"type": "n8n-nodes-base.httpRequest",
"position": [
240,
336
],
"parameters": {
"url": "={{ $json.URL }}#publications ",
"options": {
"allowUnauthorizedCerts": true
}
},
"typeVersion": 4.1
},
{
"id": "ac9d664f-1a7a-4463-8e27-4afbfb3c6e88",
"name": "Extraer todas las publicaciones de la página",
"type": "n8n-nodes-base.html",
"position": [
464,
336
],
"parameters": {
"options": {
"cleanUpText": true
},
"operation": "extractHtmlContent",
"extractionValues": {
"values": [
{
"key": "summary",
"cssSelector": ".dropDownSummary.textArea h3 ",
"returnArray": true
},
{
"key": "publications",
"cssSelector": ".dropDownSummary.textArea ul ul li",
"returnArray": true
},
{
"key": "bio",
"cssSelector": ".dropDownSummary.textArea "
}
]
}
},
"typeVersion": 1.2
},
{
"id": "7f8666a0-1f5f-45b2-a8ae-4d1c681afb6c",
"name": "OpenAI Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
992,
560
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "OGYj7DgYv5GFLFZk",
"name": "OpenAi account 2"
}
},
"typeVersion": 1.2
},
{
"id": "eeff0140-0ce9-4126-ba89-141028200e18",
"name": "Al enviar el formulario",
"type": "n8n-nodes-base.formTrigger",
"position": [
16,
336
],
"webhookId": "24dd166e-dbcc-477c-91aa-2ec77a0acbbc",
"parameters": {
"options": {},
"formTitle": "Academic Staff Publication",
"formFields": {
"values": [
{
"fieldLabel": "Staff Name"
},
{
"fieldLabel": "URL"
},
{
"fieldLabel": "Email"
},
{
"fieldLabel": "Google Scholar URL"
}
]
}
},
"typeVersion": 2.3
},
{
"id": "b354dcc3-831b-4c8b-93e2-ec5d934d839a",
"name": "Nota adhesiva3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-16,
192
],
"parameters": {
"color": 3,
"width": 1728,
"height": 544,
"content": "# \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nBy CSChin"
},
"typeVersion": 1
},
{
"id": "79bdf992-e9ea-4495-adf7-024278849d02",
"name": "Switch",
"type": "n8n-nodes-base.switch",
"position": [
1904,
688
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "journal_papers",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "e8f90d0e-ec6b-4598-8996-9908fb175db7",
"operator": {
"type": "string",
"operation": "regex"
},
"leftValue": "={{ $json.journal_conference_toLowerCase() }}",
"rightValue": "(journal|ieee transactions|ieee/acm transactions|ieee/asme transaction|energy|applied|advanced engineering informatics|ocean engineering|water|batteries|sensors|processes|soft computing|ieee access|advances in mechanical engineering|neuralcomputing|neural computing|engineering applications of artificial intelligence|energies|renewable|sustainable|review|letters|reports|annals|bulletin|quarterly|monthly|food chemistry|waste management|food bioscience|oil crop science|environmental science and pollution research|polymer composites|progress in organic coatings|carbon|marine pollution bulletin|proceedings|materials letters|acs applied materials and interfaces|acs sustainable chemistry|chemosphere|chemical engineering science|composite structures|data in brief|reinforced plastics|water science |applied clay science|jec composites magazine|computers in biology and medicine|biomechanics and modeling in mechanobiology|rsc advances|process biochemistry|fibers and polymers|lwt|polymers|fermentation|bioprinting|data inbrief|scientific data|chemengineering|polymer testing|composites|composite|polymer|animal|aging cell|advanced materials research|computational materials science|materials research express|chemical engineering and processing|structures|advanced bioceramics|mechanisms and machine science|natural mineral nanatubes|npj heritage science)"
}
]
},
"renameOutput": true
},
{
"outputKey": "conference_papers",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "5cbb30a1-f815-4466-84e0-a0cce000fbc3",
"operator": {
"type": "string",
"operation": "regex"
},
"leftValue": "={{ $json.journal_conference_toLowerCase() }}",
"rightValue": "(conference|symposium|workshop|proceedings|tencon|congress|supercomputingasia|summit|meeting|forum|seminar|colloquium|webinar|icmt|icam|pgsret|cirp|iultcs|fluidization|power generation|micro|nano|heat|mass transfer|computer aided|tolerancing|applied mechanics|experimental mechanics|applied learning|ocean|satec|global conference on materials science and engineering|cmse)"
}
]
},
"renameOutput": true
},
{
"outputKey": "books",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "87b84199-fd0c-4393-adb8-8131225c5061",
"operator": {
"type": "string",
"operation": "regex"
},
"leftValue": "={{ $json.journal_conference_toLowerCase() }}",
"rightValue": "(crc press|springer|publisher|iet|ios press|book|woodhead publishing|trans tech publications ltd)"
}
]
},
"renameOutput": true
},
{
"outputKey": "magazine",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "63e1c345-abb7-44b7-b0d2-eb5580be302c",
"operator": {
"type": "string",
"operation": "regex"
},
"leftValue": "={{ $json.journal_conference_toLowerCase() }}",
"rightValue": "(magazine|potential|news)"
}
]
},
"renameOutput": true
},
{
"outputKey": "patent",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "9592819a-9066-4f0a-b63f-9bc89dd8fcd6",
"operator": {
"type": "string",
"operation": "regex"
},
"leftValue": "={{ $json.journal_conference_toLowerCase() }}",
"rightValue": "(us|singapore)"
}
]
},
"renameOutput": true
}
]
},
"options": {
"fallbackOutput": "extra",
"renameFallbackOutput": "Others"
},
"looseTypeValidation": true
},
"typeVersion": 3.2
},
{
"id": "8a1f8b3e-6ea5-4d38-a142-a49736f2b3c7",
"name": "Nota adhesiva",
"type": "n8n-nodes-base.stickyNote",
"position": [
1728,
192
],
"parameters": {
"width": 816,
"height": 1200,
"content": "# Switch Node: Route by publication type"
},
"typeVersion": 1
},
{
"id": "86630849-d08f-4bda-98aa-fcf103c50636",
"name": "Nota adhesiva1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-832,
192
],
"parameters": {
"width": 784,
"height": 832,
"content": "**Source:** https://www.ncl.ac.uk/singapore/staff/profile/chengchin.html#publications\n\n## Overview\nAutomated workflow extracts and organizes academic publications from university profiles using AI. Auto-categorizes and stores in Google Sheets with email notifications.\n\n## Target Audience\nAcademic Researchers, University Administrators, Research Librarians, Department Heads, PhD Students\n\n## Use Cases\nTrack faculty research output • Maintain publication databases • Generate reports by category/year\n\n## Prerequisites\n**Google Sheets** - API access, Spreadsheet IDs | **OpenAI API** - API key, GPT-4/3.5 access | **Gmail** - OAuth2 credentials (optional)\n\n## Workflow Architecture\n**Main Flow:** Form submission → Fetch/parse HTML → Split publications → AI extracts data\n**Path A:** Save to master sheet → Route by type to category sheets (Journal, Conference, Book, Magazine, Preprints, Other)\n**Path B:** Convert to CSV → Send email\n\n## Setup Instructions\n**1. OpenAI:** Model: gpt-4-turbo, Temperature: 0.3, Prompt: Extract title, authors, year, type, venue, DOI, URL\n**2. Google Sheets:** Append to master and category sheets\n**3. Routing:** Route by publication type\n**4. Email:** Subject: Publications Scraped | Body: Summary + CSV\n\n## Customization\nAdd fields: Modify prompt • Change categories: Update routing • Multiple universities: Use URL patterns • AI models: GPT-4 or GPT-3.5 • Scheduling: Use Schedule Trigger"
},
"typeVersion": 1
},
{
"id": "20239bcb-0f32-4cdc-965a-2abeab138c1d",
"name": "Separar cada publicación",
"type": "n8n-nodes-base.splitOut",
"position": [
688,
336
],
"parameters": {
"include": "selectedOtherFields",
"options": {},
"fieldToSplitOut": "publications ",
"fieldsToInclude": "Year"
},
"typeVersion": 1
},
{
"id": "0dd69765-b766-4686-9412-106f264993d8",
"name": "Guardar todo en la hoja maestra",
"type": "n8n-nodes-base.googleSheets",
"position": [
1264,
240
],
"parameters": {
"columns": {
"value": {
"year": "={{ $json.output.publications[0].year }}",
"authors": "={{ $json.output.publications[0].authors }}",
"journal_conference": "={{ $json.output.publications[0].journal_conference }}"
},
"schema": [
{
"id": "authors",
"type": "string",
"display": true,
"required": false,
"displayName": "authors",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "journal_conference",
"type": "string",
"display": true,
"required": false,
"displayName": "journal_conference",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "year",
"type": "string",
"display": true,
"required": false,
"displayName": "year",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 834341142,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k/edit#gid=834341142",
"cachedResultName": "all"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k/edit?usp=drivesdk",
"cachedResultName": "publication"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "hQFe8XTqJEiHL03Z",
"name": "Google Sheets account"
}
},
"typeVersion": 4.2
},
{
"id": "40942434-5fe1-4248-b373-863e1410e12a",
"name": "Enviar correo de notificación",
"type": "n8n-nodes-base.gmail",
"position": [
1488,
432
],
"webhookId": "bb625b4b-3e1c-4e67-874d-0ad9da2ca108",
"parameters": {
"sendTo": "{{ $json.Email }}",
"message": "=Hey, here's the scraped data of your publication from your {{ $('On form submission').item.json.URL }}!",
"options": {
"attachmentsUi": {
"attachmentsBinary": [
{}
]
}
},
"subject": "=publication csv for {{ $('On form submission').item.json['Staff Name'] }}"
},
"credentials": {
"gmailOAuth2": {
"id": "TbUa3sBo9ouHTYFh",
"name": "Gmail account 3"
}
},
"typeVersion": 2.1
},
{
"id": "0efd2d3b-af35-4791-bb28-027a3ad88e3d",
"name": "Formatear como CSV Export",
"type": "n8n-nodes-base.convertToFile",
"position": [
1264,
432
],
"parameters": {
"options": {}
},
"typeVersion": 1.1
},
{
"id": "d4c47234-566c-44a3-a157-7d5b58c01148",
"name": "Ordenar por año (Revista)",
"type": "n8n-nodes-base.sort",
"position": [
2128,
272
],
"parameters": {
"options": {},
"sortFieldsUi": {
"sortField": [
{
"order": "descending",
"fieldName": "year"
}
]
}
},
"typeVersion": 1
},
{
"id": "87d96dc4-fc62-4eb3-9147-6d0ec12f0afa",
"name": "Ordenar por año (Conferencia)",
"type": "n8n-nodes-base.sort",
"position": [
2128,
464
],
"parameters": {
"options": {},
"sortFieldsUi": {
"sortField": [
{
"order": "descending",
"fieldName": "year"
}
]
}
},
"typeVersion": 1
},
{
"id": "1d4d4253-e2da-4ccf-9bba-219225eebf4c",
"name": "Ordenar por año (Libro)",
"type": "n8n-nodes-base.sort",
"position": [
2128,
656
],
"parameters": {
"options": {},
"sortFieldsUi": {
"sortField": [
{
"order": "descending",
"fieldName": "year"
}
]
}
},
"typeVersion": 1
},
{
"id": "733ab00d-d029-493d-947e-346e54336da2",
"name": "Ordenar por año (Revista/Magacín)",
"type": "n8n-nodes-base.sort",
"position": [
2128,
848
],
"parameters": {
"options": {},
"sortFieldsUi": {
"sortField": [
{
"order": "descending",
"fieldName": "year"
}
]
}
},
"typeVersion": 1
},
{
"id": "4a140857-3012-4dbe-ace4-c02b2ab794d5",
"name": "Ordenar por año (Patente)",
"type": "n8n-nodes-base.sort",
"position": [
2128,
1040
],
"parameters": {
"options": {},
"sortFieldsUi": {
"sortField": [
{
"order": "descending",
"fieldName": "year"
}
]
}
},
"typeVersion": 1
},
{
"id": "63a9925d-8223-4ecf-bb91-0b7e8d14dbe5",
"name": "Ordenar por año (Otro)",
"type": "n8n-nodes-base.sort",
"position": [
2128,
1232
],
"parameters": {
"options": {},
"sortFieldsUi": {
"sortField": [
{
"order": "descending",
"fieldName": "year"
}
]
}
},
"typeVersion": 1
},
{
"id": "69edf87d-8d76-4991-9e29-d5ded3c9c895",
"name": "Añadir a la hoja de conferencias",
"type": "n8n-nodes-base.googleSheets",
"position": [
2352,
464
],
"parameters": {
"columns": {
"value": {
"year": "={{ $json.year }}",
"count": "={{ $json.count_journal_conference }}",
"conference": "={{ $json.journal_conference }}"
},
"schema": [
{
"id": "count",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "year",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "conference",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "conference",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"count"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 963306312,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k/edit#gid=963306312",
"cachedResultName": "conference"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k/edit?usp=drivesdk",
"cachedResultName": "publication"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "KBo80D4RMDyyBspg",
"name": "Google Sheets account 2"
}
},
"typeVersion": 4.7
},
{
"id": "1143a4fb-5f39-4ccb-89df-ea9302222afe",
"name": "Generar informe resumido",
"type": "@n8n/n8n-nodes-langchain.informationExtractor",
"position": [
912,
336
],
"parameters": {
"text": "={{ $json.publications }}",
"options": {
"systemPromptTemplate": "You are an expert extraction algorithm.\nOnly extract author names, journal, conference and year information from the text.\nIf you do not know the value of an attribute asked to extract, you may omit the attribute's value."
},
"schemaType": "fromJson",
"jsonSchemaExample": "{\n \"publications\": [\n {\n \"authors\": \"Author1, Author2, Author3\",\n \"journal_conference\": \"Journal of Example Research\",\n \"year\": \"2023\"\n }\n ]\n}"
},
"typeVersion": 1.2
},
{
"id": "49669d21-3046-4a76-bbb4-8dfb9c3de5b6",
"name": "Calcular estadísticas de publicaciones (Conteo)",
"type": "n8n-nodes-base.summarize",
"position": [
1488,
240
],
"parameters": {
"options": {},
"fieldsToSplitBy": "journal_conference,year",
"fieldsToSummarize": {
"values": [
{
"field": "journal_conference"
}
]
}
},
"typeVersion": 1.1
},
{
"id": "9e06c0d3-35e8-4724-90bf-f64071f1f4ab",
"name": "Añadir a la hoja de libros",
"type": "n8n-nodes-base.googleSheets",
"position": [
2352,
656
],
"parameters": {
"columns": {
"value": {
"book": "={{ $json.journal_conference }}",
"year": "={{ $json.year }}",
"count": "={{ $json.count_journal_conference }}"
},
"schema": [
{
"id": "count",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "year",
"type": "string",
"display": true,
"required": false,
"displayName": "year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "book",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "book",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"count"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1003783807,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k/edit#gid=1003783807",
"cachedResultName": "book"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k/edit?usp=drivesdk",
"cachedResultName": "publication"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "KBo80D4RMDyyBspg",
"name": "Google Sheets account 2"
}
},
"typeVersion": 4.7
},
{
"id": "aba55bb1-e449-449b-8679-0fa2fb366c34",
"name": "Añadir a la hoja de revistas/magacines",
"type": "n8n-nodes-base.googleSheets",
"position": [
2352,
848
],
"parameters": {
"columns": {
"value": {
"year": "={{ $json.year }}",
"journal_conference": "={{ $json.journal_conference }}",
"count_journal_conference": "={{ $json.count_journal_conference }}"
},
"schema": [
{
"id": "count_journal_conference",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "count_journal_conference",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "year",
"type": "string",
"display": true,
"required": false,
"displayName": "year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "journal_conference",
"type": "string",
"display": true,
"required": false,
"displayName": "journal_conference",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"count_journal_conference"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1439806152,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k/edit#gid=1439806152",
"cachedResultName": "magazine"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k/edit?usp=drivesdk",
"cachedResultName": "publication"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "KBo80D4RMDyyBspg",
"name": "Google Sheets account 2"
}
},
"typeVersion": 4.7
},
{
"id": "87cfc544-0139-4489-81aa-53f82479f0d9",
"name": "Añadir a la hoja de patentes",
"type": "n8n-nodes-base.googleSheets",
"position": [
2352,
1040
],
"parameters": {
"columns": {
"value": {
"year": "={{ $json.year }}",
"journal_conference": "={{ $json.journal_conference }}",
"count_journal_conference": "={{ $json.count_journal_conference }}"
},
"schema": [
{
"id": "count_journal_conference",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "count_journal_conference",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "year",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "journal_conference",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "journal_conference",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"count_journal_conference"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1401160945,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k/edit#gid=1401160945",
"cachedResultName": "patent"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k/edit?usp=drivesdk",
"cachedResultName": "publication"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "KBo80D4RMDyyBspg",
"name": "Google Sheets account 2"
}
},
"typeVersion": 4.7
},
{
"id": "508f2c4e-2de0-492a-b197-082dcc8634d9",
"name": "Añadir a la hoja de otros",
"type": "n8n-nodes-base.googleSheets",
"position": [
2352,
1232
],
"parameters": {
"columns": {
"value": {
"year": "={{ $json.year }}",
"count": "={{ $json.count_journal_conference }}",
"others": "={{ $json.journal_conference }}"
},
"schema": [
{
"id": "count",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "year",
"type": "string",
"display": true,
"required": false,
"displayName": "year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "others",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "others",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"count"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1185425191,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k/edit#gid=1185425191",
"cachedResultName": "others"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k/edit?usp=drivesdk",
"cachedResultName": "publication"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "KBo80D4RMDyyBspg",
"name": "Google Sheets account 2"
}
},
"typeVersion": 4.7
},
{
"id": "56c6c7a3-0244-439a-a314-e025ee46725c",
"name": "Añadir a la hoja de revistas",
"type": "n8n-nodes-base.googleSheets",
"position": [
2352,
272
],
"parameters": {
"columns": {
"value": {
"year": "={{ $json.year }}",
"count": "={{ $json.count_journal_conference }}",
"journal": "={{ $json.journal_conference }}"
},
"schema": [
{
"id": "count",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "year",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "journal",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "journal",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"count"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1660356448,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k/edit#gid=1660356448",
"cachedResultName": "journal"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k/edit?usp=drivesdk",
"cachedResultName": "publication"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "KBo80D4RMDyyBspg",
"name": "Google Sheets account 2"
}
},
"typeVersion": 4.7
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "9c531d58-08de-4534-a798-d9255593e46f",
"connections": {
"79bdf992-e9ea-4495-adf7-024278849d02": {
"main": [
[
{
"node": "d4c47234-566c-44a3-a157-7d5b58c01148",
"type": "main",
"index": 0
}
],
[
{
"node": "87d96dc4-fc62-4eb3-9147-6d0ec12f0afa",
"type": "main",
"index": 0
}
],
[
{
"node": "1d4d4253-e2da-4ccf-9bba-219225eebf4c",
"type": "main",
"index": 0
}
],
[
{
"node": "733ab00d-d029-493d-947e-346e54336da2",
"type": "main",
"index": 0
}
],
[
{
"node": "4a140857-3012-4dbe-ace4-c02b2ab794d5",
"type": "main",
"index": 0
}
],
[
{
"node": "63a9925d-8223-4ecf-bb91-0b7e8d14dbe5",
"type": "main",
"index": 0
}
]
]
},
"7f8666a0-1f5f-45b2-a8ae-4d1c681afb6c": {
"ai_languageModel": [
[
{
"node": "1143a4fb-5f39-4ccb-89df-ea9302222afe",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"eeff0140-0ce9-4126-ba89-141028200e18": {
"main": [
[
{
"node": "db9e10d9-1c6b-4029-bd36-2f4251c45170",
"type": "main",
"index": 0
}
]
]
},
"1d4d4253-e2da-4ccf-9bba-219225eebf4c": {
"main": [
[
{
"node": "9e06c0d3-35e8-4724-90bf-f64071f1f4ab",
"type": "main",
"index": 0
}
]
]
},
"0efd2d3b-af35-4791-bb28-027a3ad88e3d": {
"main": [
[
{
"node": "40942434-5fe1-4248-b373-863e1410e12a",
"type": "main",
"index": 0
}
]
]
},
"63a9925d-8223-4ecf-bb91-0b7e8d14dbe5": {
"main": [
[
{
"node": "508f2c4e-2de0-492a-b197-082dcc8634d9",
"type": "main",
"index": 0
}
]
]
},
"db9e10d9-1c6b-4029-bd36-2f4251c45170": {
"main": [
[
{
"node": "ac9d664f-1a7a-4463-8e27-4afbfb3c6e88",
"type": "main",
"index": 0
}
]
]
},
"4a140857-3012-4dbe-ace4-c02b2ab794d5": {
"main": [
[
{
"node": "87cfc544-0139-4489-81aa-53f82479f0d9",
"type": "main",
"index": 0
}
]
]
},
"d4c47234-566c-44a3-a157-7d5b58c01148": {
"main": [
[
{
"node": "56c6c7a3-0244-439a-a314-e025ee46725c",
"type": "main",
"index": 0
}
]
]
},
"1143a4fb-5f39-4ccb-89df-ea9302222afe": {
"main": [
[
{
"node": "0efd2d3b-af35-4791-bb28-027a3ad88e3d",
"type": "main",
"index": 0
},
{
"node": "0dd69765-b766-4686-9412-106f264993d8",
"type": "main",
"index": 0
}
]
]
},
"733ab00d-d029-493d-947e-346e54336da2": {
"main": [
[
{
"node": "aba55bb1-e449-449b-8679-0fa2fb366c34",
"type": "main",
"index": 0
}
]
]
},
"0dd69765-b766-4686-9412-106f264993d8": {
"main": [
[
{
"node": "49669d21-3046-4a76-bbb4-8dfb9c3de5b6",
"type": "main",
"index": 0
}
]
]
},
"20239bcb-0f32-4cdc-965a-2abeab138c1d": {
"main": [
[
{
"node": "1143a4fb-5f39-4ccb-89df-ea9302222afe",
"type": "main",
"index": 0
}
]
]
},
"87d96dc4-fc62-4eb3-9147-6d0ec12f0afa": {
"main": [
[
{
"node": "69edf87d-8d76-4991-9e29-d5ded3c9c895",
"type": "main",
"index": 0
}
]
]
},
"ac9d664f-1a7a-4463-8e27-4afbfb3c6e88": {
"main": [
[
{
"node": "20239bcb-0f32-4cdc-965a-2abeab138c1d",
"type": "main",
"index": 0
}
]
]
},
"49669d21-3046-4a76-bbb4-8dfb9c3de5b6": {
"main": [
[
{
"node": "79bdf992-e9ea-4495-adf7-024278849d02",
"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
¿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
Explorar nodos de n8n en la biblioteca de referencias visuales
Explorar nodos de n8n en la base de referencia visual
If
Ftp
Set
+
If
Ftp
Set
113 NodosI versus AI
Otros
Extracción de itinerarios de PDF a Google Sheets (GPT-4.1-Mini + notificación de Gmail)
Extraer itinerarios de PDF a Google Sheets usando GPT-4.1-Mini y enviar notificaciones por Gmail
Gmail
Split Out
Form Trigger
+
Gmail
Split Out
Form Trigger
9 NodosCheng Siong Chin
Desarrollo de leads y flujos de correo electrónico
Usar Google Maps, SendGrid e IA para automatizar el desarrollo de leads B2B y el marketing por correo electrónico
If
Set
Code
+
If
Set
Code
141 NodosEzema Kingsley Chibuzo
Generación de leads
Análisis automático de reuniones de Microsoft Teams usando GPT-4.1, Outlook y Mem.ai
Análisis automatizado de reuniones de Microsoft Teams con GPT-4.1, Outlook y Mem.ai
If
Set
Code
+
If
Set
Code
61 NodosWayne Simpson
Recursos Humanos
WordPress Blog Automation Pro (Investigación profunda) v2.1 Marketplace
Usar GPT-4o, Perplexity AI y soporte multilingüe para automatizar la creación de blogs optimizados para SEO
If
Set
Xml
+
If
Set
Xml
125 NodosDaniel Ng
Creación de contenido
Automatizar la preparación de reuniones de ventas y enviar a WhatsApp con IA y APIFY
Automatización de la preparación de reuniones de ventas y envío a WhatsApp con IA y APIFY
If
Set
Html
+
If
Set
Html
61 NodosJimleuk
Ventas
Información del flujo de trabajo
Nivel de dificultad
Avanzado
Número de nodos26
Categoría-
Tipos de nodos13
Descripción de la dificultad
Autor
Cheng Siong Chin
@cschinProf. Cheng Siong CHIN serves as Chair Professor in Intelligent Systems Modelling and Simulation in Newcastle University, Singapore. His academic credentials include an M.Sc. in Advanced Control and Systems Engineering from The University of Manchester and a Ph.D. in Robotics from Nanyang Technological University.
Enlaces externos
Ver en n8n.io →
Compartir este flujo de trabajo