Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

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! 

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 

Terms & Conditions