Google Sheets can give you the best features of spreadsheets: built-in formulas, pivot tables, custom reporting, and conditional formatting. It’s free, flexible, and convenient for collaboration. Airtable blends the simplicity of spreadsheets with the structure of a relational database. It helps you bring your data in order. Each of these apps is pretty good separately. However, if used together, they can provide a synergistic effect for your operational activities. Who would look for such a combination? In most cases, the interest comes from small-to-medium business owners. If you also want to know how to link Airtable to Google Sheets, come along!
Why move data from Airtable to spreadsheets
Airtable is great as a database. You can store data across different tables and connect them. For example, you can keep records of customers and items in separate tables and interlink some cells or columns. Airtable also provides a set of ready-to-use templates with a defined structure of tables, for example, Project Tracker, Product Planning, and others.
Being a powerful data input tool, Airtable does not provide many capabilities for data processing. You can’t make complex calculations or do custom reporting here. That’s why versatile data-centric specialists, such as financiers, accountants, data analysts, entrepreneurs, and others move data to Google Sheets. Here they can process it in a more flexible way.
The data structure between Google Sheets and Airtable is different. But users prefer to have access to both structures to benefit from the synergies. The main challenge with this: how to import data to spreadsheets without any distortion or loss. And here is the solution.
Sync Airtable with Google Sheets like it’s a breeze
Coupler.io is a Google Sheets add-on that allows you to import your data from various sources including Airtable. For this, no coding skills are required. All you need to do is install Coupler.io and set up a specific importer to connect with your data source.
You can install Coupler.io from G Suite Marketplace via this direct link.
Since it is a beta version of the product, you won’t be able to find it in the marketplace. At the same time, the product is currently available for free and you’re welcome to try it out.
For more information about Coupler.io and its integrations, please visit Coupler.io home page.
Here is a look at the installation process:
Check out Get started with Coupler.io to explore the details.
Setting up an importer
An importer is an integration which connects a specific app to Google Sheets. Coupler.io uses importers to enable data importing from one app into spreadsheets. Since your goal is to move Airtable data to Google Sheets, you need to add the Airtable importer. For this, go to Add-ons => Coupler.io => Open dashboard.
The dashboard with Active importers will appear.
Click on the ‘Add Importer’ button and select ‘Airtable’.
You’ll see the following window with a few fields to fill in.
Title – The name of your data source. For example: Customer Base, Order List, Inventory, etc.
Sheet Name – The name of a sheet where you will import your data. Coupler.io will generate a random name here, such as ‘airtable-addon k4dz5ale’, but you can specify any name you like.
Note: If you specify the name of an existing sheet the data will be imported to it.
Re-import Automatically – A scheduling option to update imported data from your data source. If you enable this feature, you’ll benefit from automatic data importation without any manual operation. You can schedule data re-import at the following intervals:
- 1 hour
- 3 hours
- 6 hours
- 12 hours
If you choose ‘Never’, you’ll turn it off. In this case, you’ll have to run the importer manually every time you want to update your data.
Shared URL – A shared view link of your Airtable data source.
Where to get the link? – Open your Airtable base and pick a table you want to export to Google Sheets. Click on the ‘Share’ button in the top right area of the window. In the open window, scroll down and click on ‘See the 1 shared table view link in this base’. Copy your shared view link and insert it in the field for the designated importer.
The Additional field is optional and needed if you use the protected view password feature. The Settings field allows you to choose a data import mode: replace or append. For more on this refer to Coupler.io knowledge base.
Once you’ve filled in all required fields, click on the “Add Importer” button. You’ll see your newly created importer in the list of active importers and the data from your Airtable will be exported to a new sheet.
Here is how it looks:
Note: Keep in mind that you need to add an importer for each table to be imported. So, if your Airtable database consists of three tables, you’ll need to add three Airtable importers for importing data to Google Sheets.
The entire process (installation + importer configuration) is simple and fast. You will need up to five minutes to get things done. Besides, the data will be imported smoothly, so you won’t have to fix it.
Manual copying and pasting data is a waste of time. With Coupler.io you can automate data importing, which will save you time and significantly improve work efficiency.
A real-life use case: build a custom dashboard or a pivot table
How can Coupler.io be useful in real life? Let’s check it out through the example of a regular ecommerce business: an online sandwich store in San Francisco. The owner uses Airtable to store information about customers, products, and orders. Here is this small database:
Google Sheets comes into play when there is a need to check which sandwich was the most popular last month. For this, we imported the database (all tables) using Coupler.io. Here is the raw data:
Note: Google Sheets does not detect date format automatically. After the import, you’ll have to highlight time-related columns and apply the date format manually (Format => Number => Date):
Now you can build a dashboard with a couple of clicks:
Another actionable feature is to build a pivot table with the columns and values you need. We analyzed product popularity by customers in terms of the number of orders:
Many more features and complex calculations are available. If you use Google Sheets in conjunction with Airtable, you get a powerful analytical tool to be used in any of life’s circumstances, even raising children.
To wrap up
All you need for efficient decision-making is fast and reliable access to data. And you can get it if you combine the power of Airtable’s database with the flexibility of Google Sheets. What remains is to link them together using Coupler.io – a simple and actionable solution for data-driven individuals and companies.