AI summarization of WeChat articles to Google Sheets an

This automation streamlines the process of collecting and analyzing content from WeChat — a major source of Chinese-language publications. It enables users to automatically identify relevant articles, generate AI-powered summaries, and store structured results in Google Sheets and Notion without manual scanning. Ideal for professionals who rely on timely insights from Chinese digital sources.

## Who it´s for
- Researchers and analysts tracking niche WeChat content
- Marketers gathering insights from Chinese sources
- Personal assistants and knowledge managers automating article processing
- Teams using Notion and Google Sheets as knowledge bases

## What the automation does
- Manually triggered to fetch WeChat article links from Google Sheets
- Updates data via RSS feeds and filters by publication date (e.g., last 10 days)
- Checks for uniqueness to avoid duplicates
- Cleans HTML content and passes text to AI for analysis
- Uses GPT-4.1-nano to classify relevance and generate detailed Chinese summaries
- Stores metadata, summaries, and links in Google Sheets and creates a new page in Notion
- Supports monitoring specific authors like 欧阳良宜

## What´s included
- Ready-to-use n8n workflow with LangChain integration
- Logic for manual triggering and sequential data processing
- Integrations with Google Sheets API, Notion API, RSS Feed, and OpenAI API
- Basic textual instructions for launch and adaptation

## Requirements for setup
- n8n account with workflow execution access
- Google account with Sheets API enabled
- Notion workspace with page creation permissions
- OpenAI API key compatible with GPT-4.1-nano
- Access to WeChat RSS feeds or a pre-filled spreadsheet with article links

## Benefits and outcomes
- Saves time on manual searching and reading
- Systematizes content from hard-to-access WeChat sources
- Centralized storage of analyzed materials in familiar tools
- Enables fast search and reuse of AI summaries
- Supports processing of Chinese language and local sources
- Flexible filtering by topics, dates, and authors

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via Telegram: @gleb923.