January 22, 2026

Google Maps to Google Sheets, clean leads you can trust

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

You find a promising niche on Google Maps, copy a few businesses into a sheet, and then reality hits. Half the “websites” are Google redirects, emails are missing, and you’ve already pasted the same company twice. Again.

This is where Maps leads automation pays for itself. Marketing managers trying to fill the pipeline feel it first, but agency owners and solo consultants doing research for clients get stuck in the same loop. You want a lead list you can actually trust, not a spreadsheet of maybes.

This n8n workflow pulls prospects from Google Maps, cleans and dedupes URLs, enriches business profiles via Apify, and logs everything into Google Sheets. You’ll see how it works, what you need, and what you can customize for your market.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Google Maps to Google Sheets, clean leads you can trust

Click to explore

flowchart LR

    subgraph sg0["Scraper Workflow Flow"]
        direction LR
        n0@{ icon: "mdi:cog", form: "rounded", label: "Eliminate Repeated Links", pos: "b", h: 48 }
        n2["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Query Maps Search"]
        n3["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Extract Links from Results"]
        n4@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Exclude Unrelated Links", pos: "b", h: 48 }
        n5@{ icon: "mdi:swap-vertical", form: "rounded", label: "Iterate URL Batches", pos: "b", h: 48 }
        n6@{ icon: "mdi:play-circle", form: "rounded", label: "Scraper Workflow Trigger", pos: "b", h: 48 }
        n9@{ icon: "mdi:robot", form: "rounded", label: "Business Insight Agent", pos: "b", h: 48 }
        n10@{ icon: "mdi:brain", form: "rounded", label: "OpenRouter Chat Engine", pos: "b", h: 48 }
        n11["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Assemble Prompt Text"]
        n12@{ icon: "mdi:cog", form: "rounded", label: "Combine Prompt Data", pos: "b", h: 48 }
        n16@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Branch Logic Check", pos: "b", h: 48 }
        n17["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/merge.svg' width='40' height='40' /></div><br/>Combine Data Streams"]
        n18["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Parse JSON Output"]
        n19@{ icon: "mdi:database", form: "rounded", label: "Append Data to Sheet", pos: "b", h: 48 }
        n20["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Invoke Apify Scraper"]
        n21@{ icon: "mdi:database", form: "rounded", label: "Lookup Existing Records", pos: "b", h: 48 }
        n22["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Check Domain Presence"]
        n23@{ icon: "mdi:cog", form: "rounded", label: "Aggregate URL Fields", pos: "b", h: 48 }
        n16 --> n20
        n16 --> n5
        n11 --> n9
        n22 --> n17
        n17 --> n16
        n9 --> n18
        n12 --> n11
        n20 --> n12
        n23 --> n22
        n5 --> n17
        n5 --> n21
        n21 --> n23
        n10 -.-> n9
        n0 --> n5
        n4 --> n0
        n6 --> n2
        n3 --> n4
        n19 --> n5
        n2 --> n3
        n18 --> n19
    end

    subgraph sg1["Scheduled Automation Flow"]
        direction LR
        n1@{ icon: "mdi:swap-vertical", form: "rounded", label: "Iterate Query Batches", pos: "b", h: 48 }
        n7@{ icon: "mdi:cog", form: "rounded", label: "Pause Between Runs", pos: "b", h: 48 }
        n8@{ icon: "mdi:cog", form: "rounded", label: "Run Sub-Workflow Required", pos: "b", h: 48 }
        n13@{ icon: "mdi:play-circle", form: "rounded", label: "Scheduled Automation Trigger", pos: "b", h: 48 }
        n14@{ icon: "mdi:database", form: "rounded", label: "Retrieve Sheet Rows", pos: "b", h: 48 }
        n15@{ icon: "mdi:database", form: "rounded", label: "Modify Sheet Row", pos: "b", h: 48 }
        n13 --> n14
        n1 --> n8
        n14 --> n1
        n15 --> n7
        n7 --> n1
        n8 --> n15
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n6,n13 trigger
    class n9 ai
    class n10 aiModel
    class n4,n16 decision
    class n19,n21,n14,n15 database
    class n2,n20 api
    class n3,n11,n18,n22 code
    classDef customIcon fill:none,stroke:none
    class n2,n3,n11,n17,n18,n20,n22 customIcon

The Problem: Google Maps leads get messy fast

Google Maps is a goldmine for local lead gen, but collecting that data manually is a slow grind. You run a search, open profiles, copy names, websites, phone numbers, maybe the address, and then you try to “standardize it later.” Later never comes. Meanwhile, redirects sneak into your sheet, different locations of the same brand show up as separate leads, and contact fields are missing right when you need them. The worst part is the mental load: you’re doing detective work when you should be doing outreach.

It adds up fast. Here’s where it breaks down once you try to scale beyond a handful of searches.

You waste about 2 hours building a list that still needs cleaning.
Duplicate domains slip in, so outreach looks sloppy and you burn goodwill.
Missing emails and inconsistent fields force you into another research pass.
You can’t reliably re-run the process because you don’t track what’s already processed.

The Solution: Search Google Maps, clean the data, and store it automatically

This workflow turns Google Maps searches into a repeatable lead pipeline that runs on a schedule (every hour). It starts by reading keyword queries from a dedicated Google Sheets tab, then searches Google Maps for each query via an HTTP request. From those results, it extracts external website URLs, filters out junk domains (like Google-owned pages or placeholder sites), and removes duplicates before doing anything expensive. Next, it checks your Google Sheet to see if that domain already exists, which prevents repeats from earlier runs. For each new domain, it calls an Apify scraper to pull a full business profile, and it can optionally run an AI Agent (Gemini via OpenRouter) to generate structured business insights you can actually use. Finally, everything is appended into a “Sheet1” tab, and the original keyword row gets marked as processed so the workflow doesn’t keep spinning its wheels.

The workflow begins on a schedule and grabs unprocessed search terms from Google Sheets. It then collects and cleans website URLs from Google Maps results, scrapes and enriches each business, and writes a deduped row back to your output sheet. Simple input, clean output.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

Reads your lead-gen keywords from a Google Sheets “keywords” tab on a schedule.
Searches Google Maps automatically and extracts external website URLs from results.
Filters irrelevant domains and removes duplicates before scraping.
Scrapes business profiles with Apify and optionally enriches them with an AI Agent.

A lead list that’s clean enough to use after one run, not three.
Fewer repeats in your sheet because domains are checked before appending.
Richer profiles (services, socials, opening hours, legal links) for better targeting.
Less time lost to “fixing the spreadsheet,” which means more time emailing.
A process you can rerun weekly without worrying about reprocessing old queries.

Example: What This Looks Like

Say you’re building a list for “roofing companies in Austin” and “emergency plumbers in Phoenix,” and you want about 40 solid prospects per query. Manually, you might spend about 3 minutes per business to copy details and double-check the website, which is roughly 2 hours for 40 leads. With this workflow, you drop the keywords into the sheet once, and the hourly run does the searching, cleaning, and logging while you do other work. Your “time spent” becomes a quick review and maybe a few edits, not an afternoon of copy-paste.

What You’ll Need

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Google Sheets to store keywords and results.
Apify for scraping complete business profiles.
OpenRouter API key (get it from your OpenRouter dashboard)

Skill level: Intermediate. You’ll connect accounts, paste API keys, and adjust a couple of sheet/tab names.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

A scheduled run pulls your next keywords. Every hour, n8n reads rows from your Google Sheets “keywords” tab and selects the ones you haven’t processed yet.

Google Maps search results get turned into a usable URL list. The workflow runs the Maps query via HTTP request, then parses the response to extract external website links. After that, it filters out obvious noise (Google-owned domains, placeholders) and removes duplicates.

Each domain is checked before it becomes a “lead.” n8n looks up the domain in your output sheet first. If it’s already there, it skips it. If it’s new, the workflow calls an Apify actor to scrape business details and can send that data to an AI Agent to generate structured insights (like services, market position, and suggested angles).

Clean rows land in Google Sheets, and keywords get marked done. The scraped and AI-enriched fields are appended to “Sheet1,” then the workflow updates the keyword row so it won’t run again next hour.

You can easily modify the keyword list and filtering rules to match your niche and geography based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Schedule Trigger

This workflow starts on a schedule to pull unprocessed queries and then hands off map scraping to a sub-workflow trigger.

Open Scheduled Automation Trigger and set the schedule rule to run on your desired interval (currently set to hourly).
Verify Scraper Workflow Trigger exists as an entry point for the sub-workflow; it should be connected to Query Maps Search.
Confirm the flow order: Scheduled Automation Trigger → Retrieve Sheet Rows → Iterate Query Batches.

⚠️ Common Pitfall: If the sub-workflow is not connected to Scraper Workflow Trigger, the execute workflow step will run but no scraping will occur.

Step 2: Connect Google Sheets

Google Sheets powers query intake, de-duplication checks, and output storage.

In Retrieve Sheet Rows, select your spreadsheet and sheet: Document set to the Google Sheet ID and Sheet Name set to keywords. Credential Required: Connect your googleSheetsOAuth2Api credentials.
In Lookup Existing Records, select the output sheet (e.g., Sheet1) for de-duplication checks. Credential Required: Connect your googleSheetsOAuth2Api credentials.
In Modify Sheet Row, confirm Operation is set to update and map query to {{$json.query}} with processed set to TRUE. Credential Required: Connect your googleSheetsOAuth2Api credentials.
In Append Data to Sheet, confirm Operation is append and the destination sheet is set to Sheet1. Credential Required: Connect your googleSheetsOAuth2Api credentials.

⚠️ Common Pitfall: Ensure the sheet columns in Append Data to Sheet match your headers exactly (e.g., “Business Name”, “Website URL”), otherwise auto-mapping will fail.

Step 3: Configure Maps Search and URL Filtering

This section turns queries into candidate business domains and removes irrelevant URLs.

In Query Maps Search, set URL to =https://www.google.com/maps/search/{{ $json.query }}.
In Extract Links from Results, keep the JavaScript as provided to extract domains from HTML results.
In Exclude Unrelated Links, confirm the filter uses leftValue ={{ $json.url }} and excludes the provided regex list via notRegex.
In Eliminate Repeated Links, leave defaults to remove duplicates before batching.
In Iterate URL Batches, keep the batch loop for per-domain processing and ensure it routes to both Combine Data Streams and Lookup Existing Records on the second output.

Step 4: Set Up Domain Checks and Branch Logic

This logic prevents re-processing domains already stored in your sheet.

In Aggregate URL Fields, ensure it aggregates the website_url field (as configured).
In Check Domain Presence, keep the provided JavaScript, which compares Iterate URL Batches domains with stored URLs.
In Combine Data Streams, set Mode to combineBySql and Query to SELECT * FROM input1 LEFT JOIN input2 ON 1=1.
In Branch Logic Check, verify the condition checks ={{ $json.dontExist }} is true before calling the scraper.
In Run Sub-Workflow Required, set the Workflow ID to the target scraper workflow and keep Mode as each.

Tip: The execution order is Aggregate URL Fields → Check Domain Presence → Combine Data Streams → Branch Logic Check, so any changes to fields should happen before aggregation.

Step 5: Set Up AI Enrichment and Prompt Assembly

The Apify scraper extracts content, which is turned into a prompt for the AI agent and parsed into structured JSON.

In Invoke Apify Scraper, set URL to =https://api.apify.com/v2/acts/mohamedgb00714~firescraper-ai-prompt-website-content-markdown-scraper/run-sync-get-dataset-items?token=[CONFIGURE_YOUR_TOKEN] and keep JSON Body as provided (note it uses {{$json.url}}).
In Combine Prompt Data, set Aggregate to aggregateAllItemData.
In Assemble Prompt Text, keep the script that joins promptResult values into a single prompt.
In Business Insight Agent, set Text to ={{ $json.prompt }} and keep the system message provided.
OpenRouter Chat Engine is connected as the language model for Business Insight Agent — ensure credentials are added to OpenRouter Chat Engine. Credential Required: Connect your openRouterApi credentials.
In Parse JSON Output, keep the code that strips code fences and parses valid JSON.

⚠️ Common Pitfall: Replace [CONFIGURE_YOUR_TOKEN] in Invoke Apify Scraper with your Apify token; leaving the placeholder will cause 401 errors.

Step 6: Configure Output Updates and Rate Limiting

After enrichment, the workflow appends data, updates the query row, and pauses before the next batch.

Verify Append Data to Sheet receives parsed JSON from Parse JSON Output and maps fields automatically.
Ensure Run Sub-Workflow Required → Modify Sheet Row marks each query as processed with processed = TRUE.
In Pause Between Runs, set Unit to minutes and Amount to 20 to throttle Google Maps requests.
Confirm the batch loop closes with Pause Between Runs → Iterate Query Batches for the next query.

Step 7: Test and Activate Your Workflow

Run a controlled test before turning the schedule on.

Click Execute Workflow on Scheduled Automation Trigger to run a manual test using a small set of unprocessed queries.
Verify that Query Maps Search returns HTML data, Extract Links from Results produces URLs, and Branch Logic Check routes new domains to Invoke Apify Scraper.
Confirm that Parse JSON Output produces valid JSON and Append Data to Sheet adds rows to your output sheet.
Validate that Modify Sheet Row sets processed to TRUE and the loop waits in Pause Between Runs.
Once the test is successful, toggle the workflow to Active to enable scheduled production runs.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

Google Sheets credentials can expire or need specific permissions. If things break, check the n8n credential connection status and the target spreadsheet sharing settings first.
If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
OpenRouter (Gemini) prompts are generic by default. Add your targeting rules and brand voice early or you’ll be editing outputs forever.

Frequently Asked Questions

How long does it take to set up this Maps leads automation?

About an hour if your Sheets and API keys are ready.

Do I need coding skills to automate Maps leads automation?

No. You’ll mostly connect accounts and paste API keys. The only “technical” part is making sure your sheet tabs match the workflow.

Is n8n free to use for this Maps leads automation workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenRouter and Apify usage costs, which depend on how many businesses you enrich.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I customize this Maps leads automation workflow for different cities and industries?

Yes, and it’s one of the best reasons to use this workflow. Update the queries in the Google Sheets “keywords” tab to swap locations, categories, and intent (for example, “dentist + Invisalign” versus “emergency dentist”). You can also tweak the URL filtering logic so it blocks specific directories or known aggregator domains in your niche. If you use the AI Agent step, adjust the prompt assembly so it outputs exactly what your sales team needs, like “best outreach angle” or “likely ad spend level.”

Why is my Google Sheets connection failing in this workflow?

Usually it’s an expired credential or the spreadsheet permissions changed. Reconnect the Google Sheets credential in n8n, then confirm the Google account still has access to the exact file and tabs the workflow references. Also check that the tab names haven’t been renamed (for example, “Sheet1” or “keywords”), because that can look like a connection issue even when auth is fine.

How many leads can this Maps leads automation handle?

On a typical n8n setup, hundreds of leads per day is realistic, and self-hosting scales further if your server can handle it.

Is this Maps leads automation better than using Zapier or Make?

Often, yes, because this workflow needs looping, deduping, and multi-step enrichment that gets awkward (and pricey) in simpler automation tools. n8n handles branching logic and batch processing cleanly, so you can check “already exists?” before you scrape or enrich anything. The HTTP and code steps also give you more control over filtering Google Maps results, which matters if you care about clean domains. Zapier or Make can still be fine if you only want to push a small number of pre-cleaned records into a sheet. If you’re unsure, Talk to an automation expert and get a quick recommendation.

Once this is running, your spreadsheet stops being a messy draft and starts being a lead engine. Set it up once, then spend your time on outreach and offers instead of cleaning rows.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": null,
"name": "Automated Business Data Enrichment Pipeline",
"meta": {
"instanceId": "5cb216807f3b0c358bd86ff41de1f4fad7c89b3a2ca49b4c77befbec631c5182",
"templateId": null,
"templateCredsSetupCompleted": null
},
"nodes": [
{
"id": "flowpast-topbar-6439",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
20
],
"parameters": {
"color": 7,
"width": 1930,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "79df5316-c210-478d-a4de-35b5d31924ee",
"name": "Eliminate Repeated Links",
"type": "n8n-nodes-base.removeDuplicates",
"position": [
390,
360
],
"parameters": [],
"typeVersion": 1.1
},
{
"id": "985ac7e3-b501-4079-a043-780677c94b52",
"name": "Iterate Query Batches",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1050,
200
],
"parameters": {
"options": []
},
"typeVersion": 3
},
{
"id": "3a478935-781b-4fb1-bdc7-fcf8be1334bc",
"name": "Query Maps Search",
"type": "n8n-nodes-base.httpRequest",
"position": [
1410,
280
],
"parameters": {
"url": "=https://www.google.com/maps/search/{{ $json.query }}",
"options": {
"allowUnauthorizedCerts": false
}
},
"executeOnce": false,
"typeVersion": 4.2,
"alwaysOutputData": false
},
{
"id": "477e7d55-b7d6-4b20-ac44-dd1f443e270a",
"name": "Extract Links from Results",
"type": "n8n-nodes-base.code",
"position": [
1110,
360
],
"parameters": {
"jsCode": "const data = $input.first().json.data\n\nconst regex = /https?:\\/\\/[^\\/]+/g\n\nconst urls = data.match(regex)\n\nreturn urls.map(url => ({json: {url: url}}))"
},
"typeVersion": 2
},
{
"id": "a5b67e45-a3f6-41d2-aa58-c26a441c41b2",
"name": "Exclude Unrelated Links",
"type": "n8n-nodes-base.filter",
"position": [
690,
280
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "041797f2-2fe2-41dc-902a-d34050b9b304",
"operator": {
"type": "string",
"operation": "notRegex"
},
"leftValue": "={{ $json.url }}",
"rightValue": "=(google|gstatic|ggpht|schema\\.org|example\\.com|sentry-next\\.wixpress\\.com|imli\\.com|sentry\\.wixpress\\.com|ingest\\.sentry\\.io)"
},
{
"id": "eb499a7e-17bc-453c-be08-a47286f726dd",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "12f662a8-c55f-409a-b381-f37ab6dd3794",
"name": "Iterate URL Batches",
"type": "n8n-nodes-base.splitInBatches",
"onError": "continueErrorOutput",
"position": [
40,
280
],
"parameters": {
"options": {
"reset": false
}
},
"typeVersion": 3
},
{
"id": "93437e8b-4f8d-40a1-9585-cab1b556164a",
"name": "Scraper Workflow Trigger",
"type": "n8n-nodes-base.executeWorkflowTrigger",
"position": [
1830,
350
],
"parameters": [],
"typeVersion": 1
},
{
"id": "dffaf04e-d1d2-4002-9a69-f0904b61fc2d",
"name": "Pause Between Runs",
"type": "n8n-nodes-base.wait",
"position": [
0,
210
],
"webhookId": "40eb11a9-0f7d-4932-993e-0052b69dbf9b",
"parameters": {
"unit": "minutes",
"amount": 20
},
"typeVersion": 1.1
},
{
"id": "18787007-1d11-41b9-89c3-d5f69756eda7",
"name": "Run Sub-Workflow Required",
"type": "n8n-nodes-base.executeWorkflow",
"position": [
760,
170
],
"parameters": {
"mode": "each",
"options": {
"waitForSubWorkflow": false
},
"workflowId": {
"__rl": true,
"mode": "id",
"value": ""
}
},
"typeVersion": 1.1
},
{
"id": "9fa06f2a-0e7a-43e1-b997-4b4288a990cd",
"name": "Business Insight Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1110,
700
],
"parameters": {
"text": "={{ $json.prompt }}",
"options": {
"systemMessage": "You are an expert business analyst.\n\nGiven a business website data, generate a JSON object with key business information and a detailed, insightful description that could be used to prepare for outreach or partnership discussions.\n\nFocus the description on:\n\n- What the business does (products/services)\n- Their strengths or market position\n- Technologies or platforms used (if identifiable)\n- Unique value proposition\n- Target customers\n- Any possible gaps, pain points, or areas for improvement\n- Why this business could benefit from external collaboration (e.g., automation, digital transformation, SEO, AI tools)\n\nFormat the output as a single JSON object with these fields:\n\n- business_name\n- website_url\n- email\n- phone_number\n- address\n- city\n- postal_code\n- country\n- latitude\n- longitude\n- category\n- subcategory\n- opening_hours\n- social_media_links (array)\n- about_us\n- services (array)\n- contact_page_url\n- privacy_policy_url\n- terms_conditions_url\n- logo_url\n- languages (array)\n- keywords (array)\n- google_maps_url\n- ai_description_detailed (a detailed paragraph or two with everything above)\n\nOnly output valid JSON.\nif prompt is empty just return empty json data "
},
"promptType": "define"
},
"typeVersion": 2
},
{
"id": "c191a15f-2457-49c1-976b-90b0caaf3835",
"name": "OpenRouter Chat Engine",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
1110,
840
],
"parameters": {
"model": "google/gemini-2.5-flash-lite-preview-06-17",
"options": []
},
"credentials": {
"openRouterApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "20c5612b-8fbf-4eb4-8f95-ca17acc5f0e2",
"name": "Assemble Prompt Text",
"type": "n8n-nodes-base.code",
"position": [
1410,
720
],
"parameters": {
"jsCode": "const allPromptResults = $input.first().json.data.map(item => item.promptResult).join('\\n');\n\n\nreturn {\n  \"prompt\":allPromptResults\n};"
},
"typeVersion": 2
},
{
"id": "53d2251a-f7bb-43b1-8035-c7ac74e0aa62",
"name": "Combine Prompt Data",
"type": "n8n-nodes-base.aggregate",
"position": [
1830,
700
],
"parameters": {
"options": [],
"aggregate": "aggregateAllItemData"
},
"typeVersion": 1
},
{
"id": "67dfef97-0fc2-4fa8-a7a8-08c491f8785f",
"name": "Scheduled Automation Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
1825,
130
],
"parameters": {
"rule": {
"interval": [
{
"field": "hours"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "cb651c6d-eac0-44bc-8d80-c07c5a65ce6a",
"name": "Retrieve Sheet Rows",
"type": "n8n-nodes-base.googleSheets",
"position": [
1470,
120
],
"parameters": {
"options": [],
"filtersUI": {
"values": [
{
"lookupColumn": "processed"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit#gid=[YOUR_ID]",
"cachedResultName": "keywords"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit",
"cachedResultName": "google maps  bussiness informations"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.6
},
{
"id": "423dce21-e06d-4bd2-833b-976b3ce9e231",
"name": "Modify Sheet Row",
"type": "n8n-nodes-base.googleSheets",
"position": [
330,
140
],
"parameters": {
"columns": {
"value": {
"query": "={{ $json.query }}",
"processed": "TRUE"
},
"schema": [
{
"id": "query",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "query",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "processed",
"type": "string",
"display": true,
"required": false,
"displayName": "processed",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"query"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit#gid=[YOUR_ID]",
"cachedResultName": "keywords"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit",
"cachedResultName": "google maps  bussiness informations"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.6
},
{
"id": "a996171f-c358-471d-91ba-b6c9950e7edf",
"name": "Branch Logic Check",
"type": "n8n-nodes-base.if",
"position": [
1470,
560
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7eec5545-99ac-410a-87ec-4e5f79e30202",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $json.dontExist }}",
"rightValue": ""
},
{
"id": "96fe4cf5-4689-4140-8a75-8bdbc893b363",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "4575083d-5d45-497e-a5d1-5c369f2d7b91",
"name": "Combine Data Streams",
"type": "n8n-nodes-base.merge",
"position": [
1050,
480
],
"parameters": {
"mode": "combineBySql",
"query": "SELECT * FROM input1 LEFT JOIN input2 ON 1=1",
"options": []
},
"typeVersion": 3.2
},
{
"id": "73814b4e-ab19-4a06-b180-a2997e43bdbd",
"name": "Parse JSON Output",
"type": "n8n-nodes-base.code",
"onError": "continueRegularOutput",
"position": [
690,
720
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "\n\nlet raw = $json.output;\n\n// Remove ```json or ``` wrapping if it exists\nraw = raw.replace(/^```json\\s*|\\s*```$/g, '').trim();\n\nlet outputJson;\n\ntry {\n  outputJson = JSON.parse(raw);\n} catch (err) {\n  outputJson = { error: 'Invalid JSON format in promptResult' };\n}\n\nreturn {\n  json: outputJson\n};"
},
"typeVersion": 2
},
{
"id": "54d94ef2-84cf-4568-a9d5-28ec9a818ffd",
"name": "Append Data to Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
390,
660
],
"parameters": {
"columns": {
"value": [],
"schema": [
{
"id": "Business Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Business Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Website URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Website URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone Number",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Phone Number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Address",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "City",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "City",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Postal Code",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Postal Code",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Country",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Latitude",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Latitude",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Longitude",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Longitude",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Category",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Category",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Subcategory",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Subcategory",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Opening Hours",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Opening Hours",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Social Media Links",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Social Media Links",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "About Us",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "About Us",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Services",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Services",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Contact Page URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Contact Page URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Privacy Policy URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Privacy Policy URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Terms & Conditions URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Terms & Conditions URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Logo URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Logo URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Languages",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Languages",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Keywords",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Keywords",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Google Maps URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Google Maps URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "AI Description",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "AI Description",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit#gid=[YOUR_ID]",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit",
"cachedResultName": "google maps  bussiness informations"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.5
},
{
"id": "40ec6d1f-1c98-4c9f-8499-c5893c3df7b9",
"name": "Invoke Apify Scraper",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
1770,
470
],
"parameters": {
"url": "=https://api.apify.com/v2/acts/mohamedgb00714~firescraper-ai-prompt-website-content-markdown-scraper/run-sync-get-dataset-items?token=[CONFIGURE_YOUR_TOKEN]",
"method": "POST",
"options": [],
"jsonBody": "={\n  \"enqueue\": true,\n  \"getHtml\": false,\n  \"getText\": false,\n  \"prompt\": \"You are an expert business analyst.\\n\\nGiven a business website URL, generate a JSON object with key business information and a detailed, insightful description that could be used to prepare for outreach or partnership discussions.\\n\\nFocus the description on:\\n\\n- What the business does (products/services)\\n- Their strengths or market position\\n- Technologies or platforms used (if identifiable)\\n- Unique value proposition\\n- Target customers\\n- Any possible gaps, pain points, or areas for improvement\\n- Why this business could benefit from external collaboration (e.g., automation, digital transformation, SEO, AI tools)\\n\\nFormat the output as a single JSON object with these fields:\\n\\n- business_name\\n- website_url\\n- email\\n- phone_number\\n- address\\n- city\\n- postal_code\\n- country\\n- latitude\\n- longitude\\n- category\\n- subcategory\\n- opening_hours\\n- social_media_links (array)\\n- about_us\\n- services (array)\\n- contact_page_url\\n- privacy_policy_url\\n- terms_conditions_url\\n- logo_url\\n- languages (array)\\n- keywords (array)\\n- google_maps_url\\n- ai_description_detailed (a detailed paragraph or two with everything above)\\n\\nOnly output valid JSON.\",\n  \"screenshot\": false,\n  \"startUrls\": [\n    {\n      \"url\": \"{{$json.url}}\",\n      \"method\": \"GET\"\n    }\n  ]\n}\n",
"sendBody": true,
"specifyBody": "json"
},
"typeVersion": 4.2,
"alwaysOutputData": false
},
{
"id": "e4997964-dc80-4778-9f79-ae4dc9e41284",
"name": "Lookup Existing Records",
"type": "n8n-nodes-base.googleSheets",
"onError": "continueErrorOutput",
"position": [
0,
540
],
"parameters": {
"options": [],
"sheetName": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit#gid=[YOUR_ID]",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit",
"cachedResultName": "google maps  bussiness informations"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.6,
"alwaysOutputData": true
},
{
"id": "d2380d4e-20a5-48bb-9d87-3f2c638f2fc7",
"name": "Check Domain Presence",
"type": "n8n-nodes-base.code",
"position": [
750,
540
],
"parameters": {
"jsCode": "let dontExist = true;\n\n// Get reference domain from 'Iterate URL Batches' node\nconst referenceUrl = $('Iterate URL Batches').first().json.url;\nconst referenceDomain = referenceUrl.match(/^https?:\\/\\/([^\\/?#]+)(?:[\\/?#]|$)/i)?.[1]?.toLowerCase();\n\nif (!referenceDomain) {\n  throw new Error('Invalid reference URL');\n}\n\n// Loop over input items\nfor (const item of $input.all()) {\n  const urls = item.json.website_url;\n\n  for (const url of urls) {\n    const domain = url.match(/^https?:\\/\\/([^\\/?#]+)(?:[\\/?#]|$)/i)?.[1]?.toLowerCase();\n    if (!domain) continue;\n\n    if (domain === referenceDomain) {\n      dontExist = false;\n      break;\n    }\n  }\n\n  if (!dontExist) break;\n}\n\n// Return result\nreturn {\n  json: {\n    dontExist\n  }\n};\n"
},
"typeVersion": 2
},
{
"id": "0273b1f4-5912-41fd-9899-3ec0a5a24f6c",
"name": "Aggregate URL Fields",
"type": "n8n-nodes-base.aggregate",
"position": [
330,
520
],
"parameters": {
"options": [],
"fieldsToAggregate": {
"fieldToAggregate": [
{
"fieldToAggregate": "website_url"
}
]
}
},
"typeVersion": 1
}
],
"pinData": [],
"connections": {
"Branch Logic Check": {
"main": [
[
{
"node": "Invoke Apify Scraper",
"type": "main",
"index": 0
}
],
[
{
"node": "Iterate URL Batches",
"type": "main",
"index": 0
}
]
]
},
"Assemble Prompt Text": {
"main": [
[
{
"node": "Business Insight Agent",
"type": "main",
"index": 0
}
]
]
},
"Check Domain Presence": {
"main": [
[
{
"node": "Combine Data Streams",
"type": "main",
"index": 1
}
]
]
},
"Combine Data Streams": {
"main": [
[
{
"node": "Branch Logic Check",
"type": "main",
"index": 0
}
]
]
},
"Business Insight Agent": {
"main": [
[
{
"node": "Parse JSON Output",
"type": "main",
"index": 0
}
]
]
},
"Combine Prompt Data": {
"main": [
[
{
"node": "Assemble Prompt Text",
"type": "main",
"index": 0
}
]
]
},
"Invoke Apify Scraper": {
"main": [
[
{
"node": "Combine Prompt Data",
"type": "main",
"index": 0
}
]
]
},
"Aggregate URL Fields": {
"main": [
[
{
"node": "Check Domain Presence",
"type": "main",
"index": 0
}
]
]
},
"Iterate URL Batches": {
"main": [
[],
[
{
"node": "Combine Data Streams",
"type": "main",
"index": 0
},
{
"node": "Lookup Existing Records",
"type": "main",
"index": 0
}
]
]
},
"Scheduled Automation Trigger": {
"main": [
[
{
"node": "Retrieve Sheet Rows",
"type": "main",
"index": 0
}
]
]
},
"Iterate Query Batches": {
"main": [
[],
[
{
"node": "Run Sub-Workflow Required",
"type": "main",
"index": 0
}
]
]
},
"Retrieve Sheet Rows": {
"main": [
[
{
"node": "Iterate Query Batches",
"type": "main",
"index": 0
}
]
]
},
"Modify Sheet Row": {
"main": [
[
{
"node": "Pause Between Runs",
"type": "main",
"index": 0
}
]
]
},
"Lookup Existing Records": {
"main": [
[
{
"node": "Aggregate URL Fields",
"type": "main",
"index": 0
}
]
]
},
"OpenRouter Chat Engine": {
"ai_languageModel": [
[
{
"node": "Business Insight Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Eliminate Repeated Links": {
"main": [
[
{
"node": "Iterate URL Batches",
"type": "main",
"index": 0
}
]
]
},
"Exclude Unrelated Links": {
"main": [
[
{
"node": "Eliminate Repeated Links",
"type": "main",
"index": 0
}
]
]
},
"Scraper Workflow Trigger": {
"main": [
[
{
"node": "Query Maps Search",
"type": "main",
"index": 0
}
]
]
},
"Pause Between Runs": {
"main": [
[
{
"node": "Iterate Query Batches",
"type": "main",
"index": 0
}
]
]
},
"Extract Links from Results": {
"main": [
[
{
"node": "Exclude Unrelated Links",
"type": "main",
"index": 0
}
]
]
},
"Run Sub-Workflow Required": {
"main": [
[
{
"node": "Modify Sheet Row",
"type": "main",
"index": 0
}
]
]
},
"Append Data to Sheet": {
"main": [
[
{
"node": "Iterate URL Batches",
"type": "main",
"index": 0
}
]
]
},
"Query Maps Search": {
"main": [
[
{
"node": "Extract Links from Results",
"type": "main",
"index": 0
}
]
]
},
"Parse JSON Output": {
"main": [
[
{
"node": "Append Data to Sheet",
"type": "main",
"index": 0
}
]
]
}
},
"versionId": null
}