Skip to main content
Best answer

Sync Google Sheets Update to Airtable

  • November 29, 2022
  • 2 replies
  • 128 views

Hi guys!

I´m regularly updating some Google Sheets table which I want to sync automatically with Airtable.

This is how I planned to do it:

However, within Airtable → Set up action, I have to chose a record. This record (row in Airtable) is the only record that gets updated. The other records (rows) remain the same and do not sync with the values from Google Sheets.

Does anybody have an idea how to solve that?

Best answer by Troy Tessalone

Hi @tobizaps 

Good question.

Take note of the [Or add search step] option as shown in the screenshot below.

In the Zap, as Step 2, add this action: Airtable - Find Record

Then map the returned Record ID to the Zap action step: Airtable - Update Record

 

 

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31349 replies
  • Answer
  • November 29, 2022

Hi @tobizaps 

Good question.

Take note of the [Or add search step] option as shown in the screenshot below.

In the Zap, as Step 2, add this action: Airtable - Find Record

Then map the returned Record ID to the Zap action step: Airtable - Update Record

 

 


  • Author
  • Beginner
  • 1 reply
  • November 29, 2022

Thanks a lot Troy! That´s it! :)