Reverse Geocoding

CFT

I am using a form with the pin drop to track sales employees in person visits / cold calls. The return value in my data sheet is the location coordinates hyperlink that takes you to Google Maps. Is there a way I can extract the address information from the coordinates into a separate column on my sheet? I have an enterprise account and have read what I can find on bridge and API but nothing really telling me how to do this. TIA!

Joe Goetschel

Hi CFT!

In a new column, just do a simple "={Column Name}@row" and make it a column formula.

This will convert the hyperlink to text. This this all you're looking to do or are you trying to get the URL separate?

CFT

I have it separated, looking to take the newly formatted Lat / Long and have it automatically convert and add address info into my sheet in separate columns, City, State, County. I could live with a full address and pull the data via formula if I had to.

Joe Goetschel

Totally understand now. Yes, you can do this with a Bridge workflow via JavaScript.

Let me know how we can help!

CFT

Thanks Joe, I am looking for instructions on how to do this. I am far from a programmer. I was hoping to get something detailed so I can get it set up.

My sheet set up is:

My hope is for City / State / County to autofill.

Joe Goetschel

@CFT Shoot me an email if you don't mind and I can get you some info! joe.goetschel@scscloud.com

Hope to talk soon,