Building a string from a sheet

Questions
1

Hello! I am trying to build a string sequentially as I iterate through a Google Sheet. I have seen this question asked a couple times, but those answers didn’t fit my use case.

From a high level, I am using a formatted spreadsheet to build a Wordpress form export file. This lets me generate forms from a spreadsheet and is super useful. I built it in Make.com but am trying to move over to n8n.

To build the form, I have to make a json structure with a header, body fields and a footer. So I need to store a value and slowly build on that value for each row in the spreadsheet.

Here is a loom video for context to the problem:

Information on your n8n setup

  • n8n version: 1.78.1
  • Database SQLite:
  • n8n EXECUTIONS_PROCESS setting own, main:
  • Running n8n via n8n cloud:
  • Operating system: Windows
2

Hey Nick, if I understand correctly it only outputs the first result from the row, or the last?

3

Sorry, the workflow isn’t complete. This needs to loop through the entire spreadsheet and collect data from all rows. At the moment I am only processing the first row but once I know how to build a string I will complete the loop

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.