Generate personalized marketing emails from Google Sheets with Llama AI
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 6 nodes and runs on Google Sheets events. Along the way it connects Gmail, Ollama Chat Model and Google Sheets.
How it runs
Trigger: On Google Sheets events.
- Generate Marketing Content with AI (AI Agent): runs an AI agent, with model: Llama 3.2 - Promo Content Model
- Fetch Client List (Sheet 2) (Google Sheets): uses Google Sheets
- Format Personalized Email (Code): runs custom JavaScript code
- Send Marketing Email to Client (Gmail): uses Gmail
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)
- AI Agent
@n8n/n8n-nodes-langchain.agent - Code
n8n-nodes-base.code - Gmail
n8n-nodes-base.gmail - Ollama Chat Model
@n8n/n8n-nodes-langchain.lmChatOllama - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Google Sheets
n8n-nodes-base.googleSheets
From the author
An AI-powered email marketing automation workflow that generates personalized marketing emails using data from Google Sheets and delivers them directly to clients. This workflow combines the power of AI content generation with spreadsheet-based campaign…