How to Export List to Airtable and Create New Records without Duplicates

·

hey i wanted to export my list to airtable and create new records, but i dont want to have repeat records that i already have on my airtable. is there any way I can set a formula in which it looks at my airtable data and only creates new records if there arent any matching or similar entries already there?

4 comments

· Sorted by Oldest

Hashir Azam
·
·
https://app.clay.com/workspaces/216138/tables/t_s2vpNSpWruVG/views/gv_S6rIxHkjoakX#
Hashir Azam
·
·
here is my airtable list https://airtable.com/invite/l?inviteId=invfKSvddZHn1cxdm&inviteToken=6dc04c59dce6fd[…]email&utm_source=product_team&utm_content=transactional-alerts
Clay Team
APP
·
·
Hey, thanks for reaching out, sorry for the delay! Taking a look
Clay Team
APP
·
·
We do have a Lookup Record in Airtable integration that could help with that step, where you check for any existing matches and if they exist you use that as a conditional formula so it does not create a contact.
5d3287a3-649a-46a9-aa7c-16f33da0f7bc.png(43 kB)

Hashir Azam
·
·
https://app.clay.com/workspaces/216138/tables/t_s2vpNSpWruVG/views/gv_S6rIxHkjoakX#
Hashir Azam
·
·
here is my airtable list https://airtable.com/invite/l?inviteId=invfKSvddZHn1cxdm&inviteToken=6dc04c59dce6fd[…]email&utm_source=product_team&utm_content=transactional-alerts
Clay Team
APP
·
·
Hey, thanks for reaching out, sorry for the delay! Taking a look
Clay Team
APP
·
·
We do have a Lookup Record in Airtable integration that could help with that step, where you check for any existing matches and if they exist you use that as a conditional formula so it does not create a contact.
5d3287a3-649a-46a9-aa7c-16f33da0f7bc.png(43 kB)