Automate Niche Web Content to Google Sheets with AI & Kagi

Automatically discover, analyze, and organize niche web content with this powerful n8n workflow that combines Kagi's independent search capabilities with AI-powered content analysis, seamlessly saving enriched results to Google Sheets for easy research and content curation.

What This Workflow Does

This comprehensive automation accepts any topic through a webhook, searches for small and independent web content using the Kagi Enrichment API, then leverages AI to intelligently categorize, summarize, and score each discovery. Here's the complete process:

• Receives topic requests via webhook POST with topic field
• Queries Kagi Enrichment API to find niche, independent websites on your specified topic
• Extracts and maps search results into structured title, URL, and snippet data
• Processes each result through AI analysis for categorization and summary generation
• Assigns usefulness scores (1-10) to help prioritize content quality
• Automatically appends enriched data as new rows in your Google Sheets

Use Cases

Perfect for content researchers building curated databases of independent publications, marketing teams discovering untapped niche websites for outreach campaigns, and competitive analysts tracking emerging voices in specific industries. Ideal for anyone who values discovering authentic, non-mainstream content sources while maintaining organized research workflows.

Technical Details

Built with essential n8n nodes including webhook triggers, HTTP requests for Kagi API integration, code nodes for data processing, and Google Sheets connectors. Requires Kagi API token, OpenRouter credentials (easily swappable with other LLM providers), and Google Sheets OAuth2 authentication. Your target spreadsheet should include columns for title, url, snippet, category, summary, and usefulness_score.

This workflow transforms manual web research into an automated content discovery engine, helping you build comprehensive databases of niche content while AI handles the heavy lifting of analysis and organization. Deploy once and scale your research capabilities exponentially.