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

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

1. A manual trigger starts the workflow. 2. The workflow reads your best client domains from Google Sheets. 3. It loops through each client and fetches similar companies from PredictLeads. 4. It extracts lookalike company details such as domain, company name, industry, and similarity score. 5. 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 6. 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 7. It writes scored lookalikes to the Scored Lookalikes tab in Google Sheets.

Setup