I've come up with a method for finding the lat/long coordinates of a list of addresses by using the US Census Geolocation Data. Unlike the Google Maps API and the Alteryx Address tools, the US Census API is free to use and publicly available, no credentials needed.
Here is the API's documentation: https://geocoding.geo.census.gov/geocoder/Geocoding_Services_API.html
As a backup, I've included a copy of ZIP Code Tabulation Areas from the Census Gazetteer files: https://www.census.gov/geographies/reference-files/time-series/geo/gazetteer-files.html
This means that even if you only have a ZIP code, the app will give back the lat/long of the center of the zip code area, thereby providing a rough estimate of the location.
The app file as-is is meant to be used on the server so the entire team can benefit from the tool, but it can easily be converted to a local flow or macro.
Hope this helps!
-Genesis Vasquez, NHTSA ODI
