Update Google Contacts from Excel

Hello!

I’m creating a scenery with watch trigger of Excel table and update them in Google Contacts.

But, the scenery shows error because I don’t have Contact ID in Excel

How can i do this?

Welcome to the Make community!

You can perform a “Search Contacts” to see if the contact exists first.

Screenshot_2024-06-14_140657

If yes, the contact with the ID will be returned, and you can map that ID into the Update module.

samliewrequest private consultation

Join the Make Fans Discord server to chat with other makers!

1 Like

Great. It’s sounds like the best way, but I don’t know how to set up the Query Search.
In Excel I just have the Name and Phone, and I would like to search the phone and returns the contact id to use the updated module.

So what happens if you map the phone number into that field?

samliewrequest private consultation

Join the unofficial Make Discord server to chat with us!

1 Like