Send a daily AI morning briefing with Google Gemini, RSS, Sheets, Gmail and weather

by Oka Hironobu ✓ · 37 views · created 2026-07-27 · Personal Productivity, Multimodal AI

What this workflow does

This AI workflow has 13 nodes and runs on a schedule (every day at 06:00). Along the way it connects Google Sheets, Google Gemini Chat Model and Gmail. It also calls api.open-meteo.com over HTTP.

How it runs

Trigger: On a schedule (every day at 06:00).

1. Read News Feed (RSS Read): reads an RSS feed
2. Get Today Tasks (Google Sheets): uses Google Sheets
3. Get Weather (HTTP Request): calls api.open-meteo.com
4. Take Top Headlines (Code): runs custom JavaScript code
5. List Open Tasks (Code): runs custom JavaScript code
6. Shape Weather (Code): runs custom JavaScript code
7. Combine All Sources (Merge): merges the data from its input branches
8. Bundle Sources (Aggregate): combines items into one
9. Build Briefing Input (Code): runs custom JavaScript code
10. Write Morning Briefing with Gemini (Basic LLM Chain): sends a prompt to an LLM, with model: Google Gemini Chat Model

…plus 1 more step. See the full node list below.

Services it uses

Google SheetsGoogle Gemini Chat ModelGmail

HTTP calls to: api.open-meteo.com

Before you upgrade to n8n 3.0

Nodes used (10)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• RSS Readn8n-nodes-base.rssFeedRead
• Coden8n-nodes-base.code
• Mergen8n-nodes-base.merge
• Google Sheetsn8n-nodes-base.googleSheets
• HTTP Requestn8n-nodes-base.httpRequest
• Aggregaten8n-nodes-base.aggregate
• Basic LLM Chain@n8n/n8n-nodes-langchain.chainLlm
• Google Gemini Chat Model@n8n/n8n-nodes-langchain.lmChatGoogleGemini
• Gmailn8n-nodes-base.gmail

From the author

Quick Overview This workflow runs every morning to pull top BBC News headlines via RSS, today’s open tasks from Google Sheets, and a one-day forecast from Open-Meteo, then uses Google Gemini to write a short morning briefing and emails it to you via Gmail.…

View the original on n8n.io → Check your own copy