Cold lead re-engagement email generator with GPT-4o-mini, Outlook, and Sheets

This powerful n8n workflow helps you automatically re-engage cold leads by summarizing their past emails and generating personalized outreach with OpenAI. It pulls in contacts from Google Sheets, fetches their prior communication from Outlook, and then uses an AI agent to analyze, strategize, and write a draft re-engagement message — all automatically.

---

⚙️ What the Workflow Does

1. 📄 Get Contacts from Google Sheets - Pulls a list of contacts and their email addresses from a Google Sheet.

2. 📥 Search Emails from Outlook - For each contact, fetches all emails received from that address since January 1, 2025.

3. 📊 Aggregate Emails - Merges relevant email fields (subject, body, createdDateTime) into a single string for analysis.

4. 🧠 Use OpenAI to Analyze and Draft Response - AI Agent summarizes the lead’s communication history. - Suggests how to re-engage them in bullet points. - Writes a personalized draft email to re-initiate the conversation.

5. 📝 Save to Google Sheets - Appends or updates the original row with: - Summary of communication - Re-engagement ideas - Suggested subject line - Suggested email body