Google Maps leads to Google Sheets with n8n

Each morning your sheet gains a row for every new business the search finds: name, address, phone, website, rating, review count, category and any emails found on the business's own site. Places already in the sheet are skipped, so the list grows without duplicates.

Change the search in the request body to your own category and city, and raise the per-search limit once the first run looks right. The Actor visits each business website to look for contact pages, which is where the emails come from.

Run on Apify

Built-in nodes only Imports on n8n Cloud and self-hosted n8n 1.80 or later, no community nodes. 11 of 11 checks pass; validated, not executed.

Source: Google Maps
Actor: Google Maps Business Lead Finder with Email & Social Links
Destination: Google Sheets
Store price: $0.99 per 1,000 results (pay per event)
Cost on the Free plan: about $0.42 a run (start $0.40 + up to 20 results), about $12.59 a month daily, plus platform usage
Data checked: 2026-11-12

Method

Get an Apify token

Sign in to Apify and copy a personal API token from Console: Settings, API and integrations. The workflow keeps it in an n8n credential, never in the file.

Import the workflow

In n8n choose Workflows, Import from file, or paste the JSON onto an empty canvas.

Run by hand
Every day
Run Apify Actor
Only records not sent before
Keep main fields
Send to Google Sheets

n8n workflowgoogle-maps-leads-to-google-sheets.n8n.json

Actor on Apify

Show the file (207 lines)

{
  "name": "Google Maps leads to Google Sheets",
  "nodes": [
    {
      "id": "509d4612-2b8a-4dc6-ab8a-c397f93c9eeb",
      "name": "Run by hand",
      "type": "n8n-nodes-base.manualTrigger",
      "typeVersion": 1,
      "position": [
        0,
        0
      ],
      "parameters": {}
    },
    {
      "id": "4eee49e2-88cd-4154-a73d-aae1a912e03b",
      "name": "Every day",
      "type": "n8n-nodes-base.scheduleTrigger",
      "typeVersion": 1.2,
      "position": [
        0,
        200
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 8
            }
          ]
        }
      },
      "notes": "Activate the workflow to run on this schedule."
    },
    {
      "id": "c5045336-dcd8-4d61-af73-5330168f04f3",
      "name": "Run Apify Actor",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.2,
      "position": [
        260,
        100
      ],
      "parameters": {
        "method": "POST",
        "url": "https://api.apify.com/v2/actors/vexaloom-labs~google-maps-business-lead-finder-with-email/run-sync-get-dataset-items",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth",
        "sendBody": true,
        "specifyBody": "json",
        "jsonBody": "{\n  \"mode\": \"searchPlaces\",\n  \"searchQueries\": [\n    \"coffee shops in Austin TX\"\n  ],\n  \"maxPlacesPerSearch\": 20,\n  \"language\": \"en\",\n  \"extractEmailsFromWebsite\": true,\n  \"maxEmailsPerWebsite\": 5,\n  \"maxContactPagesPerWebsite\": 2,\n  \"onlySaveResults\": \"allPlaces\",\n  \"websiteFilter\": \"allPlaces\",\n  \"skipClosedPlaces\": false\n}",
        "options": {
          "timeout": 310000
        }
      },
      "notes": "Actor: vexaloom-labs/google-maps-business-lead-finder-with-email. Select a Header Auth credential: name Authorization, value Bearer + your Apify token. Edit the JSON body to change the input.",
      "notesInFlow": false
    },
    {
      "id": "04208c8a-673c-4326-aa3d-8e4f02a3c86b",
      "name": "Only records not sent before",
      "type": "n8n-nodes-base.removeDuplicates",
      "typeVersion": 2,
      "position": [
        500,
        100
      ],
      "parameters": {
        "operation": "removeItemsSeenInPreviousExecutions",
        "logic": "removeItemsWithAlreadySeenKeyValues",
        "dedupeValue": "={{ $json.placeId }}",
        "options": {
          "scope": "node",
          "historySize": 10000
        }
      },
      "notes": "Remembers each placeId it has passed on (up to 10,000) across runs, so a record is sent once. Needs n8n 1.64 or later."
    },
    {
      "id": "7e87da9a-fac8-48b8-a610-f389e9ae0b07",
      "name": "Keep main fields",
      "type": "n8n-nodes-base.code",
      "typeVersion": 2,
      "position": [
        740,
        100
      ],
      "parameters": {
        "jsCode": "// Keeps the Actor's main fields as flat, spreadsheet-safe values.\nconst columns = [\"title\",\"address\",\"totalScore\",\"reviewsCount\",\"website\",\"sourceUrl\",\"contactPageUrl\",\"url\",\"placeId\",\"searchQuery\",\"categoryName\",\"phone\",\"emails\",\"emailsMxValid\"];\n// A dotted name such as author.name reads the nested value.\nconst read = (obj, key) => (key in obj ? obj[key] : key.split('.').reduce((v, part) => (v && typeof v === 'object' ? v[part] : undefined), obj));\nreturn $input.all().map((item) => {\n  const row = {};\n  const present = columns.filter((key) => read(item.json, key) !== undefined);\n  // A record shaped differently from the published schema keeps its own fields rather than arriving blank.\n  for (const key of present.length >= 2 ? present : Object.keys(item.json)) {\n    const value = read(item.json, key);\n    row[key] = value === null || value === undefined ? '' : typeof value === 'object' ? JSON.stringify(value) : value;\n  }\n  return { json: row };\n});"
      }
    },
    {
      "id": "caff81da-6e9f-46e4-ae58-03b1f27a7723",
      "name": "Send to Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.5,
      "position": [
        980,
        100
      ],
      "parameters": {
        "operation": "append",
        "documentId": {
          "__rl": true,
          "value": "",
          "mode": "list",
          "cachedResultName": ""
        },
        "sheetName": {
          "__rl": true,
          "value": "Sheet1",
          "mode": "name"
        },
        "columns": {
          "mappingMode": "autoMapInputData",
          "value": {},
          "matchingColumns": [],
          "schema": []
        },
        "options": {}
      },
      "notes": "Pick your spreadsheet. The tab is set to Sheet1; change it if yours has another name. Add these headers in row 1: title, address, totalScore, reviewsCount, website, sourceUrl, contactPageUrl, url, placeId, searchQuery, categoryName, phone, emails, emailsMxValid."
    },
    {
      "id": "6fec453a-ccdd-49f0-a12f-b5117bf71fa7",
      "name": "Setup",
      "type": "n8n-nodes-base.stickyNote",
      "typeVersion": 1,
      "position": [
        0,
        -370
      ],
      "parameters": {
        "content": "## Google Maps Business Lead Finder with Email & Social Links\n\nSource: [vexaloom-labs/google-maps-business-lead-finder-with-email](https://apify.com/vexaloom-labs/google-maps-business-lead-finder-with-email) on Apify.\n\n1. In **Run Apify Actor**, create a Header Auth credential: name `Authorization`, value `Bearer YOUR_APIFY_TOKEN` with your token.\n2. Open **Send to Google Sheets** and connect your Google Sheets account.\n3. Edit the JSON body of **Run Apify Actor** to change the input.\n\nGenerated by recipeforagents.com. Validated, not executed: runs are billed to your Apify account.",
        "height": 340,
        "width": 460,
        "color": 6
      }
    }
  ],
  "connections": {
    "Run by hand": {
      "main": [
        [
          {
            "node": "Run Apify Actor",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Every day": {
      "main": [
        [
          {
            "node": "Run Apify Actor",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Run Apify Actor": {
      "main": [
        [
          {
            "node": "Only records not sent before",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Only records not sent before": {
      "main": [
        [
          {
            "node": "Keep main fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Keep main fields": {
      "main": [
        [
          {
            "node": "Send to Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "pinData": {},
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "meta": {
    "templateCredsSetupCompleted": false
  },
  "tags": []
}

Validated, not executed: 11 of 11 checks pass

It has a nodes array and a connections object
Every node has a name, type, typeVersion, position and parameters
Node names are unique
Every node type is a known n8n core node (or the Apify node)
Every node uses a typeVersion that n8n ships
Every connection points at an existing node
At least one trigger starts the workflow
Every working node is reachable from a trigger
Apify calls use POST and a credential for the token
Actor input matches the Actor's published input schema
No token or credential value is embedded

Add the Apify credential

Open Run Apify Actor. Under Credential, create a Header Auth credential with the name Authorization and the value Bearer, a space and your token.

Set the input

The request body holds the Actor input: the Actor's Store prefill with maxPlacesPerSearch set for this recipe. Change maxPlacesPerSearch to your own.

{
  "mode": "searchPlaces",
  "searchQueries": [
    "coffee shops in Austin TX"
  ],
  "maxPlacesPerSearch": 20,
  "language": "en",
  "extractEmailsFromWebsite": true,
  "maxEmailsPerWebsite": 5,
  "maxContactPagesPerWebsite": 2,
  "onlySaveResults": "allPlaces",
  "websiteFilter": "allPlaces",
  "skipClosedPlaces": false
}

Every input field is documented on the Google Maps Business Lead Finder with Email & Social Links page.

Only new records go through

The Only records not sent before node (n8n's Remove Duplicates, set to remove items processed in previous executions) remembers each placeId it has passed on, so a record reaches Google Sheets once even when the next run returns it again. It needs n8n 1.64 or later; clear its history from the node to resend everything.
Connect Google Sheets

Open Send to Google Sheets, select your Google credential, then pick the spreadsheet from the list. The tab is set to Sheet1; change it if yours has another name. Put these headers in row 1 so the columns map automatically: title, address, totalScore, reviewsCount, website, sourceUrl, contactPageUrl, url, placeId, searchQuery, categoryName, phone, emails, emailsMxValid.
Run once, then turn it on

Click Execute workflow and check the first records in Google Sheets. When they look right, activate the workflow so the daily trigger runs it at 08:00 in your instance's timezone.

Where it breaks

Emails exist only for businesses whose own website publishes one; many local listings have none.
Google Maps returns a limited set of places per search, so split a large city into neighbourhood searches.
Rename a sheet header and its column stops filling: the node matches headers to field names exactly.
The workflow uses Apify's synchronous endpoint, which waits up to 300 seconds. Bigger runs answer HTTP 408: lower the limit or switch to an asynchronous run.
Each run is billed to your Apify account at the Store price ($0.99 per 1,000 results (pay per event)).

Bigger runs: the long-run workflow starts the run, waits for it and reads the dataset, so it never hits the 300-second limit.

If the workflow fails

Why does the workflow or script stop with HTTP 408?

The synchronous endpoint waits at most 300 seconds. After that it answers 408 while the run keeps going in Apify. Lower the result limit, or start the run asynchronously, wait for it to finish and then read its dataset.

Source: Apify API: run Actor synchronously and get dataset items

What do 400, 401, 402 and 403 from the Apify API mean?

Read error.type in the response body. 400 is invalid Actor input. 401 (user-or-token-not-found) means a token reached Apify but it is wrong or revoked. 402 with x402-payment-required means no token reached Apify at all: the n8n credential or the Authorization: Bearer header is missing, and Apify is offering its pay-per-run x402 route for agents instead; any other 402 is an exhausted usage limit on the account that pays for the run. 403 is a token without permission for that Actor or storage.

Source: Apify API: authentication; Apify documentation: agentic payments with x402; Apify API: run Actor synchronously and get dataset items

n8n says Install this node to use it after import. Why?

The workflow names a node or node version your instance does not have, usually a community node. The workflows here use only built-in nodes at versions n8n has shipped since 1.80, so they import on n8n Cloud and older self-hosted instances without community nodes.

Source: n8n issue: unrecognized node type after import

Why does the HTTP Request node time out before Apify answers?

Set the node's Timeout option to at least 300000 ms so n8n waits as long as Apify's synchronous endpoint. The workflows here already set 310000. A failure at exactly 30 seconds points to a proxy in front of n8n.

Source: n8n HTTP Request node documentation

Every fix in one place

Same data in an agent

Want Claude, Cursor or ChatGPT to call the Actor directly instead of on a schedule? The Google Maps Business Lead Finder with Email & Social Links page has MCP configs for eight clients and a SKILL.md. The Google Maps MCP server bundles every Google Maps Actor in one URL.

Questions

Why does the second run add fewer rows?

The workflow remembers every place ID it has written and skips them on later runs. Only businesses that are new to the search results reach the sheet.

Can I search several cities at once?

Yes. Add more entries to the searchQueries list in the request body, one city or neighbourhood each, and the Actor runs them in one go.

More recipes

Google Maps leads to HubSpot
Send a Google Maps business search into HubSpot as contacts, one contact per place with its name, phone…
Google MapsHubSpot
Google Maps competitor scan to Slack
Scan a map area grid for one kind of business and post each competitor to Slack with its rating, review…
Google MapsSlack
Reddit posts to Google Sheets
Collect public posts and comments from a subreddit into a Sheet for research, with duplicate protection and…
RedditGoogle Sheets
LinkedIn jobs to Google Sheets
Export public job postings into a Sheet so a recruiter or researcher can filter by role, company and location.
LinkedIn JobsGoogle Sheets
TikTok hashtag trends to Google Sheets
Log the view and video counts of the TikTok hashtags you follow in a Google Sheet every day, so you can…
TikTokGoogle Sheets
Instagram posts to Google Sheets
Log the latest posts of the Instagram profiles you track in a Google Sheet, with captions, likes, comments…
InstagramGoogle Sheets

Google Maps leads to Google Sheets with n8n

Method

Get an Apify token

Import the workflow

n8n workflowgoogle-maps-leads-to-google-sheets.n8n.json

Add the Apify credential

Set the input

Only new records go through

Connect Google Sheets

Run once, then turn it on

Where it breaks

If the workflow fails

Same data in an agent

Questions

More recipes

Google Maps leads to HubSpot

Google Maps competitor scan to Slack

Reddit posts to Google Sheets

LinkedIn jobs to Google Sheets

TikTok hashtag trends to Google Sheets

Instagram posts to Google Sheets