Help me with my first workflow pls

[ManuelZ]

Hey there I am completely new to N8N and tried to build my first workflow. The idea is to generate Project Status reports for all active projects of a portfolio based on tasks, risks and issue (each stored in a different Airtable but linked to the project) of the individual projects. I used chatGPT to help me with the setup. Initially I was using a loop but could not get it to work no I tried without the loop (getting all the data in paralell) and then combining it with a JS. But somehow only one of Get xx nodes executes leaving an error at the JS since the others didn’t execute. This cant be that difficult right haha maybe you guys have a much easier idea.

Describe the problem/error/question

What is the error message (if any)?

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

• n8n version:
  1.119.1 on local host using Docker
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app):
• Operating system: mac os

[Javier_Castillo]

Hey! Can you share the output of the first node? For any special reason are you using JS?

[ramin1]

you must use a Mege Node probably

[ManuelZ]

[
{
“id”: “rec0QhiLXOZ5ijzhC”,
“createdTime”: “2025-11-22T13:14:15.000Z”,
“Name”: “Northwind Solar Expansion”,
“Project Code”: “PRJ-2025-001”,
“Status”: “Active”,
“PM”: “Elena Fischer”,
“Client”: “GreenGrid Energy”,
“Start Date”: “2025-01-15”,
“End Date (Planned)”: “2025-12-20”,
“End Date (Forecast)”: “2025-12-30”,
“Budget”: 2500000,
“Category”: “Renewable”,
“# Tasks”: 2,
“Tasks”: [
“rechbQA4dGkTXQD6m”,
“recAEFPcuBDEaeBEg”
],
“# Open Risks”: 2,
“Risks”: [
“recGUhnB8GioH2YLR”,
“recbMiu0DLgJcNeKk”
],
“Issues”: [
“recov7A7dFtkLW9eL”,
“rec6YG0Ow28jq7Eaj”
],
“Status Reports”: [
“recH8QsNnehngRR3s”
],
“Schedule Variance (days)”: 10
},
{
“id”: “recngEiy9ChkFseXV”,
“createdTime”: “2025-11-22T13:14:15.000Z”,
“Name”: “Westfield Gas Plant Modernization”,
“Project Code”: “PRJ-2023-089”,
“Status”: “Active”,
“PM”: “Sophie Keller”,
“Client”: “Westfield Energy”,
“Start Date”: “2023-05-10”,
“End Date (Planned)”: “2025-03-31”,
“End Date (Forecast)”: “2025-04-10”,
“Budget”: 3750000,
“Category”: “Plant”,
“# Tasks”: 1,
“Tasks”: [
“recT6EAk7dyzSmMhE”
],
“# Open Risks”: 1,
“Risks”: [
“rec6YSMZBRionfOFx”
],
“Issues”: [
“recPDDmR1nXbxBWnn”
],
“Status Reports”: [
“recLSej6OF10guzph”
],
“Schedule Variance (days)”: 10
},
{
“id”: “recsfi68T0KnwJ7hR”,
“createdTime”: “2025-11-22T13:14:15.000Z”,
“Name”: “Eagle Drilling Phase 2”,
“Project Code”: “PRJ-2025-034”,
“Status”: “Active”,
“PM”: “Jens Bauer”,
“Client”: “Eagle Exploration”,
“Start Date”: “2025-04-05”,
“End Date (Planned)”: “2026-02-28”,
“End Date (Forecast)”: “2026-03-15”,
“Budget”: 5200000,
“Category”: “Drilling”,
“# Tasks”: 1,
“Tasks”: [
“recxCxWIv3Y30UQKa”
],
“# Open Risks”: 1,
“Risks”: [
“rec2m6dwpctIy45ko”
],
“Issues”: [
“recyqTxq8bcUVySiK”
],
“Status Reports”: [
“recKJMkJK5EtfJzdA”
],
“Schedule Variance (days)”: 15
}
]

[ManuelZ]

I started with a loop so it runs through every project indivudually and gehts the risks, issues and tasks, but i couldnt make it work. so used ChatGPT and it proposed it this way.

[ManuelZ]

I managed using the merge node, thanks a lot

[Javier_Castillo]

Sorry I couldn´t reply before. Great that you solved it!