Skip to content
  • Documentation >
  • Tutorials >
  • How to connect Airtable and Google contacts and synchronize contacts between these services

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

One of the many great features of Ibexa Connect 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

  1. Go to your dashboard and click Create a new scenario.

    Dashboard-create_a_new_scenario_.png

  2. Select Google Contact and then Watch contacts module.

  3. In the module, click Add to add a connection. A dialog pops up asking you to name your connection. You can enter whichever name you like. We recommend using 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.

    My_google_connection.png

  4. Click Save. A window pops up asking you to select which Google account you want to use. Select the appropriate account and approve access for Ibexa Connect.

    Airtable-and-Google_contacts-2.png

Adding Airtable

  1. Add a new module to the scenario, select Airtable and Create a record module.

  2. Add a connection to Airtable in the same way you did with the Google Contacts module.

  3. After clicking the Add button, the system prompts you to enter your Airtable email, password, and API token.

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

    Airtable-and-Google_contacts-3.png

  5. Copy your API token over to the API token field in Ibexa Connect and click Save.

    Airtable_.png

Configuring the scenario

After your Google and Airtable accounts have been linked to Ibexa Connect, you can continue setting up your scenario.

  1. In Airtable, select a table that stores your contacts.

  2. The same fields show in Ibexa Connect as in your table. In our example, there are only 3 fields: Name, Email, and Phone. When you click on the field, a number of options show 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 Email field, 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:

    Airtable-and-Google_contacts-5.png

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

  4. Your scenario should look like this:

    Airtable-and-Google_contacts-6.png

  5. Run your scenario.

    If you have some contacts in Google Contacts and if everything has been processed without errors, Watch contacts module generates some bundles. Also Create a record module successfully creates new records out of the bundles which the Watch contacts module generated.

  6. Go to your table and verify that the data is there.

    Airtable-and-Google_contacts-7.png