Airtable Base Backups to S3

Description

This workflow exports every table in a base as its own CSV, saves the files in a time-stamped folder in Amazon S3, pings you on Slack, and optionally prunes older copies. You get an automated weekly backup that is easy to inspect or re-import as needed. You can easily swap the S3 node for the storage provider of your choice.

++How it works++

Weekly Backup
Schedule trigger fires weekly
Sets and formats the week ex. [2025-W12]
Create a folder in S3 bucket with the week
Loops through all tables in Airtable base creating CSVs and uploading to the new path
Slack message is sent on completion

Monthly Prune
Schedule trigger fires weekly
Sets a cut-off date 4 weeks in the past
Lists folders in S3
Deletes all folders > 4 weeks old

++Setup Steps++

Clone workflow
Swap credentials for Airtable, AWS, and Slack
Ensure AWS credential has appropriate IAM policy to manage bucket & objects
Set workflow to "Active"