Manage LinkedIn outreach leads from Google Sheets — search by name, read live conversation threads, update status, and send contextual follow-up messages. Use after linkedin-dm to move leads through the pipeline (Sent → Replied → Call Scheduled → Demo Done → Closed).
Manage LinkedIn outreach leads from Google Sheets — search by name, read live conversation threads, update status, and send contextual follow-up messages. Use after linkedin-dm to move leads through the pipeline (Sent → Replied → Call Scheduled → Demo Done → Closed).
Manage ongoing LinkedIn conversations from a central Google Sheet CRM. Read threads, draft context-aware replies, send messages, and keep the sheet updated — all from one skill.
Pre-flight Checklist
Before doing anything:
Sheet ID — Confirm the CRM sheet ID (from linkedin-dm setup). Default: 1eEZDGcr1dIbSC782mNkxvD7pVrF8rOFySWCVZ1RXkhM, tab: Sheet1 (or Outreach if renamed).
gog auth — Run gog auth list. If no tokens: see gog auth setup below.
Browser — Open the openclaw browser profile and confirm LinkedIn is logged in. Navigate to /feed/ first.
Mode — Identify which mode the user wants (see Modes).
Sheet Schema
The CRM sheet uses these columns (A–P):
Col
Field
Notes
A
Date Sent
ISO date
B
Person Name
Full name
C
Role / Title
D
Company
E
LinkedIn URL
Profile URL
F
Relationship Hook
Hook used in opener
G
Opener Sent
Message 1 text
H
Pitch Sent
Message 2 text
I
Campaign
Batch label
J
Status
Current pipeline stage
K
Notes
Context and history
L
Last Updated
ISO timestamp
M
Last Reply Date
When they last replied
N
Last Reply (preview)
First 200 chars of their last reply
O
Conversation Log
Full thread (see format below)
P
Next Action
What to do next (agent or human)
Status values:Sent → Replied → Call Scheduled → Demo Done → Follow Up Sent → No Response → Closed Won → Closed Lost
Conversation Log format (column O):
[2026-02-13 17:05 SENT] Hey Rishabh, we both had stints at CRED...
[2026-02-13 17:05 SENT] I'm building an AI calling agent...
[2026-02-15 09:30 RECEIVED] Hey! Sounds interesting, tell me more.
[2026-02-15 09:45 SENT] Happy to show you a live demo — are you free Thursday?
User says: "Who needs a follow-up?" or "Check my outreach"
Load all rows from the sheet.
Filter by status and time:
Sent older than 3 days → candidate for "No Response" or gentle follow-up
Replied → needs a response
Follow Up Sent older than 5 days → consider "No Response"
Call Scheduled → check if call happened, update status
Present a table of candidates:
Name Status Last Updated Suggested Action
Rishabh Nayan Replied 2026-02-14 Reply to their message
Shorya Saini Sent 2026-02-10 Follow-up nudge (4 days)
Shantam Mohata Sent 2026-02-13 Too soon (today)
User picks who to action, then enter Mode 2 for each.
Response Playbook
Use these as a guide — always adapt to the actual conversation:
They said
Intent
Your move
"Sounds interesting, tell me more"
Curious
Short explanation + offer a specific demo slot
"How does it work?"
Exploring
2-line description + invite to a 15-min call
"We already use [X]"
Objection
Acknowledge, explain differentiation, offer demo
"Send me more details"
Soft interest
Share a Loom/deck/link + follow up in 2 days
"Not relevant right now"
Soft no
Respect it, leave door open: "No worries, I'll ping you in a few months"
"Who else is using it?"
Trust-building
Share a relevant use case, offer intro to a user
[No reply in 4 days]
Silence
Light nudge: "Hey [Name], just checking — any thoughts?"
[No reply in 8 days]
Cold
One final message, then mark No Response
Anti-Detection Rules
Same rules as linkedin-dm:
Always go to /feed/ before navigating to a profile
Wait 2–4 seconds after loading feed
Max 15–20 messages per session (combined sends across follow-ups)
Space out follow-ups: don't ping multiple people in rapid succession
Natural delays between typing and sending (1–2 seconds)
gog Auth Setup
If gog auth list returns empty, the user needs to set up Google OAuth credentials:
A browser window will open — log in and grant access
Verify: gog auth list
Fallback (no gog): All sheet reads/writes can be done manually via browser — open the sheet in the openclaw browser and update cells directly. Less automated but functional.
Session Limits
Max 15–20 follow-up messages per session
Log every send immediately to sheet (don't batch)
If gog is unavailable, log to local linkedin_followup_log.json and sync to sheet next session
