Overview
Overview This workflow helps you automatically collect verified business leads from Google Search using SerpAPI — no coding required. It extracts company names, websites, emails, and phone numbers directly from search results and saves them into Google Sheets for easy follow-up or CRM import. Perfect for marketers, freelancers, and agencies who want real, usable leads fast — without manual scraping or paid databases. How It Works SerpAPI Node performs a Google search for your chosen keyword or niche. Split Out Node separates each result for individual processing. HTTP Request Node optionally visits each site for deeper data extraction. Code Node filters, validates, and formats leads using smart parsing logic. Google Sheets Node stores the final structured data automatically. All steps include sticky notes with configuration help. Setup Steps Setup takes about 5–10 minutes: Add your SerpAPI key (replace the placeholder). Connect your Google Sheets account. Update the search term (e.g., “Plumbers in New York”). Run the workflow and watch leads populate your sheet in real time. An n8n automation workflow template by Muhammad Shaheer Awan.
Muhammad Shaheer Awan
web
free
Others in the same category, ranked by how often they are opened.
