AutomationFlowsData & Sheets › Extract Business Data From Google Maps via Chat to Excel & Google Sheets

Extract Business Data From Google Maps via Chat to Excel & Google Sheets

ByAndrew @boanse on n8n.io

This workflow is designed for marketers, researchers, and business owners who need to quickly find and export company data from Google Maps into a structured table format.

Chat trigger trigger★★★★☆ complexityAI-powered15 nodesChat TriggerGoogle SheetsHTTP Request
Data & Sheets Trigger: Chat trigger Nodes: 15 Complexity: ★★★★☆ AI nodes: yes Added:

This workflow corresponds to n8n.io template #6249 — we link there as the canonical source.

This workflow follows the Chat Trigger → Google Sheets recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "id": "xIzZrNbnDh5o7gIc",
  "name": "Parser_from_Google_Maps_GoogleAPI-v1-db",
  "nodes": [
    {
      "id": "ebf2a54d-61b9-4efd-ad37-8b25e642b239",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        380
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "7b515f36-19d2-4ae0-be03-c9bc61c280ca",
      "name": "Tariffs",
      "type": "n8n-nodes-base.set",
      "position": [
        660,
        200
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "bc6963f3-c9da-4468-bf9c-9832b87ca34a",
      "name": "Split Out Maps NEW",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        1100,
        200
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "af4291c6-65bb-4f4a-b9d6-6814e1b8bab3",
      "name": "Extract Data",
      "type": "n8n-nodes-base.set",
      "position": [
        1320,
        200
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "f2f20b15-c1cf-440d-8714-da592ea6d115",
      "name": "When chat message received",
      "type": "@n8n/n8n-nodes-langchain.chatTrigger",
      "position": [
        0,
        200
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "dc966dd0-23e3-4f4a-9713-e846e230a938",
      "name": "Initialization",
      "type": "n8n-nodes-base.set",
      "position": [
        440,
        200
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "d994641d-2774-4818-bc2f-303f20cd1e67",
      "name": "Variables Chat",
      "type": "n8n-nodes-base.set",
      "position": [
        220,
        200
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "7fe48b56-7683-4d5a-9580-be7cd93a12dd",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        -160
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "d3e192cd-93a4-426e-b8f7-3c5524da9ac9",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -320,
        160
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "546569c2-c598-47a0-a6a9-a084d6d0c922",
      "name": "Get Data in XLSX",
      "type": "n8n-nodes-base.convertToFile",
      "position": [
        1760,
        0
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "28c0f5dd-23c1-485e-9a50-89d9b208fd17",
      "name": "Upsert Data in Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1760,
        200
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "9f063a5e-fdf1-4120-940e-19c253cead62",
      "name": "Prepare Data",
      "type": "n8n-nodes-base.set",
      "position": [
        1540,
        200
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "a9769fd3-9a14-4851-9578-a783e4d82f16",
      "name": "Extract Google Map",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        880,
        200
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "2eabbd24-fdc7-44c1-9034-fdb30c530a10",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        660,
        380
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "632a6f60-0b08-4cf7-b521-acffbd39539b",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1540,
        380
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "24425271-1fd6-466d-bdd8-c5df169ed690",
  "connections": {
    "Tariffs": {
      "main": [
        [
          {
            "node": "Extract Google Map",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Data": {
      "main": [
        [
          {
            "node": "Prepare Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Data": {
      "main": [
        [
          {
            "node": "Upsert Data in Sheets",
            "type": "main",
            "index": 0
          },
          {
            "node": "Get Data in XLSX",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Initialization": {
      "main": [
        [
          {
            "node": "Tariffs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Variables Chat": {
      "main": [
        [
          {
            "node": "Initialization",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Google Map": {
      "main": [
        [
          {
            "node": "Split Out Maps NEW",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out Maps NEW": {
      "main": [
        [
          {
            "node": "Extract Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When chat message received": {
      "main": [
        [
          {
            "node": "Variables Chat",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

This workflow is designed for marketers, researchers, and business owners who need to quickly find and export company data from Google Maps into a structured table format.

Source: https://n8n.io/workflows/6249/ — original creator credit. Request a take-down →

More Data & Sheets workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Data & Sheets

This workflow builds a free lead generation system that scrapes emails from Google Maps listings and exports them directly into Google Sheets. It’s built in n8n using HTTP requests and JavaScript—no p

HTTP Request, Google Sheets, Chat Trigger
Data & Sheets

This workflow is ideal for lead generation agencies, researchers, and small business owners who need to quickly collect and analyze company data from search results and save them into Google Sheets fo

HTTP Request, Chat Trigger, Google Sheets
Data & Sheets

jobs. Uses chatTrigger, httpRequest, googleSheets. Chat trigger; 9 nodes.

Chat Trigger, HTTP Request, Google Sheets
Data & Sheets

My workflow 2. Uses httpRequest, googleSheets, chatTrigger. Chat trigger; 8 nodes.

HTTP Request, Google Sheets, Chat Trigger
Data & Sheets

template-demo-chatgpt-image-1-with-drive-and-sheet copy. Uses manualTrigger, httpRequest, googleDrive, splitOut. Event-driven trigger; 16 nodes.

HTTP Request, Google Drive, Google Sheets +1