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

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 1. Connect your Google Sheets account 2. Replace the spreadsheet ID and column names with your own 3. Set up your OpenAI credentials (or whichever LLM you prefer) 4. Tweak the prompt for tone or style 5. 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
Download the workflow JSON file after purchase.
Open n8n → click the menu → Import from File.
Select the downloaded JSON and import.
Set up credentials for each node that requires them.
Click Execute Workflow to test, then activate.
Setup guide included
Purchase to unlock the full step-by-step guide
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.