Latenode
Google sheets
Headless browser

Extract & store contact data from TruePeopleSearch via Zyte API

This automation extracts contact information, specifically phone numbers and email addresses, from TruePeopleSearch using the Zyte API and saves the data into a spreadsheet. It starts by pulling lead data (first name, last name, and search URL) from a Google Sheet, then sends the TruePeopleSearch URL to the Zyte Scraping API to retrieve the search results.

The workflow parses the first matching profile link, visits the page, and extracts the full name, age/DOB, primary phone, other phone numbers, emails, and current address. If no phone numbers are found in the primary profile, it detects a relative's profile link and scrapes their contact data as a fallback. Finally, it writes all the scraped information back into the same row in the Google Sheet.

Updated Apr 2, 2026Est. run: 9sEst. cost: $0.0006
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 contact information (phone numbers and email addresses) from TruePeopleSearch using the Zyte API.
  • Retrieves lead data (first name, last name, search URL) from a Google Sheet.
  • Scrapes the TruePeopleSearch profile page and parses the contact details.
  • Writes the scraped information back into the same row in the Google Sheet.
  • Detects and pulls contact data from a relative's profile as a fallback if no phone numbers are found.

How it works

1
Trigger

Read Lead Data from Google Sheet

The workflow starts by reading lead information (first name, last name, and search URL) from a Google Sheet.

2
Action

Scrape TruePeopleSearch using Zyte API

The workflow sends the TruePeopleSearch URL to the Zyte Scraping API to retrieve the search results.

3
Logic

Extract Contact Details from Profiles

The workflow parses the first matching profile link, visits the page, and extracts the full name, age/DOB, primary phone, other phone numbers, emails, and current address. If no phone numbers are found in the primary profile, it detects a relative's profile link and scrapes their contact data as a fallback.

4
Action

Write Enriched Lead Data to Google Sheet

Finally, the workflow writes all the scraped information back into the same row in the Google Sheet.

Setup guide

1

Add Google Sheets Connection

Add a Google Sheets connection in the Latenode Credentials panel. Authenticate with your Google account and grant the necessary permissions to access your Google Sheets data.

2

Configure Google Sheets Input Node

Add a Google Sheets node to your workflow. Configure the node to pull data from the specific Google Sheet and range containing the lead information (first name, last name, search URL).

3

Add Zyte Scraping API Credential

Add a Zyte Scraping API credential in the Latenode Credentials panel. Enter your Zyte API key to enable the workflow to securely access the Zyte Scraping API.

4

Configure Zyte Scraping API Node

Add a Zyte Scraping API node to your workflow. Configure the node to send the TruePeopleSearch search URL to the Zyte API and extract the necessary data (profile links, name, age, phone numbers, emails, address).

5

Map Output Data to Google Sheets

Configure the Google Sheets node to write the extracted contact information (name, age, phone numbers, emails, address) back to the same row in the Google Sheet as the original lead data.

Requirements

Access to a Google Sheets account with a spreadsheet containing the lead data (first name, last name, search URL)
Zyte API access with a valid API key
Permission to access and scrape the TruePeopleSearch website using the Zyte Scraping API
Latenode workspace with the 'headless-browser' and 'code' nodes available for web scraping and data processing

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 new Notion items to Google Docs documents

This Latenode automation template allows you to automatically create a new Google Docs document whenever a new item is added to a Notion database. This streamlines your workflow, ensuring that your important information is easily accessible across both platforms. The integration works by detecting new items in your Notion database and then creating a corresponding document in a specified Google Docs folder, with the content from the Notion item copied over. This saves time and keeps your documentation organized, allowing you to focus on more strategic priorities.

8s$0.0005
Data, spreadsheets & databases

Automatically create Google Docs from new Google Forms submissions

This Latenode automation template creates a Google Doc based on a pre-defined template, using data from new submissions in a linked Google Forms spreadsheet. Whenever a new response is added or an existing one is updated in the spreadsheet, the integration automatically generates a corresponding Google Doc, eliminating the need for manual copy-pasting. This saves time and ensures that all form responses are captured in a document format for further processing. The key integrations involved are Google Forms and Google Docs, with the Google Forms spreadsheet serving as the data source and the generated Google Docs as the output.

7s$0.0004
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