I am trying to pull the data of our clients from jotform into a spreadsheet (Google Sheets).
I am using a HTTP Request to connect to Jotform, Split Out to show each item in a different row, Edit Fields to choose the specific data I want to pull out, and connected to a Google Sheet that I have already created.
For now I am only trying to pull the name of our clients to test out everything (this is my first time using n8n). When I run it, the green check appears but it only inputs the name of 1 of our clients, it doesn’t display all of them.
It sounds like to me that you’re having an issue with the sheets node only actually ever running with the first item, without seeing the workflow I wouldn’t be able to identify the issue.
Sometimes though it is necessary to add a loop node into a workflow, so probably directly after the splitout, place a loop, then place the sheets node where the “replace me” node appears and wire it in the same way.