Skip to main content

Skip trace people with ScraperCity and save contact details to Google Sheets

Workflow preview

Workflow preview
100%
Skip trace people with ScraperCity and save contact details to Google Sheets preview
Open on n8n.io

1. Workflow Overview

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 add...

Best for

  • Lead Generation automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-base.manualtrigger, n8n-nodes-base.set, n8n-nodes-base.code, n8n-nodes-base.httprequest, n8n-nodes-base.splitinbatches, n8n-nodes-base.wait, n8n-nodes-base.if, n8n-nodes-base.removeduplicates

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Alex Berman.

Original n8n.io source

1.1 Workflow description

Title
Skip trace people with ScraperCity and save contact details to Google Sheets
Workflow name
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

  1. A configuration node lets you define up to five people to search (by name, phone, or email).
  2. The workflow submits a skip trace job to the ScraperCity People Finder API and captures the returned run ID.
  3. A polling loop checks job status every 60 seconds until the scrape is marked SUCCEEDED (scrapes typically take 10--60 minutes).
  4. Once complete, the results CSV is downloaded, parsed, and deduplicated.
  5. Clean contact records are written row-by-row into a Google Sheet.

How to set up

  1. Create a ScraperCity account at app.scrapercity.com and copy your API key.
  2. In n8n, create a Header Auth credential named ScraperCity API Key with the header name Authorization and value Bearer YOUR_KEY.
  3. Connect your Google Sheets OAuth2 credential.
  4. Open the Configure Search Inputs node and replace the sample names/phones/emails.
  5. Set your Google Sheet ID and sheet name in the Write Results to Google Sheets node.
  6. 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.

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - When clicking 'Execute workflow'

Type / Role
n8n-nodes-base.manualTrigger - manualTrigger
Config choices
Version 1

Block 2 - Configure Search Inputs

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 3 - Build Request Body

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 4 - Submit Skip Trace Job

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 5 - Store Run ID

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 6 - Polling Loop

Type / Role
n8n-nodes-base.splitInBatches - splitInBatches
Config choices
Version 3

Block 7 - Wait 60 Seconds

Type / Role
n8n-nodes-base.wait - wait
Config choices
Version 1.1

Block 8 - Check Scrape Status

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 9 - Is Scrape Complete?

Type / Role
n8n-nodes-base.if - if
Config choices
Version 2.2

Block 10 - Download Results CSV

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 11 - Parse and Format CSV Results

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 12 - Remove Duplicate Contacts

Type / Role
n8n-nodes-base.removeDuplicates - removeDuplicates
Config choices
Version 2

Block 13 - Write Results to Google Sheets

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.6

Block 14 - Overview

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 15 - Section - Configuration

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 16 - Section - Submit Job

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 17 - Section - Async Polling Loop

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 18 - Section - Download and Output

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

3. Summary Table

Workflow Skip trace people with ScraperCity and save contact details to Google Sheets
Complexity advanced
Nodes 18
Categories Lead Generation
Author Alex Berman
Published 05 Mar 2026

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/13883/13883.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does Skip trace people with ScraperCity and save contact details to Google Sheets do?

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 add...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Lead Generation use case.