Discover and score local B2B leads with Serper Maps and Google Sheets

by Khadija Naeem ✓ · 2 views · created 2026-09-03 · Lead Generation, AI Summarization

What this workflow does

This workflow has 5 nodes and runs from “Set Lead Search Parameters” (no trigger node, so run it manually or call it from another workflow). Along the way it connects Google Sheets.

How it runs

Trigger: From “Set Lead Search Parameters” (no trigger node, so run it manually or call it from another workflow).

1. Set Lead Search Parameters (Edit Fields (Set)): sets or maps fields
2. Generate Search Pages Code (Code): runs custom JavaScript code
3. Post to Serper Maps API (HTTP Request): calls an HTTP API
4. Process and Deduplicate Leads (Code): runs custom JavaScript code
5. Append Leads to Google Sheets (Google Sheets): uses Google Sheets

Services it uses

Google Sheets

Before you upgrade to n8n 3.0

Nodes used (4)

• Edit Fields (Set)n8n-nodes-base.set
• Coden8n-nodes-base.code
• HTTP Requestn8n-nodes-base.httpRequest
• Google Sheetsn8n-nodes-base.googleSheets

From the author

Quick overview This workflow runs on demand to discover local businesses using the Serper Maps API, then filters, scores, and deduplicates the listings before appending qualified leads to a Google Sheets tab. How it works 1. Runs when you manually trigger the…

View the original on n8n.io → Check your own copy