Convert user location to an address

[Vitor_Rosas]

Hello folks,

I’m improving an existing app and I 'm collecting the users location when they make de 1st access but I’d like to convert the location provided by Location component to an address. I didn’t find anything about it.

Did you already faced the same issue ?

[Jeff_Hager]

User coordinates-> zip & postal code in sheets

You can, with this: https://www.labnol.org/google-maps-sheets-200817 Of course this requires Script, but at least you don’t have to write a new one. The formula I am talking about is GOOGLEMAPS_REVERSEGEOCODE. You can alter the script to only show post codes, or split the address to read only the post code in the final column.

[Vitor_Rosas]

Great Jeff! Thanks! It will help me a lot.