AutomationMart
Home/Browse/Classify and summarize WeChat articles with GPT-4 Nano to Google Sheets and Notion
n8n

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

n8nn8n21 modulesv1.0
SlackNotionGoogle SheetsOpenAI

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 lin

At a glance

Classify and summarize WeChat articles with GPT-4 Nano to Google Sheets and Notion is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Slack, Notion, Google Sheets, OpenAI. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Slack, Notion, Google Sheets, OpenAI
Modules
21
Price
Free
Version
v1.0
Classify and summarize WeChat articles with GPT-4 Nano to Google Sheets and Notion workflow diagram

About this workflow

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

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Create Slack messages for new Bigin by Zoho CRM deals

Every time a deal in your Bigin by Zoho CRM is added, Make will create a message in your Slack.

Free

Send a Slack message from a new Uniqode QR code scan

Every time a new Uniqode QR code scan happens, Make will automatically send a Slack message.

Free

Automated GitHub scanner for exposed AWS IAM keys

Automated GitHub Scanner for Exposed AWS IAM Keys Overview This n8n workflow automatically scans GitHub for exposed AWS IAM access keys associated with your AWS account, helping security teams quickly identify and respond to potential security breaches. When compromised keys are found, the workflow generates detailed security reports and sends Slack notifications with actionable remediation steps. 🔑 Key Features - Automated AWS IAM Key Scanning: Regularly checks for exposed AWS access keys on Gi

Free

Pdf RAG agent with Telegram chat & auto-ingestion from Google Drive

How it works This workflow creates an intelligent document assistant called "Mookie" that can answer questions based on your uploaded documents. Here's how it operates: - Document Ingestion: The system can automatically load PDF files from Google Drive or accept PDFs uploaded directly through Telegram, then processes and stores them in a PostgreSQL vector database using Mistral embeddings - Smart Retrieval: When users ask questions via Telegram or a web chat interface, the AI agent searches thro

Free

Source top GitHub talent by language & location with Gemini AI and BrowserAct

AI-Powered Top GitHub Talent Sourcing (by Language & Location) to Google Sheet This n8n template is a powerful talent sourcing engine that finds, analyzes, and scores GitHub contributors using a custom AI formula. This workflow is ideal for technical recruiters, hiring managers, and team leads who want to build a pipeline of qualified candidates based on specific technical skills and location. --- Self-Hosted Only This Workflow uses a community contribution and is designed and tested for self-h

Free

Generate images and convert to video using Flux, Kraken & Runway

(Image Generation → Hosting → Video Generation) This workflow is designed for creators, automation enthusiasts, and indie hackers who want to generate image-based videos automatically using AI tools — at a low cost. --- ⚙️ Workflow Overview This automation performs the following steps: 1. Trigger (Schedule or manual) 2. Generate an image using Flux (choose between two APIs) 3. Upload the image to Kraken.io to get a public URL 4. Send the image to Runway ML (choose between two APIs) to generate a

Free

Extract Website URLs from Sitemap.XML for SEO Analysis

Overview This n8n workflow automates the process of crawling a website's sitemap to extract URLs, which is particularly useful for SEO analysis, website auditing, or content monitoring. By leveraging n8n's nodes, the workflow fetches the sitemap from a specified URL, processes the XML data, and extracts individual URLs, which can then be converted into a downloadable file or integrated with tools like Google Sheets. How It Works The workflow operates in a sequential manner, utilizing a se

Free

Extract and merge Twitter (X) threads using TwitterAPI.io

Twitter (X) Thread Fetcher: Extract and Merge Tweets from Threads What it does - Thread Detection: Automatically detects whether the provided Twitter link is a single tweet or a thread. - Tweet Extraction: Fetches and returns the content of a single tweet, or gathers all tweets in a thread by retrieving the first tweet and all connected replies. - Thread Merging: Merges all tweets in the correct order to reconstruct the complete thread, filtering out any empty results. - Seamless Integration: Ea

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free