Hello, one of the workflows that I am using gives me an error in Google Sheets which is “Nofields- item(s)exist, but they’re empty” can you give me a step by step solution that worked before.
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.)
Hi @Kuti01 As i can see your JSON expression is returning undefined i would recommend making sure you have a returning item named email so that the add to sheet node can pick that up. The error also suggests that there is no field which exists to map so make sure that is a ready json variable to be mapped.
You’re right about the undefined issue. One quick debugging step — add a Function node just before Google Sheets that logs the actual data structure: console.log($json); return $json;. This shows you exactly what the previous node returns, so you can map the right field names. Sometimes the shape differs from what you expect, especially with API responses that have different nesting levels.
