I was looking for a way to extract/validate a US address in a single Google sheet cell.
I was looking for a way to extract/validate a US address in a single Google sheet cell.
Hi
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
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.