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 !Screenshot 20260505 at 5.41.56 PM.png(fileId:6044) !Screenshot 20260505 at 5.36.40 PM.png(fileId:6042) !Screenshot 20260505 at 5.38.36 PM.png(fileId:6046) !Screenshot 20260505 at 5.39.31 PM.png(fileId:6045) !Screenshot 20260505 at 5.39.44 PM.png(fileId:6043)