The method
Use this prompt in ChatGPT/Gemini/Claude as a debugging companion. Provide the n8n workflow JSON or a detailed description of the workflow and the error encountered. Specify the nodes involved and the expected vs. actual output.
The prompts
Prompt 1
Analyze the following n8n workflow JSON and identify potential issues causing the error: 'TypeError: Cannot read properties of undefined (reading 'data')' in the Function node. The workflow receives data from a Webhook node, transforms it using a Function node, and then sends it to a Google Sheets node. Provide suggestions for fixing the error, including potential data type mismatches or missing data fields. Here is the workflow JSON: [Paste n8n workflow JSON here]. Explain your reasoning step by step and include code snippets where applicable.
Prompt 2
I'm encountering an issue in my n8n workflow. I'm trying to fetch data from a REST API using the HTTP Request node, then transform it using a Function node, and finally store it in a PostgreSQL database using the PostgreSQL node. However, the PostgreSQL node is throwing an error: 'column "my_column" does not exist'. Can you analyze this scenario and provide me with potential causes and solutions? Consider data type conversions, incorrect column mappings, and missing data fields. I'm using the following SQL query in the PostgreSQL node: `INSERT INTO my_table (my_column, another_column) VALUES ($1, $2)`. What could be going wrong and how can I fix it?