Best answer

Validate/Extract US address from a Google Sheet cell

  • 2 December 2021
  • 5 replies

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

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Userlevel 7
Badge +14

Hi @Yidi 

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. 

Userlevel 7
Badge +14


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

Can zapier connect to google maps for address validation? 

Userlevel 7
Badge +14


GMaps is not an available Zap app integration from Google:

The GMaps API would have to be used:

App APIs can be used in Zaps with the Webhooks app: