Serper Maps Lead Finder: n8n to Google Sheets Scoring

Turn Serper Maps results into scored local business leads—automatically push to Google Sheets

Serper Maps Lead Finder: n8n to Google Sheets Scoring is an on-demand n8n workflow that pulls local business listings from the Serper Maps API, filters and deduplicates them, computes a lead score from available signals, and then appends qualified leads into the Leads tab of Google Sheets.

What this workflow does

• Manual trigger: Runs when you manually start the workflow in n8n.
• Reads your search settings: Loads the Serper API key, query, location coordinates, and page/result limits from configuration steps.
• Paginates and searches: Creates paged Serper Maps searches and calls the Serper Maps API for each page.
• Extracts and filters listings: Pulls business listings and filters out blocked company types/domains. Optionally requires a website and/or a phone number.
• Deduplicates and scores: Removes duplicate results, calculates a lead score using available listing signals, and keeps only leads that meet your minimum score and maximum result count.
• Appends standardized rows: Writes leads to the Leads tab with columns for name, phone, website, address, score, and source details.

Use cases

• Generate a targeted list of local service businesses for outreach campaigns.
• Continuously expand a lead database by re-running the workflow with new Serper Maps queries.
• Pre-qualify leads by filtering out missing contact info and using scoring thresholds to reduce junk entries.

Technical details

• Serper Maps API via HTTP Request
• Workflow configuration using Set and Code nodes
• Google Sheets integration to append results into the Leads tab
• Includes deduplication, lead scoring, and quality filters before writing to Sheets

Setup in minutes

• Paste your Serper API key in the “Lead Search Configuration” step.
• Connect your Google Sheets credential in n8n.
• Create a sheet tab named Leads with the columns used by the append step and set the Google Sheet document ID.