Geocoding addresses

I used to use Google Sheets to geocode for Leaflet maps, but:

You can display Geocoding API results on a Google Map, or without a map. If you want to display Geocoding API results on a map, then these results must be displayed on a Google Map. It is prohibited to use Geocoding API data on a map that is not a Google map.

Geocoding API Policies

So here are other possibilities for getting your geocoding done:

And if you are going to use a Google Map, then this code will be helpful to get your addresses geocoded for you.