#Sync airtable and google sheets how to#
#Sync airtable and google sheets full#

The integration is now ready and you can run the scenario. In the end, your scenario should look like this: Press the Ok Button to save and close the configuration dialog. Your Airtable module configuration should now look like this: Fill in the Airtable Phone field the same way. 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.

Since Google Contacts allows you to store multiple emails for a single contact, we will select only the first one.

#Sync airtable and google sheets full#

For the Name field, you can use Google Contacts' Full Name field.

#Sync airtable and google sheets how to#

When you click on the field, you will be presented with a number of options on how to fill this field. In our example, we have just 3 fields: Name, Email, and Phone. After you select your table you will be presented with fields that are preset in this table.

First, you have to select a table that will store your contacts. Now that you have your API token, just copy it over to the API token field in Integromat and click the Save button.Īfter the account has been linked to Integromat, you can continue setting up your scenario. If you already have a token, there is no need to regenerate a new one. But it is easy to generate one - just press the Generate token link and your API token will be generated by Airtable. If you haven't used Airtable's API before, you will not have an API token. In order to get your API token, head to, scroll down a bit and there you will see the API token field. After clicking the Add button, you will be prompted to enter your Airtable email, password, and API token. Now, add a connection to Airtable in the same way you did with the Google Contacts module. In the next step, add a new module to the scenario, select Airtable and the Create a record module. Select the appropriate account and approve access for Integromat. Your Google email or name is a good choice.Īfter you click the Save button, a window will pop up asking you to select which Google account you want to use. 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. A dialog will pop up asking you to name your connection. Then, in this module, to the right of the Connection field press the Add button. Then add the Google Contacts Watch contacts module. Adding Google Contactsįirst, you have to 'Create a new scenario' in your dashboard. In the following guide, we will show you how to connect Airtable to Google Contacts and synchronize a list of contacts between these services. One of the many great features of Integromat is the ability to interconnect services. How to connect Airtable and Google contacts and synchronize contacts between these services