Through this seamless integration, Coefficient elevates the capabilities of Airtable users in project and document management, contact databases, and task lists. By offering a streamlined method to import essential data into Google Sheets/Excel, Coefficient empowers users to further enhance their workflows.

Connecting to Airtable

Import from Airtable

Schedule your Import, Snapshots, and Add Automations

FAQs for Airtable

Connecting to Airtable

When you begin an Airtable import for the first time, you will need to go through a few steps to authorize Coefficient and provide access to your bases and workspaces.

6. Click “+Add a base”, then select the base you would like to give Coefficient access to and click “Grant Access” when done.

Import from Airtable

5. The Import Preview window will reflect a sample (50 rows) of data based on the fields selected (checked/unchecked). 

ℹ️ Note: All filters/sorting options are reflective of the Airtable view when imported using Coefficient. This means that if you want to filter/sort your data further, you will need to make the adjustment in the Airtable UI for that view.6. Congratulations on your first Airtable import in Coefficient! 🎉

ℹ️ Note: The default name of your import is based on the Table’s name and not the View name. You can always modify it to your liking if needed. 👍🏼

Schedule your Import, Snapshots, and Add Automations

Once you have pulled your data into spreadsheets using Coefficient, you can set up the following:

FAQs for Airtable

When I connected Coefficient to Airtable, I picked a specific base, but now I want to import from other bases. What do I do?

This is easily remedied in Coefficient - not to worry. You will need to go through these steps to “Reauthorize” Coefficient to your Airtable instance. This means that you are going to expand the permissions for Coefficient to pull in more data from your other bases. When you get to the screen to “+Add a base” make sure you select the option, “All current and future bases in all current and future workspaces”.

I need to add a filter/sort to my Airtable import. How do I do that?

Any filtering and sorting must be done in the Airtable UI. So if you need additional filters on your Coefficient import, you will need to update the source in the Airtable UI.

How do I import a view that is a Gannt chart?

Gannt charts are not currently supported in Coefficient. If you select a Gannt chart/view we will default to pulling in all of the records from the underlying table.

I am getting this error message when I try to authenticate with Airtable, how can I resolve this?

Airtable has a limit of up to 20 connections per user per app when connecting to third-party integrations like Coefficient. To resolve this error, you need to log in to Airtable and delete one of your expired connections.

Steps to Delete an Expired Connection in Airtable:

1. Click your Profile (avatar) icon on the upper-right-hand side.
2. Select “Integrations”.
3. Go to the “Third-party integrations” tab.
4. Select Coefficient from the list and click ‘Delete’.
5. Go back to the sidebar and try to re-authenticate again.

If you followed the above steps and removed the expired connection and are still seeing the error message (above), please reach out to support (support@coefficient.io) for further assistance.

I am getting an "Invalid Airtable view URL" error when creating an import. What do I do?