Workflow Templates

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.

Who's it for Marketing teams, content creators, and agencies managing Webflow CMS sites who need to optimize SEO metadata at scale. How it works The workflow fetches CMS items from Webflow, then uses AI to rewrite titles and descriptions to meet SEO best practices (50-60 character titles, 120-155 character meta descriptions). It automatically publishes changes back to Webflow and logs all updates to Google Sheets for audit purposes. Requirements Webflow site with CMS collections MCP Webflow OAuth2 credentials Any LLM api Google Sheets for logging (optional) How to set up Get your collection ID: In Webflow, go to your CMS collection → copy the collection ID Update Set Fields node: Replace collectionId with yours Update Format for Update node: Replace collectionId Match field names: If your collection uses different fields than "name" and "project-summary", update the agent prompt and Format for Update code Test first: Set batch size to 1 and run on a single item Scale up: Increase batch size gradually How to customize Change character limits: Adjust minTitleLength, maxTitleLength, minSummaryLength, maxSummaryLength in Set Fields node. Add more fields like alt-text, post body, slug, etc. Different field names: Update agent system prompt, Structured Output Parser schema, and Format for Update code

What this workflow does This workflow automatically generates and publishes Instagram content using AI. It: Generates content ideas using AI Creates images automatically Edits images (resize/format) Publishes directly to Instagram How it works Trigger starts the workflow (manual or scheduled) AI generates a content idea and prompt Image is generated via API Image is processed and formatted Post is published automatically Setup Connect your OpenAI (or AI provider) credentials Add your image generation API key Connect your Instagram account (Optional) Connect Google Drive for storage Setup time: 15–20 minutes

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.

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.

Who’s it for This workflow is ideal for: Content creators producing daily historical or educational videos YouTube automation enthusiasts building AI-driven channels Educators sharing engaging historical facts in short-form video format Anyone creating an automated AI video pipeline with human approval How it works This workflow automates the full pipeline of generating and publishing historical videos: Triggers daily at 1 AM and initializes retry tracking (maximum 3 attempts) Fetches historical events for the current date and selects one randomly Uses Google Gemini to generate a cinematic text-to-video script Sends the prompt to fal.ai (Hunyuan LoRA) to generate a short video Polls the generation status every 30 seconds until the video is ready Downloads the generated video and sends it to Telegram with context Waits for manual approval via Telegram If approved → uploads the video to YouTube and sends a confirmation message If declined → retries with a new event (up to 3 attempts total) How to set up Import the workflow into n8n Configure your Telegram credentials Set your Telegram Chat ID using a variable or Set node (avoid hardcoding) Configure HTTP Header Auth credentials for fal.ai (API key required) Set up Google Gemini API credentials Connect your YouTube account using OAuth2 (Optional) Adjust the schedule time in the trigger node Activate the workflow Requirements n8n (cloud or self-hosted) fal.ai account and API key (for video generation) Google Gemini API access YouTube account with upload permissions Telegram account for approval notifications How to customize the workflow Adjust retry limits in the retry logic node Modify video parameters (resolution, frames, aspect ratio) in the fal.ai request Change the script style by editing the Gemini prompt Replace the historical events API with another content source Customize Telegram messages or approval flow

How it works Runs on schedule (Monday-Friday at 9 AM) to automate lead generation Searches for companies on Google Maps by location and category Extracts owner information from company websites and impressum pages Enriches leads with email addresses and LinkedIn profiles using Lemlist Generates personalized compliment messages using Claude AI Creates custom video messages with Pitchlane Uploads qualified leads to your CRM for follow-up Set up steps Configure Google Maps search parameters (location, category, search terms) Add Serper API credentials for Google Maps search Connect Lemlist for lead enrichment and upload Configure Pitchlane API credentials for video creation Set up Google Docs for documentation and notes Connect Claude AI for personalized message generation Adjust the schedule trigger time if you want a different time than 9 AM Keep detailed workflow notes in the sticky notes inside your workflow

Stop manually copy-pasting client data into Word templates. This workflow automates the entire invoicing process, handling complex line items, VAT calculations, PDF generation, and CRM syncing in under 20 seconds. It is designed to solve the "Admin Trap" by connecting your database (Airtable) to your document generator (Google Drive/Docs) via a Webhook trigger. ⚡ What this workflow does Receives Data: Listens for a Webhook (compatible with frontends like Lovable, Softr, or standard forms) containing the Client ID and a list of Services. Splits Line Items: Uses a "Split In Batches" logic to iterate through multiple services/products, ensuring every line item is recorded individually. Database Sync: Creates a parent "Invoice" record and links child "Service" records in Airtable. Generates PDF: Populates a Google Doc/Sheet template with dynamic client data and service rows, then exports it as a PDF. Files & Links: Uploads the PDF to a designated Google Drive folder and attaches the file URL back to the specific Invoice record in Airtable. 🛠 Setup Requirements 1. Airtable Base Structure You need three linked tables to make this work: Clients: Stores Address, VAT Number, and Email. Invoices: The master record containing Date, Total Amount, and the Invoice PDF attachment field. Services: Stores individual line items (Value, Units, VAT Amount) linked to the Invoices table. 2. Google Drive Template Create a Google Doc or Sheet. Use {{variable_name}} placeholders for Client Name, Address, and Invoice ID. Ensure you have a section for line items that matches the automation loop. 💡 Use Case Perfect for freelancers, agencies, and founders who want to trigger invoices from a dashboard or dropdown menu without manually calculating VAT or typing out addresses. 👋 Need help building this? Want to automate & scale your business? I help founders automate their "boring work" so they can focus on sales. https://www.linkedin.com/in/sergiomedinah/ https://sergio-medina.com/

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

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

🚀 Overview Transform your Telegram channel or group into a fully functional, automated e-commerce storefront. This n8n workflow template allows you to sell both physical and digital products directly within Telegram, utilizing Paystack for secure checkout and Google Sheets as a lightweight, free database for inventory and order management. Say goodbye to complex website builders and monthly subscription fees. With this serverless setup, you can launch a store in minutes and manage everything from a simple spreadsheet. ✨ Key Features 🛒 Interactive Shopping Cart:** Users can browse products, select quantities, and manage their cart entirely through seamless Telegram inline buttons. 💳 Secure Payments:** Direct integration with the Paystack API generates unique, secure checkout links for every order. 📦 Smart Fulfillment:** Automatically detects if an order is digital or physical. Digital goods (e.g., PDFs, E-books via Google Drive) are delivered instantly upon payment confirmation. Physical orders are marked as "Paid" and queued for shipping. 📊 Free Database (Google Sheets):** No SQL required! Manage your product catalog, track active user sessions, and view order history entirely within Google Sheets. 🔍 Order Tracking System:** Customers can use the /orders command or search by their unique ORD- ID to view their purchase history, resume pending payments, or track shipped items. ⚙️ Built-in Validation:** Includes robust data validation for email addresses (catching common typos like .con) and physical delivery addresses. 🛠 Prerequisites To run this template, you will need the following accounts: Telegram: A free Telegram Bot Token (obtained via BotFather). Paystack: A Paystack account to receive payments (you will need your Secret Key). Google Workspace: A Google account to host the Google Sheets database and Google Drive (if selling digital files). 📝 Setup Instructions 1. Database Setup Create a new Google Sheet (Template; https://docs.google.com/spreadsheets/d/1x58FYmsdo2K2dKNm81LgCSrGvHwhenkJTtjDIxc8-2w/edit?gid=187299608#gid=187299608 with three tabs: Products, Orders, and Session. Products Tab Headers: id, name, price, type (physical/digital), stock, description, file_url (optional, for digital goods). Orders Tab Headers: order_id, reference, user_id, email, address, items_json, total, status, payment_link, tracking, created_at. Session Tab Headers: user_id, chat_id, state, cart_json, selected_product_id, selected_product_name, selected_product_price, selected_product_type, input_quantity, input_email, input_address. 2. n8n Node Configuration Import this template into your n8n workspace. Update the Google Sheets credentials and replace the Document ID in all sheet nodes with your specific spreadsheet ID. Add your Telegram Bot Token via n8n's credential manager to activate the Telegram Trigger and messaging nodes. Locate the nodes containing the YOUR_PAYSTACK_SECRET_KEY placeholder (e.g., Paystack Init Transaction) and insert your actual Paystack Secret Key. 3. Webhook Activation Double-click the Paystack Webhook node. Copy the "Production URL" provided by n8n. Log into your Paystack Dashboard, navigate to Settings > Webhooks, and paste the URL. This ensures your bot receives real-time payment confirmations. 💡 Use Cases Digital Creators:** Sell e-books, courses, templates, or software directly to your Telegram audience with instant file delivery. Local Businesses:** Automate orders for physical goods, food delivery, or merchandise without needing a dedicated website. Dropshipping:** Seamlessly collect orders and addresses before forwarding them to suppliers. 🔗 Apps Integrated Telegram Paystack Google Sheets Google Drive (Optional) You can also test the workflow live on Telegram: @sellvia_paystack_bot or https://t.me/sellvia_paystack_bot) 👋 Need help or want to customize this workflow? 📺 Contact: Fiverr 📩 Consultation: Book Appointment

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.