Send Airtable contacts to Attio when a form is submitted 

Airtable is a powerful low-code platform for building collaborative apps, databases, and forms. Here’s how to collect leads from your form in Airtable, and use Zapier to send them to your Attio list.

Prep: Connect Attio to Zapier

Follow our guide on how to connect Attio to Zapier, making sure you've set up your API key with both read and write permissions.

Prep: Connect Airtable to Zapier

To connect Airtable to Zapier, you’ll need your API Key. From your Airtable dashboard, click the profile icon in the top right - this will be an avatar if you’ve set one. Choose Account from the dropdown to access the Account overview.

Under API you can generate your API key and copy it to your clipboard. By default your key will have read and write permissions, which is what we want.

Next, head to your Zapier dashboard and click Add connection in the top right. Search for Airtable and pick it from the dropdown. You’ll now be prompted for your API Key - enter it and click Yes, Continue. If you get stuck, this guide should help.

1. Create a form in Airtable

To collect leads, we're going to build a form in Airtable. Navigate to the Create… menu in the bottom left of your Airtable dashboard and choose Form - this will bring up the form editor window. Here you can customize your form, adding whichever fields you’d like. For this example, our form will collect a name, email address, a company name, and a domain. We can remove the other fields we won't need from the template by dragging them to the pane on the left.

An example Airtable form with fields for name, email address, company name, and web address.
Create a new form in Airtable

When you’re done, head to the top navigation to preview your form with Open form or share it with a link or embed code by clicking Share.

Note: It’ll be helpful later on if you’ve given your form a memorable name.

Now that your form is out there collecting data, new submissions will be recorded in your Airtable Base. Next we'll set up a trigger in Zapier to run whenever this happens.

2. Create a trigger in Zapier

From your Zapier dashboard, click Create Zap in the top left.

Search for Airtable in the App Event window, and from the Trigger Event dropdown pick New Record. Choose your Airtable account and click Continue.

Next, set up the trigger. Select your Base (our ‘Sales’ database in this example) and Table (we’ll be using a list called ‘Leads’) from the dropdowns. You can leave Limit to View blank. Continue to test your trigger.

An Airtable trigger is shown in Zapier, with a chosen base and table - the Zap will trigger when a new record is added.
Tell Zapier what to look for before running the Zap

3. Tidy up your data

Once you’ve set up your trigger, you’ll need to do a bit of housekeeping to format the data correctly. Our Airtable form collects full names in one field, so we need to split them into two values before we can send them to Attio.

Click Format on the right of the new action step, and choose Text from the Action Event dropdown. For Transform, scroll down and pick Split Text. In the Input field, select 1.Name. Leave Separator blank and pick First from the Segment Index dropdown. Continue to test your step.

Zapier's split text tool is being used to break up the name Pippa Duffy into  seperate first and name values.
Use Zapier's Formatter to split first and last names into separate values

Add another action with the + icon, and repeat the process except this time, pick Last from the Segment Index dropdown. Learn more about splitting names in Zapier.
Run a test and Continue.

4. Create a person in Attio

With your data now formatted, create a new action step and pick Attio from the App Event dropdown. For Action Event, choose Find or Create a Person. Select your Attio account, and set up your action like this:

An action step in Zapier is shown, with name and address values being pulled in from prior steps.
Locate an existing person or create a new one in your Attio workspace

Test your action and Continue.

5. Create and link a company in Attio

Next up we'll create a new company in Attio. Add another step and choose Attio, but this time select Find or Create Company. Choose your Attio account and set up your action like this:

Another action step in Zapier, this time creating a new company record. The example company name is given, along with its web address.
Create a new company in your Attio workspace using values from previous steps

We now need a step to link your person to their company in Attio. Add another action with + and choose Attio. Pick Link a Person and Company from the dropdown, and choose your Attio account once again. In this step, we’re telling Zapier to link the data we sent to Attio in steps 4 and 5 of our Zap. Set your action up like this:

An action step in Zapier shows the linking of both the person and company records created in prior steps
Attio treats people and companies differently - you'll need to tell Zapier to link the two records

You can leave Title blank. Test your action and Continue.

Note: If your Airtable form collects job titles, clicking in the Title box and selecting this data from the Insert data dropdown will send this extra field to Attio.

6. Create an entry for your record

Now onto the final step. Add a final action and pick Attio from the list of apps. Choose Find or Create Entry for your Action Event - this step will move your newly created person (with their company info) into a list. Select your Attio account, and set up your action like this:

The final action step in the Zap shows an entry being created in the Sales list of our example workspace, pulling in data from prior steps
Create a new entry in your chosen Attio list using values from prior steps

Once tested, your Zap is good to go! Now anytime someone fills out your Airtable form, Zapier will format their data and send them to your Attio list.

Couldn't find something?

Send us a message in the chat on the right ✌️

© 2023 Attio Ltd. All rights reserved.
We use cookies to improve your experience. You can opt out of certain cookies. Find out more in our privacy policy.