Classify and Summarize WeChat Articles with GPT-4, Nano to Google Sheets, and Notion - n8n Workflow | Neura Market
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, data analytics, 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 rss_feed_url 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., data analytics, AI).
5. **Notion (Optional)**: Swap the databaseId (e.g., 22e79d55-2675-8055-a143-d55302c3c1b1) with your own.
6. **Run Workflow**: Trigger manually via the "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.
Platform
n8n
Category
AI
Price
Free
Creator
Seven Liu
if
set
code
merge
notion
stickyNote
rssFeedRead
googleSheets
manualTrigger
chainLlm
How to import this workflow into n8n
1Purchase or download the workflow to get the n8n workflow JSON file.
2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
3Open each node marked with a credential warning and connect your own accounts and API keys.
4Run the workflow once manually to verify the data flow, then toggle it to Active.