Introducing Transfer by Zapier
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
Here are your assigned articles :)
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.