planeta ai logo
Darmowy szablon automatyzacji

Zbieraj firmowe wiadomości e-mail z Map Google bez korzystania z interfejsów API stron trzecich

83894
1 mies. temu
26
bloków


Dla kogo jest ten szablon?

Ten szablon workflow jest przeznaczony dla profesjonalistów z obszaru sprzedaży, marketingu oraz rozwoju biznesu, którzy poszukują efektywnego i ekonomicznego sposobu na generowanie leadów. Wykorzystując podstawowe węzły n8n, szablon umożliwia scrapowanie adresów e-mail firm z Google Maps bez konieczności korzystania z płatnych API czy zewnętrznych usług, co gwarantuje brak dodatkowych kosztów.

Szablon idealnie sprawdzi się w przypadku właścicieli małych firm, freelancerów oraz agencji. Automatyzuje on proces zbierania danych kontaktowych, stanowiąc potężne narzędzie dla każdego, kto chce skalować swoje działania leadowe bez ponoszenia dodatkowych wydatków.

Obejrzyj tutorial wideo tutaj: https://youtu.be/HaiO-UeiKBA

Jak to działa?

Ten szablon usprawnia proces scrapowania e-maili z Google Maps, wykorzystując wyłącznie podstawowe węzły n8n, zapewniając całkowicie darmowe i samodzielne rozwiązanie. Oto jak działa:

Wprowadzanie zapytań

Podajesz listę zapytań, z których każde zawiera słowa kluczowe związane z rodzajem biznesu, który Cię interesuje, oraz konkretny region lub podregion.

Iteracja przez zapytania

Workflow przetwarza każde zapytanie po kolei. Dla każdego z nich uruchamia pod-workflow odpowiedzialny za zadania związane ze scrapowaniem.

Scrapowanie Google Maps w poszukiwaniu URL-i

Korzystając z tych zapytań, workflow scrapuje Google Maps, aby zebrać adresy URL list firm pasujących do podanych kryteriów.

Pobieranie zawartości HTML

Workflow następnie pobiera strony HTML zebranych adresów URL w celu dalszego przetwarzania.

Ekstrakcja e-maili

Za pomocą węzła Code Node z niestandardowym kodem JavaScript, workflow uruchamia wyrażenia regularne na zawartości HTML, aby wyodrębnić adresy e-mail firm.

Konfiguracja

Dodawanie zapytań

Otwórz pierwszy węzeł "Run Workflow" i wprowadź listę zapytań, z których każde zawiera słowa kluczowe biznesowe oraz docelowy region.

Konfiguracja węzła Google Sheets

Otwórz węzeł Google Sheets i wybierz dokument oraz konkretny arkusz, do którego będą zapisywane wyniki scrapowania.

Uruchomienie workflow

Kliknij "Test workflow" i obserwuj, jak Twój dokument Google Sheets stopniowo wypełnia się adresami e-mail firm.

Dostosowanie według potrzeb

Możesz dostosować wyrażenia regularne w węźle Code Node, aby udoskonalić logikę ekstrakcji e-maili lub dodać logikę do wyodrębniania innych rodzajów informacji.

Przykłady zastosowań

Ten szablon automatyzacji może być wykorzystywany w wielu scenariuszach biznesowych. Oto kilka potencjalnych zastosowań:

  • Generowanie leadów dla agencji marketingowych poszukujących nowych klientów.
  • Budowanie bazy kontaktowej dla firm oferujących usługi B2B.
  • Pozyskiwanie potencjalnych klientów dla freelancerów specjalizujących się w konkretnych niszach.
  • Rozwijanie sieci kontaktów dla startupów poszukujących partnerów biznesowych.
  • Zbieranie danych kontaktowych dla firm organizujących eventy branżowe.
  • Pozyskiwanie leadów dla firm konsultingowych oferujących specjalistyczne usługi.
  • Automatyzacja procesu poszukiwania dostawców lub podwykonawców dla małych przedsiębiorstw.


   Skopiuj kod szablonu   
{"name":"Google Maps Email Scraper Template","tags":[],"nodes":[{"id":"79df5316-c210-478d-a4de-35b5d31924ee","name":"Remove Duplicate URLs","type":"n8n-nodes-base.removeDuplicates","position":[-780,380],"parameters":{},"typeVersion":1.1},{"id":"985ac7e3-b501-4079-a043-780677c94b52","name":"Loop over queries","type":"n8n-nodes-base.splitInBatches","position":[-1080,-100],"parameters":{"options":{}},"typeVersion":3},{"id":"3a478935-781b-4fb1-bdc7-fcf8be1334bc","name":"Search Google Maps with query","type":"n8n-nodes-base.httpRequest","position":[-1380,380],"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":"Scrape URLs from results","type":"n8n-nodes-base.code","position":[-1180,380],"parameters":{"jsCode":"const data = $input.first().json.datannconst regex = /https?:\/\/[^\/]+/gnnconst urls = data.match(regex)nnreturn urls.map(url => ({json: {url: url}}))"},"typeVersion":2},{"id":"a5b67e45-a3f6-41d2-aa58-c26a441c41b2","name":"Filter irrelevant URLs","type":"n8n-nodes-base.filter","position":[-980,380],"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":"40ec6d1f-1c98-4c9f-8499-c5893c3df7b9","name":"Request web page for URL","type":"n8n-nodes-base.httpRequest","onError":"continueRegularOutput","position":[-380,460],"parameters":{"url":"={{ $json.url }}","options":{}},"typeVersion":4.2,"alwaysOutputData":false},{"id":"12f662a8-c55f-409a-b381-f37ab6dd3794","name":"Loop over URLs","type":"n8n-nodes-base.splitInBatches","onError":"continueErrorOutput","position":[-580,380],"parameters":{"options":{"reset":false}},"typeVersion":3},{"id":"e6957d05-3533-48ae-9cc1-ee4ac026a2a6","name":"Loop over pages","type":"n8n-nodes-base.splitInBatches","onError":"continueErrorOutput","position":[-360,120],"parameters":{"options":{}},"typeVersion":3,"alwaysOutputData":false},{"id":"018621c0-0ea9-4865-b110-b6d0727f0588","name":"Scrape emails from page","type":"n8n-nodes-base.code","onError":"continueRegularOutput","position":[-200,220],"parameters":{"mode":"runOnceForEachItem","jsCode":"const data = $json.datannconst emailRegex = /[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.(?!png|jpg|gif|jpeg)[a-zA-Z]{2,}/gnnconst emails = data.match(emailRegex)nnreturn {json: {emails: emails}}"},"typeVersion":2},{"id":"5509b8e2-a6fc-4fbe-bbc5-1bc1d5de1c98","name":"Aggregate arrays of emails","type":"n8n-nodes-base.aggregate","position":[-40,100],"parameters":{"options":{"mergeLists":true},"fieldsToAggregate":{"fieldToAggregate":[{"fieldToAggregate":"emails"}]}},"typeVersion":1},{"id":"f1f01f03-b62e-453f-b938-ffe4f9b3f4de","name":"Split out into default data structure","type":"n8n-nodes-base.splitOut","position":[180,100],"parameters":{"options":{},"fieldToSplitOut":"emails"},"typeVersion":1},{"id":"ec27d665-d9c1-4f10-9c52-0d5ea89cbf77","name":"Remove duplicate emails","type":"n8n-nodes-base.removeDuplicates","position":[400,100],"parameters":{"compare":"selectedFields","options":{},"fieldsToCompare":"emails"},"typeVersion":1.1},{"id":"4a071bf0-23ad-455b-b231-bafd3b32e4f8","name":"Filter irrelevant emails","type":"n8n-nodes-base.filter","position":[600,100],"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.emails }}","rightValue":"=(google|gstatic|ggpht|schema\.org|example\.com|sentry\.wixpress\.com|sentry-next\.wixpress\.com|ingest\.sentry\.io|sentry\.io|imli\.com)"}]}},"typeVersion":2.2},{"id":"59675faa-2b0d-4ba5-82c7-dc5dedcad31e","name":"Save emails to Google Sheet","type":"n8n-nodes-base.googleSheets","position":[800,100],"parameters":{"columns":{"value":{"Emails":"={{ $json.emails }}"},"schema":[{"id":"Emails","type":"string","display":true,"removed":false,"required":false,"displayName":"Emails","defaultMatch":false,"canBeUsedToMatch":true}],"mappingMode":"defineBelow","matchingColumns":["Emails"]},"options":{},"operation":"append"},"typeVersion":4.5},{"id":"93437e8b-4f8d-40a1-9585-cab1b556164a","name":"Starts scraper workflow","type":"n8n-nodes-base.executeWorkflowTrigger","position":[-1600,380],"parameters":{},"typeVersion":1},{"id":"eed77477-777d-450d-a975-4d2848b1cf55","name":"Run workflow","type":"n8n-nodes-base.manualTrigger","position":[-1320,-100],"parameters":{},"typeVersion":1},{"id":"dffaf04e-d1d2-4002-9a69-f0904b61fc2d","name":"Wait between executions","type":"n8n-nodes-base.wait","position":[-700,0],"webhookId":"40eb11a9-0f7d-4932-993e-0052b69dbf9b","parameters":{"amount":2},"typeVersion":1.1},{"id":"18787007-1d11-41b9-89c3-d5f69756eda7","name":"Execute scraper for query","type":"n8n-nodes-base.executeWorkflow","position":[-880,0],"parameters":{"mode":"each","options":{"waitForSubWorkflow":false},"workflowId":{"__rl":true,"mode":"id","value":"={{ $workflow.id }}"}},"typeVersion":1.1},{"id":"67fcde25-05e4-437c-b799-4448baea7891","name":"Sticky Note","type":"n8n-nodes-base.stickyNote","position":[-2280,-140],"parameters":{"color":5,"width":740,"height":180,"content":"## 🛠 Setupn1. Setup your list of queries in the "Run workflow" manual trigger node. Watch this (https://youtu.be/HaiO-UeiKBA) on how to generate the queries with ChatGPT.n3. Choose a sheet to populate with data in the **Google Sheets node**n4. Run the workflow and start getting leads into your Google Sheets document"},"typeVersion":1},{"id":"ac880457-44b4-4ff7-8440-b4107f8468bb","name":"Sticky Note2","type":"n8n-nodes-base.stickyNote","position":[-700,-120],"parameters":{"color":6,"height":100,"content":"**Optional** 👇nSet wait time between each query workflow execution. Default is 2 seconds."},"typeVersion":1},{"id":"d83afb3d-7b71-4b47-9b50-28837aac408c","name":"Sticky Note3","type":"n8n-nodes-base.stickyNote","position":[-1600,260],"parameters":{"width":480,"height":100,"content":"### Scraper 👇nThis workflow will be executed in the background for each query. Click the **All executions** tab in the left sidebar to see the executions running."},"typeVersion":1},{"id":"007b621a-3d41-4358-aa45-560a3c8e3414","name":"Sticky Note4","type":"n8n-nodes-base.stickyNote","position":[820,300],"parameters":{"color":4,"height":180,"content":"👆 n1. Setup your **credentials**. Here's a (https://youtu.be/O5RnWDM27M8) on how to do that.nn2. Choose which document and sheet to save the scraped emails to. "},"typeVersion":1},{"id":"fc0b837f-624c-4d25-8ed7-f787f76c785b","name":"Sticky Note5","type":"n8n-nodes-base.stickyNote","position":[-1760,-360],"parameters":{"color":3,"content":" ## ⚠️ NotennA (https://youtu.be/HaiO-UeiKBA) for this workflow guide is available on my [Youtube channel](https://www.youtube.com/channel/UCn8xmUBunez1SsDVRfZDUGA)"},"typeVersion":1},{"id":"2f8665d5-2890-4f7d-908b-9c09a66b6c93","name":"Sticky Note6","type":"n8n-nodes-base.stickyNote","position":[-2280,-360],"parameters":{"color":7,"width":480,"height":140,"content":"## Google Maps Automatic Email ScrapernnThis workflow automatically scrapes emails from businesses on Google Maps based on a list of queries that you provide."},"typeVersion":1},{"id":"7414b2ed-259d-47da-bbd1-d9ce0d64d43c","name":"Sticky Note7","type":"n8n-nodes-base.stickyNote","position":[-1000,540],"parameters":{"color":6,"width":160,"height":100,"content":"**Optional** 👆nAdd or change the regex for filtering irrelevant URLs."},"typeVersion":1},{"id":"789c9a02-e6e7-4ea6-a7a2-acc7715b377a","name":"Sticky Note8","type":"n8n-nodes-base.stickyNote","position":[580,260],"parameters":{"color":6,"width":200,"height":100,"content":"**Optional** 👆nAdd or change the regex for filtering irrelevant/incorrect email addresses."},"typeVersion":1}],"active":false,"pinData":{"Run workflow":[{"json":{"query":"hollywood+dentist"}},{"json":{"query":"downtown+los+angeles+dentist"}},{"json":{"query":"santa+monica+dentist"}},{"json":{"query":"westwood+dentist"}},{"json":{"query":"west+l.a.+dentist"}},{"json":{"query":"the+valley+dentist"}},{"json":{"query":"echo+park+dentist"}},{"json":{"query":"culver+city+dentist"}},{"json":{"query":"pasadena+dentist"}},{"json":{"query":"silver+lake+dentist"}},{"json":{"query":"mid-wilshire+dentist"}},{"json":{"query":"beverly+hills+dentist"}},{"json":{"query":"north+hills+dentist"}},{"json":{"query":"south+los+angeles+dentist"}}]},"settings":{"executionOrder":"v1"},"connections":{"Run workflow":{"main":[[{"node":"Loop over queries","type":"main","index":0}]]},"Loop over URLs":{"main":[[{"node":"Loop over pages","type":"main","index":0}],[{"node":"Request web page for URL","type":"main","index":0}]]},"Loop over pages":{"main":[[{"node":"Aggregate arrays of emails","type":"main","index":0}],[{"node":"Scrape emails from page","type":"main","index":0}]]},"Loop over queries":{"main":[[],[{"node":"Execute scraper for query","type":"main","index":0}]]},"Remove Duplicate URLs":{"main":[[{"node":"Loop over URLs","type":"main","index":0}]]},"Filter irrelevant URLs":{"main":[[{"node":"Remove Duplicate URLs","type":"main","index":0}]]},"Remove duplicate emails":{"main":[[{"node":"Filter irrelevant emails","type":"main","index":0}]]},"Scrape emails from page":{"main":[[{"node":"Loop over pages","type":"main","index":0}]]},"Starts scraper workflow":{"main":[[{"node":"Search Google Maps with query","type":"main","index":0}]]},"Wait between executions":{"main":[[{"node":"Loop over queries","type":"main","index":0}]]},"Filter irrelevant emails":{"main":[[{"node":"Save emails to Google Sheet","type":"main","index":0}]]},"Request web page for URL":{"main":[[{"node":"Loop over URLs","type":"main","index":0}]]},"Scrape URLs from results":{"main":[[{"node":"Filter irrelevant URLs","type":"main","index":0}]]},"Execute scraper for query":{"main":[[{"node":"Wait between executions","type":"main","index":0}]]},"Aggregate arrays of emails":{"main":[[{"node":"Split out into default data structure","type":"main","index":0}]]},"Search Google Maps with query":{"main":[[{"node":"Scrape URLs from results","type":"main","index":0}]]},"Split out into default data structure":{"main":[[{"node":"Remove duplicate emails","type":"main","index":0}]]}}}
  • CSV
  • Sheet
  • Spreadsheet
  • GS
  • API
  • Request
  • URL
  • Build
  • cURL
  • cpde
  • Javascript
  • JS
  • Python
  • Script
  • Custom Code
  • Function
Planeta AI 2025 
magic-wandmenu linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram