DuyTran
Workflows by DuyTran
Create & publish inspirational videos with FFmpeg, Google Drive & YouTube
Auto Video Merge & Social Upload Automation An end-to-end workflow for generating, merging, and publishing short-form inspirational videos across YouTube, TikTok, Instagram, Threads, X, and Facebook. 📌 Overview: This workflow automates the entire video production and publishing pipeline. It takes random quotes, background videos, and background music from Google Sheets & Google Drive, merges them into a final video using an API, uploads the output to multiple social platforms, and updates the content tracking sheet automatically. Perfect for creators who publish motivational or short-form content daily. 🚀 Key Features 1. Trigger Options Manual Trigger – Generate videos anytime. Scheduled Trigger – Auto-generate videos every 5 minutes or at your preferred interval. 2. Source Data Collection The workflow retrieves content from Google Sheets & Google Drive: Quotes – From Quotes_status sheet Background Videos – From a Google Drive folder Background Music – From a Google Drive folder Each item is appended back into Sheets for status tracking. Nodes used: Retrieve Quote Data List Video Background Files List Music Background Files Retrieve Video Background Data Retrieve Music Background Data 3. Random Content Selection A Code node selects one random: Quote Video background Music track This ensures each final output video is unique. Node: Select Random Video, Music & Quote 4. Video Generation & Merging The workflow sends selected video + music URLs to an FFmpeg merge API: Initiates the video merge Continuously polls the status API until the job finishes Downloads the merged MP4 file Saves the final video locally (video1.mp4) Nodes: upload and gen video check status If Wait download video Save Final Video 5. Optional: Upload to TikTok / Instagram / X / Threads Disabled by default but preconfigured for: TikTok Instagram X (Twitter) Threads These nodes use upload-post.com API for multi-platform posting. Nodes (disabled): Upload Video and Description to Tiktok Upload Video to Instagram Upload Video to X Upload Video to Threads Each platform’s upload result is written back into Google Sheets: TiktokURL InsURL XURL ThreadsURL 6. Upload to YouTube (Enabled) The merged video is published to YouTube via the YouTube OAuth2 node. Generates title using filename Uses the quote as a description Uploads as a public YouTube Short Node: Upload to YouTube1 After uploading, the YouTube link is saved into the Google Sheet. 7. Google Sheets Status Update Once the workflow finishes uploading: Updates the row associated with the selected quote Mark status as DONE Stores YouTube / TikTok / Instagram / X / FB URL Nodes: Tiktok Update Quote Upload Status Update Instagram status Update X status Update FB status 8. File Upload to Google Drive The final MP4 is also stored back into a designated Google Drive folder. Node: Upload file 9. Telegram Notifications The workflow sends Telegram messages to notify: Merge status YouTube Upload ID Nodes: Send a text message 📁 Files Used Workflow JSON: /mnt/data/Video merge and upload Youtube.json 🧩 Ideal Use Cases Motivational video channels TikTok/Reels/Shorts content farms Automated inspirational quote pages Multi-platform social media distribution Zero-touch daily video generation 🌟 Summary This n8n workflow is a complete video-automation system. It builds an original video using randomized components, merges it through an external API, publishes it across multiple social platforms, and updates your content tracking sheet—all without manual effort.
Document Q&A chatbot with Google Drive, GPT-4-mini & Telegram (RAG system)
Description 📌 Overview This workflow creates a chat-based Retrieval-Augmented Generation (RAG) agent that lets you upload documents to Google Drive and then query them directly through Telegram. It uses embeddings, vector storage, and an AI agent to retrieve, analyze, and answer user questions with context-aware responses. 🧩 Key Features 📂 Google Drive Integration Watches a folder for new file uploads. Downloads and loads documents automatically into the system. 🔎 Vector Embeddings & Storage Uses OpenAI embeddings to transform documents into vectors. Stores them in an in-memory vector store for retrieval. 🤖 AI Agent with Memory Built on LangChain Agent + GPT-4.1-mini. Performs similarity search in the vector store. Provides contextual answers with citations from the uploaded documents. Maintains short-term conversation memory for better continuity. 💬 Telegram Bot Integration Users can send questions directly to the bot. AI agent retrieves relevant information and replies with clear answers. ⚙️ How It Works Trigger: Upload a file into the Google Drive folder. Processing: Workflow downloads the file → loads → embeds → stores in vector memory. Query: User sends a question via Telegram. Retrieval & Response: AI agent searches stored documents → analyzes results → returns summarized answer in Telegram. 🔐 Requirements Google Drive OAuth credentials. OpenAI API key (for embeddings + LLM). Telegram Bot API token. 📥 Use Cases 📑 Knowledge base assistant – Upload internal docs and query them in chat. 🏫 Learning support – Students upload study materials and ask questions. 📊 Business intelligence – Teams upload reports and get instant summaries. More templet: https://auton8n.pw/
Daily news summarization with OpenAI Perplexity AI delivered via Telegram
Overview This n8n workflow automatically fetches the latest news articles from multiple RSS sources, filters for the last 24 hours, summarizes them into a concise ~400-word digest in Vietnamese, and then delivers the result directly to Zalo and Telegram. It’s designed for professionals who need a quick, AI-curated overview of daily news without manually browsing multiple websites. 🧩 Key Features ⏰ Triggers Schedule Trigger: Run at specific times (e.g., morning briefing). Zalo & Telegram Triggers: Start workflow when requested via chat. 🌐 News Collection Fetches news from 4 RSS sources (RSS.app, Google News, etc.). Extracts standardized fields (title, pubDate, content). 🔍 Filtering & Processing Keeps only news published in the last 24h. Limits to 20 most recent items. Aggregates multiple feeds into one dataset. 🧠 AI Summarization Uses OpenAI Assistant to generate 15–19 highlights (~400 words). Translates into Vietnamese, removes special symbols. Optionally calls Perplexity AI to refine content into a financial–economic–political style summary. Maintains short-term context with Memory Buffer for improved output. 📲 Delivery Channels Sends digest directly to Zalo (personal & group chat). Sends digest to Telegram bot. ⚙️ Workflow Steps Trigger – schedule or chat command (Zalo/Telegram). RSS Fetchers (4 feeds) – collect news. Edit Fields – normalize title, date, and content. Merge & Filter – unify feeds, keep only last 24h. Limit & Aggregate – select top 20 articles. AI Summarization – generate digest via OpenAI + Perplexity. Delivery – send results to Zalo & Telegram. 🔐 Requirements ✅ RSS source URLs (already set in workflow). 🔑 OpenAI API key. 🔑 Perplexity API key. 📲 Zalo User API + Telegram Bot API credentials. 📥 Example Use Case A financial analyst or business leader wants a daily briefing in Vietnamese. At 7 AM, they automatically receive a curated 400-word digest via Telegram and Zalo. Can also trigger the report on-demand from chat. 🛠 Customization Options Add/remove RSS sources. Adjust summary length (short/medium/long). Output to other channels (Email, Slack, Notion). Change language from Vietnamese → English. ⚠️ Limitations RSS feeds must be valid & accessible. Summaries depend on AI quality and may vary slightly. Perplexity API requires active subscription. 📌 SEO Tags n8n workflow, rss news summarizer, daily news digest, telegram news bot, zalo ai assistant, openai news summary, perplexity ai, financial political economic news More template: https://auton8n.pw/
Generate multi-period financial reports from Google Sheets with AI analysis
Description: 1. Overview This workflow generates automated revenue and expense comparison reports from a structured Google Sheet. It enables users to compare financial data across the current period, last month, and last year, then uses an AI agent to analyze and summarize the results for business reporting. 2. Prerequisites A connected Google Sheets OAuth2 credential. A valid DeepSeek AI API (or replaceable with another Chat Model). A sub-workflow (child workflow) that handles processing logic. Properly structured Google Sheets data (see below). 3. Required Google Sheet Structure Column headers must include at least: Date, Amount, Type. 4. Setup Steps Import the workflow into your n8n instance. Connect your Google Sheets and DeepSeek API credentials. Update: Sheet ID and Tab Name (already embedded in node: Get revenual from google sheet). Custom sub-workflow ID (in the Call n8n Workflow Tool node). Optionally configure chatbot webhook in the When chat message received node. 5. What the Workflow Does Accepts date inputs via AI chat interface (ChatTrigger + AI Agent). Fetches raw transaction data from Google Sheets. Segments and pivots revenue by classification for: Current period Last month Last year Aggregates totals and applies custom titles for comparison. Merges all summaries into a final unified JSON report. 6. Customization Options Replace DeepSeek with OpenAI or other LLMs. Change the date fields or cycle comparisons (e.g., quarterly, weekly). Add more AI analysis steps such as sentiment scoring or forecasting. Modify the pivot logic to suit specific KPI tags or labels. 7. Troubleshooting Tips If Google Sheets fetch fails: ensure the document is shared with your n8n Google credential. If parsing errors: verify that all dates follow the expected format. Sub-workflow must be active and configured to accept the correct inputs (6 dates). 8. SEO Keywords: Google Sheets report, AI financial report, compare revenue by month, expense analysis automation, chatbot n8n report generator, n8n Google Sheet integration More template: https://auton8n.pw/product_info.php?cPath=5&sort=1a&products_id=13