Back to Templates

Automate News Discovery & Publishing with GPT-4, Google Search API & Slack

Created by

Created by: Kalyxi Ai || kalyxi

Kalyxi Ai

Last update

Last update 22 days ago

Share


🚀 Automate News Discovery & Publishing with GPT-4, Google Search API & Slack

🎯 Overview

Automated content publishing system that discovers industry news, transforms it into original articles using GPT-4, and publishes across multiple channels with SEO optimization and intelligent duplicate prevention.

✨ Key Features

  • 🤖 Smart Query Generation - AI agent generates unique search queries while checking Google Sheets to avoid duplicates
  • 🔍 News Discovery - Uses Google Custom Search API to find recent articles (last 7 days)
  • 🧠 Content Intelligence - Processes search results and skips anti-bot protected sites automatically
  • 📝 GPT-4 Article Generation - Creates professional, SEO-optimized news articles in Reuters/Bloomberg style
  • 📢 Multi-Channel Publishing - Publishes to CMS with automatic Slack notifications
  • 📊 Comprehensive Tracking - Logs all activity to Google Sheets for analytics and duplicate prevention

🔄 How It Works

  1. ⏰ Scheduled Trigger runs every 8 hours to maintain consistent content flow
  2. 🤖 AI Agent generates targeted search queries for your niche while checking historical data
  3. 🔍 Google Search finds recent articles and extracts metadata (title, snippet, source)
  4. 🛡️ Smart Content Handler bypasses sites with anti-bot protection, using search snippets instead
  5. ⚡ GPT-4 Processing transforms snippets into comprehensive 2000+ word articles with proper formatting
  6. 🚀 Publishing Pipeline formats content for CMS with SEO metadata and publishes automatically
  7. 📱 Notification System sends detailed Slack updates with article metrics
  8. 📈 Activity Logging tracks all published content to prevent future duplicates

🔧 Setup Requirements

📋 Prerequisites

  • Google Custom Search API key and Search Engine ID
  • OpenAI GPT-4 API access
  • Google account for tracking spreadsheet
  • Slack workspace for notifications
  • CMS or website with API endpoint for publishing

🛠️ Step-by-Step Setup

Step 1: 🔎 Google Custom Search Configuration

  1. Go to Google Custom Search Engine
  2. Create a new search engine
  3. Configure to search the entire web
  4. Copy your Search Engine ID (cx parameter)
  5. Get your API key from Google Cloud Console

Step 2: 📊 Google Sheets Template Setup

Create a Google Sheet with these required columns:

  • Column A: timestamp - ISO date format (YYYY-MM-DD HH:MM:SS)
  • Column B: query - The search query used
  • Column C: title - Published article title
  • Column D: url - Published article URL
  • Column E: status - Publication status (success/failed)
  • Column F: word_count - Final article word count

Template URL: Copy this Google Sheets template

Step 3: 🔑 Credential Configuration

Set up the following credentials in n8n:

  1. 📊 Google Sheets API - OAuth2 connection to your Google account
  2. 🤖 OpenAI API - Your GPT-4 API key
  3. 📱 Slack Webhook - Webhook URL for your notification channel
  4. 🔍 Custom Search API - Your Google Custom Search API key

Step 4: ⚙️ Workflow Customization

Modify these key parameters to fit your needs:

  • 🎯 Search Topic: Edit the AI agent prompt to focus on your industry
  • ⏰ Publishing Schedule: Adjust the cron trigger (default: every 8 hours)
  • 📝 Article Length: Modify GPT-4 prompt for different word counts
  • 🌐 CMS Endpoint: Update the publishing node with your website's API

🎨 Customization Options

🎯 Content Targeting

  • Modify the AI agent's search query generation to focus on specific industries
  • Adjust date restrictions (currently set to last 7 days)
  • Change the number of search results processed per run

✍️ Article Style

  • Customize GPT-4 prompts for different writing styles (formal, casual, technical)
  • Adjust article length requirements
  • Modify SEO optimization parameters

📡 Publishing Channels

  • Add additional CMS endpoints for multi-site publishing
  • Configure different notification channels (Discord, Teams, etc.)
  • Set up social media auto-posting integration

💡 Use Cases

  • 📰 Automated news websites
  • 📝 Industry blog content generation
  • 🔍 SEO content pipeline automation
  • 📊 News aggregation and republishing
  • 📈 Content marketing automation

🛠️ Technical Notes

  • Workflow includes error handling for anti-bot protection
  • Duplicate prevention through Google Sheets tracking
  • Rate limiting considerations for API usage
  • Automatic retry logic for failed requests

🆘 Support

For setup assistance or customization help, refer to the workflow's internal documentation nodes or contact the template creator.