AI powered information monitoring with OpenAI Google Sheets Ji
Check Legal Regulations: This workflow involves scraping, so ensure you comply with the legal regulations in your country before getting started. Better safe...
🔌 Nodes & Integrations Used (7)
📖 Implementation & Setup Guide
**Check Legal Regulations**: This workflow involves scraping, so ensure you comply with the legal regulations in your country before getting started. Better safe than sorry!
📌 Purpose This workflow enables **automated and AI-driven topic monitoring**, delivering **concise article summaries** directly to a **Slack channel** in a structured and easy-to-read format. It allows users to stay informed on specific topics of interest effortlessly, without manually checking multiple sources, ensuring a **time-efficient and focused** monitoring experience.
**To get started, copy the Google Sheets template required for this workflow from [here](https://docs.google.com/spreadsheets/d/1F2FzWt9FMkA5V5i9d_hBJRahLDvxs3DQBOLkLYowXbY).**
🎯 Target Audience This workflow is designed for: - **Industry professionals** looking to track key developments in their field. - **Research teams** who need up-to-date insights on specific topics. - **Companies** aiming to keep their teams informed with relevant content.
⚙️ How It Works 1. **Trigger:** A **Scheduler** initiates the workflow at regular intervals (default: every hour). 2. **Data Retrieval:** - RSS feeds are fetched using the **RSS Read** node. - Previously monitored articles are checked in **Google Sheets** to avoid duplicates. 3. **Content Processing:** - The article relevance is assessed using **OpenAI (GPT-4o-mini)**. - Relevant articles are scraped using **Jina AI** to extract content. - Summaries are generated and formatted for Slack. 4. **Output:** - Summaries are posted to the specified Slack channel. - Article metadata is stored in **Google Sheets** for tracking.
🛠️ Key APIs and Nodes Used - **Scheduler Node:** Triggers the workflow periodically. - **RSS Read:** Fetches the latest articles from defined RSS feeds. - **Google Sheets:** Stores monitored articles and manages feed URLs. - **OpenAI API (GPT-4o-mini):** Classifies article relevance and generates summaries. - **Jina AI API:** Extracts the full content of relevant articles. - **Slack API:** Posts formatted messages to Slack channels.
---
This workflow provides an **efficient and intelligent way** to stay informed about your topics of interest, directly within Slack.
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
AI_powered_information_monitoring_with_OpenAI_Google_Sheets_Ji.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related Messaging & Chat Workflows
View All in Messaging & Chat →Add a bug to Linear via Slack command
Use Case When building a product it's important to discover and eliminate bugs as quickly as possible. Since we're using our product at n8n a lot, we wanted ...
AI Children s Storytelling on Telegram
Production-ready n8n automation template for AI Children s Storytelling on Telegram built by AhiXLight. Seamlessly connects Lm Chat Open Ai, Chain Summarization, Text Splitter Recursive Character Text Splitter with 14 configured nodes.
AI Event Banner Generator with BannerBear
Production-ready n8n automation template for AI Event Banner Generator with BannerBear built by AhiXLight. Seamlessly connects Form Trigger, HTTP Request, Bannerbear with 16 configured nodes.
AI Event Banner Generator with n8n
Production-ready n8n automation template for AI Event Banner Generator with n8n built by AhiXLight. Seamlessly connects Form Trigger, HTTP Request, Bannerbear with 16 configured nodes.