I’ve used Airtable as a custom ERP across a few businesses. I’ve always been annoyed by how difficult it is to bulk export/import attachments so I built bulkAirtable.
Imports require routing via an S3 bucket / Google Drive folder; exports download directly to your computer.
Install
Python 3.9+. A personal access token with data.records:read, data.records:write, and schema.bases:read.
pip install "git+https://github.com/sburl/bulkAirtable.git#egg=bulkAirtable[upload]"
Put BASE_ID, TABLE_ID, and AIRTABLE_TOKEN in a .env. For imports, also configure S3 or Google Drive using the setup instructions on GitHub. Then:
python -m bulkAirtable.bulkUploadAirtable
python -m bulkAirtable.bulkDownloadAirtable