🔬 Convert addresses to latLong with Google Sheets and Google Maps API
⚡ 3,627 views · 🔬 Document Extraction & Analysis
Description
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 geolocation data for use cases like delivery routing, event planning, or market analysis.
What the Template Does
- Fetch Address Data: Retrieves addresses from a Google Sheet.
- Google Maps API Integration: Sends each address to the Google Maps API and retrieves the corresponding LatLong coordinates.
- Update Google Sheets: Automatically updates the same Google Sheet with the LatLong data for each address.
Enhancements
- Google Sheets Template: Provide a pre-configured Google Sheets template that users can copy. Example link: Google Sheets Template.
Columns required:
- Address: Column to input addresses.
- LatLong: Column for the latitude and longitude results.
Updated Workflow Structure
- Trigger:
- A manual trigger node starts the workflow.
- Retrieve Data from Google Sheets:
- Fetch addresses from a Google Sheet.
- Send to Google Maps API:
- For each address, retrieve the LatLong coordinates directly via the Google Maps API.
- Update Google Sheets:
- Write the LatLong results back into the Google Sheet.
Steps to Use
- Prepare Google Sheet:
- Copy the provided Google Sheets template and add your addresses to the
Addresscolumn.
- Copy the provided Google Sheets template and add your addresses to the
- Configure Google Cloud API:
- Enable the Maps API for your Google Cloud project.
- Generate an API key with the required permissions.
- Run the Workflow:
- Start the workflow in n8n; it will process the addresses automatically.
- Updated LatLong data will appear in the corresponding Google Sheet.
- Review the Results:
- Use the enriched LatLong data for mapping or analysis.
🔗 Nodes Used
Google Sheets, HTTP Request
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File