I was looking for a way to extract/validate a US address in a single Google sheet cell.
Best answer
Validate/Extract US address from a Google Sheet cell
- Beginner
Best answer by Troy Tessalone
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
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
Can you provide a specific example to give context?
- Beginner
I have a long list of address i’m sending out mail to.
See some example cells:
|
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. |
here the address should start from the number 9+14- Zapier Orchestrator & Solution Partner
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:
- Street 2 being included/excluded
- Cities with mutliple names
- States with multiple names
+14- Zapier Orchestrator & Solution Partner
- Answer
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.