Airtable

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.

  1. Select the Data tab at the top left of the global navigation. Then click on Connections in the Data Library section.
  2. Select the blue Connect button, search for Airtable, and click on the logo.
  3. 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.

  4. 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.

  5. Now, you can add the tables listed in the custom tables.

  6. 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.

Adding Airtable Base Data to Metrics

  1. Click on Add metric from the dashboard. Under Airtable Settings, you can select Get Airtable Base from the drop-down list.
  2. In order to pull information, you will then need the Base ID and the Base Name.
  3. 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.
  1. Next, select the base you would like to access.
  1. 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.
  1. 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.

  2. 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.

Was this article helpful?