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'm looking to use a Google sheet as a database with multiple businesses' contact information. Based on the zip code input from a form (using Gravity Form), I want the sheet to look for the closest zip code and send an email.

I've tried using the lookup row function with Google sheet, but it won't trigger unless the zip code in the Google sheet is an exact match

Hi @AndreM 

Good question.

If you are trying to use a GSheet, then the value will need to exist as part of the lookup.

You’d need to map every Zip to it’s parent Zip.

Hey there @AndreM, As Troy is alluding to there isn’t a great way to do this in Zapier.   There is no way for Google Sheets to be able to compute the distance of Zip Code 1 vs Zip Code 2 and then pick the closest one.  

You would need some sort of a tremendously large reference table of all Zip Codes and their distances from one another to do a few different lookups and then perform the search of the Google Sheet.

Would your idea still work if you focused at the State level instead of the Zip Code level?  That may be a workaround if you needed to automate this through Zapier in some way if you would be able to modify your non-Zapier workflow.

Terms & Conditions