All-in-one collaboration platform of Airtable unites the best parts of spreadsheets and databases to deliver a flexible management solution for teams of any size. Here is a quick overview of the Airtable/Grow integration.
Connecting to Airtable
Before connecting please collect your Base ID and Base Name.
- Select the Data tab at the top left of the global navigation. Then click on Connections in the Data Library section.
- Select the blue Connect button, search for Airtable, and click on the logo.
-
A window will pop up to log in with your Airtable credentials. After entering your credentials you will see another screen stating that Grow is requesting Airtable access. Click the + Add a base button and select the base you want Grow to have access.
We highly recommend to provide access to all boards in order to avoid future disconnections or limited access to your data. To provide access to all boards, select All current and future bases in all current and future workspaces option.
-
Select Grant Access. You will see a green confirmation message that the connection has been made.
You might jump directly to the access screen if you were already logged in with your Airtable account. Grow will use that account to connect.
Now, you can add the tables listed in the custom tables.
- To connect your Airtable account you will need your API Key. To find your API Key, log in to Airtable and go to your account page. It will you will find your API Key on the Overview page.
Data Warehousing
Airtable is on the Grow Data Warehouse, which we highly recommend you use. For more information about warehousing your data, visit the Data Warehouse Help Article.
Tables
The list of tables available depends on your unique Airtable. You can expect to see one table per dataset associated with the project ID in your connection.
Custom Tables
Grow offers you the flexibility to configure custom tables as you see fit. This helps you to bring only relevant data into Grow, increasing the performance of the metrics.
You can customize the table as per the available options in the dropdown provided for Base, Table and, View.
Warehousing Your Data
-
In the Connections Overview Page, click on your Airtable connection.
This opens the Connection Details page. - Select the Manage Connection button inside the Connection Details section to open the warehouse table selection flow.
-
Select the data you want stored in the Data Warehouse and click the Sync & Store button at the bottom of the Manage Connection page.
This begins the initial population of your warehouse with the tables you defined. Populating your data warehouse for the first time may take a while, sometimes up to several hours.
You may continue working within the app while your data is In Queue or Processing.
If your data source is not already connected, refer to the Connecting to a Data Source for more details.
Sync Interval
Full Sync
Full sync intervals is 12 hours for Custom Tables.
Incremental Sync
Incremental sync is not supported for Custom Tables.
To learn more about sync intervals and how to adjust the default settings, please visit the Sync section of the Data Warehouse help article.
Adding Airtable Base Data to Metrics
- Click on Add metric from the dashboard. Under Airtable Settings, you can select Get Airtable Base from the drop-down list.
- In order to pull information, you will then need the Base ID and the Base Name.
- In order to find your Base ID, first click on the Airtable API documentation link next to your API Key. You can also Google Airtable API documentation.
You need to log in to Airtable if you aren't already.
- Select the base you would like to access.
- Pull the Base ID from the example URL they give in the introduction to the base you chose. It's the value between "/ /" and looks like apphXmBxHuxynZ2Kf.
- Your Base Name is found in two places. The first place you can find it is at the end of the example URL.
For example, this one is called Design Projects, just remove the "%20".
Another place to find the Base Name is on the left side of the API documentation, remove the TABLE from the name.
- Populate these values into the respective fields in Grow and hit Get Data.
Now you can add any transforms to your Airtable data and build your metrics.
Endpoints
Airtable's graphical interface provides the ability to create custom databases, or bases. Before a base is pulled into Grow it can be organized specifically to the nature of the metric or metrics desired. This provides a highly personalized and focused reporting experience in Grow.
FAQ
Why are my fields showing ID numbers instead of actual values?
Your data is coming in as IDs rather than values because you are linking that data to other fields in Airtable. This works great in Airtable, but we can't get those actual values in Grow, it will only come in as the ID numbers. You could bring in the table you are referencing in Airtable and join this data together in Grow with a Join report, or you could change your table in Airtable to not reference the other table and the values will come in as you see them on the table.
Why are not all my notes coming through?
There is a 450 character limit for information coming through into Grow for a specific cell. So, if your note has more than 450 characters in it, it will return as a blank cell.