This workflow creates highly tailored outreach messages by analyzing a lead’s Twitter/X activity and LinkedIn posts, combining them with your company profile and personal details. It identifies shared interests or relevant touchpoints, then writes a personalized cover letter-style email with a custom subject line. The agent uses RapidAPI for scraping, filters raw data, processes insights through an AI prompt, and sends the final email automatically while logging activity back into Google Sheets.

The workflow starts with a Google Sheet tracker containing LinkedIn URLs and Twitter usernames. If a row has valid data, the system scrapes the lead’s Twitter posts, LinkedIn posts, and profile information. Company and personal variables are injected to give the AI context. A structured prompt identifies a mutual point of connection and generates a fully formatted cover letter and subject. After validation, the system emails the lead directly and updates tracking data in Google Sheets.

HIGHLIGHTS: • Scrapes Twitter/X posts and activity using RapidAPI • Collects and filters LinkedIn posts for relevance • Injects company and personal variables for accurate personalization • AI-generated subject and cover letter based on shared interests • Auto-sends outreach emails and logs results in Google Sheets

November 26, 2025

Automation

N8N

$600 – $900

$120 – $200

A clear look at the problem, the system we built, and the measurable results it delivered.

The client faced low conversion from generic outreach, struggled with time-consuming research, and needed a way to build genuine, personalized connections at scale.

We developed an N8N workflow that scrapes social profiles, finds mutual interests, and generates a personalized cover letter-style email using structured AI output. The agent then automatically sends the email and tracks it in Google Sheets.

Outreach became more targeted, human, and effective, leading to stronger engagement. Research time dropped to zero as the agent handled all scraping and personalization, while Google Sheets tracking improved pipeline visibility and follow-up accuracy.