Workflow Templates

Geopolitics Breaking News Alert System Workflow Name: Geopolitics Breaking News Alert System Author: Devjothi Dutta Category: Productivity, News & Media, AI/Machine Learning Complexity: Medium Setup Time: 45-60 minutes 📖 Description An intelligent geopolitical monitoring system that filters 200+ daily news articles down to only the critical breaking news that matters to you. This workflow uses smart keyword filtering and AI-powered scoring to eliminate noise, reduce AI costs, and deliver only high-priority geopolitical alerts to Telegram. The Problem: Traditional news monitoring is overwhelming - hundreds of articles per hour, 95% irrelevant to your region of interest, no urgency prioritization, and critical breaking news gets buried in noise. The Solution: This workflow combines dual-layer filtering (primary + secondary keywords) with AI scoring to distinguish actual breaking news from general news coverage. By filtering first and scoring second, you reduce AI API costs by 80-90% while ensuring you never miss critical geopolitical developments. Switch between monitoring India, China, Middle East, Russia-Ukraine, or any region by simply changing a configuration file. Perfect for government analysts, corporate security teams, investment research firms, news organizations, or anyone who needs to stay informed about geopolitical developments without information overload. 👥 Who's it for For Government & Defense Analysts: Monitor specific regions for military actions, diplomatic developments, and security threats Filter by mission-critical keywords to eliminate irrelevant news AI scoring identifies genuine breaking news vs routine coverage Reduce analyst workload by 90% through intelligent automation For Corporate Security & Risk Teams: Track geopolitical risks affecting global supply chains and operations Custom keyword filters for industry-specific concerns (e.g., "semiconductor", "tariff", "sanctions") Real-time alerts for events impacting business continuity Cost-efficient monitoring with minimal AI API usage For Investment Research Firms: Monitor emerging market geopolitical risks affecting portfolio companies AI scoring differentiates market-moving events from background noise Configurable alert thresholds based on investment strategy (conservative vs aggressive) Track multiple regions simultaneously with different configs For News Organizations & Journalists: Monitor breaking geopolitical developments for editorial coverage Filter by urgency to prioritize assignment desk resources Aggregate multiple international news sources in one place Extend alerts to newsroom Slack channels or email ✨ Key Features 🎯 Smart Dual-Layer Filtering - Primary keywords ensure regional relevance, secondary keywords filter by event type (military, diplomatic, economic) 🤖 AI-Powered Urgency Scoring - GPT-4o-mini scores articles 1-10 based on geopolitical urgency, distinguishing breaking news from routine coverage 💰 Cost-Efficient Design - Filter first, score second approach reduces AI API calls by 80-90% (only ~5 articles analyzed out of 200) 🌍 Multi-Region Support - Monitor India, China, Middle East, Russia-Ukraine, or any region by switching config files 📰 Multi-Source RSS Aggregation - Combines 6 international news sources (NYT, BBC, Al Jazeera, SCMP, regional feeds) 🔄 Duplicate Detection - Persistent storage prevents re-analyzing same articles across multiple executions 📊 Consolidated Alerts - Single Telegram message with all breaking news, grouped by urgency score ⏰ Flexible Scheduling - Configure trigger interval per your needs (15min for active conflicts, 3hr for routine monitoring) 💾 Config-Driven Architecture - All filters, keywords, and scoring rules in Google Drive JSON file 🔒 Production Ready - Tested end-to-end with real-world India and China configurations 📈 Scalable Design - Run multiple regional configs in parallel, extend to Slack/WhatsApp/Email delivery 🛠️ Requirements Required Services: n8n (version 1.0+) - Workflow automation platform Free tier: n8n cloud or self-hosted Docker Required feature: Data Tables (for duplicate tracking) OpenAI API (GPT-4o-mini) - AI scoring engine Cost: ~$0.10/day for 30min intervals Free tier: $5 credit for new accounts Telegram Bot - Alert delivery Free: Create via @BotFather on Telegram Get chat ID via @userinfobot Google Drive - Config file storage Free: Any Google account Used for publicly shared JSON config files Required Credentials: OpenAI API Key** - Get from platform.openai.com (GPT-4o-mini access) Telegram Bot Token** - Create bot via @BotFather, get token n8n Data Table** - Built-in n8n feature (no external credential) Optional: Slack Webhook URL (for extending alerts to Slack) SMTP credentials (for email alerts) Twilio account (for WhatsApp/SMS alerts) 📦 What's Included This workflow package includes: Complete n8n workflow JSON (ready to import) Complete setup guide - Detailed configuration with Data Table setup, troubleshooting Technical architecture documentation Use cases and customization guide 4 pre-built regional configs (India, China, Middle East, Russia-Ukraine) 🚀 Quick Start Full setup takes 45-60 minutes. For detailed step-by-step instructions, see SETUP_GUIDE.md Overview Create n8n Data Table (analyzed_articles with 2 columns) Upload config to Google Drive (choose region, share publicly, get file ID) Import workflow (22 nodes ready to configure) Configure nodes: Update Google Drive config URL with your file ID Update 6 RSS Feed URLs for your region Link 3 Data Table nodes to analyzed_articles table Add credentials (OpenAI API, Telegram Bot) Set schedule (15min-daily based on monitoring needs) Test workflow (verify filtering, scoring, alerts work) Activate (workflow runs automatically on schedule) Quick Start Result: ✅ 200+ articles processed → 5-7 filtered → 3-5 scored → 1-3 alerts sent ✅ Telegram receives consolidated breaking news message ✅ Workflow runs every 30min (or your chosen interval) ✅ Total monthly cost: $3-5 (OpenAI API only) Need help? See detailed SETUP_GUIDE.md for complete instructions with screenshots and troubleshooting. 📊 Workflow Stats Nodes:** 22 Complexity:** Medium Execution Time:** ~30-60 seconds per run Monthly Cost:** $3-5 (OpenAI API usage only) Maintenance:** Minimal (update RSS feeds if sources change) Scalability:** Handles 200+ articles per execution, easily scales to 10+ RSS feeds 🎨 Customization Options Add more regions:** Create new config JSON files for North Korea, Taiwan, Africa, Latin America, etc. Multi-channel alerts:** Extend to Slack, WhatsApp, Email, Discord, Microsoft Teams, SMS Severity-based routing:** Send critical alerts (score 9-10) via SMS, others to Telegram Custom scoring models:** Switch between GPT-4o-mini, GPT-4o, Claude based on config Exclude keywords:** Add "exclude_keywords" array to filter out sports, entertainment, weather Alert digest mode:** Aggregate alerts into daily/weekly summary emails instead of real-time Dashboard integration:** Connect to Grafana or Metabase for visual trend analysis Webhook triggers:** Use workflow output to trigger other n8n workflows or external systems Custom RSS feeds:** Add industry-specific or regional news sources Adjust alert threshold:** Change from score >= 6 to higher/lower based on notification preferences 🔧 How it Works Schedule Trigger (Configurable): Workflow runs at your configured interval (15min, 30min, 1hr, 3hr, daily, etc.) Trigger frequency depends on use case: active conflicts need more frequent monitoring Config Loading: HTTP Request node fetches JSON config from Google Drive Config contains: keywords, scoring rules, AI role, alert threshold, Telegram chat ID RSS Aggregation: 6 RSS Feed nodes fetch articles from international news sources Merge node combines all feeds (~200 articles per execution) RSS Cleanup node strips HTML and normalizes to 5 fields (60-75% size reduction) Smart Filtering (Cost Optimization Layer 1): Dynamic Filter checks PRIMARY keywords (geographic/entity: "india", "modi", "delhi") Also checks SECONDARY keywords (event type: "military", "conflict", "trade deal") Both conditions required: Article must mention at least one primary AND one secondary Result: 200 articles reduced to ~5-7 relevant articles (95% reduction) Why this matters: Eliminates noise BEFORE expensive AI scoring Duplicate Detection (Cost Optimization Layer 2): Queries Data Table for previously analyzed article links Filters out articles already scored in last 7 days Result: 5-7 filtered articles reduced to 3-5 new articles Why this matters: Prevents redundant AI API calls (saves 80% on repeat articles) Dynamic AI Prompt Generation: Code node builds system prompt from config.ai_role and config.scoring_criteria Instructs AI: "You are a geopolitical analyst for [REGION]. Score articles 1-10..." Includes scoring rubric: 9-10 = Military Action, 7-8 = Trade/Economic, etc. AI Urgency Scoring (Breaking News Detection): Breaking News Analyzer (GPT-4o-mini) evaluates geopolitical urgency Scores 1-10: Distinguishes genuine breaking news from routine coverage Returns: score, category, reasoning, should_alert (true/false based on threshold) Cost: $0.002 per article (only 3-5 articles scored per execution) Alert Decision: IF node checks: should_alert === true (score >= config.alert_threshold) Only high-priority alerts proceed to Telegram Articles below threshold are logged but not sent Alert Aggregation: Consolidates multiple breaking news alerts into single Telegram message Groups by urgency score with color-coded emojis (🔴 9-10, 🟠 7-8, 🟡 6-7) Includes: score, category, title, link for each alert Telegram Delivery: Sends consolidated alert to configured Telegram chat Uses HTML formatting for bold text and clickable links Chat ID dynamically loaded from config (different regions → different chats) 💡 Pro Tips Start with Higher Threshold:** Begin with alert_threshold = 7 to avoid alert fatigue, lower to 6 after tuning keywords Regional RSS Matters:** Use region-specific news sources for better coverage (e.g., Times of India for India, not just BBC/NYT) Test Keywords First:** Run workflow manually with "Test Workflow" to verify keyword filtering before activating schedule Monitor AI Costs:** Check OpenAI usage dashboard after first week to confirm ~$0.10/day cost estimate Tune Secondary Keywords:** Add domain-specific terms to secondary keywords (e.g., "semiconductor" for tech supply chain monitoring) Use Separate Configs for Critical Regions:** Clone workflow for high-priority regions instead of switching configs manually Schedule Based on Time Zones:** Align execution intervals with business hours in monitored region (e.g., 9AM-6PM IST for India) Clear Duplicates for Testing:** Manually clear analyzed_articles Data Table when testing new configs for fresh results Backup Working Configs:** Export and version control config files before making major keyword changes Consider Alert Fatigue:** Score 9-10 events are rare (0-1 per day), score 6-8 events are common (2-5 per day) - set threshold accordingly 🔗 Related Workflows Multi-Region Geopolitics Dashboard** - Combine multiple regional configs into single monitoring dashboard Geopolitical Risk Scoring for Portfolios** - Integrate with stock portfolio data to assess investment risk Automated Geopolitical Intelligence Reports** - Generate daily/weekly PDF reports from breaking news data Conflict Escalation Tracker** - Track score trends over time to detect escalating tensions Supply Chain Risk Alerting** - Focus on trade/sanctions news affecting global supply chains 📧 Support & Feedback For questions, issues, or feature requests: GitHub:** n8n-geopolitics-breaking-news-alert Repository n8n Community Forum:** Tag @devdutta Email:** devjothi@gmail.com 📄 License MIT License - Free to use, modify, and distribute ⭐ If you find this workflow useful, please share your feedback and star the workflow!

How it works This workflow automatically detects new image files uploaded to a Google Drive folder, extracts Japanese text using OCR, summarizes it with AI, and records the result in Google Sheets. Finally, it sends a completion email notification with the file name and summary. Workflow steps: Google Drive New File Trigger – Watches a specific Google Drive folder for new image uploads. Download Image File – Downloads the newly uploaded image for processing. Extract Text with OCR.space – Sends the image to the OCR.space API to extract text (Japanese supported). Format OCR Result & Check for Empty – Cleans and validates the extracted text. Generate Summary with OpenRouter AI – Uses an AI model to generate a short summary of the text. OpenRouter Chat Model – Connects the AI Agent to the OpenRouter language model. Append row in sheet – Adds the file name, AI summary, and processing date to Google Sheets. Send Completion Notification via Gmail – Sends an email with the summarized content and Google Sheets link. Process Completed – Marks the workflow’s successful end. Setup steps Connect your Google Drive, Google Sheets, and Gmail accounts through credentials. Set your OCR.space API key in the HTTP Request node. Add your OpenRouter API key credential for the AI node. Replace the Google Sheet ID and folder ID with your own. Customize the Gmail recipient and email message as needed. Adjust the polling frequency (e.g., every 1 minute) depending on your workflow needs. Ideal for Digitizing and summarizing handwritten or printed book pages. Automatically extracting and archiving text from scanned reports or notes. Businesses or educators automating document reading and summarization tasks. ⚙️ Note: Each node includes a clear English Sticky Note above it for easier understanding and documentation.

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Overview Automate your email management with this n8n workflow that fetches, summarizes, and shares critical emails from your Gmail inbox. Designed for busy professionals, this workflow runs daily to extract important emails from the past 24 hours, summarizes key details (like credentials, OTPs, deadlines, and action items), converts the summary into a PDF, and sends it to your Discord channel for quick access. Key Features Scheduled Automation**: Triggers daily at 8 PM to process emails from the last 24 hours. Gmail Integration**: Retrieves emails labeled "INBOX" and "IMPORTANT" using secure OAuth2 authentication (no hardcoded API keys). Smart Email Parsing**: Extracts essential fields (subject, sender, and plain text) while cleaning up URLs, extra lines, and formatting for clarity. AI-Powered Summarization**: Uses OpenAI's GPT-4.1-mini to create concise plain text and markdown summaries, highlighting urgent actions with "[Action Required]". PDF Conversion**: Converts the markdown summary into a professional PDF using PDF.co API. Discord Notifications**: Shares the PDF via a Discord webhook for seamless team communication. Why Use This Workflow? Save time by automating email triage and focusing on what matters. Stay organized with clear, actionable summaries delivered to Discord. Securely handle sensitive data with proper credential management. Perfect for teams, freelancers, or anyone managing high email volumes. Setup Instructions Configure Gmail OAuth2 credentials for secure access. Set up PDF.co API and Discord webhook credentials. Customize the schedule or filters as needed. Activate and let the workflow handle your daily email summaries!

Customer Feedback Loop Analyzer (n8n Automated Workflow) This workflow automates the process of collecting customer feedback from forms and emails, analyzes it using AI, classifies it by category and sentiment, logs it into Google Sheets, and routes it to the right communication channels like Slack or email. It closes the feedback loop efficiently by ensuring every review is categorized, tracked, and acted upon. Who’s it for Product managers wanting structured customer insights Customer support teams needing fast issue routing Engineering teams who want to be alerted to bugs quickly Growth & UX teams tracking feature requests and usability feedback Any business managing customer feedback at scale How it works Form submission trigger captures reviews submitted via customer review forms. Gmail trigger listens for new feedback emails. Extract details (Code node) parses sender details and extracts the actual review text. AI node (LLM) summarizes the feedback, determines sentiment, and classifies it (Bug, Feature Request, UX Issue, Other). Google Gemini (optional) provides advanced classification/summarization. Google Sheets node logs all structured feedback for historical tracking. Switch node routes feedback into separate flows by category. Slack node instantly notifies the team of critical feedback (e.g., Bugs). Email node sends reports to relevant stakeholders (e.g., Feature Requests to product managers). How to set up Import the workflow JSON into your n8n instance. Connect credentials for: Gmail (for receiving/sending feedback) Google Sheets (for logging reviews) Slack (for real-time team alerts) Configure your Google Sheet (columns for Date, Reviewer, Sentiment, Category, Feedback). Adjust the AI node prompt to reflect your team’s preferred categories. Set Slack channels and email recipients for notifications. Activate workflow. Requirements n8n (cloud or self-hosted) Gmail API access (OAuth2 connected in n8n) Google Sheets API access Slack webhook or OAuth connection (Optional) Google Gemini or another LLM integration How to customize Modify the AI prompt to classify into different categories (e.g., “Support Issue”, “Billing Problem”). Extend the Google Sheet schema to include product version, tags, or priority scores. Add a translation step if feedback is multilingual. Replace Slack notifications with Teams/Discord if needed. Connect to Jira or Trello to auto-create tasks for certain categories. Add-ons Sentiment-based alerts**: Trigger Slack notifications only if sentiment is negative. Monthly report generator**: Compile all feedback into a PDF and email it automatically. CRM integration**: Sync categorized feedback into HubSpot or Salesforce. Auto-response emails**: Acknowledge receipt of customer feedback via Gmail. Use Case Examples SaaS product team routes all Bug feedback directly to engineering Slack channel. UX team receives only “UX Issue” categorized feedback for design improvements. Marketing team logs Feature Requests into Google Sheets for roadmap prioritization. Customer support automatically responds with a thank-you email for all submissions. Common Troubleshooting | Issue | Possible Cause | Solution | | ------------------------ | ----------------------------------------- | ----------------------------------------------------- | | Workflow doesn’t trigger | Gmail/Form node not authenticated | Reconnect Gmail / check webhook form integration | | No data extracted | Code node parsing wrong field | Update regex/parsing logic to match email format | | AI classification fails | Invalid LLM credentials or quota exceeded | Reconnect LLM node / check usage limits | | Feedback not logged | Wrong Google Sheet ID or missing sharing | Verify Sheet ID and grant access to connected account | | Slack messages not sent | Invalid webhook or channel not found | Reconfigure Slack node with valid channel/webhook | | Email reports fail | Gmail OAuth token expired | Refresh Gmail credentials in n8n | Need Help? Our n8n automation experts at WeblineIndia can help you: Fine-tune the AI prompts for better categorization accuracy Build custom dashboards from your Google Sheet data Add multilingual feedback handling Connect to your ticketing system (Jira, Trello, Asana) for seamless issue tracking

AI-Powered HR Candidate Evaluation Agent with LinkedIn Data Enrichment in CSV/XLSX Format 🎯 Overview Transform your manual hiring process into an intelligent evaluation system that saves 15-20 minutes per candidate! This workflow automates the entire candidate assessment pipeline - from CSV/XLSX upload to AI-powered scoring with LinkedIn insights. When you upload a candidate list, this workflow automatically: 📊 Converts your file into a formatted Google Sheet with RTL support 🔍 Researches each candidate's recent LinkedIn posts via Apify 🤖 Evaluates candidates using GPT-4.1 with context-aware scoring (0-100) 💬 Generates professional Hebrew explanations for each score 📈 Auto-sorts by score and applies professional formatting ⚠️ Sends error alerts to keep everything running smoothly Cost per candidate: ~$0.05 | Time saved: 15-20 minutes each 👥 Who's it for? HR teams drowning in candidate applications Recruitment agencies needing consistent evaluation criteria Hiring managers seeking data-driven candidate insights Companies looking to scale their team Anyone tired of manual spreadsheet juggling ⚡ How it works Form submission triggers with CSV/XLSX upload Google Drive stores the file and creates a new Sheet Data extraction processes the file content AI Agent loops through each candidate: Fetches up to 3 recent LinkedIn posts via Apify Analyzes qualifications against job requirements Generates evaluation score and Hebrew explanation Sheet formatting applies filters, sorting, and styling Error handling notifies admin of any issues 🛠️ Setup Instructions Time to deploy: 15 minutes Requirements: Google account (Drive + Sheets access) OpenAI API key (GPT-4.1 access) Apify API key (for LinkedIn scraping) Gmail account (for error notifications) Step-by-step: Import this template into your n8n instance Configure Google credentials: Connect Google Drive OAuth2 Connect Google Sheets OAuth2 Add OpenAI API key to the GPT-4.1 node Set up Apify credentials for LinkedIn scraping Configure Gmail for error alerts (update email in "Send a message" node) Update folder IDs in Google Drive nodes to your folders Test with a sample CSV containing 2-3 candidates Activate and share the form URL with your team! 📋 Input File Format Your CSV/XLSX should include these columns (Hebrew): שם פרטי (First name) שם משפחה (Last name) חשבון לינקדאין (LinkedIn URL) Your custom evaluation questions 🎨 Customization Options Easy tweaks: Scoring criteria**: Modify the AI agent's system message Language**: Switch from Hebrew to any language Scoring rubric**: Adjust the 50/25/15/10 weighting LinkedIn posts**: Change from 3 posts to more/fewer Sheet styling**: Customize colors and formatting Advanced modifications: Add integration with your ATS (Greenhouse, Lever, etc.) Connect to Slack for real-time notifications Add multiple evaluation agents for different roles Implement multi-language support Add candidate email automation 💡 Pro Tips Better LinkedIn data**: Ensure candidates provide complete LinkedIn URLs (not just usernames) Consistent scoring**: Run batches of similar roles together for normalized scoring Cost optimization**: Adjust Apify settings to fetch only essential data Scale smartly**: Process in batches of min 10-20 for optimal performance ⚠️ Important Notes LinkedIn scraping respects Apify's rate limits Scores are relative within each batch - don't compare across different job roles The workflow handles both CSV and XLSX formats automatically Error notifications help you catch issues before they cascade 📊 Expected Results After implementation, expect: Data-driven evaluation across candidates Professional explanation for hiring decisions Happy recruiters who can focus on human connection Built with ❤️ by Elay Guez

n8n Forum Job Aggregator - AI-Powered Email Digest Overview Automate your n8n community job board monitoring with this intelligent workflow that scrapes, analyzes, and delivers opportunities straight to your inbox. Perfect for freelancers, agencies, and developers looking to stay on top of n8n automation projects without manual checking. How It Works Scrapes the n8n community job board to find new postings from the last 7 days Extracts key metadata including job titles, descriptions, posting dates, and client details Analyzes each listing using OpenRouter AI to generate concise summaries of project requirements and client needs Delivers a professionally formatted email digest with all opportunities organized and ready for review Prerequisites OpenRouter API Key**: Sign up at OpenRouter.ai to access AI summarization capabilities SMTP Email Account**: Gmail, Outlook, or any SMTP-compatible email service Setup Steps Time estimate: 5-10 minutes Configure OpenRouter Credentials Add your OpenRouter API key in n8n credentials manager Recommended model: GPT-3.5-turbo or Claude for cost-effective summaries Set Up SMTP Email Configure sender email address Add recipient email(s) for digest delivery Test connection to ensure delivery Customize Date Range (Optional) Default: Last 7 days of job postings Adjust the date filter node to match your preferred frequency Test & Refine Run a test execution Review email formatting and AI summary quality Customize HTML template styling to match your preferences Customization Options Scheduling**: Set up cron triggers (daily, weekly, or custom intervals) Filtering**: Add keyword filters for specific technologies or project types AI Prompts**: Modify the summarization prompt to extract different insights Email Design**: Customize HTML/CSS styling in the email template node Example Use Cases Freelance Developers**: Never miss relevant n8n automation opportunities Agencies**: Monitor market demand and competitor activity Job Seekers**: Track n8n-related positions and consulting gigs Market Research**: Analyze trends in automation project requests Example Output Each email digest includes: Job title and posting date AI-generated summary (e.g., "Client needs workflow automation for Shopify order processing with Slack notifications") Direct link to original posting Organized by recency

Description Automate your weekly cross-platform social media analytics workflow with AI-powered insights. 📊🤖 This system retrieves real-time Twitter (X) and Facebook data, validates and merges the metrics, formats them via custom JavaScript, generates a visual HTML summary with GPT-4o, stores structured analytics in Notion, and broadcasts key results through Gmail and Slack — all in one seamless flow. Perfect for marketing, social media, and growth teams tracking weekly engagement trends. 🚀💬 What This Template Does 1️⃣ Starts on manual execution to fetch the latest performance data. 🕹️ 2️⃣ Collects live metrics from both Twitter (X API) and Facebook Graph API. 🐦📘 3️⃣ Merges API responses into one unified dataset for analysis. 🧩 4️⃣ Validates data completeness before processing; logs missing or invalid data to Google Sheets. 🔍 5️⃣ Uses JavaScript to normalize data into clean JSON structures for AI analysis. 💻 6️⃣ Leverages Azure OpenAI GPT-4o to generate a professional HTML analytics report. 🧠📈 7️⃣ Updates Notion’s “Growth Chart” database with historical metrics for record-keeping. 🗂️ 8️⃣ Sends the HTML report via Gmail to the marketing or analytics team. 📧 9️⃣ Posts a summarized Slack message highlighting key insights and platform comparisons. 💬 Key Benefits ✅ Eliminates manual social media reporting with full automation. ✅ Ensures clean, validated data before report generation. ✅ Delivers visually engaging HTML performance summaries. ✅ Centralizes analytics storage in Notion for trend tracking. ✅ Keeps teams aligned with instant Slack and Gmail updates. Features Dual-platform analytics integration (Twitter X + Facebook Graph). Custom JavaScript node for data normalization and mapping. GPT-4o model integration for HTML report generation. Real-time error logging to Google Sheets for transparency. Notion database update for structured performance tracking. Slack notifications with emoji-rich summaries and insights. Gmail automation for formatted weekly performance emails. Fully modular — easy to scale to other social platforms. Requirements Twitter OAuth2 API credentials for fetching X metrics. Facebook Graph API credentials for retrieving page data. Azure OpenAI credentials for GPT-4o AI report generation. Notion API credentials with write access to “Growth Chart.” Slack Bot Token with chat:write permission for updates. Google Sheets OAuth2 credentials for error logs. Gmail OAuth2 credentials to send HTML reports. Environment Variables TWITTER_API_KEY FACEBOOK_GRAPH_TOKEN AZURE_OPENAI_KEY NOTION_GROWTH_DB_ID SLACK_ALERT_CHANNEL_ID GOOGLE_SHEET_ERROR_LOG_ID GMAIL_MARKETING_RECIPIENTS Target Audience 📈 Marketing and growth teams analyzing engagement trends. 💡 Social media managers tracking cross-channel performance. 🧠 Data and insights teams needing AI-based summaries. 💬 Brand strategists and content teams monitoring audience health. 🧾 Agencies and operations teams automating weekly reporting. Step-by-Step Setup Instructions 1️⃣ Connect all required API credentials (Twitter, Facebook, Azure OpenAI, Notion, Gmail, Slack, Sheets). 2️⃣ Replace the username and page IDs in the HTTP Request nodes for your brand handles. 3️⃣ Verify the JavaScript node output structure for correct field mapping. 4️⃣ Configure the Azure GPT-4o prompt with your preferred tone and formatting. 5️⃣ Link your Notion database and confirm property names match (followers, likes, username). 6️⃣ Add recipient email(s) in the Gmail node. 7️⃣ Specify your Slack channel ID for automated alerts. 8️⃣ Test run the workflow manually to validate end-to-end execution. 9️⃣ Activate or schedule the workflow for regular weekly reporting. ✅

Overview This comprehensive workflow transforms Excel spreadsheets into professional, AI-generated reports with automated analysis and insights. Whether you're dealing with financial data, customer tracking, sales metrics, inventory management, or any structured data in Excel format, this template leverages artificial intelligence to create detailed, actionable reports with visualizations and key findings. How It Works Automated Report Generation Pipeline: File Processing Trigger**: Workflow initiates when Excel files are uploaded through a web form or file system Data Extraction & Validation**: Automatically reads Excel sheets, validates data structure, and identifies key metrics AI-Powered Analysis**: Uses advanced language models to analyze data patterns, trends, and anomalies Report Generation**: Creates comprehensive reports with executive summaries, detailed analysis, and actionable recommendations Multi-Format Output**: Generates reports in various formats (PDF, HTML, Word) with embedded charts and visualizations Automated Distribution**: Sends completed reports via email or saves to designated cloud storage locations Setup Instructions Estimated Setup Time: 10-15 minutes Prerequisites n8n instance (v0.200.0 or higher) OpenAI/Claude API key for AI analysis Email service credentials (for report distribution) Cloud storage access (Google Drive, Dropbox, etc.) - optional Configuration Steps Configure File Input Trigger Set up webhook or file system trigger for Excel file uploads Configure accepted file formats (.xlsx, .xls, .csv) Add file size and validation checks Setup Data Processing Nodes Configure Excel file reader with sheet selection options Set up data validation and cleaning processes Define column mapping and data type recognition Configure AI Analysis Engine Add your AI service API credentials (OpenAI, Anthropic, etc.) Customize analysis prompts based on your data types Set up context-aware report generation parameters Setup Report Generation Configure report templates for different data types Set up chart generation and data visualization options Define output formats and styling preferences Configure Distribution Channels Set up email service for automated report delivery Configure cloud storage integration for report archiving Add notification systems for completion alerts Use Cases Financial Reporting Budget Analysis**: Analyze spending patterns and budget variance reports P&L Statements**: Generate profit and loss summaries with trend analysis Cash Flow Reports**: Create comprehensive cash flow analysis with forecasting Expense Tracking**: Automated expense categorization and spending insights Sales & CRM Analytics Sales Performance**: Generate sales team performance reports with KPIs Customer Analysis**: Create customer segmentation and lifetime value reports Lead Tracking**: Analyze conversion funnels and lead quality metrics Territory Management**: Regional sales analysis and market penetration reports Operations Management Inventory Reports**: Stock level analysis with reorder recommendations Project Tracking**: Progress reports with timeline and resource analysis Quality Metrics**: Performance dashboards with trend identification Resource Planning**: Capacity utilization and allocation reports HR & Administrative Employee Performance**: Generate comprehensive performance review reports Attendance Tracking**: Analyze attendance patterns and productivity metrics Training Records**: Skills gap analysis and training effectiveness reports Compliance Reporting**: Regulatory compliance status and audit reports Key Features Intelligent Data Recognition**: Automatically identifies data types and relationships Contextual Analysis**: AI provides industry-specific insights and recommendations Professional Formatting**: Clean, corporate-ready report layouts Interactive Visualizations**: Embedded charts, graphs, and data visualizations Executive Summaries**: AI-generated executive summaries highlighting key findings Trend Analysis**: Historical data comparison and future projections Anomaly Detection**: Automatically flags unusual patterns or outliers Multi-Language Support**: Generate reports in multiple languages Batch Processing**: Handle multiple files simultaneously Error Handling**: Robust error management with detailed logging Technical Requirements n8n instance with sufficient memory for Excel processing (minimum 2GB RAM recommended) AI service API access (OpenAI GPT-4, Claude, or similar) Email service (Gmail, Outlook, SendGrid, etc.) Optional: Cloud storage service credentials Stable internet connectivity for AI API calls Supported Data Types Financial Data**: Revenue, expenses, budgets, forecasts Sales Data**: Transactions, leads, customer information, pipeline data Operational Data**: Inventory, production metrics, quality scores HR Data**: Employee records, performance metrics, attendance Marketing Data**: Campaign metrics, conversion rates, ROI analysis Custom Data**: Any structured Excel data with clear column headers Output Options PDF Reports**: Professional PDF documents with embedded charts HTML Dashboards**: Interactive web-based reports Word Documents**: Editable Word reports with tables and charts Excel Summaries**: Enhanced Excel files with analysis sheets PowerPoint Presentations**: Executive presentation slides Advanced Features Custom Branding**: Add your company logo and branding to reports Scheduled Processing**: Set up automated report generation schedules Template Customization**: Create custom report templates for different data types Integration Ready**: Easy integration with existing business systems Audit Trail**: Complete logging of all processing steps and data changes Support & Troubleshooting For optimal performance, ensure your Excel files have clear column headers and consistent data formatting. The AI analysis works best with clean, well-structured data. For complex financial calculations, verify results against your existing systems during initial setup.

AI-Powered Product-Qualified Lead (PQL) Scoring & Sales Routing One-Line Description Automatically score product usage signals from Amplitude cohorts and route hot leads to sales with enriched context. Detailed Description What it does: This workflow transforms behavioral data into sales-ready leads by instantly detecting when users hit your PQL threshold, enriching their profile with company intelligence, and using AI to score their conversion potential. Hot leads are routed directly to sales with personalized conversation starters, while warm and cold leads enter appropriate nurture sequences. Who it's for: Product-led growth (PLG) teams** bridging the gap between product adoption and sales conversion Sales development teams** needing real-time alerts on high-intent users with actionable context Revenue operations professionals** optimizing lead handoff processes between product and sales Key Features: Real-time PQL detection** - Triggers instantly when users enter Amplitude behavior cohorts, eliminating manual lead review Multi-source enrichment** - Combines product usage data with company intelligence from People Data Labs and AI-powered research AI-driven scoring** - Evaluates usage intensity, ICP fit, intent signals, and timing to produce 0-10 lead scores with breakdown reasoning Smart routing logic** - Automatically categorizes leads as hot (8-10), warm (5-7), or cold (0-4) for appropriate follow-up workflows Sales enablement context** - Provides conversation starters, key insights, red flags, and handoff recommendations tailored to each lead Customizable criteria** - References external Google Doc for PQL rules, allowing non-technical teams to update scoring logic How it works: Trigger: Amplitude fires webhook when user enters predefined PQL cohort based on product usage patterns Enrichment: Pulls company data from People Data Labs and conducts AI research on company stage, tech sophistication, and budget indicators AI Scoring: Agent evaluates combined usage + enrichment data against ICP criteria stored in Google Docs, producing structured scoring output Routing: High-scoring leads (hot) generate formatted Slack alerts for immediate sales outreach; warm/cold leads could trigger email sequences (not shown in this template) Setup Requirements Prerequisites: Amplitude account** with cohort webhook capability (Growth plan or higher) People Data Labs API key** for company/person enrichment (paid credits required) Perplexity API** for AI-powered company research Anthropic Claude API** for PQL scoring logic Google Gemini API** for Slack message formatting Slack workspace** with OAuth app configured for posting messages Google Docs** containing your PQL criteria and ICP definition (publicly readable or authenticated access) Estimated Setup Time: 45-60 minutes including API credential configuration, Amplitude cohort definition, and PQL criteria document creation Installation Notes Amplitude cohort setup**: Define your PQL cohort using behavioral criteria (e.g., "Users who viewed 5+ pages AND invited team members in last 7 days"). Configure webhook to fire on cohort entry. PQL criteria document**: Create a Google Doc outlining your scoring components (usage intensity factors, ICP requirements, intent signals). Update the Google Docs Tool node with your document URL. Free email filtering**: The workflow includes logic to flag free email domains (Gmail, Yahoo, etc.) which you may want to route differently Testing tip**: Use Amplitude's "Test Webhook" feature to send sample payloads before going live Customization Options Replace People Data Labs** with Clearbit, Apollo, or other enrichment providers by swapping the HTTP Request node Add CRM integration** to automatically create opportunities or update lead scores in Salesforce/HubSpot Extend routing paths** by adding branches for warm/cold leads (e.g., trigger email sequences via Customer.io, Braze) Adjust scoring weights** by modifying the AI agent prompt or criteria document without touching workflow logic Multi-channel alerts** by duplicating output nodes to send to email, SMS, or CRM tasks in addition to Slack Category Sales Tags amplitude pql product-qualified-leads sales-automation lead-scoring enrichment people-data-labs slack-notifications ai-scoring revenue-operations Use Case Examples SaaS PLG companies**: Automatically escalate free trial users who hit usage milestones (API calls, integrations connected, team invites sent) to sales for upgrade conversations Developer tools**: Identify enterprise-ready accounts based on team size growth, deployment patterns, and GitHub integration usage, routing to enterprise sales team B2B marketplaces**: Surface buyers showing high-intent behavior (multiple searches, saved items, pricing page views) to account executives with company context for proactive outreach

Transform month-end reporting from manual drudgery to automated intelligence - automatically pull P&L data from accounting systems, detect financial anomalies, generate AI-powered insights, calculate health scores, and distribute professional reports with conditional CFO review and smart team alerts. What This Workflow Does Revolutionizes financial reporting with intelligent automation, anomaly detection, and AI-powered analysis: Scheduled Monthly Automation** - Runs automatically on 1st of each month at 9 AM, eliminating manual trigger requirements Dual Period Data Fetching** - Pulls current and previous month P&L data from accounting systems for comparative analysis Automatic Period Calculation** - Intelligently calculates reporting dates for current month and comparison period Smart Data Validation** - Merges and validates financial data from multiple sources ensuring calculation accuracy Growth Rate Analysis** - Automatically calculates month-over-month growth for revenue, expenses, and net income Intelligent Anomaly Detection** - Flags revenue changes >20%, expense growth >15%, and budget variances >25% Financial Health Scoring** - Computes 0-100 health score based on profitability, growth, expenses, and anomaly count AI-Powered Executive Insights** - Generates CFO-level summaries, identifies top concerns, provides actionable recommendations Budget Variance Analysis** - Detailed tracking of budget vs actual with percentage variances by expense category Conditional CFO Review** - Routes reports with health scores <50 or 3+ anomalies through executive approval Professional Report Design** - Creates color-coded reports with health banners, metric cards, and anomaly alerts AI Insights Section** - Prominently displays executive summary, key insights, and recommended actions Anomaly Alert Display** - Visual severity badges (high/medium) with detailed anomaly descriptions Comparative P&L Statements** - Side-by-side current vs previous period with growth percentages PDF Conversion** - Transforms HTML into print-ready, board-presentation quality PDF reports Google Drive Archival** - Automatically saves reports to organized folders with searchable filenames by period Automated Email Distribution** - Sends reports to stakeholders (CEO, CFO, Board) with AI insights in email body Context-Aware Notifications** - Critical Slack alerts for health <60, standard notifications for healthy financials Multi-Currency Support** - Handles USD, EUR, GBP with proper currency symbols and formatting Fiscal Year Tracking** - Organizes reports by fiscal year with period identification and report ID tracking Key Features Proactive Anomaly Detection**: Automatically flags unusual financial patterns before they become major issues using configurable thresholds AI Financial Analysis**: GPT-4 generates executive summaries, identifies top 3 concerns, and provides 2-3 actionable recommendations Health Score Algorithm**: 0-100 scoring system weighing profitability (+20), revenue growth (+15), expense control (+10), and anomaly absence (+5) Smart Routing Logic**: Critical issues (health <50 or 3+ anomalies) trigger CFO review, healthy reports auto-distribute Visual Health Indicators**: Color-coded banners (green/yellow/red) instantly communicate financial status Severity-Based Alerts**: High-severity anomalies get urgent Slack notifications, normal reports get standard updates Comparative Analytics**: Side-by-side period comparison showing dollar amounts and percentage changes Budget Compliance Tracking**: Highlights categories over/under budget with color-coded variance indicators Automated Commentary**: AI-generated insights eliminate manual analysis and report writing Real-Time Data Integration**: Fetches live data from accounting APIs ensuring reports reflect latest financials Conditional Workflows**: Different paths for critical vs healthy financials ensuring appropriate oversight Professional Formatting**: Board-ready reports with company branding, metric dashboards, and executive summaries Perfect For CFO Offices** - Automated monthly reporting with AI insights for board presentations and investor updates Finance Departments** - Eliminate 4-6 hours of manual report creation and variance analysis Controllers** - Proactive budget monitoring with automatic anomaly detection and alerts Accounting Firms** - Scalable client reporting with AI-generated commentary and insights Private Equity** - Portfolio company monitoring with health scoring and automated distribution Investment Firms** - Standardized reporting across portfolio companies with comparative analytics Small Business Owners** - Executive-level insights without hiring a full-time CFO Nonprofit Organizations** - Board reporting with budget variance tracking for grants and donations Startups** - Investor updates with professional formatting and AI-powered analysis Corporate Finance Teams** - Monthly business reviews with automated data compilation and presentation What You Will Need Required Integrations Accounting System API** - QuickBooks, Xero, FreshBooks, or custom REST API for P&L data extraction (API credentials required) HTML to PDF API** - PDF conversion service (API key required) - approximately 1-5 cents per report OpenAI API** - GPT-4 access for AI insights generation (API key required) - approximately 5-10 cents per report Gmail or SMTP** - Email delivery service for distributing reports to stakeholders Google Drive** - Cloud storage for report archival and compliance record-keeping Optional Integrations Slack Webhook** - Finance team notifications with metrics and alert levels based on health scores CRM Integration** - Link to customer data for revenue attribution and customer segment analysis Data Warehouse** - Connect to Snowflake, BigQuery for consolidated multi-source reporting Business Intelligence Tools** - Export data to Tableau, Power BI for deeper trend analysis Quick Start Import Template - Copy JSON workflow and import into your n8n instance Configure Accounting API - Update "Fetch Current P&L" and "Fetch Previous P&L" nodes with your accounting system API endpoint and credentials Set Schedule - Adjust "Schedule Monthly" trigger if needed (default: 1st of month, 9 AM) Setup OpenAI - Add OpenAI API credentials to "AI Financial Insights" node for automated analysis Configure PDF Service - Add HTML to PDF API credentials in the "HTML to PDF" node Setup Gmail - Connect Gmail OAuth2 credentials and update sender email in "Send to Stakeholders" node Connect Google Drive - Add Google Drive OAuth2 credentials and set folder ID for report archival in "Save to Google Drive" node Customize Company Info - Edit "Prepare Report Data" node with your company name, logo URL, fiscal year, and prepared by information Configure Stakeholders - Update stakeholder list with actual recipient names and email addresses for automated distribution Set Anomaly Thresholds - Adjust detection thresholds in "Analyze Financial Data" node if your business requires different sensitivity levels Configure Slack - Add Slack webhook URLs in "Alert - Critical" and "Notify - Standard" nodes for team notifications Test Workflow - Run manually with sample data to verify API connections, calculations, AI insights, and PDF generation Monitor First Run - Check first automated execution on the 1st to ensure accounting data pulls correctly Customization Options Anomaly Thresholds** - Adjust revenue (default 20%), expense (default 15%), and variance (default 25%) sensitivity levels Health Score Weights** - Modify scoring algorithm bonuses for profitability, growth, expense control, and anomaly absence AI Prompt Engineering** - Customize AI instructions to focus on specific financial metrics or industry concerns Report Templates** - Create different HTML designs for monthly vs quarterly vs annual reports Multi-Department Reporting** - Generate separate reports for each business unit with department-specific budgets Custom Metrics** - Add industry-specific KPIs like EBITDA, burn rate, runway, CAC, LTV, ARR, MRR Chart Integration** - Add revenue trend charts, expense pie charts using Chart.js or D3.js libraries Drill-Down Links** - Embed links to detailed transaction reports in accounting system for deeper analysis Year-Over-Year Comparisons** - Extend to include YoY analysis alongside month-over-month comparisons Forecast Integration** - Add forecast vs actual comparisons with variance explanations and revised projections Cash Flow Statements** - Extend to include operating, investing, financing cash flows and balance sheet summaries Scenario Analysis** - Add best case, worst case, and expected case financial projections for decision modeling Multi-Currency Consolidation** - Aggregate financial data from international entities with exchange rate conversions Approval Workflows** - Add multi-level review and approval steps before distribution to board or investors Alert Escalation** - Configure progressive alerts to VP Finance, CFO, CEO based on severity and response time Expected Results 95% time savings** - Reduce monthly reporting from 4-6 hours to 15 minutes of automated execution 100% calculation accuracy** - Eliminate manual errors in growth rates, variances, and health scoring Proactive issue detection** - Identify financial anomalies on day 1 instead of discovering them mid-month Executive-level insights** - AI generates CFO-quality analysis without requiring finance expertise Faster decision making** - Stakeholders receive reports with actionable recommendations on 1st of month Improved oversight** - Conditional CFO review ensures critical issues get executive attention Reduced fire drills** - Anomaly detection prevents surprises in board meetings or investor calls Better budget control** - Immediate visibility into 25%+ variances enables faster corrective action Enhanced credibility** - AI-powered insights and professional reports improve stakeholder confidence Scalable intelligence** - Handle 10x more entities without additional analysts or manual work Compliance automation** - Automated archival with report IDs meets audit and regulatory requirements Strategic focus shift** - Finance team shifts from manual reporting to strategic planning and analysis Pro Tips Validate API Connections** - Test accounting system API calls before month-end to avoid production failures Customize AI Context** - Tailor AI prompts with your industry terminology and specific concerns for better insights Set Realistic Thresholds** - Adjust anomaly detection based on your business volatility and acceptable variance Review First AI Output** - Validate AI insights quality in first few runs and refine prompts as needed Schedule Buffer Time** - Run workflow after accounting close is complete to ensure data accuracy Test Alert Routing** - Verify CFO review emails trigger correctly for critical health scores Archive Systematically** - Organize Drive folders by fiscal year and report type for easy retrieval Monitor Health Trends** - Track health scores over time to identify improving or declining financial patterns Document Anomalies** - Keep log of flagged anomalies and corrective actions for continuous improvement Customize for Audience** - Different stakeholder lists for internal management vs board vs investors Version Control Reports** - Use report ID and timestamps in filenames for easy version tracking Benchmark Thresholds** - Compare your anomaly thresholds against industry standards and adjust accordingly Secure Sensitive Data** - Use encrypted email or secure portal for highly confidential financial reports Regular Threshold Review** - Quarterly review and adjust detection thresholds based on false positive rates AI Insight Validation** - Spot-check AI recommendations against CFO analysis to ensure quality Business Impact Metrics Track these key metrics to measure workflow success: Report Generation Time** - Average minutes from trigger to stakeholder inbox (target: under 15 minutes) Anomaly Detection Rate** - Percentage of financial issues flagged by workflow vs manually discovered (target: >80%) AI Insight Quality** - CFO rating of AI recommendations usefulness on 1-5 scale (target: 4+) Health Score Accuracy** - Correlation between health scores and actual financial performance outcomes False Positive Rate** - Percentage of flagged anomalies that were not actual issues (target: <20%) CFO Review Efficiency** - Time saved on critical issue analysis with pre-flagged anomalies and AI insights Distribution Timeliness** - Days after month close when stakeholders receive report (target: day 1) Finance Team Productivity** - Hours saved monthly on reporting and analysis (typical: 20-30 hours) Budget Adherence** - Improvement in staying within budget after implementing proactive variance alerts Decision Response Time** - Days from anomaly detection to management corrective action Report Accuracy** - Percentage of reports with calculation errors (target: 0%) Stakeholder Satisfaction** - Survey rating on report clarity, insights, and actionable recommendations (target: 4.5/5) Template Compatibility Compatible with n8n version 1.0 and above Works with n8n Cloud and Self-Hosted instances Requires OpenAI API access (GPT-4 recommended for best insights) Requires HTML to PDF API service subscription Requires accounting system with REST API (QuickBooks, Xero, FreshBooks, or custom) No coding required for basic setup Fully customizable for industry-specific requirements Integrates with major accounting platforms via API Multi-currency support built-in Supports monthly reporting cycles (extendable to quarterly/annual) Ready to transform your financial reporting? Import this template and start generating intelligent financial reports with AI-powered insights, automatic anomaly detection, health scoring, and conditional CFO review - freeing your finance team to focus on strategic decision-making instead of manual number-crunching and report writing!

Description Automate your team's daily stand-ups with AI-powered morning briefs, directly pulled from ClickUp tasks and shared via Slack and Gmail every morning. ☀️📋💬 What This Template Does Triggers automatically at 9:15 AM each morning via cron. ⏰ Fetches the latest sprint and all active or due-today tasks from ClickUp. Categorizes tasks by status, priority, and assignee for clear visibility. Uses Azure OpenAI GPT-4o to generate a detailed, structured morning summary. Formats the AI summary into a clean HTML email and a Slack post. Sends automated updates to Gmail and Slack channels. Includes real-time error detection and Slack alerts for quick debugging. Key Benefits ✅ Eliminates manual stand-up prep by generating AI-driven daily reports. ✅ Keeps teams aligned with clear task summaries and blocker tracking. ✅ Automatically distributes updates across Slack and Gmail. ✅ Provides HTML-formatted emails and Slack markdown summaries. ✅ Reduces time spent on daily check-ins and sprint reviews. Features Fully automated daily scheduling using cron triggers. Real-time task fetching and categorization from ClickUp. GPT-4-powered summarization for executive-style briefs. Responsive HTML email builder for beautiful reports. Slack integration for quick, shareable updates. Error handling with dedicated Slack notifications. Requirements ClickUp OAuth2 credentials for task access. Azure OpenAI GPT-4o API credentials for summary generation. Slack API credentials for channel posting. Gmail OAuth2 credentials for sending email reports. Target Audience Project managers and team leads needing automated daily briefings 👩‍💼 Development teams using ClickUp for sprint and task tracking 💻 Agencies or operations teams coordinating across tools 🔄 Remote teams seeking quick alignment and productivity boosts 🌍 Step-by-Step Setup Instructions Connect your ClickUp account via OAuth2 and update Team, Space, and Folder IDs. ⚙️ Add Azure OpenAI GPT-4o credentials for AI summary generation. 🤖 Configure Slack OAuth2 credentials and set the target channel ID. 💬 Connect Gmail OAuth2 and define recipient email addresses. 📧 Customize the schedule trigger time (default: 9:15 AM). 🕒 Test the workflow to verify proper data retrieval and message delivery. 🚀

Blog Post Content Creation (Multi-Topic with Brand Research, Google Drive, and WordPress) Description This workflow automates the full lifecycle of generating and publishing SEO-optimized blog posts from a list of topics. It reads topics (and optionally brands) from Google Sheets, performs brand research, generates a structured HTML article via AI, converts it into an HTML file for Google Drive, publishes a draft post on WordPress, and repeats this for every row in the sheet. When the final topic has been processed, a single Slack message is sent to confirm completion and share links. How It Works 1. Input from Google Sheets A Google Sheets node reads rows containing at least: Brand (optional, can be defaulted) Blog Title or Topic A Split In Batches node iterates through the rows one by one so each topic is processed independently. 2. Configuration The Configuration node maps each row’s values into: Brand Blog Title These values are used consistently across brand research, content creation, file naming, and WordPress publishing. 3. Brand Research A Language Model Chain node calls an OpenRouter model to gather background information about the brand and its services. The brand context is used as input for better, on-brand content generation. 4. Content Creation A second Language Model Chain node uses the brand research and the blog title or topic to generate a full-length, SEO-friendly blog article. Output is clean HTML with: Exactly one `` at the top Structured ` and ` headings Semantic tags only No inline CSS No <html> or <body> wrappers No external resources 5. HTML Processing A Code node in JavaScript: Strips any markdown-style code fences around the HTML Normalizes paragraph breaks Builds a safe file name from the blog title Encodes the HTML as a binary file payload 6. Upload to Google Drive A Google Drive node uploads the generated HTML file to a specified folder. Each topic creates its own HTML file, named after the blog title. 7. Publish to WordPress An HTTP Request node calls the WordPress REST API to create a post. The post content is the generated HTML, and the title comes from the Configuration node. By default, the post is created with status draft (can be changed to publish if desired). 8. Loop Control and Slack Notification After each topic is processed (Drive upload and WordPress draft), the workflow loops back to Split In Batches to process the next row. When there are no rows left, an IF node detects that the loop has finished. Only then is a single Slack message sent to: Confirm that all posts have been processed Share links to the last generated Google Drive file and WordPress post Integrations Used OpenRouter - AI models for brand research and SEO content generation Google Sheets - Source of topics and (optionally) brands Google Drive - Storage for generated HTML files WordPress REST API - Blog post creation (drafts or published posts) Slack - Final summary notification when the entire batch is complete Ideal Use Case Content teams and agencies managing a queue of blog topics in a spreadsheet Marketers who want a hands-off pipeline from topic list to WordPress drafts Teams who need generated HTML files stored in Drive for backup, review, or reuse Any workflow where automation should handle the heavy lifting and humans only review the final drafts Setup Instructions Google Sheets Create a sheet with columns like Brand and Blog Title or Topic. In the Get Blog Topics node, set the sheet ID and range to match your sheet. Add your Google Sheets credentials in n8n. OpenRouter (LLM) Add your OpenRouter API key as credentials. In the OpenRouter Chat Model nodes, select your preferred models and options if you want to customize behavior. Google Drive Add Google Drive credentials. Update the folder ID in the Upload file node to your target directory. WordPress In the Publish to WordPress node, replace the example URL with your site’s REST API endpoint. Configure authentication (for example, Application Passwords or Basic Auth). Adjust the status field (draft or publish) to match your desired workflow. Slack Add Slack OAuth credentials. Set the channel ID in the Slack node where the final summary message should be posted. Run the Workflow Click Execute Workflow. The workflow will loop through every row in the sheet, generating content, saving HTML files to Drive, and creating WordPress posts. When all rows have been processed, a single Slack notification confirms completion.