I want to "Add New or Update" the records in Airtable whenever Google Contact is updated/created. What modules should I use in the flow?

How To
,
1

I want to “Add New or Update” the records in Airtable whenever Google Contact is updated/created. What modules should I use in the flow? Is “Google Contact - Watch New contact” or “Google Contact - Upsert”? I’ve tried both with no luck.

Right now I use “Watch Contacts” and “Create Record” - all contacts are added again and again, I have many duplicate records in my Airtable. ;-(

2

You will have to perform a Search in the Airtable for that contact.

Try using the Airtable “Search Records” module:

Searches for specific records or returns all records.

For more information, see https://www.make.com/en/integrations/airtable, and https://www.make.com/en/help/app/airtable in the help centre.

Connect the Search module to a router with two paths, and filters to check the result of the Airtable Search module.

  • If there are results, update the record in Airtable.

  • If there are no results, create a new record in Airtable.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

1 Like
3

Thanks a lot Samliew, may I ask, what should I put in the Formula for it to compare the new phone number with those already in the Airtable?

4

Hello @Chloe_Chiu,
As @samliew, you need to get data from airtable and then compare it with the Google contact data.

Loop(Iteration) through all the rows of Airtable, then use a router, Then use 2 different routes for found and not found..

Need to set filters like this https://www.make.com/en/help/scenarios/filtering#filtering
In the filter settings use the field and its value for comparison. (values are data-type sensitive).

I hope this helps :+1: