Best answer

Validate/Extract US address from a Google Sheet cell

  • 2 December 2021
  • 5 replies
  • 31 views

I was looking for a way to extract/validate a US address in a single Google sheet cell.

 

icon

Best answer by Troy Tessalone 7 December 2021, 19:57

View original

5 replies

Userlevel 7
Badge +12

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 +12

@Yidi 

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 +12

@Yidi

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

Reply