by dmr
This n8n workflow implements a version of the Adaptive Retrieval-Augmented Generation (RAG) framework. It recognizes that the best way to retrieve information often depends on the type of question asked. Instead of a one-size-fits-all approach, this workflow adapts its strategy based on the user's query intent. 🌟 How it Works Receive Query: Takes a user query as input (along with context like a chat session ID and Vector Store collection ID if used as sub-workflow). Classify Query: First, the workflow classifies the query into a predefined category. This template uses four examples: Factual: For specific facts. Analytical: For deeper explanations or comparisons. Opinion: For subjective viewpoints. Contextual: For questions relying on specific background. Select & Adapt Strategy: Based on the classification, it selects a corresponding strategy to prepare for information retrieval. The example strategies aim to: Factual: Refine the query for precision. Analytical: Break the query into sub-questions for broad coverage. Opinion: Identify different viewpoints to look for. Contextual: Incorporate implied or user-specific context. Retrieve Info: Uses the output of the selected strategy to search the specified knowledge base (Qdrant vector store - change as needed) for relevant documents. Generate Response: Constructs a response using the retrieved documents, guided by a prompt tailored to the original query type. By adapting the retrieval strategy, this workflow aims to provide more relevant results tailored to the user's intent. ⚙️ Usage & Flexibility Sub-Workflow:** Designed to be called from other n8n workflows, passing user_query, chat_memory_key, and vector_store_id as inputs. Chat Testing:** Can also be triggered directly via the n8n Chat interface for easy testing and interaction. Customizable Framework:** The query categories (Factual, Analytical, etc.) and the associated retrieval strategies are examples. You can modify or replace them entirely to fit your specific domain or requirements. 🛠️ Requirements Credentials:** You will need API credentials configured in your n8n instance for: Google Gemini (AI Models) Qdrant (Vector Store)
by Matthew
AI-Powered Viral Video Factory 🚀 This workflow automates the entire process of creating short, cinematic, fact-based videos ready for social media. It takes a single concept, generates a script and visuals, creates video clips, adds a voiceover, and assembles a final video, which is then uploaded directly to your Google Drive. It's perfect for content creators and marketing agencies looking to scale video production with minimal manual effort. How It Works 🎬 Generate a Viral Idea 💡: The workflow begins with the Create New Idea1 (OpenAI) node, which generates a viral-ready video concept, including a punchy title, hashtags, and a brief description based on a core theme (e.g., space, black holes). This idea is then logged in a Google Sheet. Create a Cinematic Script & Voiceover 📜: An OpenAI node (Generating scenes1) creates a detailed 12-scene script, outlining the visuals for a 60-second video. The script text for all scenes is combined and prepared for voiceover generation by another OpenAI node (Generate Voiceover). Generate Scene-by-Scene Visuals ✨: The workflow loops through each of the 12 scenes to create an animated clip: Image Generation: An HTTP Request node sends the scene's prompt to the fal-ai/flux model to create a photorealistic still image. Animation Prompting: The Video Prompts1 (OpenAI Vision) node analyzes the generated image and creates a new, specific prompt to animate it cinematically. Image-to-Video: Another HTTP Request node uses the fal-ai/kling-video model to turn the still image into a 5-second animated video clip based on the new animation prompt. Assemble the Final Video 🎞️: Stitch Clips: Once all 12 clips are generated, the Merge Clips node uses the fal-ai/ffmpeg-api to concatenate them into a single, seamless 60-second video. Add Audio: The Combine Voice and Video node then layers the AI-generated voiceover onto the stitched video. Deliver to Google Drive 📂: Finally, the completed video is converted from a URL to a file and automatically uploaded to your specified Google Drive folder for easy access and publishing. Key Technologies Used n8n**: For orchestrating the entire automated workflow. OpenAI (GPT-4.1 & GPT-4o)**: For idea generation, scriptwriting, voiceover, and vision analysis. Fal.ai**: For high-performance, API-based image generation (Flux), video animation (Kling), and video processing (FFMPEG API). Google Drive & Sheets**: For logging ideas and storing the final video output. Setup Instructions Add Credentials: In n8n, add your OpenAI API key. Connect your Google account for Google Sheets and Google Drive access. You will need a Fal.ai API Key. Configure Fal.ai API Key: Crucially, you must replace the placeholder API key in all HTTP Request nodes that call the fal.run URL. Find the Authorization header in each of these nodes and replace the existing key with your own Key YOUR_FAL_AI_KEY_HERE. Nodes to update: Create Images1, Get Images1, Create Video1, Get Video1, Merge Clips, Get Final video, Combine Voice and Video. Configure OpenAI Nodes: Select each OpenAI node (e.g., Create New Idea1, Generating scenes1) and choose your OpenAI credential. You can customize the main prompt in the Create New Idea1 node to change the theme of the videos you want to generate. Configure Google Sheets & Drive: In the Organise idea, caption etc1 node, select your Google Sheets credential and specify the Spreadsheet and Sheet ID you want to use for logging ideas. In the Upload file to drive node, select your Google Drive credential and choose the destination folder for your final videos.
by MAMI YAMANE
AI Editor-in-Chief: Trend Research to 3 Notion Blog Drafts This workflow acts as your personal "AI Editor-in-Chief," fully automating the process from trend research to content creation. It scrapes Google Search results and generates three distinct article drafts (with different angles) complete with AI-generated cover images, saving everything directly to Notion. 🎯 Target Audience Bloggers & Affiliate Marketers: Individuals who struggle with writer's block and want to maintain a consistent posting schedule. Content Marketers & Editors: Teams running owned media who need to efficiently generate high-volume article ideas and drafts based on trends. SEO Specialists: Professionals who need to quickly create content based on the latest search keywords. ⚙️ How it Works & Features This workflow automates the entire editorial process: Automated Research: Scrapes top Google Search results for a specific keyword (e.g., "2025 AI Tools") using Apify. Multi-Angle Planning: GPT-4o analyzes the research and brainstorms article concepts from 3 different perspectives (e.g., "Beginner's Guide," "Critical Review," "Business Use Case"). Writing & Visualizing: For each concept, the AI writes a full article body in Markdown and DALL-E 3 generates a matching cover image. CMS Entry: Automatically saves the Title, Body Text, and Cover Image URL into a Notion database as a draft. Notification: Sends a completion report with links to the created Notion pages via Slack. 🛠 Setup Instructions Import: Copy the workflow JSON and paste it into your n8n editor. Credentials: Set up credentials for the following nodes: Apify: Required for the Google Search Scraper actor. OpenAI: Required for GPT-4o and DALL-E 3. Notion: Connect your account to access your database. Slack: Connect your account for notifications. Configuration: Open the Workflow Configuration node and set your desired Search Keyword. Notion Setup: Create a database in Notion (with properties for Title, Content, etc.). Crucial Step: Go to the Notion database page menu ... > Connect to and select your n8n integration to grant permission. Select this database in the Save Article to Notion node. Slack Setup: In the Send Completion Notification to Slack node, specify the target channel name (e.g., general). 📦 Requirements n8n Version: v1.0 or higher (recommended). Apify Account: Access to the apify/google-search-scraper actor. OpenAI Account: API access to GPT-4o and DALL-E 3. Notion Account: A workspace with a database. Slack Account: A workspace for receiving notifications. 🔧 Customization Change Keywords: Simply update the searchKeyword value in the Workflow Configuration node to target any topic (e.g., "Keto Diet," "Tech Gadgets," "Investment Trends"). Adjust Angles: Modify the System Prompt in the AI Editorial Meeting node to change the persona or angles (e.g., "Pros & Cons," "Global Reaction," "Tutorial"). Change Destination: You can replace the Notion node with a WordPress node to draft articles directly into your CMS. Scheduling: Update the Schedule Trigger node to run daily, weekly, or on specific days as needed.
by Gloria
What if AI didn't just write content—but actually thought about how to write it? This n8n workflow revolutionizes content creation by deploying multiple specialized AI agents that handle every aspect of blog writing—from research to publication-ready posts. The breakthrough? AI that creates its own prompts, dynamically adapting to different topics and business needs without constant human intervention. Plus, it doesn’t stop at writing — the system also scans all your website URLs, finds the best internal matches for each topic, and inserts SEO-optimized anchor links automatically. 🤖 The Self-Thinking Content System 🧠 Cognitive Content Creation: Unlike basic AI writing tools, this system thinks through the entire content strategy 🔄 Fully Automated Workflow: Set it up once and produce complete, SEO-optimized blog posts with minimal oversight 🎯 Industry-Adaptive Intelligence: Automatically tailors content approach based on your specific niche and audience 📊 Data-Driven Decisions: AI agents analyze search intent and competitive landscape before writing a single word ⚡ Modular AI Architecture: Specialized agents handle different stages of content creation for superior quality ⚙️ Workflow Breakdown 1️⃣ Keyword Research & Content Ideation Identifies high-value topics with traffic potential Analyzes search intent to match user expectations Maps content opportunities your competitors are missing 2️⃣ Dynamic Prompt Generation Revolutionary feature: AI creates its own writing instructions Customizes prompts based on topic complexity and audience needs Eliminates the need for prompt engineering expertise 3️⃣ Modular AI Writing Process Research Agent gathers comprehensive topic information Structure Agent creates logical, engaging outlines Writing Agent produces in-depth, authoritative content Each agent specializes in its role for maximum quality 4️⃣ Final Refinements Editing Agent polishes grammar, tone, and readability SEO Agent optimizes for search engines without sacrificing quality Fact-checking protocols ensure accuracy and credibility 5️⃣ Publication-Ready Output Delivers complete, formatted blog posts ready for immediate use Includes meta descriptions, title suggestions, and header structure Automatically organizes content in your preferred format 6️⃣ Smart Internal Linking Collects all URLs from your website automatically Identifies the best matching pages for each topic Inserts optimized anchor words with hyperlinks for SEO boost 🎯 Perfect For: Content Marketers who need consistent, high-quality output Business Owners looking to maintain an authoritative blog without the time investment Digital Agencies scaling content creation for multiple clients SEO Professionals focusing on quality content that ranks Solopreneurs who can't afford to spend days writing blog posts 📦 What's Included: ⚙️ Complete n8n Workflow: Pre-configured with all necessary nodes and connections 🌐 Internal Linking Function: Automatically matches your content with existing URLs and inserts SEO-friendly anchor words 🔌 AI Agent Configuration: Ready-to-use AI agent settings for each content creation stage 📊 Airtable Database Structure: Pre-built tables and fields specifically designed for content writing. Requires minimal human editing 🚀 Getting Started: Import the provided workflow into your n8n instance Configure your preferred AI provider credentials Set your content parameters and business information Trigger the workflow and watch as complete blog posts are generated Use immediately or make minor adjustments to match your style perfectly ⚡ Technical Requirements: Access to n8n (self-hosted or cloud) OpenAI API account (or alternative AI provider) Basic familiarity with workflow automation Optional: WordPress, Shopify or similar CMS for direct publishing integration This template is based on a video of Wayne Eagle 💡 You can also connect this workflow with my SEO Keyword Research Automation using DataForSEO and Airtable and my SEO-Based Keyword Categorization & Clustering Strategy Workflow with Airtable, both available on my profile, to build a fully automated, end-to-end SEO content machine. Stop spending countless hours writing blog posts or wasting money on mediocre content writers. Upgrade to an AI system that thinks for itself and produces truly exceptional content at scale.
by Daniel Lianes
Auto-generate SEO blog posts from Google Trends to WordPress This workflow provides complete blog automation from trend detection to publication. It eliminates manual content research, writing, and publishing by using AI agents, Google Trends analysis, and WordPress integration for hands-free blog management that scales your content strategy. Overview This workflow automatically handles the entire blog creation pipeline using advanced AI coordination and SEO optimization. It manages trend discovery, topic selection, content research, writing, HTML formatting, and WordPress publishing with built-in internal linking and comprehensive performance tracking. Core Function: Autonomous blog generation that transforms trending Google searches into SEO-optimized WordPress posts with zero manual intervention, maintaining consistent publishing schedules while capturing emerging traffic opportunities. Key Capabilities Automated trend detection** - Discovers emerging topics using Google Trends via SerpAPI before they become saturated AI-powered topic selection** - Intelligent evaluation of search volume, user intent, and competition levels Content research automation** - Perplexity API integration for reliable source gathering and fact verification SEO-optimized writing** - AI agents create keyword-focused, engaging content with proper structure Internal linking intelligence** - Automatic cross-linking with existing posts for enhanced SEO authority WordPress publishing** - Direct publication with semantic HTML formatting and complete metadata Performance tracking** - Comprehensive logging in Google Sheets for analytics and optimization Tools Used n8n**: Workflow orchestration platform managing the entire automation pipeline SerpAPI**: Google Trends data access and trend analysis for keyword discovery Perplexity API**: Reliable content research and fact-checking for authoritative sources OpenRouter**: Gateway to multiple AI models for specialized content generation tasks WordPress API**: Direct publishing integration with full metadata and formatting control Google Sheets**: Performance logging, internal link database, and analytics tracking Built-in SEO Logic**: Automated slug generation, meta descriptions, and HTML optimization How to Install Import the Workflow: Download the JSON file and import into your n8n instance Configure API Access: Set up SerpAPI, Perplexity, and OpenRouter credentials in n8n WordPress Integration: Add WordPress site credentials and enable REST API access Google Sheets Setup: Create tracking spreadsheet using provided template structure Schedule Configuration: Set desired publication frequency (daily, weekly, or custom) Content Customization: Adjust AI prompts and SEO parameters for your niche Test Execution: Run manual test to verify all integrations work correctly Use Cases Content Marketing Automation**: Maintain consistent blog publishing without manual content creation SEO Traffic Capture**: Generate optimized posts targeting trending keywords before competition Authority Building**: Regular publication on emerging topics to establish thought leadership Organic Growth Strategy**: Systematic content creation that builds domain authority over time Content Calendar Management**: Automated scheduling eliminates manual planning and publishing Internal Link Building**: Systematic SEO improvement through intelligent cross-linking strategy Setup requirements SerpAPI account**: For Google Trends data access and trend monitoring capabilities Perplexity API**: Professional content research and reliable source verification OpenRouter account**: Access to GPT-4.1 and other advanced AI models for content generation WordPress site**: With REST API enabled and proper user permissions configured Google Sheets**: For comprehensive performance tracking and internal link database management Total setup time: 15-20 minutes once all API accounts are properly configured. How to customize Content Focus: Modify trend detection parameters and keyword filters to target your specific niche. Adjust topic selection criteria based on your content strategy and audience interests. Writing Style: Customize AI writing prompts to match your brand voice, adjust article length requirements, modify tone and complexity, or update HTML template structure for consistent formatting. SEO Strategy: Update internal linking logic for your site structure, modify meta description templates, adjust keyword density parameters, or customize slug generation patterns. Publishing Control: Change automation frequency, add human review checkpoints, integrate with social media platforms, or connect to email marketing systems for content distribution. Performance Optimization: Adjust Google Sheets tracking columns, modify trend analysis parameters, or integrate with analytics platforms for deeper insights. Google Sheets Template The workflow includes a pre-configured Google Sheets template for tracking: Publication dates and performance metrics Target keywords and search volume data Internal link mapping and SEO improvements Content performance analytics WordPress URLs and metadata tracking Template Structure: Date Published | Title | Slug | Target Keyword | WordPress URL | Internal Links Added | Traffic Data Was this helpful? Let me know! I truly hope this automated blog system helps scale your content strategy. Your feedback helps me create better automation resources for the community. Want to take content automation further? If you're looking to optimize your content strategy or need custom automation solutions: Advisory (Discovery Call): Have content goals but unsure how automation can help? Let's explore how AI-powered workflows can transform your content pipeline and drive organic growth. Schedule a Discovery Call Custom Content Automation: Need a tailored solution for your specific content workflow, CMS integration, or multi-platform publishing strategy? Let's build the perfect automation for your needs. Book Content Automation Consulting Stay Updated on Automation For more content automation strategies, AI workflow tips, and business automation insights: Follow me on LinkedIn #n8n #automation #wordpress #seo #contentmarketing #ai #blogging #googletrends #serpapi #perplexity #workflow #contentautomation #seooptimization #aiwriting #blogautomation #digitalmarketing #contentcreation #organicgrowth #inboundmarketing #productivity
by Guillaume Duvernay
Go beyond basic AI-generated text and create articles that are well-researched, comprehensive, and credible. This template automates an advanced content creation process that mimics a professional writing team: it plans, researches, and then writes. Instead of just giving an AI a topic, this workflow first uses an AI "planner" to break the topic down into logical sub-questions. Then, it deploys an AI "researcher" powered by Linkup to search the web for relevant insights and sources for each question. Finally, this complete, sourced research brief is handed to a powerful AI "writer" to compose a high-quality article, complete with hyperlinks back to the original sources. Who is this for? Content marketers & SEO specialists:** Scale the production of well-researched, link-rich articles that are built for authority and performance. Bloggers & thought leaders:** Quickly generate high-quality first drafts on any topic, complete with a list of sources for easy fact-checking and validation. Marketing agencies:** Dramatically improve your content turnaround time by automating the entire research and first-draft process for clients. What problem does this solve? Adds credibility with sources:** Solves one of the biggest challenges of AI content by automatically finding and preparing to include hyperlinks to the web sources used in the research, just as a human writer would. Ensures comprehensive coverage:** The AI-powered "topic breakdown" step prevents superficial content by creating a logical structure for the article and ensuring all key aspects of a topic are researched. Improves content quality and accuracy:** The "research-first" approach provides the final AI writer with a rich brief of specific, up-to-date information, leading to more detailed and factually grounded articles than a simple prompt ever could. Automates the entire writing workflow:** This isn't just an AI writer; it's an end-to-end system that automates the planning, research, and drafting process, saving you hours of manual work. How it works This workflow orchestrates a multi-step "Plan, Research, Write" process: Plan (Decomposition): You provide an article title and guidelines via the built-in form. An initial AI call acts as a "planner," breaking down the main topic into an array of logical sub-questions. Research (Web Search): The workflow then loops through each of these sub-questions. For each one, it uses Linkup to perform a targeted web search, gathering multiple relevant insights and their source URLs. Consolidate (Brief Creation): All the sourced insights from the research phase are compiled into a single, comprehensive research brief. Write (Final Generation): This complete, sourced brief is handed to a final, powerful AI writer (e.g., GPT-5). Its instructions are clear: write a high-quality article based only on the provided research and integrate the source links as hyperlinks where appropriate. Setup Connect your Linkup account: In the Query Linkup for insights (HTTP Request) node, add your Linkup API key. We recommend creating a "Generic Credential" of type "Bearer Token" for this. Linkup's free plan is very generous and includes credits for ~1000 searches per month. Connect your AI provider: Connect your AI provider (e.g., OpenAI) credentials to the two Language Model nodes. For cost-efficiency, we recommend a smaller, faster model for Generate research questions and a more powerful, creative model for Generate the AI output. Activate the workflow: Toggle the workflow to "Active" and use the built-in form to enter an article title and guidelines to generate your first draft! Taking it further Control your sources:* For more brand-aligned or niche content, you can restrict the web search to specific websites by adding site:example.com OR site:anothersite.com to the query in the *Query Linkup for insights** node. Automate publishing:* Connect the final *Article result* node to a *Webflow* or *WordPress** node to automatically create a draft post in your CMS. Generate content in bulk:* Replace the *Form Trigger* with an *Airtable* or *Google Sheet** trigger to automatically generate a whole batch of articles from your content calendar. Customize the writing style:* Tweak the system prompt in the final *Generate the AI output** node to match your brand's specific tone of voice, add SEO keywords, or include calls-to-action.
by Easy8.ai
Auto-Generate SEO FAQ Answers from Google Sheets with OpenAI Intro/Overview This workflow automates the process of generating SEO-optimized FAQ answers using AI, pulling questions from a Google Sheet and writing answers back into the same sheet. It’s ideal for content marketers, SEO specialists, and digital teams looking to scale FAQ content generation with minimal manual input. By combining the power of Google Sheets, AI, and WordPress, the workflow transforms raw questions into structured, keyword-targeted answers tailored for specific audiences — ready for use on landing pages, blogs, or help centers, and automatically publishes them as WordPress posts. How it works Schedule Trigger**: Executes the workflow at a set interval to check for new or unprocessed questions in the Google Sheet. Get Questions from Sheet**: Reads from a specific Google Sheet, targeting columns for: Question (FAQ prompt) KW (target SEO keyword) Audience (intended reader) Article (desired WordPress post title) Filter**: Ensures only rows without an existing answer are processed (i.e., empty "Answer" column). Generate FAQ Answer**: Passes the question, keyword, and audience to the OpenAI Chat Model using a structured prompt to generate: A concise TL;DR-style summary A detailed, SEO-optimized markdown-formatted answer OpenAI Chat Model**: Utilizes GPT-4 Turbo with a controlled temperature (0.7) and token limit (1000) to produce structured, on-brand, keyword-optimized content. Parse FAQ Answer**: Extracts and formats the AI response into separate fields for writing back to the sheet. Update Sheet with Answer**: Writes the AI-generated answer into the Answer column of the same row in the source Google Sheet. WordPress Node**: Publishes each generated answer as a new WordPress post Uses “Create Post” operation Title: Taken from the Article column in the sheet Content: Uses the detailed AI-generated answer Requires valid WordPress credentials (REST API / Application Password) How to Use Importing the Workflow Download or import the workflow JSON into your n8n instance. Credential Setup Connect your Google Sheets credentials. Add your OpenAI API Key in the relevant node. Connect your WordPress credentials for content publishing. Node Assignment Update the following: Google Sheet ID Sheet range (ensure it includes all relevant columns) Timezone & Schedule Adjust the Schedule Trigger node to match your preferred time and frequency (e.g., every weekday at 9 AM). Testing Guidance Add a few sample FAQ entries in your sheet. Run the workflow manually to verify: Prompt quality Answer accuracy Proper sheet update Successful WordPress post creation Example Use Cases Marketing teams generating bulk FAQ content for landing pages SEO professionals creating keyword-optimized responses for user queries Agencies producing personalized FAQ sections for multiple client niches SaaS companies automating knowledge base content with targeted messaging Content teams publishing AI-generated FAQs directly to WordPress blogs Requirements ✅ Google Account with access to the target Google Sheet ✅ OpenAI API Key (GPT-4 Turbo or equivalent) ✅ WordPress account with REST API or Application Password access ✅ Google Sheet with the following columns: Question: The FAQ prompt KW: Target keyword for SEO Audience: Intended reader persona Article: Desired WordPress post title Answer: Output column (leave empty initially) Customization (Optional Section) Tone & Style**: Modify the system prompt to reflect your brand voice (e.g., friendly, expert, concise). Model**: Use a different AI model (e.g., Gemini, Claude, or OpenAI GPT-4.1). Output Format**: Adjust the markdown output to use different heading levels, bullet styles, or HTML if required. Audience Logic**: Expand the input options to fine-tune responses for more specific demographics or buyer personas. Multi-output Options**: Extend the workflow to post content to Notion, CMS, or documentation platforms alongside Google Sheets and WordPress. This automation accelerates content creation, automatically keeps your FAQ sections SEO-friendly, and publishes the results directly to WordPress — keeping your content pipeline running hands-free once deployed.
by Miftah Rahmat
Automate Water Bill Calculations with Telegram, Gemini AI, and Google Sheets This workflow automates the calculation of monthly water bills. Residents can send a photo of their water meter along with their name via Telegram. The workflow uses Gemini AI to extract the meter reading, calculates the usage difference compared to the previous month, and updates a Google Sheet with the billing details. Finally, the workflow sends a summary back via Telegram. Don’t hesitate to reach out if you have any questions or run into issues! 🙌 Requirements A Telegram bot token (created via BotFather). A Google account with access to Google Sheets. A Gemini API key (). A pre-created Google Sheet with the required columns. Google Sheet Setup Create a new Google Sheet with the following columns: Nama, Volume Sebelumnya, Volume Saat Ini, Harga/m³, Jumlah Bayar, Beban, Total Bayar, Tanggal Input Workflow Setup Instructions Connect Google Sheets Add your Google Sheets credentials in n8n. Link the workflow to your sheet with the structure above. Set Up Telegram Bot Create a Telegram bot via BotFather. Copy your bot token into the Telegram Trigger node. Configure Gemini AI Obtain a Gemini API key from Google AI Studio. Add it to your n8n credentials. The workflow will parse the meter reading from the uploaded image. Example Calculation Previous Volume: 535 m³ Current Volume: 545 m³ Usage: 10 m³ Price per m³: Rp3.000 Fixed cost: Rp3.000 Total Bill: Rp33.000 How It Works User sends a photo of the water meter with caption (name). Telegram Trigger receives the message. Gemini AI reads the meter number from the photo. Workflow fetches previous volume from Google Sheets. Usage and total bill are calculated. Data is stored back into Google Sheets. Bot replies in Telegram with detailed bill info. Customization Change Harga/m³ in the sheet to match your community’s water price. Update Beban if your community uses a different fixed fee. Edit the Telegram reply message node to adjust wording. With this workflow, you can streamline water billing for residents, ensure accuracy, and save time on manual calculations.
by PTS
Who this is for Anybody using Firefly III, especially home/self-hosted users, who want to add some level of automation to their transaction tracking, either in addition to or because they can't or don't want to use the dataimporter How it works - posting transactions User sends a transaction screenshot/image or statement to a Telegram bot Gemini analyzes it based on the user's requirements (asset account IDs & categories) The transaction information is parsed to create a suitable POST to a Firefly instance The transaction(s) are posted to Firefly via its API, using an OAuth2 credential How it works - requesting budget reports User sends the word 'Report' via telegram A 'GET' API request is sent to Firefly for all budgets between the beginning of the month and the request date, including remaining amounts for each This is converted to a CSV file The CSV is sent to the user via Telegram Prerequisites Telegram, and knowledge of how to set up a bot (search for BotFather in Telegram) An existing instance of Firefly III with admin access for creating OAuth2 credentials How to set it up - Credentials Open Telegram, and search for BotFather Create a new bot by following the instructions Save the API key provided In n8n, create a new Telegram credential using the info for the new bot Create an OAuth client in Firefly, using the redirect URL found in n8n's OAuth2 API credential creator Fill the n8n OAuth2 API credential form as Authorization Code, filling in the remaining parameters from the info created in Firefly Create a Gemini credential following the instructions in n8n How to set it up - the workflow Set the credential in each Telegram node Set the Firefly credential in each http node Set the correct base URL for the Firefly instance in each http node Set the desired Gemini credential and model in each AI node Set the correct Bank IDs (as per Firefly) and preferred categories in the AI node system message Customization options The user can specify all types of asset and expense accounts, as well as a specific list of categories and descriptions for Gemini to use. Gemini can also be swapped out for any other AI/LLM. Additionally, anyone can build on this by reviewing the Firefly API documents to automate almost any other part of the Firefly software.
by Cheng Siong Chin
Introduction Generates complete scientific papers from title and abstract using AI. Designed for researchers, automating literature search, content generation, and citation formatting. How It Works Extracts input, searches academic databases (CrossRef, Semantic Scholar, OpenAlex), merges sources, processes citations, generates AI sections (Introduction, Literature Review, Methodology, Results, Discussion, Conclusion), compiles document. Workflow Template Webhook → Extract Data → Search (CrossRef + Semantic Scholar + OpenAlex) → Merge Sources → Process References → Prepare Context → AI Generate (Introduction + Literature Review + Methodology + Results + Discussion + Conclusion via OpenAI) → Merge Sections → Compile Document Workflow Steps Input & Search: Webhook receives title/abstract; searches CrossRef, Semantic Scholar, OpenAlex; merges and processes references AI Generation: OpenAI generates six sections with in-text citations using retrieved references Assembly: Merges sections; compiles formatted document with reference list Setup Instructions Trigger & APIs: Configure webhook URL; add OpenAI API key; customize prompts Databases: Set up CrossRef, Semantic Scholar, OpenAlex API access; configure search parameters Prerequisites OpenAI API, CrossRef API, Semantic Scholar API, OpenAlex API, webhook platform, n8n instance Customization Adjust reference limits, modify prompts for research fields, add citation styles (APA/IEEE), integrate databases (PubMed, arXiv), customize outputs (DOCX/LaTeX/PDF) Benefits Automates paper drafting, comprehensive literature integration, proper citations
by Alexandru Burca
Daily News Digest Video Generator for YouTube Shorts Instalations Instructions Youtube Instalation Instructions Overview This workflow automatically creates and publishes daily news digest videos from WordPress articles to YouTube. It runs every evening at 7 PM, compiling the day's top stories from a news portal into a professionally formatted vertical video (1080x1920px) optimized for social media platforms like YouTube Shorts. What It Does 1. 🕐 Scheduled Trigger Runs automatically every day at 19:00 (7 PM) 2. 📰 Fetches Today's Articles Retrieves all published WordPress posts from the current day 3. ✅ Validates Content Ensures there are at least 3 articles before proceeding 4. 🎬 Video Detection Scans article content HTML for embedded videos Extracts MP4 URLs from WordPress video players Parses wp-playlist-script JSON data Falls back to ` and <source>` tag detection 5. 🧹 Data Processing Extracts** article titles, links, and featured media IDs Decodes HTML entities**: Converts – to –, " to ", etc. Fetches featured images** from WordPress Media API Assigns default images** for articles without featured media Calculates reading time** per article (3-7 seconds based on word count) Cleans text**: Removes HTML tags and normalizes whitespace 6. 🎥 Video Generation (via Shotstack API) Intro Slide (3 seconds) Black background Large logo (centered) Title on center Current date in DD-MM-YYYY format News Slides (3-7 seconds each) Each article is displayed with: Background**: Video (if available) or featured image, cropped to fit Dark overlay**: 40% opacity black layer for text readability Article headline**: Large white text at top Small logo**: Top-right corner Pagination counter**: Bottom-right white badge (e.g., "1 / 22") CTA button**: Centered CTA Background music**: Subtle looped audio track Transitions**: Smooth fade in/out between slides Outro Slide (3 seconds) Identical to intro slide Provides clean ending to the video 7. ⏳ Processing Wait Waits 30 seconds for Shotstack to render the video Polls Shotstack API to verify video completion 8. 📥 Download Video Retrieves the finished MP4 file from Shotstack Downloads video data for YouTube upload 9. 📤 YouTube Upload Automatically uploads to YouTube with: Title**: "Daily Digest - [Day] [Weekday], [Year]" Description**: Same as title Category**: News & Politics Made for kids**: Yes Tags**: dailydigest ✨ Key Features Intelligent Content Handling ✅ Automatic video/image detection and intelligent media selection ✅ Dynamic reading time calculation for optimal viewer engagement ✅ HTML entity cleaning for proper text display (WordPress compatibility) ✅ Fallback default images for articles without media ✅ Video background support with automatic muting Professional Video Production ✅ Vertical format optimized for mobile viewing (1080x1920px) ✅ Professional branding with logos and consistent styling ✅ Smooth fade transitions between slides ✅ Background music with looping support ✅ Dynamic pagination counters ✅ Call-to-action buttons for engagement Customization ✅ Centralized variables for easy branding updates ✅ Configurable logos, colors, and text ✅ Adjustable reading time calculation ✅ Flexible date formatting ✅ Customizable audio track 🎯 Use Cases Perfect for: 📰 News websites wanting to repurpose daily articles 📱 Media outlets creating social media content 🎥 Content creators automating video production 🔄 Publishers maximizing content distribution 📊 Marketing teams driving traffic from social platforms 🔧 Customization Options Easy Changes Update logos by changing logo_big and logo_small URLs Modify branding colors via button_bg_color variable Adjust button text with button_text variable Change video title with daily_digest_text variable Update background music by replacing audio URL Advanced Customization Adjust reading time formula in calculateReadingTime() function Modify date format in getRomanianDate() function Change video dimensions (currently 1080x1920) Update font family and sizes Adjust overlay opacity and colors Modify transition effects 📋 Prerequisites Required Credentials WordPress API - Access your WordPress site Shotstack API - API key for video rendering (Stage environment) YouTube OAuth2 - Authenticated YouTube account for uploads
by MUHAMMAD SHAHEER
Who’s it for This template is designed for creators, researchers, freelance writers, founders, and automation professionals who want a reliable way to generate structured, citation-backed research content without doing manual data collection. Anyone creating blog posts, reports, briefs, or research summaries will benefit from this system. What it does This workflow turns a simple form submission into a complete research pipeline. It accepts a topic, determines what needs to be researched, gathers information from the web, writes content, fact-checks it against the collected sources, edits the draft for clarity, and compiles a final report. It behaves like a small agentic research team inside n8n. How it works A form collects the research topic, depth, and desired output format. A research agent generates focused search queries. SERP API retrieves real-time results for each query. The workflow aggregates and structures all findings. A writing agent creates the first draft based on the data. A fact-checking agent verifies statements against the sources. An editor agent improves tone, flow, and structure. A final review agent produces the completed research document with citations. This workflow includes annotated sticky notes to explain each step and guide configuration. Requirements Groq API key for running the Llama 3.3 model. SERP API key for performing web searches. An n8n instance (cloud or self-hosted). No additional dependencies are required. How to set up Add your Groq and SERP API credentials using n8n’s credential manager. Update the form fields if you want custom depth or output formats. Follow the sticky notes for detailed configuration. Run the workflow and submit a topic through the form to generate your first research report. How to customize Replace the writer agent with a different model if you prefer a specific writing style. Adjust the number of search queries or SERP results for deeper research. Add additional steps such as PDF generation, sending outputs to Notion, or publishing to WordPress. Modify the form to suit industry-specific content needs.