With this integration, you can send information from Typeform to an Airtable base. From collecting leads for your sales CRM to organizing an event, you can use the conversational feel of Typeform to populate your Airtable.
What you need:
- An Airtable account with a base and table set up.
- A Free or higher Typeform account.
- A typeform with questions corresponding to your Airtable fields.
Read on for detailed instructions on how to connect to Airtable and set up your mappings.
Using Airtable in Automations? You can also send form submission or contact data to Airtable from Automations. To get started, create an automation, add a Send to integration action, choose Airtable, then follow the steps below. The main difference is how you open the integration.
Getting started
Typeform offers a neat way to collect information and send it to an Airtable. The first thing you’ll need to do is create the typeform that will feed your Airtable. For every Airtable field you want to send information to, you need a corresponding question in your typeform.
For this tutorial, we’re using an event planning Airtable, and a typeform with questions that correspond to each field. So, the Date field has a corresponding typeform Date question, and so on. Once you’ve made a typeform, with questions for all the information you want to collect in Airtable, you can set up the integration.
Note that this integration only creates new Airtable records, and does not update existing Airtable records. This integration also does not backfill responses you've already collected. However, you can add a Typeform Extension to your Airtable base to populate a table from existing responses you've collected. Learn more about importing responses from a typeform to an Airtable base here.
Note! If you're using a free Airtable plan, please check out their API rate limits here. If you go over the rate limit, the integration may stop working.
1. Open the Airtable integration. If you're setting this up from your typeform, open it from your Workspace, go to the Connect panel, find Airtable, and click Connect. If you're setting it up from Automations, add a Send to integration action and choose Airtable. Then continue to step 2.
2. If you’ve already connected an Airtable account to your Typeform account, click the dropdown under Choose an account to select which account you want to use for this automation.
If you haven’t connected an Airtable account yet, click Add a new account and follow the prompts to log into your Airtable account.
3. Now it's time to grant Typeform Airtable access. Click Grant access.
Now you can select the base where you want your Typeform data to be sent.
Click Next.
Warning! Airtable has a restriction that prevents a single user from authorizing the same integration more than 20 times. If you encounter an error message resembling the one below, it indicates that you have reached the maximum number of access permissions:
You have reached the maximum number of access permissions for this integration. You can't re-authorize this integration until you revoke at least one of the permissions for Typeform from the Integrations of your Account menu.
To address this limitation, consider one of the following suggestions:
- Reuse an authorization: Optimize your authorizations by reusing an existing one across multiple forms. This allows you to stay within the 20-authorization limit without creating new ones each time.
- Create an authorization with more permissions: Alternatively, create authorizations with broader permissions that can be reused across various forms. If you're not very tech-savvy, you might need a hand from a developer friend for this one.
- Revoke an authorization: Finally, you can follow the guidelines provided in Airtable's help article to revoke an authorization. However, be cautious as revoking an authorization will break any existing integrations relying on it.
4. Next, you’ll choose the table you want to send data to.
Note that this integration will only create new records in the table. Existing records won't be updated based on matching information.
5. Time for the really important part: connecting your typeform questions to their corresponding fields.
Click + Map to Property
Choose a question from the left dropdown, then click on the right dropdown to find the corresponding Airtable field.
Below you can see our typeform questions on the left.
And on the right, the valid Airtable fields.
Here are our questions and fields connected.
After connecting each question, click + Map to Property, and when you’ve finished, click Finish.
Note! If you do not see a corresponding Airtable field, check the field type in Airtable, to ensure it matches your typeform question type. There is a table of compatible questions and field types at the end of this article.
6. That’s it. Your Airtable setup is now live.
If you set it up from the Connect panel, you’ll see the Airtable integration listed there. Use the blue toggle to turn it on or off, and click the three-dot menu if you want to delete it.
If you set it up from Automations, you’ll see Airtable as part of your automation workflow.
Currently, you can’t edit the Airtable integration. If you’ve changed your typeform questions or want to update how questions map to Airtable fields, you’ll need to delete the integration and set it up again.
7. To finish, test your setup by submitting a response through your typeform. Open the form, complete it, and click Submit.
Then check Airtable to make sure your submission appears in the correct table. You should see the new record almost immediately.
If everything looks right, you can delete the test record in Airtable if needed. After that, your future typeform responses will continue flowing into Airtable automatically.
You can find the list of Typeform questions and compatible Airtable field types along with answers to the most common questions about mappings here.