This n8n workflow streamlines the process of enriching address data with geocoding information and geographical details. It is designed to fetch addresses from a Google Sheet, geocode each address using the OpenRouteService API, and then save the resulting coordinates and location data back into the Google Sheet.
The workflow begins with a manual trigger or test trigger, which prompts the collection of address records from a specified Google Sheet. Each address is then processed in a loop where an HTTP request is sent to the OpenRouteService geocoding API using the address and country code.
The geocoding response is parsed to extract precise GPS coordinates (latitude and longitude) along with additional location data such as borough, neighborhood, and local administrative area. These details are then written back into the original Google Sheet, updating the records with enriched geographical information.
This workflow is particularly useful for real estate, logistics, local government, or any organization that maintains address databases and needs to visualize or analyze locations more accurately.
Reviews
There are no reviews yet.