Lead Finder Automation: Collect Businesses by Sector and Area in Your Own Spreadsheet

What does it do?

The task a sales team spends the most time on is finding companies to call and collecting their contact details one by one. This automation takes over that part: you enter a search such as "dental clinic, Kadıköy, 50 companies"; the system finds the businesses, looks for an email address on their websites and writes everything into your Google Sheets spreadsheet, row by row.

How does it work?

1. The sector, location and quantity are entered.
2. The business records on Google Maps are retrieved.
3. Companies already added to the list are skipped; the same company is not written twice.
4. For companies with a website, the home page and contact page are scanned and an email address is searched for.
5. The results are added to your spreadsheet; with the "status" and "note" columns you run your sales follow-up from the same place.

What goes into the spreadsheet?

Company name · category · phone · website · email · address · Google rating · number of reviews · Maps link · status · note

Real test result (27.09.2026)

In a search for "accounting office, Kadıköy", 20 companies: phone and address for all 20, and an email address for 8 of the 11 companies with a website. Total time 84 seconds.

For companies without a website, no email address can be found; phone and address still come through.

What does it not do? (on purpose)

• We do not sell ready-made lists. The system is set up in your account and the data stays in your spreadsheet; it is not kept on our server.
• It does not send automatic bulk mail. Bulk sending can land your domain on spam lists; you make the first contact yourself, personally.
• Related sectors can get mixed into the search results (e.g. a law office in an accounting search); they are filtered out using the category column.

What is needed for setup?

An Apify account (the service that retrieves the Maps data), a Google account (for the spreadsheet) and n8n (your own server or n8n cloud). We open the accounts together with you, set up the connections and run the first search together. The Apify usage fee varies with the number of companies you retrieve and is charged directly to your account.

Personal data note

The system collects only publicly available business information (the Google Maps listing and the contact details the company publishes on its own website). For sole proprietorships, this information may count as personal data; when making contact, complying with the rules on commercial messages and Turkey's personal data protection law (KVKK) is the user's responsibility. We recommend adding an opt-out to your first message, such as "if you'd rather not, I won't write again".

Frequently asked questions

Do you provide the list?

No, the system runs in your account and you create the list yourself.

Does it work for every sector?

You can search for any type of business listed on Google Maps; result quality varies by sector and region.

Is an email address found for every company?

No; it cannot be found for companies without a website or companies that do not publish an address on their site. In our test, it was found for most of the companies with a website.

Does it also send emails?

No, on purpose. A personal first contact is the better choice for both the reply rate and the security of your domain.