Convert addresses to latLong with Google Sheets and Google Maps API
Ready for 3.0What this workflow does
This workflow has 4 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets. It also calls maps.googleapis.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Extract The Places from Google Sheet (Google Sheets): uses Google Sheets
- Using Google Map API to Return Lat Long Back (HTTP Request): calls maps.googleapis.com
- Update Lat-Long in Each Places (Google Sheets): update
Services it uses
HTTP calls to: maps.googleapis.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (3)
- Manual Trigger
n8n-nodes-base.manualTrigger - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets
From the author
Template Detail This template automates the process of converting a list of addresses into their latitude and longitude (LatLong) coordinates using Google Sheets and the Google Maps API. It's designed for businesses, developers, and analysts who need accurate…