FM
FlowMarket
General Automation Beginner ⚡ 4 n8n Nodes

Convert addresses to latLong with Google Sheets and Google Maps

Template Detail This template automates the process of converting a list of addresses into their latitude and longitude (LatLong) coordinates using Google Sh...

🔌 Nodes & Integrations Used (2)

HTTP Request Google Sheets

📖 Implementation & Setup Guide

#### **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** 1. **Fetch Address Data**: Retrieves addresses from a Google Sheet. 2. **Google Maps API Integration**: Sends each address to the Google Maps API and retrieves the corresponding LatLong coordinates. 3. **Update Google Sheets**: Automatically updates the same Google Sheet with the LatLong data for each address.

---

#### **Enhancements** 1. **Google Sheets Template**: Provide a pre-configured Google Sheets template that users can copy. Example link: [Google Sheets Template](https://docs.google.com/spreadsheets/d/1VvFne32djbKeo-g5pbpOaFKxU-ps0LyVVKsBbIUjRxk/edit?usp=sharing).

Columns required: - **Address**: Column to input addresses. - **LatLong**: Column for the latitude and longitude results.

---

#### **Updated Workflow Structure**

  1. **Trigger**:
  2. - A manual trigger node starts the workflow.
  3. **Retrieve Data from Google Sheets**:
  4. - Fetch addresses from a Google Sheet.
  5. **Send to Google Maps API**:
  6. - For each address, retrieve the LatLong coordinates directly via the Google Maps API.
  7. **Update Google Sheets**:
  8. - Write the LatLong results back into the Google Sheet.

---

#### **Steps to Use** 1. **Prepare Google Sheet**: - Copy the provided Google Sheets template and add your addresses to the `Address` column. 2. **Configure Google Cloud API**: - Enable the Maps API for your Google Cloud project. - Generate an API key with the required permissions. 3. **Run the Workflow**: - Start the workflow in n8n; it will process the addresses automatically. - Updated LatLong data will appear in the corresponding Google Sheet. 4. **Review the Results**: - Use the enriched LatLong data for mapping or analysis.

⚡ How to import this workflow into n8n:

  1. Click the Direct Download JSON button above to save Convert_addresses_to_latLong_with_Google_Sheets_and_Google_Maps.json.
  2. Log in to your n8n Cloud or self-hosted n8n instance.
  3. In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
  4. Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
  5. Click Execute Workflow to test and switch to Active!

Related General Automation Workflows

View All in General Automation →