Serper Maps Lead Scoring & Dedup to Google Sheets (n8n)

Find Better Local Leads From Serper Maps—Score, Deduplicate, and Save to Google Sheets (n8n)

This n8n workflow runs a Serper Maps search for local businesses, deduplicates and qualifies the results, then calculates a lead score and appends only the best-fit leads to your Google Sheets “Leads” tab.

What this workflow does

Designed for B2B lead research and qualification, the workflow:

Runs manually when you start it in n8n.

Sets Serper Maps search inputs including your API key, query, map coordinates (ll), page, and result limits—along with qualification rules.

Builds a list of page requests and calls the Serper Maps API for each page of results.

Deduplicates businesses and filters out listings that don’t meet requirements (for example, missing a website ) or match blocked company terms/domains .

Calculates a lead score for each remaining business, keeps leads above your minimum score , and caps results to your maximum result count .

Appends qualified lead records to the Google Sheets “Leads” tab, including: name, phone, website, address, score , and source metadata .

Use cases

• Generate a targeted prospect list for local B2B outreach by industry keywords and location coordinates.

• Continuously build a qualified lead pipeline in Google Sheets without manual cleanup.

• Reduce duplicate entries and exclude unwanted vendors using blocked domains/terms and qualification rules.

Technical details

• n8n nodes: Set , Code , Sticky Note , HTTP Request , Google Sheets .

• Integrations: Serper Maps API and Google Sheets (append into a tab named “Leads”).

Setup checklist

• Add your Serper API key to the Lead Search Configuration values (or use an n8n credential/variable).

• Connect Google Sheets in n8n and create a tab named “Leads” with matching columns.

• Update the Google Sheets document ID and tune query, coordinates (ll), paging/max caps, and scoring thresholds.