About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.
Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.
Have a question? Let's get you an answer!
Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.
All of our best learning resources can be found here.
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.
Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.
Check out what is new and upcoming with Zapier with our regular product updates.
Early Access Program
Want to join Early Access? Learn more here.
Look as good as Zapier makes you feel with our new swag storefront.
I was looking for a way to extract/validate a US address in a single Google sheet cell.
Best answer by Troy Tessalone 7 December 2021, 19:57
Can you provide a specific example to give context?
I have a long list of address i’m sending out mail to.
See some example cells:
here the address should start from the number 9
D e f e ndant's R e sid e nc e Addr 9 S XXXXX AVE XXX X CITY, STATE XXXXX
here the address should start from the number 1948
D e f e ndant's R e sid e nc e Addr 1948 XXXXX XXXXXXXX CITY, STATE XXXXX
This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.
It’s going to be tough to reliably parse a full address in that format into the individual address data points due to likely data variations such as these:
Can zapier connect to google maps for address validation?
GMaps is not an available Zap app integration from Google: https://zapier.com/apps/categories/google
The GMaps API would have to be used: https://developers.google.com/maps
App APIs can be used in Zaps with the Webhooks app: https://zapier.com/apps/webhook/integrations
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.