Classify and summarize WeChat articles with GPT-4 Nano to Google Sheets and Notion

Who’s it for 👥 This template is perfect for content creators, marketers, and researchers managing WeChat public account articles! 🚀 It’s ideal for n8n newcomers or anyone wanting to save time on manual content analysis, especially if you use Google Sheets for tracking. 📊 Whether you’re into AI, 欧阳良宜, or automation, this is for you! 😄 How it works / What it does 🔧 This workflow automates the retrieval, filtering, classification, and summarization of WeChat articles. 🌐 It reads RSS feed links from a Google Sheet, filters articles from the last 10 days ⏳, cleans HTML content 🧹, classifies them as relevant or not 🎯, generates insightful Chinese summaries with AI 🤖, and saves results to Google Sheets and Notion. 📝 Outputs are Slack-formatted for team collaboration! 💬 How to set up 🛠️ 1. Prepare Google Sheets: Use your own documentId (replace the example) and set up sheets "Save Initial Links" (gid=198451233) and "Save Processed Data" (gid=1936091950). 📋 2. Configure Credentials: Add Google Sheets and OpenAI API credentials—avoid hardcoding keys! 🔐 3. Set RSS Feed: Update the rssfeedurl in the "RSS Read" node with your WeChat RSS feed. 🌐 4. Customize AI: Tweak "Relevance Classification" and "Basic LLM Chain" prompts for your topics (e.g., 欧阳良宜, AI). 🎨 5. Notion (Optional): Swap the databaseId (e.g., 22e79d55-2675-8055-a143-d55302c3c1b1) with your own. 📚 6. Run Workflow: Trigger manually via the "When clicking ‘Execute workflow’" node. 🚀 Requirements ✅ - n8n account with Google Sheets and OpenAI integrations. - Access to a WeChat public account RSS feed. - Basic JSON and node config knowledge. How to customize the workflow 🎛️ - Topic Adjustment: Update categories in "Relevance Classification" for new topics (e.g., "technology", "education"). 🌱 - Summary Length: Modify the LLM prompt in "Basic LLM Chain" to adjust length or style. ✂️ - Output Destination: Add Slack or Email nodes for more outputs. 📩 - Date Filter: Change the "IF (Filter by Date)" condition (e.g., 7 days instead of 10). ⏰ - Scalability: Use a "Schedule Trigger" node for automation. ⏳