AutomationMart
Home/Browse/Generate cold email icebreakers and subject lines with Google Sheets and OpenAI
n8n

Generate cold email icebreakers and subject lines with Google Sheets and OpenAI

n8nn8n9 modulesv1.0
Google SheetsOpenAIGoogle DriveLinkedIn

Email List Personalization - Icebreaker & Subject Line Generator Reads an enriched lead list from Google Sheets, generates a personalized icebreaker + subject line for each lead using OpenAI, and writes results back to the same sheet -- ready for your email sequencer. --- Who is this for? SDRs, founders, and agency owners running cold outbound who want personalized first lines without spending 2-3 minutes per lead on manual research. Sits between your Apollo / Sales Nav export and Instantly / Sm

At a glance

Generate cold email icebreakers and subject lines with Google Sheets and OpenAI is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, OpenAI, Google Drive, LinkedIn. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets, OpenAI, Google Drive, LinkedIn
Modules
9
Price
Free
Version
v1.0
Generate cold email icebreakers and subject lines with Google Sheets and OpenAI workflow diagram

About this workflow

Email List Personalization - Icebreaker & Subject Line Generator Reads an enriched lead list from Google Sheets, generates a personalized icebreaker + subject line for each lead using OpenAI, and writes results back to the same sheet -- ready for your email sequencer. --- Who is this for? SDRs, founders, and agency owners running cold outbound who want personalized first lines without spending 2-3 minutes per lead on manual research. Sits between your Apollo / Sales Nav export and Instantly / Smartlead / Lemlist. What problem does this solve? Generic cold emails get ignored. Writing unique icebreakers for 200+ leads/day is not realistic by hand. This workflow does it at $0.002/lead with GPT-4.1-mini -- spartan, human-sounding copy that references real prospect details. How it works 1. Read Lead Sheets from Google Sheets (enriched with LinkedIn data) 2. Filter Empty Rows rows where icebreakers or subjectLine is empty (safe to re-run) 3. Limit To 200 Leads batch to 200 leads per run 4. Process One-By-One with an IF safety check before each API call 5. Genrates Icebreaker a JSON response with few-shot examples locking the tone: - icebreaker -- spartan one-liner referencing their company/role/industry - subjectLine -- personalized with name + relevant hook - shortenedCompanyName -- strips "Agency", "Inc.", "LLC" for natural copy - verdict -- true for real people, false for company pages (filter before sending) 6. Write Result To Sheet to the same row via rownumber match key 7. Rate Limit Delay between calls to avoid throttling Setup 1. Google Sheets -- Connect OAuth2 in both sheet nodes. Point to your lead spreadsheet. 2. OpenAI -- Connect API key. Default: GPT-4.1-mini. Swap to GPT-4o for premium campaigns. 3. Sheet columns needed: firstname, lastname, email, jobtitle, company, linkedinindustry, location, summary, linkedindescription, linkedinspecialities, linkedincompanyemployeecount, linkedinfoundedyear, icebreakers, subjectLine, rownumber 4. Customize the prompt -- Swap the few-shot examples in the OpenAI node to match your voice and offer. 5. Test first -- Set Limit to 5, run manually, review output, then scale. Customization tips - Trigger -- Replace Manual Trigger with Schedule or Google Drive Trigger for automation - Batch size -- Adjust the Limit node to match your daily send volume - Model -- GPT-4.1-mini ($0.002/lead) vs GPT-4o ($0.01/lead) --- Built by Devon Toh

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

AI agent chat

This workflow employs OpenAI's language models and SerpAPI to create a responsive, intelligent conversational agent. It comes equipped with manual chat triggers and memory buffer capabilities to ensure seamless interactions. To use this template, you need to be on n8n version 1.50.0 or later.

Free

Automate HubSpot to Salesforce lead creation with Explorium AI enrichment

Automatically enrich prospect data from HubSpot using Explorium and create leads in Salesforce This n8n workflow streamlines the process of enriching prospect information by automatically pulling data from HubSpot, processing it through Explorium's AI-powered tools, and creating new leads in Salesforce with enhanced prospect details. Credentials Required To use this workflow, set up the following credentials in your n8n environment: HubSpot - Type: App Token (or OAuth2 for broader compatibility)

Free

Automated funding intelligence: CrunchBase to Google Sheets tracking workflow

Automated Funding Intelligence: CrunchBase to Google Sheets Tracking Workflow! Workflow Overview This cutting-edge n8n automation is a sophisticated startup funding intelligence tool designed to transform market research into actionable insights. By intelligently connecting CrunchBase, data processing, and Google Sheets, this workflow: 1. Discovers Funding Opportunities: - Automatically retrieves latest funding rounds - Tracks industry-specific investments - Eliminates manual market research

Free

Create a branded AI chatbot for websites with Flowise multi-agent chatflows

This workflow integrates Flowise Multi-Agent Chatflows into a custom-branded n8n chatbot, enabling real-time interaction between users and AI agents powered by large language models (LLMs). --- Key Advantages: ✅ Easy Integration with Flowise: Uses a low-code HTTP node to send user questions to Flowise's API (/api/v1/prediction/FLOWISEID) and receive intelligent responses. Supports multi-agent chatflows, allowing for complex, dynamic interactions. 🎨 Customizable Chatbot UI: Includes pre-built

Free

Add a new row to a Google Sheets spreadsheet from a new project event in QuickCapture

Every time a new event appears in your project in QuickCapture, a new row will be created in a Google Sheet spreadsheet. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1T0H8fEKZxDexPIG7PumEEiCj0HCnBu9Zc8mbdEJU8Ps/edit?usp=sharing).

Free

Monitor Google Sheets rows and generate Perplexity AI and ChatGPT Assistant

Automatically monitor Google Sheets for new rows, generate chat responses with Perplexity AI and ChatGPT's assistant, and update rows with insights.

Free

Automated AI content creation & Instagram publishing from Google Sheets

Automated AI Content Creation & Instagram Publishing from Google Sheets This n8n workflow automates the creation and publishing of social media content directly to Instagram, using ideas stored in a Google Sheet. It leverages AI (Google Gemini and Replicate Flux) to generate concepts, image prompts, captions, and the final image, turning your content plan into reality with minimal manual intervention. Think of this as the execution engine for your content strategy. It assumes you have

Free

Generate and auto-evaluate Facebook ad headlines using GPT-4o-mini

Generate and Auto-Evaluate Facebook Ad Headlines using GPT-4o-mini Built with n8n + OpenAI This workflow captures a product description, generates ad headlines, evaluates them with custom criteria, decides whether another draft is needed, and finally sends the best version via Gmail. --- ⚡ Section 1: Capture the Brief & Build the Prompt 📝 FormTrigger\CopywritingBrief → A simple form asks: “What is your product about?” ⚙️ Set\PromptForHeadline → Prepares the input by appending the instruction:

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free