The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"name": "Jira[AI] Form",
"nodes": [
{
"parameters": {
"project": {
"__rl": true,
"value": "10454",
"mode": "list",
"cachedResultName": "Proyecto Prueba 2.0"
},
"issueType": {
"__rl": true,
"value": "10441",
"mode": "list",
"cachedResultName": "Historia"
},
"summary": "={{ $json.resultado }}",
"additionalFields": {}
},
"type": "n8n-nodes-base.jira",
"typeVersion": 1,
"position": [
540,
-180
],
"id": "28ab72ac-30e7-427f-9f8e-486452e85f7a",
"name": "Jira Software"
},
{
"parameters": {
"rule": {
"interval": [
{
"field": "seconds",
"secondsInterval": 10
}
]
}
},
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1.2,
"position": [
-420,
-80
],
"id": "8b6acd55-cb8e-4946-8615-9646373986f0",
"name": "Schedule Trigger",
"disabled": true
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "={{ $json.url_sheets }}",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "Historias",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1eGbQRdFwbaHfFpQyyK8HPHO34tA1S_mFDnfEjM0rOy0/edit#gid=0"
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.6,
"position": [
-40,
-320
],
"id": "92bd5f96-9822-4be1-8037-7202006f0204",
"name": "Hoja Historias"
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "={{ $json.url_sheets }}",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": 670051511,
"mode": "list",
"cachedResultName": "descripcion",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1eGbQRdFwbaHfFpQyyK8HPHO34tA1S_mFDnfEjM0rOy0/edit#gid=670051511"
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.6,
"position": [
-40,
-140
],
"id": "bb8613d1-acb6-4343-8599-3afe56f8126a",
"name": "Google Sheets"
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "345a7891-a3ce-49e6-a15e-5caf2473fcb9",
"name": "url_sheets",
"value": "1eGbQRdFwbaHfFpQyyK8HPHO34tA1S_mFDnfEjM0rOy0",
"type": "string"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
-260,
-240
],
"id": "304a3a1a-e5a1-40b7-915d-23e54836ed66",
"name": "Edit Fields"
},
{
"parameters": {},
"type": "n8n-nodes-base.manualTrigger",
"typeVersion": 1,
"position": [
-420,
-240
],
"id": "1523be74-59b6-4442-b9a2-84ee6cba11b3",
"name": "When clicking \u2018Execute workflow\u2019"
},
{
"parameters": {
"mode": "combine",
"combineBy": "combineAll",
"options": {}
},
"type": "n8n-nodes-base.merge",
"typeVersion": 3.2,
"position": [
140,
-240
],
"id": "2847e8c0-1472-4d6f-9004-52e06cff542a",
"name": "Merge"
},
{
"parameters": {
"jsCode": "const proyectokey = $input.first().json.fields.project.id;\nconst keytarea = $('Datos_Estaticos_Proyecto_tipo_tareas1').first().json.resultado;\nconst parent_issue_key = $input.first().json.key\n\nreturn [\n {\n json: {\n keytarea: keytarea,\n codigo_tipo_tarea: \"TANA_01\",\n nombre_tipo_tarea: \"Tarea de An\u00e1lisis\",\n issue_type: \"10462\",//An\u00e1lisis\n proyecto: proyectokey,\n parent_issue_key: parent_issue_key\n }\n },\n {\n json: {\n keytarea: keytarea,\n codigo_tipo_tarea: \"VANA_01\",\n nombre_tipo_tarea: \"Verificaci\u00f3n par de An\u00e1lisis\",\n issue_type: \"10417\",//Ver. An\u00e1lisis\n proyecto: proyectokey,\n parent_issue_key: parent_issue_key\n }\n },\n {\n json: {\n keytarea: keytarea,\n codigo_tipo_tarea: \"TDES_01\",\n nombre_tipo_tarea: \"Tarea de Dise\u00f1o\",\n issue_type: \"10463\",//Dise\u00f1o\n proyecto: proyectokey,\n parent_issue_key: parent_issue_key\n }\n },\n {\n json: {\n keytarea: keytarea,\n codigo_tipo_tarea: \"VDES_01\",\n nombre_tipo_tarea: \"Verificaci\u00f3n par de Dise\u00f1o\",\n issue_type: \"10418\",//Ver. Dise\u00f1o\n proyecto: proyectokey,\n parent_issue_key: parent_issue_key\n }\n },\n {\n json: {\n keytarea: keytarea,\n codigo_tipo_tarea: \"TDEV_01\",\n nombre_tipo_tarea: \"Administraci\u00f3n de Cargos\",\n issue_type: \"10465\",//Desarrollo\n proyecto: proyectokey,\n parent_issue_key: parent_issue_key\n }\n },\n {\n json: {\n keytarea: keytarea,\n codigo_tipo_tarea: \"CTES_01\",\n nombre_tipo_tarea: \"Caso de prueba. Administraci\u00f3n de Cargos\",\n issue_type: \"10438\",//Caso de Prueba\n proyecto: proyectokey,\n parent_issue_key: parent_issue_key\n }\n },\n {\n json: {\n keytarea: keytarea,\n codigo_tipo_tarea: \"VTES_01\",\n nombre_tipo_tarea: \"Verificaci\u00f3n Casos de prueba\",\n issue_type: \"10419\",//Ver. Casos de Prueba\n proyecto: proyectokey,\n parent_issue_key: parent_issue_key\n }\n }\n];\n"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
820,
-180
],
"id": "3166bc79-67f4-42ae-9998-9dba9da58070",
"name": "Datos_Estaticos_Proyecto_tipo_tareas"
},
{
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "const Codigo = $json['Codigo del proyeto'];\nconst Numero_Historia = $json.Numero;\nconst str = Codigo + '_' + Numero_Historia;\n\nreturn {\n json: {\n resultado: str\n }\n};\n"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
520,
-380
],
"id": "532be3ad-0d14-4a05-8f06-b39e3b798c1a",
"name": "Datos_Estaticos_Proyecto_tipo_tareas1"
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "45c83ac6-2752-45ac-b37c-2d40ae668ab9",
"name": "resultado",
"value": "={{ $json.resultado }} - {{ $('Merge').item.json['Nombre del la historia'] }}",
"type": "string"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
660,
-380
],
"id": "80ea0fac-1415-4787-b392-666481a3e753",
"name": "Edit Fields1"
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "7e61ba4c-f5ce-4a36-9cc7-f6949c4140c6",
"name": "codigo_nombre",
"value": "={{ $json.keytarea }}_{{ $json.codigo_tipo_tarea }} - {{ $json.nombre_tipo_tarea }}",
"type": "string"
},
{
"id": "ea2c9f69-13f6-4c72-b909-d88619cf7da0",
"name": "proyecto",
"value": "={{ $json.proyecto }}",
"type": "string"
},
{
"id": "80f84e76-87d2-4ba6-a3b1-7b871b55e6b6",
"name": "issue_type",
"value": "={{ $json.issue_type }}",
"type": "string"
},
{
"id": "2d7bb868-0347-452d-98cb-b39a01c24a5e",
"name": "parent_issue_key",
"value": "={{ $json.parent_issue_key }}",
"type": "string"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
1040,
-380
],
"id": "84ca07a9-724e-4639-a94c-53fd41eefbcd",
"name": "Edit Fields2"
},
{
"parameters": {
"operation": "get",
"issueKey": "={{ $json.key }}",
"additionalFields": {}
},
"type": "n8n-nodes-base.jira",
"typeVersion": 1,
"position": [
680,
-180
],
"id": "80fb59d8-cab1-4700-a8f0-a3a1622dcf27",
"name": "Jira Software1"
},
{
"parameters": {
"project": {
"__rl": true,
"value": "={{ $json.proyecto }}",
"mode": "id"
},
"issueType": {
"__rl": true,
"value": "={{ $json.issue_type }}",
"mode": "id"
},
"summary": "={{ $json.codigo_nombre }}",
"additionalFields": {
"parentIssueKey": "={{ $json.parent_issue_key }}"
}
},
"type": "n8n-nodes-base.jira",
"typeVersion": 1,
"position": [
1040,
-180
],
"id": "3e9fd65d-59f8-4947-a0f5-7da6a526f2c0",
"name": "Jira Software2"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "0c765f65-8eb1-4137-b398-e3a61642d42b",
"leftValue": "={{ $json.Estado }}",
"rightValue": "aprobado",
"operator": {
"type": "string",
"operation": "equals",
"name": "filter.operator.equals"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
280,
-240
],
"id": "533b8d37-e196-4b2b-931e-04dbb0902a1f",
"name": "If"
},
{
"parameters": {},
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
540,
0
],
"id": "ceaaaca5-2a8d-4950-8d2b-d2c05429addf",
"name": "No Operation, do nothing"
},
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"value": "={{ $('Edit Fields').item.json.url_sheets }}",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "Historias",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1eGbQRdFwbaHfFpQyyK8HPHO34tA1S_mFDnfEjM0rOy0/edit#gid=0"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"Numero": "={{ $('Hoja Historias').item.json.Numero }}",
"Nombre del la historia": "={{ $('Hoja Historias').item.json['Nombre del la historia'] }}",
"Historia": "={{ $('Hoja Historias').item.json.Historia }}",
"Estado": "creado"
},
"matchingColumns": [
"Nombre del la historia"
],
"schema": [
{
"id": "Historia",
"displayName": "Historia",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Nombre del la historia",
"displayName": "Nombre del la historia",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Numero",
"displayName": "Numero",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Estado",
"displayName": "Estado",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "row_number",
"displayName": "row_number",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"readOnly": true,
"removed": true
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.6,
"position": [
1220,
-180
],
"id": "0e9b917f-3b5d-4c78-94a6-cfaa43863b48",
"name": "Google Sheets1"
}
],
"connections": {
"Schedule Trigger": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
},
"Hoja Historias": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields": {
"main": [
[
{
"node": "Hoja Historias",
"type": "main",
"index": 0
},
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"When clicking \u2018Execute workflow\u2019": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
},
"Merge": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Datos_Estaticos_Proyecto_tipo_tareas": {
"main": [
[
{
"node": "Edit Fields2",
"type": "main",
"index": 0
}
]
]
},
"Datos_Estaticos_Proyecto_tipo_tareas1": {
"main": [
[
{
"node": "Edit Fields1",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields2": {
"main": [
[
{
"node": "Jira Software2",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields1": {
"main": [
[
{
"node": "Jira Software",
"type": "main",
"index": 0
}
]
]
},
"Jira Software": {
"main": [
[
{
"node": "Jira Software1",
"type": "main",
"index": 0
}
]
]
},
"Jira Software1": {
"main": [
[
{
"node": "Datos_Estaticos_Proyecto_tipo_tareas",
"type": "main",
"index": 0
}
]
]
},
"Jira Software2": {
"main": [
[
{
"node": "Google Sheets1",
"type": "main",
"index": 0
}
]
]
},
"If": {
"main": [
[
{
"node": "Datos_Estaticos_Proyecto_tipo_tareas1",
"type": "main",
"index": 0
}
],
[
{
"node": "No Operation, do nothing",
"type": "main",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "631f319c-68c9-4b02-a70e-4942ada50fdb",
"meta": {
"templateCredsSetupCompleted": true
},
"id": "tWjz78nqtrGxX8HZ",
"tags": []
}
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Jira[AI] Form. Uses jira, googleSheets. Scheduled trigger; 16 nodes.
Source: https://gist.github.com/brayanmezac/fd0546d1b810c79422806c5d0e63a043 — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This workflow automates video distribution to 9 social platforms simultaneously using Blotato's API. It includes both a scheduled publisher (checks Google Sheets for videos marked "Ready") and a subwo
Google Sheets, HTTP Request, Form Trigger +2
YogiAI. Uses googleSheets, googleSheetsTool, httpRequest, stopAndError. Scheduled trigger; 61 nodes.
Google Sheets, Google Sheets Tool, HTTP Request +1
This workflow monitors Google Calendar for events indicating that a customer will visit the company today or the next day, retrieves the required details, and sends reminder notifications to the relev
Google Calendar, Google Sheets, HTTP Request +1
Useful if a team is working within a single instance and you want to be notified of what workflows have changed since you last visited them. Another use-case might be monitoring your managed instances
Google Sheets, Execute Workflow Trigger, n8n
ofn hook v0.24.0 beta. Uses start, httpRequest, functionItem, itemLists. Scheduled trigger; 42 nodes.
Start, HTTP Request, Function Item +3