On2Air Backups is an automated backup app for your Airtable bases. Create scheduled backups of your critical business data stored in Airtable and export your information to Dropbox, Box, or Google Drive.
In this tutorial
- On2Air Backups Trial Information
- 1. Install the On2Air Backups Extension in your Airtable Base
- 2. Connect Your Airtable Account
- 3. Connect Your Cloud Storage Account (Google Drive, Dropbox, or Box)
- 4. Create a Backup Project
- 5. Click Start Backup
- 6. Upgrade and Choose Your Backup Schedule
- Customize Your Backup (Include/Exclude Fields, View, and Attachments)
- Backups History Log
- Backup Folder Structure and File Name Convention
- Need Support?
On2Air Backups Trial Information
In the On2Air Backups Trial, we allow 1 Airtable Base, 10 Tables, 100 Records per table, and 25 Attachments (total). After the trial creates a backup to your storage drive, it deactivates.
To enable an automated backup schedule, upgrade to a plan . Once you’ve upgraded, you’ll then need to set the Schedule and Reactivate the backup.
1. Install the On2Air Backups Extension in your Airtable Base
- First, open your Airtable base and click Extensions
- Click Add an extension
- Type On2Air in the search box and choose On2Air Backups
- Click Add Extension to add it to your Airtable base
- You’ll now click Create New Account to create an On2Air account. You’ll go through the account creation process.
If you’ve ever added On2Air Backups to other bases in your Airtable workspace, Select your On2Air account.
2. Connect Your Airtable Account
Now, you’ll need to connect your Airtable account
- First, copy your Airtable API Key - How to Find your Airtable API Key
- Note: We are transitioning to the new Airtable OAuth connection. You’ll be able to quickly upgrade the API Key to OAuth soon. In the meantime, please connect with your API Key.
- Click the Configure Airtable API button
- Paste your Airtable API key into the On2Air Backups API Key field
You can label the Connection whatever you would like
- Next, Activate the Airtable Connection toggle
- Click Save Changes
- Close out the popup and click the Configure Airtable API button again. This will refresh the app to accept your token.
Final
3. Connect Your Cloud Storage Account (Google Drive, Dropbox, or Box)
Next, you’ll connect your cloud storage account in Google Drive, Dropbox, and Box.
- Click Configure Backup Destination
- Depending on your cloud storage option, the setup will look slightly different
You will need to accept the permissions that popup when connecting your storage drive to On2Air. Once you’ve accepted permissions and connected your account, you can now create a backup.
- Once you’ve connected to Storage, click Configure Backup Destination again, close the popup, and On2Air Backups will refresh and connect
4. Create a Backup Project
Once you’ve connected your storage drive, create your backup project
- Click Create New Project
- A Backups Project allows you to add 1 or multiple bases to a Project
- On2Air Backups will automatically detect the Airtable base you’re in
- Click Configure Settings
- Next to Storage Connection, choose Update
- By default, we’ll add the backup to the root of your storage drive. You can change to a specific folder
- Now, you can Choose a folder from your storage drive or Create a New Folder where your backups will be sent
Then click Save Backups Details
Now that your folder is chosen, the Trial Schedule is automatically set to One-Time.
In the On2Air Backups Trial, we allow 1 Airtable Base, 10 Tables, 100 Records per table, and 25 Attachments (total). After the trial creates a backup to your storage drive, the backup project deactivates.
To enable an automated backup schedule, upgrade to a plan . Once you’ve upgraded, you’ll then need to set the Schedule and Reactivate the backup.
5. Click Start Backup
- Click Start Backup to start your Backup
- The Status will change to Active while it creates a backup in your storage drive
- Click Backup History to see the backups begin and when it’s done processing.
Backups begin within approximately 1 minute and the time it takes to complete the backup will depend on the number of records/fields in your Airtable base and the number of attachments.
You can click Refresh on the Backup History page to watch the progress.
6. Upgrade and Choose Your Backup Schedule
To fully automate Airtable backups, upgrade to a Backups plan
On2Air Backups Plan
The Backup Schedule options available will depend on your plan
Available Plans and Schedules
STARTER - $9.99/month - UPGRADE 1 Airtable Base, 50,000 Records, 2,500 Attachments - Monthly Backup Schedule
ESSENTIALS - $29.99/month - UPGRADE 15 Airtable Bases, 250K Records, 25K Attachments, - Monthly or Weekly Backup Schedule
PROFESSIONAL - $49.99/month - UPGRADE 50 Airtable Bases, 1 Million Records, 500K Attachments - Monthly, Weekly, or Daily Backup Schedule
PREMIUM -$79.99/month - UPGRADE 250 Airtable Bases, 5 Million Records, 1 Million Attachments - Monthly, Weekly, Daily, Hourly Backup Schedule
SCHEDULE OPTIONS
Monthly - Choose a day of the month Options are: * 1st day of month * Mid month (15th) * Last day of month
Weekly - Choose any day of the week
Daily - Choose a time of day * Choose a specific hour of the day * Toggle Yes to Include Weekends (Optional)
Hourly - Choose hourly * Toggle Yes to Include Weekends (Optional)
- Once you’ve upgraded, you need to set your new automated Schedule
- In your Backups Project, click Settings, then click Schedule
- Choose your Backup Project Interval and Interval Value
- Click Update Schedule
Enable Your Backup
Once you’ve set your backup schedule (paid plans), click Start Backup
Customize Your Backup (Include/Exclude Fields, View, and Attachments)
You can customize what’s included in your Airtable base backup, such as specific fields, views, or attachments.
Backups History Log
See how you can view all your backups details and history
Backup Folder Structure and File Name Convention
Learn how we name the files and attachments in your storage drive
Need Support?
Send us a message. If we’re online, we’ll get back to you as soon as possible. If not, we’ll follow up by email.
The folder and file structure for your backups
YourFolderName --> BackupProjectName_AirtableID --> BaseName_AirtableID --> TableName.csv or TableName.json
BaseName_AirtableID --> Attachments --> TableName_AirtableID --> FieldID_RecordID_AttachmentID_NameOfFile
Also, in Attachments
Attachments --> Attachments_TableName.json
Dropbox Folder Structure
Box Folder Structure
Google Drive Folder Structure
Airtable Base Used in Backup
- In your Backup Project, click the Settings tab
- Click Schedule
- Choose your Backup Project Interval - Trial mode will allow you to select a One Time backup interval
- Click Create Schedule
Individual Base Backup Settings
Base - Change the Airtable connection or Airtable base included in your Backup Project
* Click **Update** * Choose your desired Airtable base * Select **Update Backup Base**
Auto Add New Tables - Choose Yes if you would like any new tables added to your base automatically added to your Backup Project
Auto Add New Attachments - Choose Yes if you would like any new attachment fields added to your base automatically added to your Backup Project
Backup Format - Export the backup in CSV or in JSON format
Remove From Project - Remove a base from your Backup Project * Click Remove Base
Rename Backup - Click in the Backup Title field and rename your Backup * Click out of the field to automatically save
Back to Previous Page - Each page of the app includes a button at the top to go back to the previous screen
Adding Your Airtable Bases to Your Backup Project
- In the Bases tab, click Add Base to Backup
- Click Select Connection and choose your desired Airtable connection If you haven’t connected to your Airtable account, set up the connection in Accounts and Integrations by clicking Add a new connection in the integration settings
Learn how to set up new connections
- Select the Base you want to add to your backup
- Click Add New Backup Base
Backup Project Settings
Storage
- Click Select Storage Connection
You can connect to Google Drive, Dropbox, or Box depending on your plan If you have not connected your Backup Storage account, set up the connection in Accounts and Integrations by clicking Add a new connection in the integration settings
Learn how to set up new connections
- Click Select Connection and choose your desired backup storage location The root folder location in your storage account will appear
- Click Create New Folder (Recommended if first backup project) and give it a name such as On2Air Backups
- Choose your newly created folder
- Click Save Backup Details
Delete Your Project
Delete - If you no longer want your Backup Project
* From your Backup Project, select the **Settings** tab * Click **Delete Backup** _**WARNING**: Deleting a backup cannot be undone_