This template looks up people from a Google Sheet on TruePeopleSearch. A new row starts the run.
JavaScript calls the Zyte API, parses name, age, phone, email, and addresses, and updates that row. If the main profile has no phone, the same node fetches relative profiles. Connect Google Sheets. Put the Zyte API key in that JavaScript node.
Latenode bills workflow runtime in CPU seconds. The first 10,000 CPU seconds are free each month, then usage follows pay-as-you-go CPU-second pricing. 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 CPU seconds work →Workflow preview
The scenario starts when you add a person to the Google Sheet you watch.
JavaScript calls the Zyte API for that person. Put the Zyte API key in that JavaScript node.
JavaScript extracts name, age, phone, email, and addresses. If the main profile has no phone, it fetches relative profiles the same way.
Google Sheets writes those fields back onto the same row, including an error note if the lookup fails.
Add a Google Sheets connection. Use a sheet with columns for name, location, age, phone, email, addresses, and status.
Add a Google Sheets trigger for new rows on that lookup tab.
Add a JavaScript node that calls the Zyte API for the TruePeopleSearch profile. Put the Zyte API key in that JavaScript node.
Update the same Google Sheets row with the parsed fields. If the main profile has no phone, fetch relative profiles in that JavaScript node before you write. Add a test row and confirm the cells fill in.
FAQ
More templates
This template watches a Notion database for new pages, reads the title and properties, and creates a Google Doc from that text. Use it when a database row should become a shareable document. Connect Notion and Google Docs, then point the trigger at the database you want to watch.
This template starts on a new Google Form response, then creates a Google Doc from the template you pick and replaces placeholders with the answers. Use it for intake letters, briefs, or certificates that should match each submission. Connect Google Forms and Google Docs, then point the trigger at the form and the Docs step at the template.
This template receives Kartra calendar bookings on a Latenode webhook, maps name, email, and slot time in JavaScript, and appends a row in Google Sheets. Paste the webhook URL into Kartra. If the payload is only an id, use that JavaScript node to call the Kartra API and put the Kartra API key in that node. Connect Google Sheets and point add-row at the spreadsheet that stores leads.
