Latenode
Google sheets
Headless browser

Extract contacts from TruePeopleSearch and log to Google Sheets

This Latenode automation extracts contact information, such as phone numbers and email addresses, from TruePeopleSearch using the Zyte API. It is designed for data brokers, skip tracers, and real estate professionals who need accurate contact data for their clients or leads, even when the main profile is empty.

The workflow scrapes TruePeopleSearch and logs all extracted information, including name, age, phone, email, and addresses, into a Google Sheets spreadsheet. If the original profile lacks a phone number, the automation will also scrape any available relative profiles to find additional contact information. The workflow includes error handling and retry logic to ensure the most complete data set possible, providing a scalable and reliable way to enhance people-based data sets.

Updated Apr 6, 2026Est. run: 26sEst. cost: $0.0703
How Latenode estimates time and cost

Latenode bills workflow runs in credits: 1 credit = 30 seconds of processing. Minimum charge per run depends on your plan. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.

Full pricing — how credits work →
Data, spreadsheets & databases

Workflow preview

What this template does

  • Extracts phone numbers and email addresses from TruePeopleSearch using the Zyte API
  • Logs all extracted data, including name, age, phone, email, and addresses, into a Google Sheets spreadsheet
  • Scrapes relative profiles to find additional contact information if the main profile is empty
  • Includes error handling and retry logic to ensure a complete data set
  • Provides a scalable and reliable way to enhance people-based data sets

How it works

1
Trigger

Receive data or events to trigger the workflow

The workflow is triggered by receiving data or events, such as a new person to look up or a request to extract contact information.

2
Action

Fetch data from the source spreadsheet

The workflow fetches the relevant data from a Google Sheets spreadsheet, which may contain a list of people to look up on TruePeopleSearch.

3
Logic

Skip rows that have already been processed

The workflow filters out any rows that have already been processed, to avoid duplicating work.

4
Logic

Process a subset of the rows to avoid overloading

The workflow limits the number of rows it processes at a time, to avoid overloading the TruePeopleSearch API or the Google Sheets integration.

5
Action

Fetch person profiles from TruePeopleSearch

The workflow uses the Zyte API to scrape the TruePeopleSearch website and fetch the profiles for each person in the list.

6
Action

Extract contact details

The workflow parses the scraped TruePeopleSearch data and extracts the relevant contact information, such as name, age, phone number, email address, and addresses.

7
Action

Update Google Sheets with main profile data

The workflow stores the extracted contact details from the main profile in the Google Sheets spreadsheet.

8
Logic

Determine if phone numbers were found

The workflow checks if any phone numbers were found in the main profile data. If no phone numbers were found, it proceeds to the next step to search for relative profiles.

9
Action

Fetch relative profiles from TruePeopleSearch

If no phone numbers were found in the main profile, the workflow uses the Zyte API to scrape additional relative profiles from TruePeopleSearch in an attempt to find more contact information.

10
Action

Extract relative profile data

The workflow parses the scraped data from the relative profiles and extracts any additional contact information, such as phone numbers or email addresses.

11
Action

Update Google Sheets with relative profile data

The workflow stores the extracted contact details from the relative profiles in the Google Sheets spreadsheet.

12
Logic

Check for errors

The workflow checks for any errors that may have occurred during the scraping or data extraction process.

13
Action

Log errors to Google Sheets

If any errors were detected, the workflow logs the issues to the Google Sheets spreadsheet for further investigation.

Setup guide

1

Add Zyte Credential

1. Go to the Latenode Credentials panel. 2. Add a new credential for Zyte API. 3. Enter your Zyte API key.

2

Configure Google Sheets Connection

1. Go to the Latenode Credentials panel. 2. Add a new credential for Google Sheets. 3. Authorize Latenode to access your Google Sheets account. 4. Select the Google Sheets document and worksheet where you want to save the extracted data.

3

Set up TruePeopleSearch Scraper

1. Add a new Headless Browser node to your workflow. 2. Configure the node to visit the TruePeopleSearch website. 3. In the node settings, map the input data (e.g., person's name) to the appropriate website fields. 4. Configure the scraping logic to extract the required information (name, age, phone, email, addresses).

4

Handle Relative Profiles

1. Add an additional Headless Browser node to your workflow. 2. Configure this node to visit any relative profile URLs found during the initial scrape. 3. Extract the contact information (phone, email) from the relative profiles and map it to the Google Sheets output.

5

Set up Error Handling

1. Add a Google Sheets node to your workflow. 2. Configure this node to log any errors or issues encountered during the scraping process. 3. Map the error details (e.g., error message, URL, timestamp) to the appropriate Google Sheets columns.

Requirements

Obtain a Zyte API key to access the TruePeopleSearch data source
Connect a Google Sheets spreadsheet to the Latenode workspace to store the extracted contact data
Set up the Latenode headless browser node to scrape the TruePeopleSearch website
Configure the Latenode JavaScript node to process the scraped data and write it to the Google Sheets spreadsheet

FAQ

Common questions about this template

Each run uses credits on your Latenode plan. We charge for processing time (1 credit = 30 seconds). Your actual cost depends on your plan and how long the run takes. See pricing plans for plans and how credits work.
Contact support →

More templates

You might also like

Browse all templates →
Data, spreadsheets & databases

Automatically sync Notion items to new Google Docs documents

This automation allows users to automatically create a new Google Docs document whenever a new item is added to a Notion database. It streamlines the process of transferring data from Notion to Google Docs, making it easier for teams to collaborate on documents and reports. The automation triggers when a new item is added to the specified Notion database, and it then creates a corresponding Google Docs document with the relevant information. This integration between Notion and Google Docs helps users to centralize their data and workflows, improving productivity and efficiency.

26s$0.0703
Data, spreadsheets & databases

Automatically generate customized Google Docs from new form data

This automation allows users to create a new Google Doc based on a predefined template, using data from a new submission in a linked Google Form. Whenever a new row is added to the associated Google Sheets spreadsheet, the automation will trigger and generate a personalized document using the form data. This streamlines the process of creating documents from structured data, making it more efficient for individuals or teams working with Google's productivity suite. The primary systems involved are Google Forms, Google Sheets, and Google Docs.

26s$0.0703
Data, spreadsheets & databases

Automatically notify via Burst SMS when new rows added to Google Sheets

This Latenode automation allows users to stay focused on their primary workflows by automatically sending SMS messages through the Burst SMS platform whenever a new row is added to a specified Google Sheets spreadsheet. It connects the Google Sheets data source to the Burst SMS service, streamlining the notification process. Users can configure the specific spreadsheet and mobile number to receive the SMS updates, helping them stay informed without getting distracted from their main tasks.

7s$0.0004