Creating an archive for Airtable in Google Sheets
Using the Airtable API, create an archive for a series of tables within an Airtable base. Create a unified view of the data and continuously update a Google Sheet as a backup or a record of past entries.
What is Airtable anyway?
Airtable is a powerful tool for making database-like systems that are easy to edit and manage by anyone. Some companies even use Airtable as the production database on which their entire business runs! There are times when it might've been handy to have a backup, though; that's where this flow comes in.
Making an Airtable archive with Parabola
In this example, we start out by pulling in content from the 'People' and the 'Work' tables using Parabola's Airtable import. We join employees with the work they have been assigned using our Join step, then bring in the 'Customers' table to sync up employees' work with the current status of those customers. Finally, we bring in the 'Tracking' table to see how far along each of those deals is.
Along the way we clean up and organize the data using a variety of handy Parabola steps: Column Rename, Column Filter, and Column Reorder. All those steps do exactly what they it sounds like they do, and best of all they do it repeatedly, so you define the procedure once, and Parabola will take care of it on your behalf forever.
Finally, we export the compiled data to Google Sheets!