{
"name": "Testing Plan Generator",
"nodes": [
{
"parameters": {
"fileSelector": "/files/**/*.swift",
"options": {
"dataPropertyName": "data"
}
},
"type": "n8n-nodes-base.readWriteFile",
"typeVersion": 1,
"position": [
240,
0
],
"id": "182716fe-03c7-4202-b7fb-cb9b6ed65447",
"name": "Read/Write Files from Disk",
"alwaysOutputData": true
},
{
"parameters": {
"operation": "text",
"options": {}
},
"type": "n8n-nodes-base.extractFromFile",
"typeVersion": 1,
"position": [
448,
0
],
"id": "6d033752-970c-4b9f-88aa-5f139529e9e9",
"name": "Extract from File"
},
{
"parameters": {
"batchSize": 2,
"options": {}
},
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 3,
"position": [
656,
0
],
"id": "dfc4bcaf-bbc1-4064-893d-103f9e6183f4",
"name": "Loop Over Items"
},
{
"parameters": {
"modelId": {
"__rl": true,
"value": "gpt-4.1-mini",
"mode": "list",
"cachedResultName": "GPT-4.1-MINI"
},
"messages": {
"values": [
{
"content": "=Analyze what this code does:\n\n{{ $json.data }}\n\nThen create a testing plan in JSON:\n\nbeing the fields names always the same and the field to split called testingPlan\n\n {\n \"Section\": \"Debug Console View UI\",\n \"TestCode\": \"DCV-001\",\n \"TestTitle\": \"Display and Layout Verification\",\n \"TestDescription\": \"Verify window opens with expected title, size, and layout.\",\n \"TestSteps\": [\n \"Open the debug console window.\",\n \"Verify title is 'BettrPaste Debug Console'.\",\n \"Check size is at least 800×400.\"\n ],\n \"Results\": \"\"\n }\n\nTest as much as possible"
}
]
},
"simplify": false,
"jsonOutput": true,
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.openAi",
"typeVersion": 1.8,
"position": [
864,
96
],
"id": "974a2078-1c10-4518-9aff-5f0cca6d17a9",
"name": "Message a model",
"credentials": {
"openAiApi": {
"id": "Nl90VT1FH73O6pfN",
"name": "OpenAi account"
}
}
},
{
"parameters": {
"fieldToSplitOut": "choices[0].message.content.testingPlan",
"include": "selectedOtherFields",
"fieldsToInclude": "choices[0].message.content.Tests[0].Section, , choices[0].message.content.Tests[0].TestTitle",
"options": {}
},
"type": "n8n-nodes-base.splitOut",
"typeVersion": 1,
"position": [
1216,
96
],
"id": "c3a212a9-d41a-41bb-903e-11984cd65cd2",
"name": "Split Out"
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "https://docs.google.com/spreadsheets/d/1gQmrFelKwgVW4X-uylnIxQGXrPUnmdLvQKPAkPabAbw/edit?usp=sharing",
"mode": "url"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "Hoja 1",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gQmrFelKwgVW4X-uylnIxQGXrPUnmdLvQKPAkPabAbw/edit#gid=0"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"Section": "={{ $json['choices[0].message.content.testingPlan'].Section }}",
"TestCode": "={{ $json['choices[0].message.content.testingPlan'].TestCode }}",
"Test Title": "={{ $json['choices[0].message.content.testingPlan'].TestTitle }}",
"Test Description": "={{ $json['choices[0].message.content.testingPlan'].TestDescription }}",
"TestSteps": "={{ $json['choices[0].message.content.testingPlan'].TestSteps }}"
},
"matchingColumns": [],
"schema": [
{
"id": "Section",
"displayName": "Section",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "TestCode",
"displayName": "TestCode",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Test Title",
"displayName": "Test Title",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Test Description",
"displayName": "Test Description",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "TestSteps",
"displayName": "TestSteps",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Results",
"displayName": "Results",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
1424,
96
],
"id": "4383e57c-82b5-45f6-bce8-da42108c4653",
"name": "Append row in sheet",
"credentials": {
"googleSheetsOAuth2Api": {
"id": "3RJVN99OW5OyvE9U",
"name": "Google Sheets account"
}
}
},
{
"parameters": {
"rule": {
"interval": [
{
"field": "weeks",
"triggerAtDay": [
1
],
"triggerAtHour": 10
}
]
}
},
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1.2,
"position": [
48,
0
],
"id": "54f12c88-3097-416e-a371-47bb33df19ef",
"name": "Schedule Trigger"
}
],
"pinData": {},
"connections": {
"Read/Write Files from Disk": {
"main": [
[
{
"node": "Extract from File",
"type": "main",
"index": 0
}
]
]
},
"Extract from File": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Message a model",
"type": "main",
"index": 0
}
]
]
},
"Message a model": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"Split Out": {
"main": [
[
{
"node": "Append row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Append row in sheet": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Read/Write Files from Disk",
"type": "main",
"index": 0
}
]
]
}
},
"active": true,
"settings": {
"executionOrder": "v1"
},
"versionId": "73301273-3155-4720-8084-d8102a80376c",
"meta": {
"templateCredsSetupCompleted": true,
"instanceId": "adb8ec888aac57768de80ecb10e8ae09b8d849cfe6fac10be16cdeafb8caa0d8"
},
"id": "jRPM5YQQVayRsjv4",
"tags": []
}