Turn latitude and longitude into address using Google Sheets and App Script

If you would like me to help you with your code, please schedule a time to have a google meet with me.
*30 minute google meet for $10*
calendly.com/a...
*15 minute meet for $5*
calendly.com/a...
*1 hour for $30*
calendly.com/a...

[@user-fd3vo9qg4g]

Very helpful! Thank you!

[@pemantauan]

thank you, this is what i look for.

[@bazaar_9.15]

thanks man, you are doing great

[@emax747]

Thanks for the short script but it is LIMITED in number of queries per day.. How can I get the same result using a https// query and with my APIKey from Google Maps API? Thanks for any help!

[@ryanpeterson7998]

thanks!

[@kabirlife1117]

Exception: Service invoked too many times for one day: geocode. (line 2). can some help me, why this error showing?

[@chimmoi3264]

do you have a solution for this issue?

[@reyhansyaiful2163]

Nice info there thank you, but i got error when testing a few of the lat nd long, idk why

[@keetakum]

this ez and good

[@shailesh1981able]

var response = Maps.newGeocoder().reverseGeocode(lat, long); Got error 'Exception: The parameters (null,null) don't match the method signature for Maps.Geocoder.reverseGeocode. reverse_geocode @ Code.gs:2' can you pls reply how to resolve it

[@wahyu7319]

same here

[@zowy5068]

same

[@daufbizz417]

function getLatLong() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var lastRow = sheet.getLastRow(); var addressesRange = sheet.getRange("F2:F" + lastRow); // Assuming addresses start from F2 downwards var addresses = addressesRange.getValues(); var output = []; for (var i = 0; i < addresses.length; i++) { var address = addresses[i][0]; if (address != "") { var response = Maps.newGeocoder().geocode(address); if (response.status === 'OK') { var location = response.results[0].geometry.location; output.push([location.lat, location.lng]); } else { output.push(["Error", "Error"]); // Push error values for both latitude and longitude } } else { output.push(["", ""]); // Push empty values for both latitude and longitude } } // Write latitude and longitude values to columns G and H sheet.getRange(2, 7, output.length, 2).setValues(output); } *Paste this to App Script then run for the result..hope will help..