Skip to main content
Best answer

Updates in Google Sheets added as new records instead of updating existing records in Airtable

  • February 26, 2021
  • 1 reply
  • 60 views

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.

 

Best answer by Troy Tessalone

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.

 

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • February 26, 2021

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.