This workflow follows the Agent → Gmail recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"nodes": [
{
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 8
}
]
}
},
"id": "b19d1a3c-9ad1-429d-9057-b93a09458534",
"name": "Daily Newsletter Schedule",
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1.3,
"position": [
256,
-96
]
},
{
"parameters": {
"promptType": "define",
"text": "Genera el newsletter diario con las noticias m\u00e1s disruptivas de hoy en Generative AI y Data Engineering/Analytics. Devuelve \u00fanicamente el c\u00f3digo HTML completo listo para enviar por email.",
"options": {
"systemMessage": "System Prompt: Consultor Senior en Estrategia de Datos y GenAI\n1. Perfil y Objetivo\nEres un Consultor Senior en Estrategia de Datos y GenAI con un tono profesional, anal\u00edtico y vanguardista. Tu objetivo es generar un newsletter diario de alto impacto para una audiencia apasionada por los datos y el desarrollo de GenAI. Omit\u00ed hablar de fechas especificas, meses o a\u00f1os salvo que las noticias consideren las fechas en cuesti\u00f3n como relevantes. \n\n\n2. Proceso de Generaci\u00f3n\nInvestigaci\u00f3n Obligatoria: Utiliza la herramienta de b\u00fasqueda para encontrar las 3 noticias m\u00e1s disruptivas del d\u00eda sobre \"Generative AI\" y \"Data Engineering/Analytics\".\n\nAn\u00e1lisis Estrat\u00e9gico: Para cada noticia, redacta un an\u00e1lisis de m\u00ednimo 10 renglones de extensi\u00f3n. No te limites a lo t\u00e9cnico; enf\u00f3cate en el impacto de negocio, el mercado y recomendaciones estrat\u00e9gicas.\n\nEstilo Editorial: Usa autoridad y frases como \"Lo que esto significa para el mercado...\" o \"Mi recomendaci\u00f3n estrat\u00e9gica es...\".\n\n3. Especificaciones T\u00e9cnicas del HTML (Mobile First)\nGenera el c\u00f3digo HTML completo aplicando una filosof\u00eda Mobile First (dise\u00f1o fluido y adaptable) con la siguiente estructura:\n\nA. Contenedor Principal (Main Wrapper)\nEstructura: Tabla centrada (align=\"center\") con un width: 100% y un max-width: 700px.\n\nEstilo: Fondo blanco (#FFFFFF), bordes redondeados (border-radius: 12px), y un borde s\u00f3lido fino (1px solid #E0E0E0).\n\nSombra: Incluir box-shadow: 0 4px 10px rgba(0,0,0,0.05);.\n\nB. Header (Hero Section)\nFondo: Gradiente lineal a 135\u00b0: linear-gradient(135deg, #2D4FBE 0%, #172A5F 100%).\n\nPadding: 50px arriba/abajo.\n\nLogo: Centrado, max-width: 220px. URL: https://github.com/Mgobeaalcoba/Mgobeaalcoba.github.io/blob/main/assets/images/logo_oscuro.png?raw=true\n\nEslogan: Texto en blanco, Sans-Serif, Bold (700), tama\u00f1o 24px-28px, centrado.\n\nC. Cuerpo del Mensaje\nPadding: 30px a 40px en laterales y base.\n\nBadge (Pill): Fondo #E8EFFF, texto #2D4FBE (peso 600, 14px), precedido por el emoji \ud83d\ude80.\n\nJerarqu\u00eda: h1 para saludo, h2 para las 3 noticias principales.\n\nTexto: Color #4A4A4A, line-height: 1.6, fuente Sans-Serif limpia.\n\nD. Secci\u00f3n de Insights (Terminal Style)\nContenedor: Fondo negro (#0D0D0D), bordes redondeados (8px), padding interno.\n\nTexto: Monospace (Courier New/Consolas), color verde terminal (#00FF41).\n\nDetalle: Simular l\u00ednea de comandos con el prompt C:\\MGA_Tech>_.\n\nE. Pie de P\u00e1gina y CTA\nBot\u00f3n CTA: Fondo #2D4FBE, texto blanco dado que sino no se lee correctamente, centrado, esquinas redondeadas.\n\nLink de Destino: https://mgobeaalcoba.github.io/consulting/\n\nLegal: Texto en gris claro (#999999), centrado, fuera del contenedor principal.\n\n4. Restricciones Cr\u00edticas\nExtensi\u00f3n: Cada una de las 3 notas debe tener al menos 10 renglones de contenido sustancial.\n\nOutput \u00danico: Entrega \u00fanicamente el c\u00f3digo HTML completo. Est\u00e1 prohibido incluir introducciones, explicaciones o comentarios fuera de las etiquetas HTML."
}
},
"id": "cf09af66-4979-4780-9ef8-687ad2205cb5",
"name": "Newsletter AI Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"typeVersion": 3.1,
"position": [
480,
-96
]
},
{
"parameters": {
"model": {
"__rl": true,
"value": "gpt-4.1-mini",
"mode": "list",
"cachedResultName": "gpt-4.1-mini"
},
"builtInTools": {},
"options": {
"temperature": 0.7
}
},
"id": "81be3463-5e13-4ffe-8167-92e6e9a59701",
"name": "OpenAI Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"typeVersion": 1.3,
"position": [
496,
128
],
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"options": {}
},
"id": "0761c27f-9c5c-4689-b03e-14ed1b0c03c3",
"name": "SerpAPI News Search",
"type": "@n8n/n8n-nodes-langchain.toolSerpApi",
"typeVersion": 1,
"position": [
624,
128
],
"credentials": {
"serpApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "id-1",
"name": "to",
"value": "={{ $json.Email }}",
"type": "string"
},
{
"id": "id-2",
"name": "subject",
"value": "Newsletter Diario - Estrategia en GenAI y Data",
"type": "string"
},
{
"id": "id-3",
"name": "html",
"value": "={{ $('Newsletter AI Agent').item.json.output }}",
"type": "string"
}
]
},
"options": {}
},
"id": "6083d50f-4a80-41ac-a9a1-fd0d16b5f9e1",
"name": "Prepare Email Data",
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
1056,
-96
]
},
{
"parameters": {
"sendTo": "={{ $json.to }}",
"subject": "={{ $json.subject }}",
"message": "={{ $json.html }}",
"options": {}
},
"id": "fc3c3b3d-da9f-4f4c-946c-5ae6cd61af31",
"name": "Send Newsletter Email",
"type": "n8n-nodes-base.gmail",
"typeVersion": 2.2,
"position": [
1280,
-96
],
"credentials": {
"gmailOAuth2": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "{{ GOOGLE_SHEETS_DOCUMENT_ID }}",
"mode": "list",
"cachedResultName": "Suscriptions Web",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/{{ GOOGLE_SHEETS_DOCUMENT_ID }}/edit"
},
"sheetName": {
"__rl": true,
"value": "{{ GOOGLE_SHEETS_SHEET_ID }}",
"mode": "list",
"cachedResultName": "newsletter",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/{{ GOOGLE_SHEETS_DOCUMENT_ID }}/edit#gid={{ GOOGLE_SHEETS_SHEET_ID }}"
},
"options": {}
},
"id": "19254748-d8aa-4873-8ab9-7dff804e802d",
"name": "Get Recipients from Sheet",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
832,
-96
],
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
}
],
"connections": {
"Daily Newsletter Schedule": {
"main": [
[
{
"node": "Newsletter AI Agent",
"type": "main",
"index": 0
}
]
]
},
"Newsletter AI Agent": {
"main": [
[
{
"node": "Get Recipients from Sheet",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Newsletter AI Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"SerpAPI News Search": {
"ai_tool": [
[
{
"node": "Newsletter AI Agent",
"type": "ai_tool",
"index": 0
}
]
]
},
"Prepare Email Data": {
"main": [
[
{
"node": "Send Newsletter Email",
"type": "main",
"index": 0
}
]
]
},
"Get Recipients from Sheet": {
"main": [
[
{
"node": "Prepare Email Data",
"type": "main",
"index": 0
}
]
]
}
},
"meta": {
"templateCredsSetupCompleted": true
},
"_documentation": {
"name": "Daily Content Digest Newsletter",
"version": "1.0",
"description": "Generates and sends a daily AI-curated HTML newsletter about Generative AI and Data Engineering trends. Uses OpenAI (gpt-4.1-mini) + SerpAPI to research the 3 most disruptive daily news items, generates a styled HTML email, then fetches the subscriber list from Google Sheets and sends the newsletter via Gmail to each subscriber.",
"trigger": "Schedule \u2014 daily at 08:00",
"ai_model": "gpt-4.1-mini (OpenAI via n8n built-in credits or custom key)",
"search_tool": "SerpAPI (real-time news search)",
"placeholders_to_fill": [
"{{ GOOGLE_SHEETS_DOCUMENT_ID }} \u2014 ID of the Google Sheets spreadsheet (subscribers list)",
"{{ GOOGLE_SHEETS_SHEET_ID }} \u2014 Sheet tab ID for the \"newsletter\" tab",
"{{ CREDENTIAL_ID }} \u2014 Auto-assigned by n8n for each credential",
"{{ WEBHOOK_ID }} \u2014 Auto-assigned by n8n"
],
"credentials_required": [
"OpenAI API (n8n free credits or own key)",
"SerpAPI account (for real-time news search)",
"Google Sheets OAuth2 (Sheets mariano@mgatc.com)",
"Gmail OAuth2 (mariano@mgatc.com Gmail)"
]
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
gmailOAuth2googleSheetsOAuth2ApiopenAiApiserpApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
05-Daily-Content-Digest. Uses agent, lmChatOpenAi, toolSerpApi, gmail. Scheduled trigger; 7 nodes.
Source: https://github.com/Mgobeaalcoba/Mgobeaalcoba.github.io/blob/main/docs/automations/05-daily-content-digest.json — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This n8n automation workflow automates the creation, scripting, production, and posting of YouTube videos. It leverages AI (OpenAI), image generation (PIAPI), video rendering (Shotstack), and platform
Agent, OpenAI Chat, Airtable Tool +7
Created by: Peyton Leveillee Last updated: October 2025
OpenAI Chat, Google Sheets, HTTP Request +5
The Multi-Model Agency Content Engine is a high-performance editorial system designed for agencies. It solves the "blank page" problem by alternating between real-world social proof and strategic expe
Google Sheets, Gmail, Google Drive +6
This workflow automates the creation, rendering, approval, and posting of TikTok-style POV (Point of View) videos to Instagram, with cross-posting to Facebook and YouTube. It eliminates manual video p
OpenAI Chat, Output Parser Item List, HTTP Request +10
SEO Blog Article Generation Workflow. Uses outputParserStructured, httpRequest, agent, lmChatOpenAi. Scheduled trigger; 56 nodes.
Output Parser Structured, HTTP Request, Agent +4