Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Data Sync & ETL

Data Sync & ETL

Geocode Addresses with Open Route API into Google Sheets

When you run it, it loops through addresses from Google Sheets, queries Open Route API for coordinates, and saves the geocoding results.

Import it free Sign in to open it

What it does

### 1. Trigger the workflow This starts by collecting all the addresses (with the country code) that need geocoding information. #### How to setup? - Load records in the Google Sheet Node: 1. Add your Google Sheet API credentials to access the Google Sheet file 2. Select the file using the list, an URL or an ID 3. Select the sheet in which you want to record your working sessions 4. Map the fields: country, address , longitude, latitude, borough, neighbourhood, localadmin Learn more about the Google Sheet Node The last five fields must be left empty as they will be filled with the API outputs.

The steps

  1. When clicking ‘Test workflow’
  2. Collect Addresses
  3. Query Open Route API
  4. Loop Over Addresses
  5. Save Results
  6. Extract Results
  7. 5 sec

Similar automations

Data Sync & ETLEstimate Driving Time and Distance with OpenRouteService7 stepsData Sync & ETLConvert Addresses to Coordinates with Google Maps and Sheets4 stepsAI Agents & AssistantsWeather Forecast Chat Agent with OpenAI and Open-Meteo27 stepsData Sync & ETLRoute scored GTM signals from BigQuery to HubSpot with Telegram and Google Sheets14 steps