Skip to content

Geocoding addresses

susanashlock edited this page Mar 23, 2020 · 1 revision

Addresses are stored in the "Street address for dropoffs"? column of the spreadsheet.

An Apps Script called "fillInGeocodes" automatically runs every 10 minutes to fill in data in the Lat and Lng columns.

You can also force this script to run. To do so from the spreadsheet, open "Tools", then "Script Editor". You should see a dropdown with a list of functions. Select "fillInGeocodes", then click on the "run" button (looks like a "play" button). Go back to the sheet and you should see the Lat and Lng cells filled in!