Build a Competitor-tracking Agent with n8n + Kimi: Full SOP (with Pitfall Log)

Workflow Overview

Goal: Auto-fetch competitor Xiaohongshu hit notes daily, use Kimi to summarize topic patterns, and structure them into a Feishu spreadsheet. n8n orchestrates the whole thing; humans only do 15 minutes of review.

Node chain: Scheduled trigger -> fetch -> Kimi rewrite -> Feishu storage -> notify.

Step 1: Scheduled Trigger and Fetch

In n8n, create a Cron node that fires daily at 9:00. Connect an HTTP Request node to pull the competitor notes list (bring your own compliant data source-do not scrape copyrighted content).

Step 2: Kimi Rewrite Prompt

Call the Kimi API and use the prompt below to structure the raw note:

You are a senior Xiaohongshu topic editor. Please extract from this note:
1. Title pattern (number / pain point / contrast)
2. Body structure (opening - middle - ending)
3. Reusable topic angle
Output JSON only, fields: title_pattern, structure, angle

Step 3: Feishu Storage and Notification

Use a Feishu Bitable node to write the structured result, then connect a WeCom bot node to notify the day's new entries.

Pitfall Log

• Kimi occasionally returns non-JSON: Stress "output JSON only" at the end of the prompt, and add a JSON-parse retry branch in n8n.
• Scrape rate too high gets rate-limited: Once per day per competitor is enough-don't get greedy.
• Feishu sheet fields must be created first: n8n won't auto-create fields; a missing field fails silently.