Daily news digest & weekly trends with AI filtering, Slack & Google Sheets

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 1. Fetches News: Pulls daily articles via NewsAPI based on your chosen keyword (default: "technology"). 2. AI Filtering: Uses an AI Agent (via OpenRouter) to filter out low-quality or irrelevant clickbait. 3. 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. 4. Data Archiving (Sheets): Extracts structured data (Title, Author, Summary, URL) and saves it to Google Sheets. 5. 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 1. Configure Credentials: You will need API keys/auth for NewsAPI, OpenRouter (or OpenAI), DeepL, Google Sheets, and Slack. 2. Setup Google Sheet: Create a sheet with the following headers in the first row: title, author, summary, url. 3. Map the Sheet: In the "Append row in sheet" and "Read sheet (weekly)" nodes, select your file and map the columns. 4. Define Keyword: Open the "Set Keyword" node and change chatInput to the topic you want to track (e.g., "Crypto", "SaaS", "Climate Change"). 5. 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).