Import list from Google Sheet - how do

[fxholl]

I need to import a list of customers from a Google Sheet and send it in batches via HTTPS node to a CRM system.

The data from Sheets looks like this:

To send it in batch, the JSON needs to look like this:

{
“consumers”: [
{}
]
}

How do I wrap the {“consumers” [ ] } around the data from Sheets?

Please share your workflow

Information on your n8n setup

• n8n version: 0.203
• Database (default: SQLite): postgres
• n8n EXECUTIONS_PROCESS setting (default: own, main): main
• **Running n8n via (Docker, npm, n8n cloud, desktop app):**docker
• **Operating system:**linux

[giulioandreini]

hi @fxholl,
you can use the Item Lists node, with the Concatenate Items operation (Aggregate → All Item Data (Into a Single List)).

Check this demo workflow:

Let me know if this helps and solves your problem.
All the best