Skip trace people with ScraperCity and save contact details to Google Sheets
Who is this for
This workflow is for skip tracers, real estate investors, debt collectors, and data brokers who need to find current contact details -- phone numbers, email addresses, and physical addresses -- for a list of people using only names, phone numbers, or email addresses as inputs.
How it works
A configuration node lets you define up to five people to search (by name, phone, or email). The workflow submits a skip trace job to the ScraperCity People Finder API and captures the returned run ID. A polling loop checks job status every 60 seconds until the scrape is marked SUCCEEDED (scrapes typically take 10--60 minutes). Once complete, the results CSV is downloaded, parsed, and deduplicated. Clean contact records are written row-by-row into a Google Sheet.
How to set up
Create a ScraperCity account at app.scrapercity.com and copy your API key. In n8n, create a Header Auth credential named ScraperCity API Key with the header name Authorization and value Bearer YOUR_KEY. Connect your Google Sheets OAuth2 credential. Open the Configure Search Inputs node and replace the sample names/phones/emails. Set your Google Sheet ID and sheet name in the Write Results to Google Sheets node. Click Execute workflow.
Requirements
ScraperCity account (app.scrapercity.com) Google Sheets OAuth2 credential in n8n
How to customize the workflow
Swap the manual trigger for a Schedule trigger to run nightly. Feed inputs from a Google Sheet instead of the Set node to process large lists. Add a Filter node after parsing to keep only records that have a verified phone number.
Related Templates
Generate Product Ad Copy & CTAs with GPT-4 for Slack and Airtable
⚡ AI Copywriter Pro: Instant Ad Copy & CTA Generator Transform product details into compelling marketing copy in second...
Auto-classify Gmail emails with AI and apply labels for inbox organization
Who is this for? Professionals and individuals who receive high volumes of emails, those who want to automatically organ...
Technology News Workflow Explanation with Key Services
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Auto-Publish Techn...
🔒 Please log in to import templates to n8n and favorite templates
Workflow Visualization
Loading...
Preparing workflow renderer
Comments (0)
Login to post comments