Skip to main content

Hello,

In short, my CRM is connected to a google sheet that updates columsn in the row everytime Certain CRM fields are udpated.

That informatino is then passed to airtable through the Zap that creates a record when a new row is added to the Google sheet. 

The issue is that when that particular row is updated it creates another record in airtable.

How do tell that zap to not create a new record in airtable if the contact already exists and just update the one that is there?

I do know that there is a create new record when the sheet updates zap (which is what I am using) and also a update record zap when the sheets updates. (Not using) 

Each row is identified by a unique number in the first column if that helps.

 

Hi @erickam 

Try adding an Airtable Find/Created Record step to your Zap followed by an Airtable Update Record step.

Logic is to create if not found, then update either the created record or the found record in Airtable.