This template starts when you add a row on a Lookups worksheet with name, company, or email.
RocketReach looks that person up, JavaScript normalizes name, title, company, email, phone, and LinkedIn, and Google Sheets writes the result to a CRM tab. Search the CRM sheet by email first so existing rows stay unique. Put the RocketReach API key on the RocketReach connection.
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 row on the Lookups worksheet. Each row is a person to enrich: name, company, email.
RocketReach looks up that name, company, or email and returns the enriched profile.
JavaScript picks name, title, company, email, phone, and LinkedIn from the RocketReach result.
Google Sheets searches the CRM worksheet by email so duplicates are skipped. If none, it appends the contact.
Use a Lookups tab for people to search and a CRM tab for enriched rows. Point the trigger at Lookups so writing to CRM does not loop.
Add a Google Sheets connection with edit access to that spreadsheet. Point the new-row trigger at Lookups.
Add a RocketReach connection and paste the API key there.
Map lookup columns into RocketReach. After JavaScript, search the CRM tab by email, then append a row when the email is new.
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.
