Quick Overview
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. How it works Runs every morning at 06:30 on a schedule. Reads the BBC News RSS feed and formats the top six headlines into a short text block. Fetches task rows from a Google Sheets worksheet and formats them as an “open tasks” list with a count. Calls the Open-Meteo forecast API for the configured location and converts the response into a single weather summary (continuing even if the API fails). Combines the news, tasks, and weather summaries into one briefing input object. Uses Google Gemini to generate a ~120-word, non-bulleted morning briefing from the combined context. Sends the generated briefing to the configured recipient using Gmail. Setup Connect credentials for Google Gemini (PaLM) API, Google Sheets OAuth2, and Gmail OAuth2. Select the Google Sheets document and worksheet that contains your tasks, and ensure it has columns like “Task” and (optionally) “Priority.” Update the RSS feed URL (if desired), set the weather latitude/longitude for your location, and set the “sendTo” email address in Gmail. Adjust the schedule time to match when you want to receive the briefing. An n8n automation workflow template by Oka Hironobu.
Oka Hironobu
web
free
Others in the same category, ranked by how often they are opened.
