Create an archive for Airtable in Google Sheets

Create an archive of an Airtable base by combining multiple tables together, formatting the data, and exporting it to Google Sheets.

Create an archive for Airtable in Google Sheets

Making an Airtable archive with Parabola

In this example, we start out by pulling in content from the 'People' and the 'Work' tables using the Pull from Airtable step. We join employees with the work they have been assigned the Merge tables horizontally 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: the Rename columns step, the Remove columns step, and the Reorder columns step. 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 send the compiled data to Google Sheets!