Generate Personalized Icebreakers

Description

Overview

Create hyper-personalized cold outreach messages at scale by combining Google Sheets, web scraping, and AI.
This workflow is perfect for sales teams, SDRs, and agency owners looking to boost reply rates with icebreakers that actually feel personal. It takes lead info from a Google Sheet—including name, email, company, and website—then visits each site, pulls meaningful text, and crafts a tailored message using AI. The personalized message is then written back into your lead sheet, ready for use in cold email, LinkedIn DMs, or CRM enrichment.

Who’s it for
Cold email outreach specialists
B2B sales and SDR teams
Lead generation agencies
Founders doing outbound manually

How it works
Pull lead data from Google Sheets
Loop through each lead and scrape their website using an HTTP node
Clean and format the website content
Use OpenAI to generate a custom-written icebreaker for each lead
Write the final icebreaker back into the spreadsheet

How to set up
Connect your Google Sheets account
Replace the spreadsheet ID and column names with your own
Set up your OpenAI credentials (or whichever LLM you prefer)
Tweak the prompt for tone or style
Hit "Execute Workflow" and watch the sheet populate

Requirements
Google Sheets credentials
OpenAI (or any compatible LLM node)
The websites listed must be publicly accessible and static

How to customize
Modify the scraping logic to focus on specific sections (e.g. About page, Case Studies)
Adjust the AI prompt to match your brand’s tone
Add filtering logic to skip low-value leads
Integrate with your CRM to send the data downstream