Hi @Grayfox , I put something together for you for Geoapify. You will just need to get an apikey from them, which is free.
I used the information from your excel file. The workflow looks like this:
I basically used the first column (Source Field), but removed the first and last names from the column, and created a URL for the geoapify’s api, for each rows:
The API KEY is set as “Enter API KEY here” in the workflow as you will need to enter your own API KEY.
After that, it will run in chunks of 5, and wait for 5 seconds between each batch/iteration:
Here’s the workflow:
Geoapify address standardization.knwf (28.2 KB)
You’ll just need to add your API KEY.