Google Maps leads with emails read from each website

Google Maps leads with emails read from each website

An n8n workflow. A form takes a keyword, a place and a number. An Apify Actor collects the matching businesses from Google
Maps, and the workflow reads each business's website to find a contact email. When the site has none, Anymail Finder
searches the domain. Every business is saved to a Google Sheet.

What is inside

• workflow.json: the workflow as n8n exports it, ten nodes and no sticky notes. It holds no credential.
• README.md: these notes.

What we changed from the original copy

• The Apify and Anymail Finder headers held a placeholder, Bearer <api key>. They now say Bearer <YOUR_APIFY_TOKEN>
  and <YOUR_ANYMAILFINDER_KEY>. Anymail Finder's documentation, read on 2 November 2026, gives the key as the whole
  header value with no Bearer before it, so the second one has none.
• The author's sheet and its tab id are gone. Both Google Sheets nodes ask for YOUR_SHEET_ID and find the tab by the name
  Sheet1.

Before you start

• An n8n instance, on n8n Cloud or your own server.
• An Apify account and its API token, with credit. The Actor, Google Maps Scraper by Compass, is paid per place scraped.
• An OpenAI API key that can use gpt-4o-mini.
• An Anymail Finder account and its API key, with credit for the lookups.
• A Google account, and a Google Sheet for the leads.

Jina's Reader needs no key in this file.

Set it up

1. In n8n, create a workflow, open its menu and choose Import from File. Pick workflow.json.
2. Make a Google Sheet with a tab named Sheet1 and these headers in row 1: Title, Street, Neighborhood, Website,
   Phone, Email, URL. Copy the sheet's ID: the long part of its address between /d/ and /edit.
3. Add a Google Sheets OAuth2 credential. In Append or update row in sheet1 and Update row in sheet, select it and
   replace YOUR_SHEET_ID with the ID.
4. Add an OpenAI credential and select it in Message a model.
5. In HTTP Request1, replace <YOUR_APIFY_TOKEN> in the Authorization header with your token. The brackets go too, so
   the header reads Bearer, a space and the token.
6. In Anymail, replace <YOUR_ANYMAILFINDER_KEY> in the Authorization header with your key, and nothing else.
7. Save, open the form's test address, fill in the three fields with 10 in Max results, and watch the sheet.
8. Press Publish at the top of the canvas (or Shift+P) when the first run looks right.

How a run goes

1. The form asks for Keyword, Location and Max results. None is marked required.
2. HTTP Request1 posts them to Apify's run-sync-get-dataset-items address for the Actor compass~crawler-google-places
   and waits for the places. The body sets the language to en.
3. Edit Fields keeps Title, Street, Neighborhood, Website, Phone (from phoneUnformatted) and URL, and adds a
   Domain taken from the website.
4. Loop Over Items takes one place at a time. Then Scrape Website fetches its site through Jina's Reader at
   https://r.jina.ai/, which returns the page as plain text. Next, Message a model asks gpt-4o-mini for the best
   contact email on it, ideally the owner's, and for the word Null when there is none.
5. Append or update row in sheet1 saves the place with that answer in Email, matching rows on Title.
6. If looks for Null in the answer. When it is there, Anymail searches the place's Domain, and Update row in sheet
   writes the list it returns into Email. Otherwise the loop moves to the next place.

Change the search

• Place and kind: the form's three fields. The Actor takes free text for both.
• Language of the results: language in the body of HTTP Request1.
• Which email counts: the prompt in Message a model. It asks for the most authoritative address.
• What is saved: the mapping in the two Google Sheets nodes, and the fields in Edit Fields.

Good to know

• Apify bills each scraped place, and its listing for the Actor sets add-on prices apart. OpenAI bills one small call for
  each place, and Anymail Finder's documentation says a credit is charged only when valid emails are found.
• Apify ends a synchronous call after 300 seconds, according to its API reference read on 2 November 2026, so a large search
  can come back without places. Start with 20.
• Jina's page, read the same day, allows 20 reads a minute without a key. A search of 100 places makes 100 reads, and a read
  that fails leaves the model nothing to read. Add a Wait node in the loop or put a Jina key in the request's header.
• Both sheet nodes match on Title, so two businesses with the same name overwrite each other.
• An empty Max results leaves the Apify request body broken. Fill all three form fields.
• The file calls Anymail Finder's older v5.0/search/company.json address and reads results.emails. Its current
  documentation describes v5.1/find-email/company, which returns the addresses in emails. The older address still
  answered when we checked. If it stops, change the address and read $json.emails in Update row in sheet.
• The check for Null is case-sensitive.
• The list holds business names, phone numbers and sometimes an owner's email. Check the rules for cold email where you
  market before you contact anyone.
• The Apify token and the Anymail Finder key sit in headers, so take them out before you share the workflow.