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 Airtable API Key, Base ID, and Base Name.
- Click on the Data tab at the top left of the global navigation. Then click on Connections in the Data Library section.
- Click on the blue Connect button, search for Airtable, and click on the logo.
- 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.
- Once you put your API Key into Grow, your account will then be authorized.
Adding Airtable base data to a Metric
- 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 will need to log in to Airtable if you aren't already.
- Next, 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.
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.
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.