by Oneclick AI Squad
This n8n workflow monitors blood stock levels daily and sends alerts when availability is low. It fetches data from a Google Sheet, checks stock status, and notifies via WhatsApp. Key Features Daily Monitoring**: Checks blood stock every day. Automated Alerts**: Sends notifications when stock is low. Real-Time Updates**: Uses live data from Google Sheets. Efficient Delivery**: Alerts sent instantly via WhatsApp. Continuous Check**: Loops to ensure ongoing monitoring. Workflow Process Daily Check Blood Stock: Triggers the workflow daily. Fetch Blood Stock: Reads data from a Google Sheet. Get All Stock: Collects all available blood stock details. Check Stock Availability: Analyzes stock levels for low thresholds. Send Alert Message: Sends WhatsApp alerts if stock is low. Sheet Columns Blood Type**: Type of blood (e.g., A+, O-). Quantity**: Current stock amount. Threshold**: Minimum acceptable stock level. Last Updated**: Date and time of last update. Status**: Current status (e.g., Low, Sufficient). Setup Instructions Import Workflow**: Add the workflow to n8n via the import option. Configure Sheet**: Set up a Google Sheet with blood stock data. Set Up WhatsApp**: Configure WhatsApp API credentials in n8n. Activate**: Save and enable the workflow. Test**: Simulate low stock to verify alerts. Requirements n8n Instance**: Hosted or cloud-based n8n setup. Google Sheets**: Access with stock data. WhatsApp API**: Integration for sending alerts. Admin Access**: For monitoring and updates. Customization Options Adjust Threshold**: Change low stock limits. Add Channels**: Include email or SMS alerts. Update Frequency**: Modify daily trigger time.
by Calvin Cunningham
AI-Assisted Lead Follow-Up With Human Approval This workflow automates your lead response process from end to end. When someone submits your n8n Form, the workflow generates an AI-written follow-up email, sends that draft to your sales team for approval, and then sends the approved email to the lead or marks it as needing revision. All lead details, drafts, approval decisions, and timestamps are stored in Airtable. Ideal For Teams that want AI to draft emails while keeping a human approval step Businesses receiving inbound inquiries that need fast, consistent responses Users building a simple form → email → CRM workflow Teams that want a record of all drafts and approval outcomes What This Template Provides AI-generated follow-up email drafts Human approval flow, using Approve and Reject links Automatic Airtable logging of leads, drafts, and statuses Fully automated pipeline triggered by a simple form submission Setup Steps (5–10 minutes) Connect Your Credentials Gmail Airtable OpenAI Create Your Airtable Table Use the following fields: Name Email Phone Company Name Message Status Email Draft Created On Add Your Airtable Base ID and Table ID Insert them into the Workflow Configuration node. Enter Your Company Details Add your: Name Title Company name Email Phone number Website Etc. These values will appear in the final approved email sent to the lead. Set the Sales Approval Email Specify the email address where draft approval requests should be sent. Deploy the Approval Webhook Switch the Webhook node to the Production URL, and confirm that the Approve and Reject links point to it. Publish Your n8n Form Submit a test lead to verify: AI draft generation Approval email delivery Airtable logging Final email sending Why Use This Template? This workflow creates a reliable, semi-automated follow-up process that blends AI speed with human judgment. It ensures consistent communication, maintains accurate CRM records, and reduces manual work without requiring a full CRM platform.
by Meelioo
How It Works Monitors Reddit:** Automatically searches specified subreddits for posts matching your keywords or flair filters (template is n8n - Now Hiring flair) AI Analysis:** Processes found posts using AI to create personalized summaries based on your custom prompts Smart Filtering:** Tracks previously sent posts in Google Sheets to avoid duplicate notifications Telegram Delivery:** Sends AI-generated summaries directly to your Telegram chat Set Up Steps Time required: ~15-20 minutes Configure Credentials (10 mins):** Set up Telegram bot token, Reddit app credentials, and Google Sheets access Customize Search Parameters (3 mins):** Define target subreddit, keywords/flairs, and post limits Personalize AI Settings (2 mins):** Adjust AI model and system prompts for your preferred summary style Set Schedule & Chat (2 mins):** Choose monitoring frequency and configure your personal Telegram chat ID >The workflow includes detailed setup instructions and configuration guidance in the sticky notes within the template.
by David Hernández Luján
Who’s it for This workflow is for system administrators or self-hosted n8n users who want to automatically check and update their n8n instance to the latest version — with Telegram notifications for every step. How it works The workflow runs daily at 9 AM or every time n8n starts. It retrieves your current version using the Execute Command node. It checks the latest release from the official n8n GitHub API. It compares both versions and decides whether an update is needed. If an update is available: Sends a Telegram alert. Verifies that there are no running executions. Runs the update command safely. Sends a confirmation message when done. If your instance is already up to date, it sends a “latest version” message instead. Requirements Self-hosted n8n** instance with access to run terminal commands. A valid Telegram Bot API credential (configured in n8n Credentials; not hardcoded). SSH credentials** To run commands on the server where n8n is installed n8n API credentials** To query running executions How to set up Import this workflow into your n8n instance. Connect your Telegram Bot credential to the Telegram nodes. Adjust the chat ID and message thread ID if needed. (Optional) Change the schedule time in the Schedule Trigger node. Save and activate the workflow. How to customize Change the update command if you’re running n8n via Docker: docker pull n8nio/n8n:latest
by Mehedi Ahamed
📌 Overview This workflow allows users to send any newspaper or article link to a Telegram bot. The workflow then: Validates the URL Scrapes the webpage (title, description, full text, images, OG metadata) Processes it using a Vision-Language Model (VLM) Generates structured summaries & highlights Downloads images (if available) Sends a formatted report + document back to Telegram Stores the summary in a vector database Allows users to chat with the article using semantic search Perfect for: ✔ News researchers ✔ Students ✔ Journalists ✔ Telegram-based AI assistants ✔ Automated media monitoring 🧠 What the Workflow Does 1. Telegram Trigger Listens for messages from the user. Detects if the message contains a valid link. 2. URL Scraper A custom n8n Code node fetches the webpage and extracts: Meta description paragraph text All image sources Open Graph metadata (og:title, og:image) Returns everything as structured JSON. 3. VLM Run – Highlighter A Vision-Language Model analyzes the scraped content and outputs: { "news_summary": { "headline": "", "source_url": "", "published_date": "", "key_points": "", "summary": "", "extracted_images_url": "" } } 4. Image Validation & Download Checks if image URLs are valid. Downloads them (if any). Sends them to Telegram as documents. 5. Summary File Generation Converts VLM output into a .txt report. Sends the report back to the user. 6. Vector Store + Q&A Agent Converts the summary into embeddings. Stores the vector in an in-memory store. Provides the user with a chat interface: Ask anything about the newspaper article. The AI agent retrieves information using the vector store. 📤 Outputs You receive: ✔ Telegram message summary ✔ Downloadable summary .txt file ✔ Extracted images (if available) ✔ Chat-based Q&A agent to explore the newspaper details 🚀 Use Cases News summarization bots Media intelligence agents Educational news explorers Topic-based daily digest creators
by Budi SJ
YouTube Comment Sentiment & Keyword Extractor Template Google Sheets: Click here to open This workflow automatically retrieves comments from YouTube videos listed in Google Sheets, analyzes sentiment and keywords using an LLM, stores the results, then generates an aggregate summary and sends a report to Telegram. ✨ Key Features Automated Scheduling** – Runs the process at regular intervals. Google Sheets Integration** – Fetches a list of videos and stores analysis results directly in Google Sheets. YouTube Comment Retrieval** – Retrieves top-level comments (up to 100 per video; can be extended with pagination). Comment Parsing** – Flattens the API response into one item per comment. AI Sentiment & Keyword Analysis** – Powered by an LLM model to extract: Sentiment (positive, neutral, negative) Sentiment score (-1 to 1) Keywords (cleaned from stopwords, emojis, hashtags) Language (ISO 639-1, 2-letter code) Data Normalization** – Ensures LLM output is consistent and safe to write to the sheet. Telegram Reporting** – Sends a concise report for each video directly to a Telegram chat. 🔐 Required Credentials Google Sheets OAuth2 API** – Read & write access to the spreadsheet. YouTube Data API Key** – To fetch comments via commentThreads. OpenRouter API Key** – To access the LLM model. Telegram Bot API** – To send reports via a Telegram bot. 🎁 Benefits End-to-End Automation** – From comment retrieval to reporting, no manual steps required. No Duplication** – Each comment is uniquely tracked by comment_id. Data Transparency** – Raw and analyzed data stored neatly in Google Sheets. Actionable Insights** – Sentiment and keyword summaries ready for content strategy decisions. Scalable** – Can be extended for pagination, reply comment analysis, or additional metrics. Cross-Platform** – Direct Telegram integration for easy monitoring on any device.
by Kirill Zolygin
This Telegram workflow batches rapid-fire messages from the same user into one prompt (20–30s debounce), then sends a single AI reply. It uses two Google Sheets: Message Retention** (date | user_id | message) — queues incoming messages. Message Checkup** (user_id | is_waiting | last_updated) — debounces per user. Flow per message: Log to Message Retention. Read Message Checkup for that user_id. If empty, synthesize { is_waiting:false }. IF (OR): last_updated is older than 30s, or is_waiting is false → Start wait window: set is_waiting=true, update last_updated, Wait (e.g., 30s). After Wait: fetch all queued messages for the user, merge them, delete those rows, send one AI answer to Telegram, then clear the Waiting row. If a new message arrives while waiting, we only refresh last_updated (extend the window) — we do not start another wait. Copy/paste: Older-than-30s: {{ new Date(Date.now() - 30000).toISOString() }} “No Rows” normalizer (Code node) ensures the IF always has data to check. Supports text and voice (voice via Whisper). Works reliably on Telegram once the webhook is registered and Sheets are shared with the service account.
by Sabrina Ramonov 🍄
Description This automation detects when you post a Tiktok video, automatically downloads the video without watermark, stores it in Google Drive, and reposts your Tiktok video to other social media platforms. All on autopilot. So you can grow your presence on multiple platforms, without more work. You can also easily add steps to customize captions per platform. Youtube Tutorial https://www.youtube.com/watch?v=yHbyEb-fBGY 📄 Documentation Full Step-by-Step Documentation How It Works 1. Trigger RSS feed triggers when you post a new Tiktok video 2. Fetch Video Download the newly posted Tiktok video (without watermark) Store video in Google Drive 3. Publish to Social Media Connect Blotato to your social accounts Choose your social accounts Post immediately or schedule for later Setup & Required Accounts Enable "Verified Community Nodes" in your n8n Admin Panel Install "Blotato" verified community node Sign up for Blotato: create API key at Dashboard → API Keys, then create your Blotato credential and connect your social accounts Sign up for RSS.app: create feed from your TikTok profile, copy RSS URL into the RSS Feed Trigger node, and set "Number of Posts" to 1 Google Drive account to store downloaded Tiktok videos Tips & Tricks Ensure your RSS feed outputs only 1 item at a time For multiple posts within an hour, set RSS.app refresh to 15 minutes (paid plan) While testing: enable only 1 social platform, deactivate others, and consider scheduling posts in the future After the workflow finishes, check your social account for the final post; if successful, enable another social media node and continue testing Troubleshooting Check your Blotato API Dashboard to see every request, response, and error. Click on a request to see the details. Need Help? In the Blotato web app, click the orange button on the bottom right corner. This opens the Support messenger where I help answer technical questions. Connect with me: Linkedin | Youtube
by Rakin Jakaria
Who this is for This workflow is for Amazon affiliate marketers and social media managers who want to quickly turn product links into engaging Facebook posts with AI-generated captions and images — fully automated. What this workflow does This workflow starts every time a new Product Link is added to a connected Google Sheet. It then: Extracts the ASIN** from the product link. Fetches product details** from Amazon using RapidAPI. Generates a short, scroll-stopping Facebook caption** with OpenRouter AI. Creates a product image prompt** and sends it to Google Gemini for high-quality image generation. Uploads the creative directly to Facebook** via the Facebook Graph API. Marks the Google Sheet row** as “Done ✅” after posting. The Facebook post includes: Product image (AI-enhanced) Short, benefit-focused caption with emojis Affiliate link Setup To set this template up, follow the sticky notes inside the workflow and: Google Sheets → Connect your sheet and ensure the columns “Product Link” & “Facebook Upload” exist. RapidAPI → Add your API key in the “Amazon Product Details” node. OpenRouter → Add credentials for caption generation. Google Gemini → Add your API key for image generation. Facebook Graph API → Connect your Facebook account for posting. How to customize this workflow to your needs Change the Facebook caption prompt to match your tone or branding. Adjust the AI image generation prompt to fit your preferred photography style. Modify the Google Sheet update logic if you want to track additional info (e.g., posting date, engagement stats). Switch Facebook posting to Instagram or another platform by replacing the final API call.
by Avkash Kakdiya
How it works This workflow listens for new products in Shopify and transforms the product data into polished social media content. It generates captions and hashtags using an AI model, then posts the product to Instagram and Facebook using the Facebook Graph API. It logs every post to Google Sheets and sends a confirmation message to Discord. The flow ensures consistent publishing across all platforms with automated formatting and tracking. Step-by-step Trigger on Shopify product creation** Shopify Trigger – Activates when a new product is added to the store. Prepare product data** parse product data – Extracts product name, price, description, URL, image, and timestamp. Generate caption and hashtags** Generate caption and hashtags – Uses an AI model to craft a caption and produce 10 relevant hashtags. Configure posting parameters** Set Configuration – Stores access tokens, platform IDs, caption text, hashtags, and image URL. Publish to Instagram** Create Instagram Media Container – Sends the image and caption to create a media container. Wait for Processing – Waits for the container to finish processing. Publish Instagram Media – Publishes the processed container to the Instagram feed. Publish to Facebook** Download Image for Facebook – Downloads the product image from Shopify. Post to Facebook Page – Uploads the image with the caption and hashtags to the Facebook Page. Merge publishing results** Merge – Combines responses from Instagram and Facebook for unified logging. Log post to Google Sheets** Log Product Post Data – Appends product info, caption, and hashtags to a spreadsheet. Notify via Discord** Notify Discord About Post – Sends a message summarizing the published product. Why use this? Ensures every new Shopify product is promoted instantly across major social platforms. Eliminates manual posting and caption creation with reliable automation. Maintains centralized logging for auditing, tracking, or analytics. Provides real-time team notifications to confirm successful posts. Reduces errors and keeps brand messaging consistent across channels.
by Nadia Privalikhina
This n8n workflow automates the entire content creation and publishing pipeline for engaging, AI-generated visual stories, ensuring image and video quality with human-in-the-loop approvals. What it does: It takes a narrative concept (e.g., 'A Day in the Life of a Serene Skeleton') and transforms it into a series of unique images and videos, which are then published across multiple social media platforms. How it works: Creative Conceptualization: An AI 'Creative Director' develops a detailed narrative, including scenes, moods, and character details. Prompt Engineering: An AI 'Creative Technician' translates the narrative into precise text-to-image and text-to-video prompts, maintaining a consistent artistic style, lighting, and character appearance. AI Asset Generation: Replicate's AI models (Qwen-Image for images and Seedance-1-Lite for videos) create the visual content from these prompts. Human-in-the-Loop Approval: Generated images and videos are sent to Slack for manual review. Users can approve or request regeneration, ensuring creative control and quality. Multi-Platform Publishing: Approved content is automatically published via Blotato to Instagram and Facebook (videos), and TikTok (image slideshows), ready for your audience. Technical Requirements: Replicate Account with Balance: For image and video generation (using Qwen-Image and Seedance-1-Lite). Blotato Subscription: For seamless publishing to multiple social media platforms. OpenRouter Account with Balance: To access various Large Language Models (LLMs) like Gemini 2.5 Flash for creative direction and prompt generation. Slack Account: For the human-in-the-loop approval process. Customization Potential: This workflow serves as a robust foundation that can be easily adapted for various use cases beyond story narratives, such as: Automating product publishing with AI-generated visuals and descriptions. Creating dynamic advertising content for campaigns. Generating personalized visual content for marketing. Scaling content creation for personal or e-commerce brands. Why use it? Ideal for content creators, marketers, and businesses seeking to scale their visual content production, maintain creative control through human oversight, and automate distribution (with scheduling option) to key social media channels (Instagram, Facebook, TikTok, X, Pinterest, YouTube, and more). Customize the initial story brief to unleash endless themed narratives tailored to your brand.
by jason
Nathan is a proof of concept framework for creating a personal assistant who can handle various day to day functions for you.