HumationHuman + Automation
Back to Catalog

AI-powered news monitoring & social post generator with OpenAI and Upload-Post

Juan Carlos Cavero GraciaJuan Carlos Cavero Gracia
1190 views
2/3/2026
OCRDocument ProcessingEmail AutomationIMAPAI Extraction
Official Page

image.png

This automation template turns any RSS feed into ready-to-publish social content using AI. It continuously ingests articles, scores their quality and relevance, crafts platform-native posts (Twitter/X threads and LinkedIn posts), routes items for review or archiving, logs everything to Google Sheets, and can publish automatically to X, Threads, and LinkedIn.

Note: This workflow uses OpenAI models for analysis and content generation and integrates with Upload-Post for multi-platform publishing and Google Sheets for tracking. Costs depend on token usage and posting volume.

Who Is This For?

  • Content Teams & Solo Creators: Ship consistent, high-signal posts without manual rewriting.
  • Newsletters & Media Brands: Turn breaking stories into shareable, platform-native content.
  • Agencies: Scale curation across clients with review and auto-publish paths.
  • Founders & PMMs: Maintain a steady public presence with minimal effort.

What Problem Does This Workflow Solve?

Manual curation and rewriting of news is slow and inconsistent. This workflow:

  • Scores Articles: Filters noise with AI quality/relevance scoring.
  • Auto-Writes Posts: Generates concise X threads and business-ready LinkedIn copy.
  • Routes Intelligently: Sends good items to publish/review and archives the rest.
  • Logs Everything: Keeps a structured history in Google Sheets for analytics.

How It Works

  1. RSS Polling: Monitors your chosen feed(s) on a schedule.
  2. Scoring AI: Rates quality and relevance; extracts summary, key topics, and angle.
  3. Parse & Enrich: Normalizes AI output and merges with article metadata.
  4. Quality Gates: Directs items to “publish/review” or “archive.”
  5. Content Generation: Produces an X thread and a LinkedIn post with clear hooks and insights.
  6. Publishing: Uploads to X, Threads, and LinkedIn via Upload-Post (optional).
  7. Sheets Logging: Writes summaries, scores, and outputs to Google Sheets.

Setup

  1. OpenAI API: Add your OpenAI credentials (models like gpt-4.1/gpt-4o).
  2. Upload-Post Credentials: Connect the Upload-Post integration and target pages (e.g., LinkedIn org ID).
  3. Google Sheets: Add OAuth credentials and point “Store Content”/“New for Review”/“Archive” to your sheets.
  4. RSS Feed URL: Replace the sample feed with your preferred sources.
  5. Thresholds & Routing: Adjust quality/relevance filters to your standards.
  6. Publishing Mode: Toggle platforms (X, Threads, LinkedIn) and decide auto vs. review-first.

Requirements

  • Accounts: n8n, OpenAI, Upload-Post, Google account (Sheets).
  • API Keys: OpenAI token, Upload-Post credentials, Google Sheets OAuth.
  • Feeds: One or more RSS URLs for your niche.

Features

  • AI Triage: Quality/relevance scoring to prioritize high-value stories.
  • Platform-Native Output: Hooked X threads and professional LinkedIn posts.
  • Review or Auto-Publish: Safe gating before posting live.
  • Analytics-Ready Logs: Structured entries in Google Sheets.
  • Modular & Extensible: Swap feeds, add Slack/Discord alerts, or plug into CMS/Notion.

Stay top-of-mind: convert fresh news into compelling, on-brand social content—automatically.

AI-Powered News Monitoring & Social Post Generator

This n8n workflow automates the process of monitoring RSS feeds for new articles, generating social media post content using OpenAI, and then conditionally processing or storing that content. It's designed to streamline content curation and social media management by leveraging AI to create engaging posts from fresh news.

What it does

  1. Monitors RSS Feeds: Regularly checks specified RSS feeds for new articles.
  2. Generates Social Media Content with AI: Uses an OpenAI Chat Model and an AI Agent to generate social media post text based on the content of new articles.
  3. Applies Conditional Logic: Evaluates the generated content (e.g., checks if a post was successfully generated or meets certain criteria).
  4. Processes Valid Posts: If the content meets the conditions, it can be further processed (e.g., uploaded to a social media platform, stored in a database, or added to a Google Sheet).
  5. Handles Invalid Posts: If the content does not meet the conditions, it can be routed for review or alternative handling.
  6. Stores Data in Google Sheets: Adds processed information (likely the news article details and generated social post) to a Google Sheet.

Prerequisites/Requirements

  • n8n Instance: A running n8n instance.
  • OpenAI API Key: For the "OpenAI Chat Model" and "AI Agent" nodes to generate content.
  • Google Sheets Account: To store the processed data. You will need to configure Google Sheets credentials in n8n.
  • RSS Feed URLs: The URLs of the RSS feeds you wish to monitor.

Setup/Usage

  1. Import the workflow: Download the provided JSON and import it into your n8n instance.
  2. Configure Credentials:
    • OpenAI: Set up your OpenAI API key as a credential in n8n and select it in the "OpenAI Chat Model" and "AI Agent" nodes.
    • Google Sheets: Set up your Google Sheets credentials (typically OAuth2) in n8n and select them in the "Google Sheets" node.
  3. Configure RSS Feed Trigger:
    • In the "RSS Feed Trigger" node, specify the URLs of the RSS feeds you want to monitor.
    • Adjust the "Interval" to define how often the workflow should check for new articles.
  4. Configure AI Agent and OpenAI Chat Model:
    • Review the prompts and settings within the "AI Agent" and "OpenAI Chat Model" nodes to ensure the generated social media content aligns with your brand and requirements.
    • The "Simple Memory" node helps the AI agent maintain context during the conversation.
  5. Configure If Node:
    • Adjust the conditions in the "If" node to filter news articles or AI-generated posts based on your specific criteria (e.g., content length, keywords, sentiment).
  6. Configure Google Sheets Node:
    • Specify the Spreadsheet ID and Sheet Name where you want to store the news article data and generated social posts.
    • Map the data fields from the previous nodes to the columns in your Google Sheet.
  7. Activate the workflow: Once configured, activate the workflow to start monitoring RSS feeds and generating social media posts automatically.

Related Templates

Automate event RSVPs with email validation & badge generation using VerifiEmail & HTMLCssToImage

Validated RSVP Confirmation with Automated Badge Generation Overview: This comprehensive workflow automates the entire event RSVP process from form submission to attendee confirmation, including real-time email validation and personalized digital badge generation. ✨ KEY FEATURES: • Real-time Email Validation - Verify attendee emails using VerifiEmail API to prevent fake registrations • Automated Badge Generation - Create beautiful, personalized event badges with attendee details • Smart Email Routing - Send confirmation emails with badges for valid emails, rejection notices for invalid ones • Comprehensive Logging - Track all RSVPs (both valid and invalid) in Google Sheets for analytics • Dual Path Logic - Handle valid and invalid submissions differently with conditional branching • Anti-Fraud Protection - Detect disposable emails and invalid domains automatically 🔧 WORKFLOW COMPONENTS: Webhook Trigger - Receives RSVP submissions Email Validation - Verifies email authenticity using VerifiEmail API Conditional Logic - Separates valid from invalid submissions Badge Creator - Generates HTML-based personalized event badges Image Converter - Converts HTML badges to shareable PNG images using HTMLCssToImage Email Sender - Delivers confirmation with badge or rejection notice via Gmail Data Logger - Records all attempts in Google Sheets for tracking and analytics 🎯 PERFECT FOR: • Conference organizers managing hundreds of RSVPs • Corporate event planners requiring verified attendee lists • Webinar hosts preventing fake registrations • Workshop coordinators issuing digital badges • Community event managers tracking attendance 💡 BENEFITS: • Reduces manual verification time by 95% • Eliminates fake email registrations • Creates professional branded badges automatically • Provides real-time RSVP tracking and analytics • Improves attendee experience with instant confirmations • Maintains clean, verified contact lists 🛠️ REQUIRED SERVICES: • n8n (cloud or self-hosted) • VerifiEmail API (https://verifi.email) • HTMLCssToImage API (https://htmlcsstoimg.com) • Gmail account (OAuth2) • Google Sheets 📈 USE CASE SCENARIO: When someone submits your event RSVP form, this workflow instantly validates their email, generates a personalized badge with their details, and emails them a confirmation—all within seconds. Invalid emails receive a helpful rejection notice, and every submission is logged for your records. No manual work required! 🎨 BADGE CUSTOMIZATION: The workflow includes a fully customizable HTML badge template featuring: • Gradient background with modern design • Attendee name, designation, and organization • Event name and date • Email address and validation timestamp • Google Fonts (Poppins) for professional typography 📊 ANALYTICS INCLUDED: Track metrics like: • Total RSVPs received • Valid vs invalid email ratio • Event-wise registration breakdown • Temporal patterns • Organization/company distribution ⚡ PERFORMANCE: • Processing time: ~3-5 seconds per RSVP • Scales to handle 100+ concurrent submissions • Email delivery within 10 seconds • Real-time Google Sheets updates 🔄 EASY SETUP: Import the workflow JSON Configure your credentials (detailed instructions included) Create your form with required fields (name, email, event, designation, organization) Connect the webhook Activate and start receiving validated RSVPs! 🎓 LEARNING VALUE: This workflow demonstrates: • Webhook integration patterns • API authentication methods • Conditional workflow branching • HTML-to-image conversion • Email automation best practices • Data logging strategies • Error handling techniques ---

Jitesh DugarBy Jitesh Dugar
67

Automatically detect & classify GitHub API errors with GPT-4o to Airtable, Notion & Slack

Automatically detect, classify, and document GitHub API errors using AI. This workflow connects GitHub, OpenAI (GPT-4o), Airtable, Notion, and Slack to build a real-time, searchable API error knowledge base — helping engineering and support teams respond faster, stay aligned, and maintain clean documentation. ⚙️📘💬 🚀 What This Template Does 1️⃣ Triggers on new or updated GitHub issues (API-related). 🪝 2️⃣ Extracts key fields (title, body, repo, and link). 📄 3️⃣ Classifies issues using OpenAI GPT-4o, identifying error type, category, root cause, and severity. 🤖 4️⃣ Validates & parses AI output into structured JSON format. ✅ 5️⃣ Creates or updates organized FAQ-style entries in Airtable for quick lookup. 🗂️ 6️⃣ Logs detailed entries into Notion, maintaining an ongoing issue knowledge base. 📘 7️⃣ Notifies the right Slack team channel (DevOps, Backend, API, Support) with concise summaries. 💬 8️⃣ Tracks & prevents duplicates, keeping your error catalog clean and auditable. 🔄 💡 Key Benefits ✅ Converts unstructured GitHub issues into AI-analyzed documentation ✅ Centralizes API error intelligence across teams ✅ Reduces time-to-resolution for recurring issues ✅ Maintains synchronized records in Airtable & Notion ✅ Keeps DevOps and Support instantly informed through Slack alerts ✅ Fully automated, scalable, and low-cost using GPT-4o ⚙️ Features Real-time GitHub trigger for API or backend issues GPT-4o-based AI classification (error type, cause, severity, confidence) Smart duplicate prevention logic Bi-directional sync to Airtable + Notion Slack alerts with contextual AI insights Modular design — easy to extend with Jira, Teams, or email integrations 🧰 Requirements GitHub OAuth2 credentials OpenAI API key (GPT-4o recommended) Airtable Base & Table IDs (with fields like Error Code, Category, Severity, Root Cause) Notion integration with database access Slack Bot token with chat:write scope 👥 Target Audience Engineering & DevOps teams managing APIs Customer support & SRE teams maintaining FAQs Product managers tracking recurring API issues SaaS orgs automating documentation & error visibility 🪜 Step-by-Step Setup Instructions 1️⃣ Connect your GitHub account and enable the “issues” webhook event. 2️⃣ Add OpenAI credentials (GPT-4o model for classification). 3️⃣ Create an Airtable base with fields: Error Code, Category, Root Cause, Severity, Confidence. 4️⃣ Configure your Notion database with matching schema and access. 5️⃣ Set up Slack credentials and choose your alert channels. 6️⃣ Test with a sample GitHub issue to validate AI classification. 7️⃣ Enable the workflow — enjoy continuous AI-powered issue documentation!

Rahul JoshiBy Rahul Joshi
41

WhatsApp customer support bot with GPT-4 Mini, Google Sheets & Rapiwa API

Who Is This For? This n8n automation workflow is designed for customer support teams, business owners, or service providers who want to automate customer interactions on WhatsApp. If you regularly receive customer queries about your products, services, or technical issues — and need a system that can instantly respond, fetch data from Google Sheets or Docs, log support tickets, and send human-like replies — this workflow is for you. It’s perfect for teams using Rapiwa, Google Sheets, and Google Docs who want to provide a smart, AI-driven, yet personal support experience. What This Workflow Does This workflow is structured around a single intelligent AI assistant called Rapiwa that interacts with customers in real time through WhatsApp. Key Features AI-Driven Support Assistant (Rapiwa) WhatsApp Integration via Rapiwa API Dynamic Data Access (Google Sheets + Docs) Knowledge Base Search Conversation Memory Automatic Logging Multi-Product Support Workflow Overview Rapiwa Trigger (Start Node) Starts the workflow automatically whenever a new WhatsApp message is received in your Rapiwa account. Example: When a customer sends a message like “What’s the price of SocialVibe?” or “I can’t access my dashboard”, this node triggers the workflow. If (Check Text) Detects if the incoming message contains text (not just images, videos, or audio). If it’s text, the workflow continues; otherwise, it stops or handles it differently. AI Agent – Customer Support Agent This is the brain of the system — your AI Assistant (Rapiwa). Interprets the user’s question, retrieves information, and replies in a clear, WhatsApp-friendly format. Reads product details and company info from Google Sheets/Docs. Fetches documentation links from the connected “Support Desk” and product-specific HTTP tools. Logs customer issues to the support sheet for tracking and analysis. Memory (Session Context) Stores chat history per user session so Rapiwa remembers context during a conversation. Research (AI Support Tool) Acts as Rapiwa’s research assistant — gathers and organizes information from multiple sources. Sources: Google Sheets, Google Docs, HTTP Tools, and Support Desk. Replay (Rapiwa Send Message) Sends the AI’s final message back to the customer on WhatsApp using the Rapiwa API. WhatsApp-optimized plain text messages only. Data & Integrations 🔹 Google Sheets (Database) Product Data Sheet: Holds product names, descriptions, and pricing. Service Data Sheet: Lists offered services with details. Support Log Sheet: Records each issue (Issue, Category, Solution). 🔹 Google Docs Provides company information when a user asks about your organization. Example Use Case User Message: > “Hi, I’m having a problem with my Faculty login.” Rapiwa’s AI Response: > “I’m sorry you’re having trouble logging in to Faculty. Please try resetting your password here: https://faculty.spagreen.net/docs/reset-password > If the issue continues, I can log this for support. Would you like me to do that?” Useful Links install process: how to install rapiwa Dashboard: https://app.rapiwa.com Official Website: https://rapiwa.com Documentation: https://docs.rapiwa.com Support & Help WhatsApp: Chat on WhatsApp Discord: SpaGreen Community Facebook Group: SpaGreen Support Website: https://spagreen.net Developer Portfolio: Codecanyon SpaGreen

RapiwaBy Rapiwa
279