我如何使用人工智能创建个性化冷电子邮件生成器

with Adam Biddlecombe Introduction Why Automate Cold Emails? Want to automate & personalize your cold outreach at scale?This guide walks you through how to: Collect targeted leads from LinkedIn Use ChatGPT & Zapier to generate 1,oo0+ personalized cold emails Automate email creation in Google sheets-so you never manuallywrite another cold email again. Let's break it down step by step. Step 1 Find & Organize Contacts for Outreach To ensure your automation works smoothly, you need clean, structured data. Where to Find Contacts: LinkedIn Sales Navigator - Best for targeted B2B leads. Apollo.io - Access a large contact database. Manual Search - If you have a niche audience Key Information to Collect: Store this data in Google Sheets or a CRM for easy integration. Step 2 Automate Contact Data toChatGPT Using Zapier This step ensures that your contact data flows into chatGpT and generates an email. Zapier Workflow: Trigger: when a new lead is added to Google Sheets. Action: Zapier sends lead details to ChatGPT Output: ChatGPT generates a fully personalized cold email. Here's a visual workflow showing how data moves through the automation: Trigger 1. New or Updated Spreadsheet Row in Google Sheets 2. Conversation in ChatGPT 3. Update Spreadsheet Row in Google Sheets Setting Up the Zap: In Zapier, select Google Sheets → New Row Added as your trigger. Choose ChatGPT -→ Send Prompt as your action. Map each field (First Name, Job Title, etc.) to the corresponding prompt variables. Send the output back to Google sheets for easy email management. Pro Tip If Zapier pulls incorrect data, check your Google Sheets column formatting-ensure allfields are properly labeled. Step 3 Use the ChatGPT Mega Promptto Generate Emails Your ChatGpT Mega Prompt needs to be structured properly for consistent.high-quality outputs. Breaking the Prompt into Logical Parts: Define Email Context & Style "You are a cold email copywriter. The goal of the email is to get someone to open it,read it, and reply. The email will align [your company's value proposition] with [therecipient's pain point]. Keep it casual, direct, and non-salesy' Provide Contact Personalization Data [firstName], [lastName], [profileUrl]:[title], [companyName], [industry]: [companyLocation], [Company Description] Generate Key Email Components "Generate a short, direct subject line." Email Preview (50 characters max) "write a preview that summarizes the email without sounding salesy:" Email Opener (Acknowledges pain point) "write a first sentence that directly references the recipient's pain point." Value Proposition (2 lines, empathetic) "Explain how our product/service solves the recipient's pain point in a waythat shows understanding and empathy' Closing Question "End the email with a short, no-pressure question like 'worth talking about?" Now that you understand how each part of the Mega Prompt works, here's the entireprompt formatted for easy copy-pasting into ChatGPT or Zapier. Full Mega Prompt (Copy & Paste for ChatGPT) You are a cold email copywriter. The goal of the email is to get someone to open it, read it,and reply. The email will align [your company's value proposition statement] with [the recipient'sidentified pain pointj. The tone should be casual, straight to the point, and not salesy. Here's the contact information for personalization: - First Name: [firstName]- Last Name: [lastName]- Job Title: [title]- Company: [companyName]- LinkedIn Profile: [profileUrl]- Industry: [industry]- Location: [companyLocation]- Company Description: [Company Description] Now, generate the following: 1. **Subject Line** (1-3 words max) that grabs attention.2. **Email Preview** (50 characters max) summarizing the email without salesy language.3. **Email Opener** that acknowledges the recipient's pain point in one sentence.4. **Value Alignment** - 2 lines showing how our solution helps, with empathy.5. **Closing Question** - End with a simple question like “Worth talking about?" Automate with Zapier Trigger: New contact added → Zapier sends data to ChatGPT → Google Sheetsauto-fills with email content. Example Prompt & Output Example Input to ChatGPT: Prompt: "You are a cold email copywriter..." (with personalization data) Example Output: Subject: Hiring Challenges? Preview: Quick tip for building better teams Email Opener: Hey [FirstName], I saw your role at [Company]. Hiring in [Industry]automated follow-ups. worth talking about? Why this works: Each email is personalized, clear, and action-driven. Pro Tip Use HubSpot's free AI-powered email writer Use AI to generate sales outreach emails inafraction of thetime Boost email marketing with templates andAI-generated content Generate email copy for diverse audiencesegments without scaling headcount or spend Create Free Emails with Al Step 4 Store & Send Cold Emails Automatically Once ChatGPT generates emails, you can: Review & Edit in Google Sheets. Auto