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.

I have a flow which requires I do a lookup to a Google Sheet. I pass a person’s name, in order to return a system user ID, so when I map to my destination it can find the record.

Here is the issue. I have about 25 lookups.  I built a Zap with all of them in a single flow, but they won’t always have a value to send to the lookup. It errors when a value isn’t sent, which is breaking the flow.

I cannot use Paths to split the logic, because i would have 25 branches since you cannot bring back together a path once split.  I cannot use a Filter, because that will stop the entire flow.  I started to build out a Sub-Zap, but don’t think that will work either.

Any suggestions on how best to construct this?

Hi ​@deejmer 

If you use Airtable, you can search to Find Record using a Search Formula.

Airtable formula reference: https://support.airtable.com/docs/formula-field-reference

 

Hi ​@deejmer 

If you use Airtable, you can search to Find Record using a Search Formula.

Airtable formula reference: https://support.airtable.com/docs/formula-field-reference

 

I'm doing a lookup now to Google Sheets and it returns a value (when one is passed).  Are you saying that by using AirTable, i'm relying on their logic to determine if a number of field values are present or not, and if so, translate them and return it?

 

How will Zapier know to consume and send only the provided values through the mapping?

 

Pardon my ignorance, i’m still learning the platform.

Hi there, ​@deejmer! 👋

Perhaps you could add an error handler to allow the Zap to still carry out the necessary actions if the name is missing? You can find out more about error handlers here: Set up custom error handling

Alternatively, you could use Formatter’s (Text) Default Value action to pass a fallback value that will ensure it finds a specific row in the spreadsheet. Then have a path check whether that specific row’s details were found and if so, carry out the necessary actions that need to still be performed when no name is present. If you’ve not used that sort of Formatter action before check out our Find and replace values in your Zaps guide to learn more.

Do you think either of those approaches could work for your needs here?

Terms & ConditionsAccessibility statement