n8n Workflow: Google Sheets + Apify + Claude Cold Email Icebreakers

Turn Google Sheets leads into personalized cold email icebreakers—automatically

This n8n workflow scans your Google Sheets for unprocessed B2B leads, uses Apify to pull each lead’s most recent LinkedIn post and website content, then leverages Anthropic Claude to generate a 15–30 word LinkedIn-based email icebreaker. Approved results are written back to your sheet with “Processed” marked as “YES.”

What this workflow does

• Reads leads from Google Sheets: start the workflow manually, then selects rows where the “Processed” column is set to “NO”.
• Processes up to 50 leads: loops through the first 50 leads one at a time.
• Scrapes recent LinkedIn activity via Apify: runs an Apify actor to fetch each lead’s recent LinkedIn posts, extracts the most recent non-repost post text, and uses it as the base for personalization.
• Fetches company website context: pulls the company website HTML, converts it to plain text, and uses Anthropic Claude to summarize relevant company details for context.
• Generates a tight icebreaker: asks Claude to produce one 15–30 word LinkedIn-based cold email icebreaker using only the LinkedIn post content—or returns “SKIP” if there isn’t a strong personalizable detail.
• Filters weak or unwanted outputs: rejects icebreakers that match banned patterns (e.g., missing “LinkedIn,” salesy language, clichés, or hyphenated phrasing) and flags them as “SKIP”.
• Writes results back to Google Sheets: appends/updates the lead row matched by email with the icebreaker and sets “Processed” to “YES”, after a short rate-limit wait.

Use cases

• Fast enrichment of SaaS sales or recruiting lead lists stored in Google Sheets.
• Creating compliant, non-generic LinkedIn-based email openers at scale with n8n.
• Automating “research → icebreaker → write back” for outbound sequences.

Technical details

• Integrations: Google Sheets, Apify, Anthropic (Claude)
• n8n workflow nodes mentioned: set, code, wait, merge, markdown, sticky note
• Controls: processes first 50 leads; loops one by one; includes rate-limit waits; updates rows matched by email.