Back to Templates

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

Created by

Created by: Alex Berman || alexberman
Alex Berman

Last update

Last update 2 days ago

Categories

Share


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

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.