Score and enrich lookalike companies with PredictLeads, Google Sheets and Slack

Description

Overview

Find companies similar to your best clients using PredictLeads, enrich each with news, hiring, and tech signals, then score them 0–100 for outreach priority.

This workflow reads your best client domains from Google Sheets, discovers lookalike companies via the PredictLeads Similar Companies API, enriches each with news events, job openings, and technology detections, then calculates a composite lead score from 0 to 100 based on multiple signals. Scored results are written to Google Sheets so your sales team can prioritize outreach.

How it works

A manual trigger starts the workflow.
The workflow reads your best client domains from Google Sheets.
It loops through each client and fetches similar companies from PredictLeads.
It extracts lookalike company details such as domain, company name, industry, and similarity score.
It loops through each lookalike and enriches it with three PredictLeads signals:

News events for recent company activity
Job openings for hiring signals
Technology detections for tech stack insights
It calculates a composite score from 0 to 100 based on:

+30 points for recent news events in the last 30 days
+30 points for active hiring with 5 or more open roles
+20 points for using target technologies such as HubSpot, Salesforce, or Marketo
+10 points for a high similarity score above 0.7
+10 points for being located in a target region such as the US, UK, or Canada
It writes scored lookalikes to the Scored Lookalikes tab in Google Sheets.

Setup

Create a Google Sheet with two tabs:

Sheet1 with a domain column for your best client domains, one per row
Scored Lookalikes with these columns:

domain
company_name
source_domain
similarity_score
news_count
job_count
tech_names
tech_match
country
composite_score
scored_at
Connect your Google Sheets account using OAuth2.
Add your PredictLeads API credentials using the X-Api-Key and X-Api-Token headers.

Requirements

Google Sheets OAuth2 credentials
PredictLeads API account: https://docs.predictleads.com

Notes

Target technologies such as HubSpot, Salesforce, and Marketo, as well as target regions such as the US, UK, and Canada, can be adjusted in the scoring code node.
The scoring weights are configurable, so you can change the point values to match your sales priorities.
Start with 3 to 5 best client domains for optimal results.
PredictLeads Similar Companies, News Events, Job Openings, and Technology Detections API docs: https://docs.predictleads.com