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 :
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
