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.

Discover businesses

The workflow searches Google Maps to find businesses in those niches.

Filter website presence

Businesses that already have websites are filtered out — focusing only on those who need one.

Enrich contact data

Additional searches extract:

• Emails
• Instagram profiles
• Facebook pages

Generate personalized outreach

Custom emails and DMs are created highlighting:

• Their business
• The missed opportunity of not having a website
• A demo/example to show potential

Attach capability deck

A Google Drive node fetches your capability deck (portfolio/services document) and attaches it to the email automatically.

Save leads

All leads are stored in Google Sheets with contact details and outreach status.

Send emails automatically

Emails are:

• Converted into clean HTML
• Sent via Gmail
• Attached with your capability deck
• Delayed randomly to simulate human behavior

Track outreach

The workflow updates:

• Outreach status → Sent
• Email sent date
• Lead progress

How to use

• Add niches like bakery, gym, salon, restaurant in Google Sheets.
• Upload your capability deck to Google Drive and connect it in the workflow.
• Configure API keys (Serper).
• Connect Gmail for sending emails.
• Run manually or schedule automation.

Requirements

• Google Sheets
• Google Drive (for capability deck)
• Gmail account
• Serper API
• n8n instance

Customising this workflow

You can adapt this workflow to:

• Offer website development services
• Sell branding or digital marketing services
• Send DMs instead of emails
• Target specific regions or industries

Enhancements you can add:

• Multiple capability decks based on niche
• Follow-up email sequences
• AI-based deeper personalization

This workflow helps you not just find leads — but pitch professionally with proof, making it easier to convert businesses into clients