Import list from Google Sheet - how do

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

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


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