Get Started
Back to Templates

Daily News Digest & Weekly Trends with AI Filtering, Slack & Google Sheets

Created by

Created by: takuma || takuma

takuma

Last update

Last update 3 hours ago

Categories

Share

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