How to connect Airtable and Google contacts and synchronize contacts between these services

One of the many great features of Integromat is the ability to interconnect services. In the following guide, we will show you how to connect Airtable to Google Contacts and synchronize a list of contacts between these services.

Adding Google Contacts

First, you have to "Create a new scenario" in your dashboard. Then add the Google Contacts Watch contacts module. Then, in this module, to the right of the Connection field press the Add button. A dialog will pop up asking you to name your connection. You can enter whatever name you like, but we recommend to use names from which you can derive which Google account the connection relates to, in case you forget it. Your Google email or name is a good choice.

After you click the Save button, a window will pop up asking you to select which Google account you want to use. Select the appropriate account and approve access for Integromat.

Adding Airtable

In the next step, add a new module to the scenario, select Airtable and the Create a record module. Now, add a connection to Airtable in the same way you did with the Google Contacts module. After clicking the Add button, you will be prompted to enter your Airtable email, password, and API token.

In order to get your API token, head to https://airtable.com/account, scroll down a bit and there you will see the API token field. If you haven't used Airtable's API before, you will not have an API token. But it is easy to generate one - just press the Generate token link and your API token will be generated by Airtable. If you already have a token, there is no need to regenerate a new one.

Now that you have your API token, just copy it over to the API token field in Integromat and click the Save button.

Configuring the scenario

After the account has been linked to Integromat, you can continue setting up your scenario. First, you have to select a table that will store your contacts. After you select your table you will be presented with fields that are preset in this table. In our example, we have just 3 fields: Name, Email, and Phone. When you click on the field, you will be presented with a number of options on how to fill this field. For the Name field, you can use Google Contacts' Full Name field. Since Google Contacts allows you to store multiple emails for a single contact, we will select only the first one. Press the Airtable Emailfield, then, in the newly opened dialog find the Emails[] field, click a little triangle to the right of Emails[], this will expand the Emails[] field, and click on Email. Fill in the Airtable Phone field the same way.

Your Airtable module configuration should now look like this:

Press the Ok Button to save and close the configuration dialog.

In the end, your scenario should look like this:

The integration is now ready and you can run the scenario. If you have some contacts in Google Contacts and if everything has been processed without errors, you will see that the Watch contacts module has generated some bundles and that the Create a record module has successfully created new records out of the bundles generated by the Watch contacts module. Now, you can go to your Airtable table and verify that the data is there.

Popular use cases from our blog

slack-automation-illustration

Slack Automation: 20 Free Templates to Get You Inspired

google-sheets-automation-alt

Google Sheets Automation for Ecommerce: 23 Free Templates

tweet-automation-illustration

How to Get Someone's Tweets Before Anyone Else Does

onboarding-automation-with-integromat-alt

How to Automate Employee Onboarding in Minutes with Integromat

shopify-order-to-manufacturer-illustration-alt

How to Auto Send Shopify Orders to Dropshipping Suppliers [Guide]

strava-exercise-to-google-sheets-illustration

Like a Champ: How to Save Strava Activities to Google Sheets

Didn’t find what you were looking for?

Ticket

Create a ticket

Contact our world-class support team and tell us what’s happening.

Create a ticket
Expert

Find an expert

We feature a network of 450+ certified partners across the globe who are ready to help

Find an expert

Automate any workflow in your business

Sign up for a free account today. No credit card required, no time limits on free plan.