Hi everybody,
I am trying to set up a specific automation. I have set up already the importation of emails in Airtable, in the table "my emails". It looks like this :
![Arthur_CRM_0-1719236650767.png Arthur_CRM_0-1719236650767.png](/t5/image/serverpage/image-id/35012iFF2ED3CCC768EBA3/image-size/medium?v=v2&px=400)
Now, I would like to automate the following steps :
- check if in table "Contacts", there is in the field "email" the same address email than in the field "email" from the table "my emails".
- if YES, then, in "my emails" in the linked field "Contact", link the existing contact with the same email address.
- if NO, then create a new record in the table "Contacts" with all the information of the new contact.
Basically the idea is simple : if the email comes from a know person, link the email to the person, if it comes from a new person, create a contact for this person.
Thank you so much,
Have a nice day,
Arthur