Best answer

Need help setting up Zap between Airtable and Google Sheet


Hi there! I’m new to Zapier and am having issues setting up a pretty straightforward Zap from Airtable to Google Sheets. 

I’m trying to have rows be duplicated for the first time from Airtable into a Google Sheet when the status is updated to “In Transit.” I am then hoping for that same entry to only update the status to “delivered” when I make that update in Airtable. 

I believe I have figured out the initial Zap from AT to Google Sheet to create the new row. My issue now is triggering the updated status when it’s changed in AT, and not duplicating the entry. 

I’m tried reviewing this help sheet but still to not avail. 

Thanks for any and all help/recommendations, Zap community! 

icon

Best answer by rebvangelos 29 May 2020, 17:07

View original

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

3 replies

Userlevel 7
Badge +9

Hey there! Welcome to the community! 

 

For  the second part of this, when the field is changed, you want to create a view with a filter that captures this status change.

You then want to create a zap which is triggered based on a new record that comes into this view

 

Then you want to find the record in Google sheets by looking it up, and then update it.

 

Let me know how you get on!

 

Thank you very much!

I believe I’ve gotten the initial transfer from AT to Sheets down

I’ve attempted to follow the steps above but it keeps “bargling” haha 

When I’m doing the Google Sheet lookup, I should use dyanmic search right? 

Ah I think I figured it out!! Thank you so much!! You’re a life-saver