Find and email website-less local businesses with Google Sheets, Serper and Gmail

Description

This n8n template demonstrates how to build a Auto Lead Gen & Outreach System for Local Businesses specifically designed to help businesses that don’t have a website yet.

The workflow identifies local businesses (like bakeries, gyms, salons, etc.) that are missing an online presence, enriches their contact data, and sends personalized outreach messages — including your capability deck automatically attached from Google Drive.

Use cases are simple but powerful: find businesses that are invisible online, show them the value of having a website, and present your services professionally with a ready-to-send portfolio.

Good to know

- This workflow targets high-opportunity leads — businesses without websites. - API usage (Google Maps & Search via Serper) may incur costs. - A 20–40 second delay is added between emails to improve deliverability. - Your capability deck is automatically fetched from Google Drive and attached to emails.

How it works

Fetch niches Niche data (e.g., bakeries, gyms) is pulled from Google Sheets.