Quick overview
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 Runs when you manually trigger the workflow. Loads the search settings such as the Serper API key, query, location coordinates, and page/result limits. Generates a list of paged Serper Maps searches and calls the Serper Maps API for each page. Extracts business listings and filters out blocked company types/domains, optionally requiring a website and/or phone number. Deduplicates results, calculates a lead score from available listing signals, and keeps only leads that meet the minimum score and maximum result count. Appends the qualified leads to the Leads tab in Google Sheets with standardized columns (name, phone, website, address, score, and source details). Setup Get a Serper API key and paste it into the Serper API key field in the Lead Search Configuration step. Connect your Google Sheets credential in n8n. Create or choose a Google Sheets spreadsheet, add a tab named Leads with the columns used by the append step, and set the Google Sheet document ID in the Google Sheets configuration. An n8n automation workflow template by Khadija Naeem.
Khadija Naeem
web
paid
Others in the same category, ranked by how often they are opened.
