Back to Templates

Score LinkedIn ICP leads and draft outreach with Claude, Notion and Sheets

Created by

Created by: Periodix || periodix
Periodix

Last update

Last update 6 hours ago

Categories

Share

Quick Overview

This workflow runs hourly to pull pending Sales Navigator search URLs from Notion, fetch matching LinkedIn profiles via Periodix Actions, score each profile with Anthropic Claude, generate personalized outreach for qualified leads, and log validated and rejected results to separate Google Sheets tabs.

How it works

  1. Runs every hour and retrieves up to 10 Notion database pages where the Status field is set to Pending.
  2. Extracts each page’s Sales Navigator search URL and iterates through the URLs to run a LinkedIn profile search using the Periodix Actions LinkedIn Search node.
  3. Cleans and normalizes the returned profile fields (name, headline, role, company, location, industry, summary, and public profile URL) and processes profiles one by one with a short delay for rate limiting.
  4. Sends each profile to the Anthropic Claude Messages API to produce an ICP fit score (1–10) and a brief scoring reason in JSON.
  5. For profiles scoring 5 or higher, asks Claude to generate a LinkedIn connection note and a first follow-up message (M1), then appends the full record to the Validated tab in Google Sheets.
  6. For profiles scoring below 5, appends the profile details, score, and reason to the Rejected tab in Google Sheets.
  7. After iterating through all profiles for a search URL, updates the originating Notion page to Status = Done and sets the Processed At date.

Setup

  1. Add Notion credentials, set your Notion database ID, and ensure your database includes Status (select with Pending/Done), Sales Nav URL (URL), Campaign (or a name field), and Processed At (date) properties.
  2. Add a Periodix Actions credential and set the Periodix profileId value used to run Sales Navigator searches.
  3. Add your Anthropic API key to both Claude HTTP Request nodes and customize the scoring and message-generation prompts with your product context and ICP criteria.
  4. Add Google Sheets OAuth credentials, set your Google Sheet ID, and create two tabs named Validated and Rejected with columns that match the workflow’s mapped fields.