Airtable Base Backups with CSV to Drive

[zynera]

Hi guys, n8n newbie here - heavy Make.com user so nocode key concepts are very familiar

I want to backup my entire Airtable base and I am doing that by getting all the bases tables, then iterating over these and getting all records for one table. Afterwards I want to create a CSV and upload it to Google Drive.

I tried it at first without the Loop node but it returned a wrong number of items for my CSV. Since I have 31 tables in total that’s also the number of CSVs I’m expecting with a different amount of lines.

After creating all the CSV I would like to upload them one by one to Drive.

Can anyone tell me what I am doing wrong here or maybe if someone has done a similar thing and is able to helo out?

Thanks in advance!

[Yo_its_prakash]

For proper Airtable to Google Drive backups via CSV:

1. Inside your Loop node:

• Add a “Set” node after the Airtable List Records node
• Configure it to save the table name with the records:

{
  "records": {{$json.records}},
  "tableName": "{{$node["Loop1"].parameter["value"]}}"
}

2. Configure your CSV Create node:

• Set “File Name” to {{$json.tableName}}.csv
• Set “Input Field” to records
• Enable “Include Empty Cells” option

3. For Google Drive uploads:

• Connect Google Drive directly to CSV node
• Use operation “Upload”
• Set folder path where you want backups
• Filename: {{$json.tableName}}_{{$today.format("YYYY-MM-DD")}}.csv

This approach properly maintains the table context throughout the workflow and creates uniquely named files for each table.

If my solution helped solve your issue, please consider marking it as the answer! A like would make my day if you found it useful!

[Daniel_Lamphere]

You need to actually connect that last node in the loop back into the front of the loop, very different than make’s iterator/repeater

[Yo_its_prakash]

This may be wrong, but we should be able to do it without the loop right, we don’t even need that node, or am i wrong

We Get the tables → we split it → then we search → then we convert

isn’t it possible @Daniel_Lamphere

[Daniel_Lamphere]

Yeah thats one of those things where I’ve seen both, really he shouldn’t need it, but I’ve had plenty of nodes(especially when working with files) need an explicit loop.