How can I get my data into Airtable arranged into different rows and column

Questions
, , ,
1

I have got data of 1000 people in form of something like people.first_name[0]. How can i select all 1000 people at once and get them iinto airtable

I tried using the set node it did was everytime gave me response in first line only and overwrite over the last one

How can I get all these people into airtable into different rows and without overwrite

image

(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.)

Share the output returned by the last node

Information on your n8n setup

  • **n8n version:**latest
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • **Running n8n via (Docker, npm, n8n cloud, desktop app):**self
  • **Operating system:**win 11
2

hello @Arsh_Tyagi

Use the Split Out node just after your input with people, like that

3

didnt work for me pls could you elaborate how can I use it

body.people[0].first_name I have this how can I make this something like body.people[i].first_name
where i belongs to 0-total number of leads

4

have you tried to set the field name to body.people in the Split Out node?

5

I have fixed this issue using the function node and writing a custom code

Thank you so much mate

1 Like