Send personalized daily learning emails for women using GPT-4o and Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 10 nodes and runs on a schedule (cron 0 9 * * *). Along the way it connects Google Sheets, OpenAI and Gmail.
How it runs
Trigger: On a schedule (cron 0 9 * * *).
- Fetch All Subscribers (Google Sheets): uses Google Sheets
- Calculate Day, Week & Phase (Code): runs custom JavaScript code
- Fetch Content Library (Google Sheets): uses Google Sheets
- Match Subscriber to Lesson (Code): runs custom JavaScript code
- Loop Each Subscriber (Loop Over Items (Split in Batches)): loops over the items in batches
- Personalize Lesson (OpenAI): uses OpenAI
- Build Personalized Email (Code): runs custom JavaScript code
- Send Daily Lesson Email (Gmail): uses Gmail
- Log Delivery to Sheets (Google Sheets): append
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Google Sheets
n8n-nodes-base.googleSheets - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - OpenAI
@n8n/n8n-nodes-langchain.openAi - Gmail
n8n-nodes-base.gmail
From the author
📊 Description Most learning newsletters send the same email to everyone. This workflow does the opposite — every subscriber gets a completely different email every single day, personalized to their topic interest, learning phase, and how far they've come in…