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"