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).
