HumationHuman + Automation
Back to Catalog

Transform RSS feeds into blog articles with GPT-4, human review & Google Docs

Daiki TakayamaDaiki Takayama
293 views
2/3/2026
CMS AutomationScheduled TaskWebflowData SyncAPI Integration
Official Page

[Workflow Overview] CleanShot 20251030 at 17.35.492x.png ⚠️ Self-Hosted Only: This workflow uses the gotoHuman community node and requires a self-hosted n8n instance.

Who's It For

Content teams, bloggers, news websites, and marketing agencies who want to automate content creation from RSS feeds while maintaining editorial quality control. Perfect for anyone who needs to transform news articles into detailed blog posts at scale.

What It Does

This workflow automatically converts RSS feed articles into comprehensive, SEO-optimized blog posts using AI. It fetches articles from your RSS source, generates detailed content with GPT-4, sends drafts for human review via gotoHuman, and publishes approved articles to Google Docs with automatic Slack notifications to your team.

How It Works

  1. Schedule Trigger runs every 6 hours to check for new RSS articles
  2. RSS Read node fetches the latest articles from your feed
  3. Format RSS Data extracts key information (title, keywords, description)
  4. Generate Article with AI creates a structured blog post using OpenAI GPT-4
  5. Structure Article Data formats the content with metadata
  6. Request Human Review sends the article for approval via gotoHuman
  7. Check Approval Status routes the workflow based on review decision
  8. Create Google Doc and Add Article Content publish approved articles
  9. Send Slack Notification alerts your team with article details

Requirements

  • OpenAI API key with GPT-4 access
  • Google account for Google Docs integration
  • gotoHuman account for human-in-the-loop approval workflow
  • Slack workspace for team notifications
  • RSS feed URL from your preferred source

How to Set Up

  1. Configure RSS Feed: In the "RSS Read" node, replace the example URL with your RSS feed source
  2. Connect OpenAI: Add your OpenAI API credentials to the "OpenAI Chat Model" node
  3. Set Up Google Docs: Connect your Google account and optionally specify a folder ID for organized storage
  4. Configure gotoHuman: Add your gotoHuman credentials and create a review template for article approval
  5. Connect Slack: Authenticate with Slack and select the channel for notifications
  6. Customize Content: Modify the AI prompt in "Generate Article with AI" to match your brand voice and article structure
  7. Adjust Schedule: Change the trigger frequency in "Schedule Trigger" based on your content needs

How to Customize

  • Article Style: Edit the AI prompt to change tone, length, or structure
  • Keywords & SEO: Modify the "Format RSS Data" node to adjust keyword extraction logic
  • Publishing Destination: Change from Google Docs to other platforms (WordPress, Notion, etc.)
  • Approval Workflow: Customize the gotoHuman template to include specific review criteria
  • Notification Format: Adjust the Slack message template to include additional metadata
  • Processing Volume: Modify the Code node to process multiple RSS articles instead of just one

Transform RSS Feeds into Blog Articles with GPT-4 Human Review and Google Docs

This n8n workflow automates the process of converting RSS feed items into blog article drafts, leveraging AI for content generation and incorporating a human review step via Slack before publishing to Google Docs.

What it does

This workflow performs the following key steps:

  1. Fetches RSS Feed Items: Regularly checks a specified RSS feed for new articles.
  2. Generates Blog Article Drafts with AI: For each new RSS item, an AI agent (powered by OpenAI's GPT-4) generates a blog article draft.
  3. Routes for Human Review: If an article draft is successfully generated, it sends a notification to a Slack channel for human review.
  4. Publishes to Google Docs: Upon human approval (or if the "If" node's condition is met for direct publishing), the generated article is saved as a new document in Google Docs.
  5. Handles Failures: If the AI agent fails to generate an article, it sends a notification to a Slack channel.

Prerequisites/Requirements

To use this workflow, you will need:

  • n8n Instance: A running n8n instance.
  • RSS Feed URL: The URL of the RSS feed you wish to monitor.
  • OpenAI API Key: For the "OpenAI Chat Model" node to power the AI Agent.
  • Slack Account & API Token: For sending notifications for human review and failure alerts.
  • Google Docs Account & Credentials: For creating new blog article documents.

Setup/Usage

  1. Import the Workflow:
    • Download the provided JSON file.
    • In your n8n instance, click "Workflows" in the left sidebar.
    • Click "New" and then "Import from JSON".
    • Paste the workflow JSON content or upload the file.
  2. Configure Credentials:
    • OpenAI Chat Model: Configure your OpenAI API Key credential.
    • Slack: Configure your Slack API Token credential.
    • Google Docs: Configure your Google Docs OAuth2 or service account credential.
  3. Configure Nodes:
    • RSS Read (Node 37): Enter the URL of the RSS feed you want to monitor.
    • AI Agent (Node 1119): Review the prompt and settings for the AI agent to ensure it generates articles according to your requirements. This node uses the "OpenAI Chat Model" (Node 1153) as its language model.
    • If (Node 20): Configure the condition for routing items. The current setup implies a condition for either direct publishing or human review. Adjust this as needed for your approval process.
    • Slack (Node 40):
      • Configure the Slack channel where human review requests will be sent (on the "True" branch of the If node).
      • Configure the Slack channel for failure notifications (on the "No Operation, do nothing" node connected to the "AI Agent" failure output).
    • Google Docs (Node 495): Specify the folder or other parameters for creating new documents.
    • Schedule Trigger (Node 839): Set the desired interval for the workflow to check the RSS feed (e.g., every hour, daily).
  4. Activate the Workflow: Once all configurations are complete, activate the workflow by toggling the "Active" switch in the top right corner of the workflow editor.

The workflow will now automatically fetch new RSS items, generate article drafts using AI, prompt for human review in Slack, and publish approved articles to Google Docs.

Related Templates

AI-powered code review with linting, red-marked corrections in Google Sheets & Slack

Advanced Code Review Automation (AI + Lint + Slack) Who’s it for For software engineers, QA teams, and tech leads who want to automate intelligent code reviews with both AI-driven suggestions and rule-based linting — all managed in Google Sheets with instant Slack summaries. How it works This workflow performs a two-layer review system: Lint Check: Runs a lightweight static analysis to find common issues (e.g., use of var, console.log, unbalanced braces). AI Review: Sends valid code to Gemini AI, which provides human-like review feedback with severity classification (Critical, Major, Minor) and visual highlights (red/orange tags). Formatter: Combines lint and AI results, calculating an overall score (0–10). Aggregator: Summarizes results for quick comparison. Google Sheets Writer: Appends results to your review log. Slack Notification: Posts a concise summary (e.g., number of issues and average score) to your team’s channel. How to set up Connect Google Sheets and Slack credentials in n8n. Replace placeholders (<YOURSPREADSHEETID>, <YOURSHEETGIDORNAME>, <YOURSLACKCHANNEL_ID>). Adjust the AI review prompt or lint rules as needed. Activate the workflow — reviews will start automatically whenever new code is added to the sheet. Requirements Google Sheets and Slack integrations enabled A configured AI node (Gemini, OpenAI, or compatible) Proper permissions to write to your target Google Sheet How to customize Add more linting rules (naming conventions, spacing, forbidden APIs) Extend the AI prompt for project-specific guidelines Customize the Slack message formatting Export analytics to a dashboard (e.g., Notion or Data Studio) Why it’s valuable This workflow brings realistic, team-oriented AI-assisted code review to n8n — combining the speed of automated linting with the nuance of human-style feedback. It saves time, improves code quality, and keeps your team’s review history transparent and centralized.

higashiyama By higashiyama
90

Ai website scraper & company intelligence

AI Website Scraper & Company Intelligence Description This workflow automates the process of transforming any website URL into a structured, intelligent company profile. It's triggered by a form, allowing a user to submit a website and choose between a "basic" or "deep" scrape. The workflow extracts key information (mission, services, contacts, SEO keywords), stores it in a structured Supabase database, and archives a full JSON backup to Google Drive. It also features a secondary AI agent that automatically finds and saves competitors for each company, building a rich, interconnected database of company intelligence. --- Quick Implementation Steps Import the Workflow: Import the provided JSON file into your n8n instance. Install Custom Community Node: You must install the community node from: https://www.npmjs.com/package/n8n-nodes-crawl-and-scrape FIRECRAWL N8N Documentation https://docs.firecrawl.dev/developer-guides/workflow-automation/n8n Install Additional Nodes: n8n-nodes-crawl-and-scrape and n8n-nodes-mcp fire crawl mcp . Set up Credentials: Create credentials in n8n for FIRE CRAWL API,Supabase, Mistral AI, and Google Drive. Configure API Key (CRITICAL): Open the Web Search tool node. Go to Parameters → Headers and replace the hardcoded Tavily AI API key with your own. Configure Supabase Nodes: Assign your Supabase credential to all Supabase nodes. Ensure table names (e.g., companies, competitors) match your schema. Configure Google Drive Nodes: Assign your Google Drive credential to the Google Drive2 and save to Google Drive1 nodes. Select the correct Folder ID. Activate Workflow: Turn on the workflow and open the Webhook URL in the “On form submission” node to access the form. --- What It Does Form Trigger Captures user input: “Website URL” and “Scraping Type” (basic or deep). Scraping Router A Switch node routes the flow: Deep Scraping → AI-based MCP Firecrawler agent. Basic Scraping → Crawlee node. Deep Scraping (Firecrawl AI Agent) Uses Firecrawl and Tavily Web Search. Extracts a detailed JSON profile: mission, services, contacts, SEO keywords, etc. Basic Scraping (Crawlee) Uses Crawl and Scrape node to collect raw text. A Mistral-based AI extractor structures the data into JSON. Data Storage Stores structured data in Supabase tables (companies, company_basicprofiles). Archives a full JSON backup to Google Drive. Automated Competitor Analysis Runs after a deep scrape. Uses Tavily web search to find competitors (e.g., from Crunchbase). Saves competitor data to Supabase, linked by company_id. --- Who's It For Sales & Marketing Teams: Enrich leads with deep company info. Market Researchers: Build structured, searchable company databases. B2B Data Providers: Automate company intelligence collection. Developers: Use as a base for RAG or enrichment pipelines. --- Requirements n8n instance (self-hosted or cloud) Supabase Account: With tables like companies, competitors, social_links, etc. Mistral AI API Key Google Drive Credentials Tavily AI API Key (Optional) Custom Nodes: n8n-nodes-crawl-and-scrape --- How It Works Flow Summary Form Trigger: Captures “Website URL” and “Scraping Type”. Switch Node: deep → MCP Firecrawler (AI Agent). basic → Crawl and Scrape node. Scraping & Extraction: Deep path: Firecrawler → JSON structure. Basic path: Crawlee → Mistral extractor → JSON. Storage: Save JSON to Supabase. Archive in Google Drive. Competitor Analysis (Deep Only): Finds competitors via Tavily. Saves to Supabase competitors table. End: Finishes with a No Operation node. --- How To Set Up Import workflow JSON. Install community nodes (especially n8n-nodes-crawl-and-scrape from npm). Configure credentials (Supabase, Mistral AI, Google Drive). Add your Tavily API key. Connect Supabase and Drive nodes properly. Fix disconnected “basic” path if needed. Activate workflow. Test via the webhook form URL. --- How To Customize Change LLMs: Swap Mistral for OpenAI or Claude. Edit Scraper Prompts: Modify system prompts in AI agent nodes. Change Extraction Schema: Update JSON Schema in extractor nodes. Fix Relational Tables: Add Items node before Supabase inserts for arrays (social links, keywords). Enhance Automation: Add email/slack notifications, or replace form trigger with a Google Sheets trigger. --- Add-ons Automated Trigger: Run on new sheet rows. Notifications: Email or Slack alerts after completion. RAG Integration: Use the Supabase database as a chatbot knowledge source. --- Use Case Examples Sales Lead Enrichment: Instantly get company + competitor data from a URL. Market Research: Collect and compare companies in a niche. B2B Database Creation: Build a proprietary company dataset. --- WORKFLOW IMAGE --- Troubleshooting Guide | Issue | Possible Cause | Solution | |-------|----------------|-----------| | Form Trigger 404 | Workflow not active | Activate the workflow | | Web Search Tool fails | Missing Tavily API key | Replace the placeholder key | | FIRECRAWLER / find competitor fails | Missing MCP node | Install n8n-nodes-mcp | | Basic scrape does nothing | Switch node path disconnected | Reconnect “basic” output | | Supabase node error | Wrong table/column names | Match schema exactly | --- Need Help or More Workflows? Want to customize this workflow for your business or integrate it with your existing tools? Our team at Digital Biz Tech can tailor it precisely to your use case from automation logic to AI-powered enhancements. Contact: shilpa.raju@digitalbiz.tech For more such offerings, visit us: https://www.digitalbiz.tech ---

DIGITAL BIZ TECHBy DIGITAL BIZ TECH
923

Daily cash flow reports with Google Sheets, Slack & Email for finance teams

Simplify financial oversight with this automated n8n workflow. Triggered daily, it fetches cash flow and expense data from a Google Sheet, analyzes inflows and outflows, validates records, and generates a comprehensive daily report. The workflow sends multi-channel notifications via email and Slack, ensuring finance professionals stay updated with real-time financial insights. 💸📧 Key Features Daily automation keeps cash flow tracking current. Analyzes inflows and outflows for actionable insights. Multi-channel alerts enhance team visibility. Logs maintain a detailed record in Google Sheets. Workflow Process The Every Day node triggers a daily check at a set time. Get Cash Flow Data retrieves financial data from a Google Sheet. Analyze Inflows & Outflows processes the data to identify trends and totals. Validate Records ensures all entries are complete and accurate. If records are valid, it branches to: Sends Email Daily Report to finance team members. Send Slack Alert to notify the team instantly. Logs to Sheet appends the summary data to a Google Sheet for tracking. Setup Instructions Import the workflow into n8n and configure Google Sheets OAuth2 for data access. Set the daily trigger time (e.g., 9:00 AM IST) in the "Every Day" node. Test the workflow by adding sample cash flow data and verifying reports. Adjust analysis parameters as needed for specific financial metrics. Prerequisites Google Sheets OAuth2 credentials Gmail API Key for email reports Slack Bot Token (with chat:write permissions) Structured financial data in a Google Sheet Google Sheet Structure: Create a sheet with columns: Date Cash Inflow Cash Outflow Category Notes Updated At Modification Options Customize the "Analyze Inflows & Outflows" node to include custom financial ratios. Adjust the "Validate Records" filter to flag anomalies or missing data. Modify email and Slack templates with branded formatting. Integrate with accounting tools (e.g., Xero) for live data feeds. Set different trigger times to align with your financial review schedule. Discover more workflows – Get in touch with us

Oneclick AI SquadBy Oneclick AI Squad
619