Score and send LinkedIn DMs with GPT-4.1-mini, Google Sheets and Phantombuster

How it works

This workflow creates an AI-powered LinkedIn DM outreach sequence that automatically scores, messages, and follows up with prospects using Google Sheets as a lightweight CRM. When the workflow runs on a schedule, it reads prospect data from Google Sheets and filters only leads that are new or due for action. Each lead is scored by GPT-4.1-mini, which assigns a lead score, priority, and recommended message angle. Based on the prospect's outreach step, the workflow either sends a personalized first DM or a follow-up DM via Phantombuster, then updates the sheet with the latest status and next action date. Leads with no reply after the full sequence are automatically closed.

Step-by-step

• Trigger and fetch prospects
• Schedule Trigger – Runs the workflow every hour automatically.
• Get Prospects from Sheet – Reads all prospect rows from Google Sheets.
• Filter Active Prospects – Filters leads that are new or have a NextActionDate due today. Skips Closed and Replied leads.
• Batch Prospects – Processes leads in batches of 3 to respect API rate limits.
• AI lead scoring
• Score Lead with AI – Sends each prospect to GPT-4.1-mini for evaluation. Returns lead score (Hot / Warm / Cold), priority, and recommended message angle.
• Parse Lead Score – Extracts and maps the AI JSON response into structured fields.
• Route by outreach step
• Route by Step – Checks the Step value for each lead and routes to the correct flow: Step 0 → first DM, Step 1 → follow-up DM, Step 2+ → auto-close.
• DM generation, send and CRM update
• Generate First DM – GPT-4.1-mini writes a short, personalized cold DM based on role, company, and AI message angle.
• Parse First DM – Extracts the generated message text.
• Send First DM via Phantombuster – Sends the DM to the prospect's LinkedIn profile via Phantombuster HTTP API.
• Update Sheet — First DM Sent – Updates the sheet: Status → Contacted, Step → 1, NextActionDate → +3 days.
• Generate Follow-up DM – GPT-4.1-mini writes a soft follow-up referencing the first message.
• Parse Follow-up DM – Extracts the follow-up message text.
• Send Follow-up DM via Phantombuster – Sends the follow-up to the same LinkedIn profile.
• Update Sheet — Follow-up Sent – Updates the sheet: Status → Follow-up Sent, Step → 2, NextActionDate → +2 days.
• Close Lead in Sheet – Marks unresponsive leads as Closed with an auto-closure note.

Why use this?

• Automates the full LinkedIn outreach sequence without manual effort
• Uses AI to personalize every DM based on prospect role, company, and scoring
• Manages the entire pipeline from a single Google Sheet — no extra CRM needed
• Timing between steps is controlled automatically via NextActionDate
• Easily customizable for different industries, message tones, or outreach sequences