Pleas help me

[vital igloo]

Hi! 👋

I’m building a lead generation workflow in n8n and would really appreciate some help or tips from the community.

Here’s what I want to build:

🔹 A bot that finds local businesses (e.g. cafes, salons, etc.) using OpenStreetMap or another data source
🔹 Filters out businesses that already have a website – I only want ones without a website
🔹 Removes duplicates to avoid contacting the same company twice
🔹 Saves the results to Google Sheets

Has anyone built something similar or know of a public template I can use as a starting point?

Thanks a lot! 🙏

[hollow rivet]

not sure about template but you can find many scraper for this purpose of apify. get apify api and choose the actor you want to use in your workflow

[warm quarry]

I think there is a very popular google maps scraper - or a few of them, you can modify it to only add business names to the sheets which don't have a website mentioned on their google maps page.

[marsh schooner]

google places (new) api. Check it out. great resource

[vital igloo]

Okej thanks allot I will try it

[vital igloo]

What node do you recommend to use for the filter so it’s only business without website

[raw eagle]

Hi! 👋
I’ve built similar workflows in n8n using data sources and Google Sheets integration. You can pull business data, filter by criteria, remove duplicates, and log results. I’d be happy to help you set this up or guide you on a template to get started!