News research and sentiment analysis AI agent with Gemini and SearXNG
This n8n workflow operates as a two-agent system where each agent has a specialized task. The process flows from initial user input to a final analysis, with a seamless handoff between the agents. How it works The Chat Trigger The entire process begins when you send a message using n8n's chat interface. This message serves as the initial prompt or query for the system. The Research Agent Takes Over The user's message is first sent to the Research Agent. This agent's job is to understand the query and gather relevant information. To do this, it has access to: LLM: Google Gemini, which acts as the agent's "brain" to process language and make decisions. Tools: web_search: It uses this tool (powered by your self-hosted SearXNG instance) to perform live searches on the internet. getcurrentdate: It can access the current date, which is useful for context-aware or time-sensitive research. The Research Agent uses these tools to find the most relevant information related to your query and then compiles it into a concise summary. Handoff to the Sentiment Analysis Agent Once the Research Agent has completed its task, it passes its findings directly to the Sentiment Analysis Agent. The Final Analysis The Sentiment Analysis Agent receives the text from the Research Agent. Its sole purpose, as defined by its system prompt, is to analyze the sentiment of the provided information. It determines if the content is positive, negative, or neutral and formulates a final response. This final analysis is then sent back to you in the chat, completing the workflow. Set up steps Select the Language Model (LLM): This workflow is pre-configured with Google Gemini. You can select a different model for the agents as needed. Configure LLM Credentials: Ensure that valid credentials for your chosen LLM are correctly set up within your n8n instance. Set Up the SearXNG Connection: Configure the node to connect to your self-hosted SearXNG instance. This enables the agent's web search capabilities. Define the Research Agent's Task: Customize the system prompt for the "Research Agent" to define its role, instructions, and how it should conduct its research. Define the Sentiment Analysis Agent's Task: Adjust the system prompt for the "Sentiment Analysis Agent" to specify how it should analyze the information provided by the Research Agent. Test the Workflow: Use the built-in chat interface in the n8n canvas to send a message and verify that the agents are functioning correctly.
AI-powered content factory: RSS to blog, Instagram & TikTok with Slack approval
This workflow automates the daily content creation process by monitoring trends, generating drafts for multiple platforms using AI, and requiring human approval before saving. It acts as an autonomous "AI Content Factory" that turns raw news into polished content for SEO Blogs, Instagram, and TikTok/Reels. How it works Trend Monitoring: Fetches the latest trend data via RSS (e.g., Google News or Google Trends). AI Filtering: An AI Agent acts as an "Editor-in-Chief," selecting only the most viral-worthy topics relevant to your niche. Multi-Format Generation: Three specialized AI Agents (using gpt-4o-mini for cost efficiency) run in parallel to generate: An SEO-optimized Blog post structure. An Instagram Carousel plan (5 slides). A Short Video Script (TikTok/Reels). Human-in-the-Loop: Sends a formatted message with interactive buttons to Slack. The workflow waits for your decision. Final Storage: If approved, the content is automatically appended to Google Sheets. Who is this for Social Media Managers & Content Creators Marketing Agencies managing multiple accounts Anyone wanting to automate "research to draft" without losing quality control. Requirements n8n: Version 1.19.0+ (requires AI Agent nodes). OpenAI: API Key (works great with low-cost gpt-4o-mini). Slack: A workspace to receive notifications. Google Sheets: To store the approved content. How to set up Configure Credentials: Set up your OpenAI, Slack, and Google Sheets credentials. Slack App: Create a Slack App, enable "Interactivity," and set the Request URL to your n8n Production Webhook URL. Add the chat:write scope and install it to your workspace. Google Sheet: Create a sheet with columns for Blog, Instagram, and Script (row 1 as headers). RSS Feed: Change the RSS node URL to your preferred topic source.
Generate professional product images | AI marketing campaign generator
π AI Marketing Campaign Generator Upload product image + details β Get complete professional marketing campaign with 5 custom-generated assets automatically. π€ AI Model GPT-4o Mini (OpenAI) - For campaign strategy | Prompt Image generation GPT Image-1 (OpenAI) - For visual asset generation π Required API Keys OpenAI API - AI analysis & image generation Google Drive API - Asset storage & organization π― What It Generates 5 Marketing Assets: Instagram Post, Instagram Story, Website Banner, Ad Creative, Testimonial Graphic Brand Strategy: Colors, tone, positioning from your product image Campaign Strategy: Messaging, target audience, objectives Visual Analysis: Extracts colors, materials, styling from uploaded image βοΈ Setup Import JSON to n8n Add OpenAI & Google Drive credentials Configure Google Drive folder for asset storage Deploy form webhook Test with product image upload π± How It Works Upload product image β AI analyzes visual + text β Generates complete campaign β Creates 5 custom marketing assets β Saves to Google Drive
Create, update posts π οΈ Wordpress tool MCP server πͺ all 12 operations
Need help? Want access to this workflow + many more paid workflows + live Q&A sessions with a top verified n8n creator? Join the community Complete MCP server exposing all Wordpress Tool operations to AI agents. Zero configuration needed - all 12 operations pre-built. β‘ Quick Setup Import this workflow into your n8n instance Activate the workflow to start your MCP server Copy the webhook URL from the MCP trigger node Connect AI agents using the MCP URL π§ How it Works β’ MCP Trigger: Serves as your server endpoint for AI agent requests β’ Tool Nodes: Pre-configured for every Wordpress Tool operation β’ AI Expressions: Automatically populate parameters via $fromAI() placeholders β’ Native Integration: Uses official n8n Wordpress Tool tool with full error handling π Available Operations (12 total) Every possible Wordpress Tool operation is included: π§ Post (4 operations) β’ Create a post β’ Get a post β’ Get many posts β’ Update a post π§ Page (4 operations) β’ Create a page β’ Get a page β’ Get many pages β’ Update a page π€ User (4 operations) β’ Create a user β’ Get a user β’ Get many users β’ Update a user π€ AI Integration Parameter Handling: AI agents automatically provide values for: β’ Resource IDs and identifiers β’ Search queries and filters β’ Content and data payloads β’ Configuration options Response Format: Native Wordpress Tool API responses with full data structure Error Handling: Built-in n8n error management and retry logic π‘ Usage Examples Connect this MCP server to any AI agent or workflow: β’ Claude Desktop: Add MCP server URL to configuration β’ Custom AI Apps: Use MCP URL as tool endpoint β’ Other n8n Workflows: Call MCP tools from any workflow β’ API Integration: Direct HTTP calls to MCP endpoints β¨ Benefits β’ Complete Coverage: Every Wordpress Tool operation available β’ Zero Setup: No parameter mapping or configuration needed β’ AI-Ready: Built-in $fromAI() expressions for all parameters β’ Production Ready: Native n8n error handling and logging β’ Extensible: Easily modify or add custom logic > π Free for community use! Ready to deploy in under 2 minutes.
Multi-platform social media publisher with Airtable, Google Drive, and Postiz
π POSTIZ MEDIA UPLOAD WORKFLOW ββββββββββββββββββββββββββββββββββββββββββββ π― PURPOSE: Automated media upload pipeline that downloads videos and images from Google Drive and uploads them to Postiz storage for social media posting. π WORKFLOW PROCESS: Webhook triggers the workflow Fetch media metadata from Airtable Download video + image from Google Drive Upload both files to Postiz storage Save Postiz file paths back to Airtable π§ TECHNICAL DETAILS: β’ API: Postiz /upload endpoint (multipart-form-data) β’ Storage: Converts Google Drive files β Postiz URLs β’ Integration: Updates Airtable with Postiz paths β’ Required: All media must be uploaded before posting π± SOCIAL MEDIA POSTING WORKFLOW ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ π― PURPOSE: Automated multi-platform social media posting using Postiz API. Distributes content across Instagram, Twitter/X (2 accounts), LinkedIn, and Facebook with platform-specific content cleaning and formatting. π COMPLETE WORKFLOW PROCESS: π Fetch social media content from Airtable database π Get integration IDs for all connected social platforms π Route each platform to appropriate content processor π§Ή Clean content to prevent JSON formatting errors π± Post to respective social media platforms simultaneously π PLATFORM COVERAGE: β’ πΈ Instagram (Visual content + captions) β’ π¦ Twitter/X Main Account (Text + images) β’ π¦ Twitter/X Alt Account (Duplicate posting) β’ πΌ LinkedIn (Professional content) β’ π Facebook (Meta ecosystem posting) β οΈ CRITICAL CONTENT CLEANING: β’ Removes line breaks (\n), carriage returns (\r), tabs (\t) β’ Replaces multiple spaces with single spaces β’ Prevents 'JSON parameter needs to be valid JSON' errors β’ ESSENTIAL: Without cleaning, all API calls fail! π§ TECHNICAL SPECIFICATIONS: β’ API: Postiz /posts endpoint (POST) β’ Authentication: HTTP Header Auth β’ Content-Type: application/json β’ Posting Type: Immediate ('now') + 1 minute delay β’ Media: References pre-uploaded Postiz image paths β’ Rate Limit: 30 requests/hour (API beta limitation) π DATA SOURCES: β’ Content: Airtable β’ Media: Pre-uploaded via separate media upload workflow β’ Fields: instagramcaption, linkedinpost, twitter single, faceboook β’ Images: References 'postiz image' field paths β‘ EXECUTION FLOW: Airtable β Integrations β Platform Router β Content Cleaners β Social Publishers π¨ TROUBLESHOOTING: β’ JSON Errors: Check content cleaning nodes β’ 500 Errors: Verify integration IDs and account connections β’ Missing Media: Ensure media upload workflow ran first β’ Rate Limits: Space out executions (30/hour limit) π DEPENDENCIES: β’ Requires: Media upload workflow (for image/video paths) β’ Connects to: Analytics and monitoring workflows β’ Updates: Airtable with posting status and URLs ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β οΈ CRITICAL NOTES: β’ Cannot use external URLs in Postiz posts β’ Files must be uploaded to google drive first - id referenced in airtable β’ Enables reference tracking for all platforms π DATA FLOW: Google Drive β Download β Postiz Upload β Airtable Update π CONNECTS TO: Main social media posting workflows that reference these uploaded file paths for Instagram, Twitter, LinkedIn, Facebook, and YouTube posting. π¬ VIDEO POSTING WORKFLOW ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ π― PURPOSE: Automated video content distribution across Instagram, Facebook, and YouTube using Postiz API. Specialized workflow for video content with platform-specific processing and cleaning. π WORKFLOW EXECUTION: π Fetch video content from Airtable database (recuoYjg4icStHsMK) π Get integration IDs for video-enabled platforms π Route platforms to appropriate video processors π§Ή Clean content for Instagram & Facebook (YouTube bypassed) πΉ Publish to video platforms simultaneously πΉ PLATFORM COVERAGE: β’ π± Instagram: Video posts & Reels (β Working) β’ π Facebook: Video content (β οΈ Test mode) β’ π¬ YouTube: Long-form videos (π¨ Broken) β‘ EXECUTION FLOW: Airtable β Integrations β Video Router β [3 Parallel Paths] βββ Instagram: Cleaner β Publisher βββ Facebook: Cleaner β Publisher βββ YouTube: [Direct] β Publisher ποΈ DATA SOURCE: β’ Base: Netkreatives.com β’ Table: Youtube tool β’ Video Field: 'postiz video' β’ Content Fields: instagram_caption, faceboook π§ TECHNICAL SPECS: β’ Method: POST β’ Auth: HTTP Header (Postiz credentials) β’ Timing: Immediate posting (+1 minute delay) β’ Media: Pre-uploaded video paths β’ Content-Type: application/json
Simple file based key value store (GetKey)
Read a value by key from a local json file. Related workflow: WriteKey Create a subfolder in your n8n homedir: /home/node/.n8n/local-files. In docker look at the data path and create a subfolder local-files. Set the correct access rights chmod 1000.1000 local-files. Put the workflow code in a new workflow named GetKey. Create another workflow with a function item: js return { file: '/4711.json', // 4711 should be your workflow id key: 'MyKey', default: 'Optional returned value if key is empty / not exists' } Pipe the function item to an Execution Workflow that calls the GetKey workflow. It would be nice if we could get someday a shiny built-in n8n node that does the job. :)
Send daily weather updates via a push notification using the Pushcut node
This workflow allows you to send daily weather updates via a push notification using the Pushcut node.
Conversational sales agent for WooCommerce with GPT-4, Stripe and CRM integration
π What this workflow does This workflow transforms your n8n instance into a fully automated AI sales assistant for WooCommerce stores. It detects customer intent from chat, searches products, answers FAQs, generates Stripe payment links, captures leads into your CRM, and even escalates to human support when needed. It provides smooth conversational memory and syncs with your knowledge base to ensure accurate, human-like responses. π€ Who is this for WooCommerce store owners who want to automate customer support and sales. Sales and marketing teams looking to scale personalized product recommendations. E-commerce managers who want to reduce manual chat handling. Anyone aiming to integrate AI assistants with payments, CRM, and FAQs. β Requirements WooCommerce account with API access. Qdrant vector store (for FAQ and RAG retrieval). OpenAI/Gemini API credentials (for intent detection + message generation). Google Drive account (to sync and update knowledge base docs). Stripe account (to generate instant payment links). CRM account (HubSpot, Pipedrive, etc.) if lead capture is required. Telegram account for optional human escalation. βοΈ How to set up Connect WooCommerce API credentials in n8n. Configure Gemini/OpenAI API for intent extraction and chat generation. Set up Qdrant for document retrieval, and link to your Google Drive Sales Docs folder. Configure Stripe API to enable instant payment link generation. Connect your CRM to capture new leads automatically. Add Telegram bot credentials for human escalation (optional). Enable conversational memory and test chat flows end-to-end. π How it works Intent Extraction β AI analyzes chat messages to detect Product Search, FAQ, Payment, or Lead Capture. Product Search β Queries WooCommerce catalog by keyword, SKU, or price range. FAQ Answering β Retrieves company policies/docs from Qdrant + Google Drive, answered via RAG. Payment Links β Stripe generates instant checkout links for customers ready to buy. Lead Capture β Name + email are auto-stored into CRM. Human Escalation β If intent is unclear, conversation is forwarded to Telegram. Conversational Memory β Maintains last 12 exchanges for natural dialogue. Knowledge Sync β Google Drive docs auto-update into Qdrant for live FAQ support. π‘ About Margin AI Margin AI is an AI-services agency that acts as your AI Service Companion. We design intelligent, human-centric automation solutionsβturning your teamβs best practices into scalable workflows and tools. Industries like marketing, sales, and operations benefit from our tailored AI consulting, automation tools, and chatbot development.
Track regional sentiment from social media with Bright Data & OpenAI
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. This workflow automatically tracks regional sentiment across social media and news outlets, giving you a real-time pulse on how people in a specific area feel about your brand or topic. Overview The automation queries Twitter, Reddit, and major news APIs filtered by geolocation. Bright Data handles location-specific scraping where APIs are limited. OpenAI performs sentiment and keyword extraction, aggregating scores into a daily report stored in Google Sheets and visualized in Data Studio. Tools Used n8n β Coordinates all steps Bright Data β Collects geo-targeted data beyond API limits OpenAI β Runs sentiment analysis and topic modeling Google Sheets β Houses cleaned sentiment metrics Data Studio / Looker β Optional dashboard for visualization How to Install Import the Workflow into n8n with the provided .json. Configure Bright Data credentials. Set Up OpenAI API key. Connect Google Sheets and create a destination spreadsheet. Customize Regions & Keywords in the Start node. Use Cases Brand Monitoring: Measure public opinion in target markets. Political Campaigns: Gauge voter sentiment by district. Market Entry: Understand regional attitudes before launching. Crisis Management: Detect negative spikes early. Connect with Me Website: https://www.nofluff.online YouTube: https://www.youtube.com/@YaronBeen/videos LinkedIn: https://www.linkedin.com/in/yaronbeen/ Get Bright Data: https://get.brightdata.com/1tndi4600b25 (Using this link supports my free workflows with a small commission) n8n automation sentimentanalysis geolocation brightdata openai sociallistening n8nworkflow nocode brandmonitoring
Send daily inspirational quotes with Gemini translation to Telegram subscribers
Send daily inspirational quotes with AI translation to Telegram subscribers This n8n workflow creates an automated daily quote bot that fetches inspirational quotes, translates them using AI, adds emoji "stickers," and sends them to registered Telegram subscribers. Perfect for content creators, coaches, or anyone wanting to share daily motivation with their audience. Who's it for Content creators and social media managers Life coaches and motivational speakers Community managers running Telegram channels Anyone wanting to automate daily inspirational content Developers learning n8n automation with AI integration How it works The workflow operates on two main flows: Daily Quote Distribution: Schedule Trigger runs daily to fetch a random inspirational quote HTTP Request fetches quotes from the ZenQuotes API (free service) Google Gemini AI translates the quote to your target language and adds relevant emoji "stickers" Google Sheets retrieves the list of registered subscribers Telegram sends the formatted quote (original + translated + emojis) to all subscribers User Registration: Telegram Trigger listens for new messages to your bot Google Sheets automatically registers new users who interact with the bot Requirements Telegram Bot Token - Create a bot via @BotFather on Telegram Google Gemini API - For AI translation and emoji enhancement Google Sheets - To store subscriber list (free Google account) ZenQuotes API - Free, no API key required How to set up Create Telegram Bot: Message @BotFather on Telegram, create a new bot, and save the token Set up Google Sheets: Create a spreadsheet with columns: registered_users, date Configure Gemini API: Get your API key from Google AI Studio Update the Set Fields node: Configure your target language and bot preferences Test the workflow: Send a message to your bot to register, then manually trigger the quote sending How to customize the workflow Change target language: Modify the AI prompt in the LLM Chain node to translate to any language Adjust sending schedule: Update the Schedule Trigger to send quotes at your preferred time/frequency Customize quote sources: Replace the HTTP Request with other quote APIs or your own content Add quote categories: Enhance the AI prompt to categorize quotes (motivational, business, life, etc.) Include user preferences: Expand Google Sheets to store user language preferences for personalized translations Good to know The workflow automatically handles new subscriber registration Supports MarkdownV2 formatting for rich text in Telegram Uses emoji "stickerization" to make quotes more engaging and visual Demo bot working with this workflow is @sgsbot on Telegram
Workshop certificate generator with Google Drive, Gmail & QR verification
Automated Pre-Issued Workshop Certificate Generator Description: This workflow automates the entire pre-issuance process of workshop participation certificates. When an attendee submits a registration form via a webhook, the workflow validates the data, verifies the attendeeβs email, generates a unique Certificate ID and QR code, creates a styled certificate image, stores it on Google Drive, emails the certificate to the attendee, logs all details in Google Sheets, and notifies organizers via Slack β all fully automated. This template is ideal for institutions, event teams, training organizations, hackathons, and workshops that want to automate certificate issuing and remove manual processing. --- Key Features: Webhook-based registration intake Required field + email validation using VerifiEmail API Auto-generated Certificate ID, QR code, and verification URL Dynamic HTML-to-Image certificate generation Automatic email delivery with certificate attachment (Gmail) Auto-upload certificate to Google Drive Real-time Slack notification for organizers Registration + certificate logging in Google Sheets Instant webhook response with certificate metadata --- How It Works (Short Summary): Webhook Trigger receives registration details. Validator checks for mandatory fields (name, email, event). Email verification ensures the email is deliverable. Certificate generation creates unique ID + QR + HTML. HTML-to-Image converts the certificate to PNG. Upload to Google Drive stores the certificate file. Email node sends the certificate to the attendee. Google Sheets logs the registration + certificate details. Slack message notifies organizers instantly. Webhook response returns success JSON. --- Use Cases: Workshops Webinars Training sessions Bootcamps Corporate events Hackathons Student registrations Event ticketing / entry pass systems --- Required Credentials: VerifiEmail API β email validation at verifi.email HTMLCSStoImage API β convert certificate HTML to PNG at htmlcsstoimg.com Gmail OAuth2 β send certificate emails Google Drive OAuth2 β store certificate files Google Sheets OAuth2 β logging Slack API β organizer notifications --- Setup Instructions: Import this template into your n8n instance. Open the Webhook node and copy the generated webhook URL. Use this URL in your registration form / frontend / Postman. Add all required credentials in the Credentials Manager. Customize certificate HTML (colors, branding, logos) if needed. Test with a sample POST request containing all required fields: name email event date time venue organization designation Enable the workflow. --- Input Format (POST Body Required): json { "name": "John Doe", "email": "john@example.com", "event": "AI Workshop 2025", "date": "25 Nov 2025", "time": "10:00 AM", "venue": "Auditorium Hall", "organization": "Tech University", "designation": "Student" } --- Output (Webhook Response): json { "success": true, "message": "Registration successful! Certificate sent to your email.", "certificateId": "CERT-12345-ABCD", "verifyUrl": "https://workshopverify.com/cert?id=CERT-12345-ABCD" } --- Why This Workflow is Useful: Eliminates manual certificate design & sending Ensures professional, consistent certificates Reduces event staff workload Guarantees accurate data logging Provides instant attendee confirmation Enhances event experience with automation ---