Generate Personalized Cold Outreach
Research prospects via LinkedIn or web, identify pain points and opportunities, then craft personalized outreach messages for LinkedIn, email, and SMS.
Overview
This workflow automates the process of crafting personalized cold outreach messages for your prospects. It researches their online presence, identifies key pain points and missed opportunities, then generates multiple message variations tailored for different channels — LinkedIn DMs, email, and SMS. Everything is saved to Google Sheets for easy tracking and follow-up.
Ideal for sales professionals, SDRs, and anyone doing targeted outreach at scale.
What It Does
- Takes a prospect's LinkedIn URL or basic profile information as input.
- Checks your connected Google Sheet for existing prospect entries to avoid duplication.
- Uses an AI agent to research the prospect online, summarize their background, and identify pain points and missed opportunities.
- Generates multiple outreach message variations in different tones (direct, friendly, minimal) and formats them for LinkedIn, email, and SMS.
- Saves all prospect data, insights, and messages back to Google Sheets.
What You Need
- A Needle account.
- A Google Sheets connection configured in Needle.
- A Google Sheet set up with columns to store prospect data (see the output fields below).
- The LinkedIn URL or basic details of the prospect you want to target.
How the Flow Works
| Step | Node | Description |
|---|---|---|
| 1 | Manual Trigger | Start the workflow by providing a prospect's LinkedIn URL or profile info. |
| 2 | Get Google Sheets Values | Fetch all prospect URLs already stored in your Google Sheet (column A) to check for existing entries. |
| 3 | AI Agent | Research the prospect using web search and browsing tools. Summarize their profile, identify pain points and opportunities, then craft multiple personalized outreach messages. |
| 4 | Upsert Google Sheets Row | Add or update a row in the Google Sheet with all the prospect data, summaries, and generated messages. |
Output Fields
The AI agent produces structured output that gets saved to your Google Sheet:
| Field | Description |
|---|---|
prospect_input | The original LinkedIn URL or prospect info provided |
prospect_summary | Short summary of who the prospect is and what they do |
pain_points | Top 3 likely pain points, separated by pipe characters |
missed_opportunities | Top 3 missed opportunities, separated by pipe characters |
v1_direct | Outreach message — direct and bold tone |
v2_friendly | Outreach message — friendly and curious tone |
v3_minimal | Outreach message — minimal and straight to the point |
linkedin_version | Best message rewritten for LinkedIn DM (short, casual) |
email_version | Best message rewritten for email (slightly more structured) |
sms_version | Best message rewritten for SMS (very short and punchy) |
final_message | The refined final version with the strongest personalization |
Notes
- Make sure your Google Sheet has write permissions and includes columns matching the output fields listed above.
- The AI agent uses web search and browsing tools to enrich prospect data — ensure your Needle account has access to these tools.
- You can customize the AI prompt to better suit your outreach style, industry, or value proposition.
- Be mindful of LinkedIn's terms of use when automating interactions based on profile data.
- Each run processes one prospect at a time, making it easy to review and approve messages before sending.
Want to showcase your own workflows?
Become a Needle workflow partner and turn your expertise into recurring revenue.
