Daily News Digest & Weekly Trends with AI Filtering, Slack & Google Sheets
Go to Workflow
takuma
Description
Who is this for
This template is perfect for:
Market Researchers** tracking industry trends.
Tech Teams** wanting to stay updated on specific technologies (e.g., "AI", "Cybersecurity").
Content Creators** looking for curated news topics.
Busy Professionals** who need a high-signal, low-noise news digest.
What it does
Fetches News: Pulls daily articles via NewsAPI based on your chosen keyword (default: "technology").
AI Filtering: Uses an AI Agent (via OpenRouter) to filter out low-quality or irrelevant clickbait.
Daily Digest (Slack):
Summarizes the top 3 articles in English.
Translates the summaries to Japanese using DeepL (optional).
Posts both versions to a Slack channel.
Data Archiving (Sheets): Extracts structured data (Title, Author, Summary, URL) and saves it to Google Sheets.
Weekly Trend Report: Every Monday, it reads the past week's data from Google Sheets and uses AI to generate a high-level trend report and strategic insights.
How to set up
Configure Credentials: You will need API keys/auth for NewsAPI, OpenRouter (or OpenAI), DeepL, Google Sheets, and Slack.
Setup Google Sheet: Create a sheet with the following headers in the first row: title, author, summary, url.
Map the Sheet: In the "Append row in sheet" and "Read sheet (weekly)" nodes, select your file and map the columns.
Define Keyword: Open the "Set Keyword" node and change chatInput to the topic you want to track (e.g., "Crypto", "SaaS", "Climate Change").
Slack Setup: Select your desired channel in the Slack nodes.
Requirements
n8n** (Self-hosted or Cloud)
NewsAPI** Key (Free tier available)
OpenRouter** (or any LangChain compatible Chat Model like OpenAI)
DeepL** API Key (for translation)
Google Sheets** account
Slack** Workspace
How to customize
Change the Language:** Remove the DeepL node if you only want English, or change the target language code.
Adjust the Prompt:** Modify the "AI Agent (Filter)" system message to change how strict the news filtering is.
Change Schedule:** Adjust the Cron nodes to run at your preferred time (currently set to Daily 8 AM and Weekly Monday 9 AM).