Daily AI Morning Briefing n8n: Gemini, RSS, Sheets & Gmail

Get a daily AI morning briefing—news, tasks, weather—delivered to your Gmail at 6:30am

With Daily AI Morning Briefing n8n: Gemini, RSS, Sheets & Gmail, your mornings start with a concise briefing: top BBC News headlines from RSS, your open tasks from Google Sheets, and a one-day forecast—written by Google Gemini and emailed to you via Gmail.

What this workflow does

• Runs every morning at 06:30 using an n8n schedule trigger.
• Pulls BBC News headlines from an RSS feed and formats the top six into a short news block.
• Reads your “open tasks” from a selected Google Sheets worksheet and formats them into an “open tasks” list (including a count).
• Fetches weather from the Open-Meteo forecast API using your configured latitude/longitude, then converts it into a single weather summary (and continues even if the API fails).
• Combines news + tasks + weather into one input object.
• Generates a ~120-word briefing with Google Gemini as a non-bulleted morning summary.
• Sends the briefing via Gmail to your configured recipient.

Use cases

• Busy SaaS operators who want a daily AI summary of what’s happening (news), what’s pending (Sheets tasks), and what to expect (weather).
• Automation engineers who need a practical n8n workflow that combines RSS, Google Sheets, and Gemini into one email.
• Teams maintaining an “open tasks” tracker in Sheets and wanting a consistent, hands-free morning update in Gmail.

Technical details

• Schedule: runs at 06:30 daily.
• Integrations/OAuth2: Google Gemini (PaLM) API, Google Sheets OAuth2, Gmail OAuth2.
• Core node types: code, gmail, merge, aggregate, sticky note, http request.
• Includes configurable inputs: RSS feed URL, Sheets document/worksheet, weather latitude/longitude, and sendTo email address.

Setup in minutes

Connect credentials for Google Gemini, Google Sheets, and Gmail, select your tasks sheet (with a “Task” column), confirm your RSS URL and weather coordinates, then set the recipient email—your daily briefing is ready.