Workflow Templates

Automate your payroll process with this efficient workflow. Triggered monthly on the 28th, it fetches employee data from a Google Sheet, uses AI to calculate net salaries with tax and deductions, structures payslip data, generates PDF payslips, and notifies employees via email while alerting HR on Slack. Ensure accurate payroll distribution with minimal manual effort. 💰📧 Good to Know The workflow runs on the 28th of each month to align with typical payroll cycles. Ensure AI credentials and Google Sheet access are configured for smooth operation. How It Works The Monthly Payroll Trigger initiates the process on the 28th. Gets Employee Data** by reading salary and deduction details from a Google Sheet. AI Calculates Salary** applies tax and deduction rules to compute net pay. Formats Payslip Data** prepares structured data for distribution. Generates PDF Payslip** creates individual payslip documents. Logs payroll data to a Google Sheet for records. Branches to: Sends Email Payslip to Employee with the PDF attachment. Notifies HR on Slack with payroll completion details. How to Use Use the manual trigger for testing, then set a monthly cron (e.g., 0 0 28 * *) for live runs on the 28th. Adjust tax and deduction rules in the AI node to match local regulations. Requirements GOOGLE_SHEET_ID**: Your Google Sheet ID (structured as below) Credentials Needed:** Google Sheets OAuth2 Gmail API Key OpenAI API Key (or similar) Slack Bot Token (with chat:write permissions) Customize:** • Employee data columns (e.g., ID, Name, Base Salary, Deductions) • Tax and deduction formulas • Email subject and Slack message format Google Sheet Structure: Create a sheet with columns: Employee ID Name Base Salary Deductions Net Salary Payslip Status Updated At Customizing This Workflow Adapt for bi-weekly payroll by adjusting the trigger to the 14th and 28th. Integrate with HR systems like BambooHR for real-time employee updates.

Cold Outreach Automation by Rysysth Technologies This n8n workflow automates the complete cold outreach process by combining Apollo.io lead generation, LinkedIn networking, and personalized email outreach into one streamlined system. How It Works Prospect Definition (Form Input) User enters job titles, company size, keywords, and locations. Apollo Search URL Generation OpenAI converts form inputs into a precise Apollo.io search URL. Lead Scraping (Apify) Apollo.io scraper collects contact details, emails, LinkedIn profiles, and company data (limited to 10 leads per run). LinkedIn & Company Data Enrichment (Unipile) Extracts LinkedIn profile and company details for each lead. CRM Sync (HubSpot) Automatically creates or updates lead records in HubSpot CRM. Personalized Outreach (AI-Powered) OpenAI generates: Custom LinkedIn connection request (under 300 characters) Email subject and body (personalized with a soft CTA) LinkedIn Connect If not already connected, workflow sends LinkedIn invites via Unipile. Email Validation (ZeroBounce) Ensures emails are valid or catch-all before outreach. Email Outreach (Gmail API) If verified, sends the AI-personalized outreach email directly from Gmail. Tools and APIs Integrated Apify** → Apollo.io scraper (lead extraction) Unipile** → LinkedIn profile enrichment and connection requests ZeroBounce** → Email verification OpenAI** → Apollo URL creation and outreach copy generation HubSpot** → CRM sync Gmail** → Automated outreach emails Key Benefits Saves time by automating manual prospecting and email writing Delivers personalized, multi-channel outreach at scale Ensures accurate CRM updates with HubSpot integration Improves email deliverability with ZeroBounce validation Designed for founders, sales teams, and agencies seeking efficient lead generation Connect with Rysysth Technologies At Rysysth Technologies, we build custom n8n workflows that go far beyond standard templates. From AI-powered prospecting to CRM automation and advanced outreach pipelines, we tailor automation solutions that align perfectly with your business goals. Let’s create your custom workflow together. Partner with Rysysth Technologies to transform your outreach process today. Website**: rysysthtechnologies.com Email**: getstarted@rysysthtechnologies.com LinkedIn**: linkedin.com/company/rysysth

🎁 Automate YouTube Giveaway Winner Selection with YouTube Comments Scraper API Description: Easily automate your YouTube video giveaways using n8n and the YouTube Comments Scraper API. This workflow fetches comments, selects a random winner, logs results to Google Sheets, and notifies the admin—all hands-free! 🧩 Node-by-Node Breakdown | Node | Name | Purpose | | ---- | -------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------- | | 1️⃣ | Form Trigger | Captures a YouTube video URL from a user via form submission. | | 2️⃣ | Fetch YouTube Comments | Makes a POST request to YouTube Comments Scraper API to retrieve comments. | | 3️⃣ | Check API Response Status | Ensures that the response status is 200 before proceeding. | | 4️⃣ | Select Random Commenter | Parses the comments and selects a random commenter as the giveaway winner. | | 5️⃣ | Log Winner to Google Sheet | Appends winner name, video URL, and date to a Google Sheet for record-keeping. | | 6️⃣ | Notify Winner Email | Sends a congratulatory email to the admin with the selected winner's name. | | 7️⃣ | Notify: Invalid API Response | If the API fails, sends an alert to the admin about the issue. | 🔑 How to Get Your RapidAPI Key To use the YouTube Comments Scraper API, follow these steps: Go to YouTube Comments Scraper API. Sign in or create a free RapidAPI account. Click the "Subscribe to Test" button. Copy your x-rapidapi-key from the "Code Snippets" or "Header Parameters" section. Paste it into your HTTP Request node in n8n. 🎯 Use Case & Benefits ✅ Use Case: Automatically pick a random commenter from a YouTube video as a giveaway winner. 🚀 Benefits: Fully automated** – no manual comment scanning or random selection. Accurate & fair** – random selection from valid commenters only. Time-saving** – especially for creators running multiple giveaways. Integrated logging** – keep a historical record of all winners in Google Sheets. Email alerts** – get notified whether the flow succeeds or fails. 👥 Who Is This For? YouTube Content Creators** running giveaways. Marketing Teams** promoting products via YouTube contests. Agencies** managing influencer campaigns. Developers & Automation Enthusiasts** looking to simplify giveaway processes. 💡 Why Use YouTube Comments Scraper API? The YouTube Comments Scraper API offers a simple and effective way to extract public YouTube comments programmatically. It’s fast, reliable, and integrates smoothly with platforms like n8n. You’ll use this API: To retrieve all comments from a YouTube video. To power fair and transparent giveaways. To trigger downstream automations like winner logging and notification. Create your free n8n account and set up the workflow in just a few minutes using the link below: 👉 Start Automating with n8n Save time, stay consistent, and grow your LinkedIn presence effortlessly!

Description: This workflow automates team capacity monitoring using Jira data to identify over-allocated team members and alert managers instantly. It ensures proactive workload management by fetching active issues, calculating utilization rates, logging capacity metrics, and sending detailed email alerts when members exceed 100% capacity. It helps project managers prevent burnout, balance workloads, and maintain operational efficiency — all with zero manual tracking. What This Workflow Does (Step-by-Step) 🟢 Manual Trigger – Start the capacity analysis manually on demand. 📋 Fetch Active Jira Issues – Retrieves all “In Progress” tasks from Jira to analyze workloads. ✅ Data Validation – Checks whether Jira returned valid data before continuing. True Path: Moves to capacity calculation. False Path: Logs query failure to error tracking sheet. 📊 Capacity Calculator – Aggregates logged hours per user and calculates utilization percentage based on an 8-hour daily capacity. 📈 Log Capacity Data to Tracking Sheet – Appends capacity metrics (Assignee, Total Hours, Utilization %, Status) to a Google Sheet for historical tracking and trend analysis. ⚠️ Over-Allocation Check – Identifies team members exceeding 100% utilization (status = “Overallocated”). 📢 Alert Report Generator – Builds a dynamic report summarizing all over-allocated members, their logged hours, utilization %, and corrective suggestions. Generates both alert and “All Clear” reports based on findings. 📧 Send Over-Allocation Alert to Manager – Sends an automated Gmail alert to the project manager, including severity-based subject lines and detailed breakdown of each over-allocated member. 🚨 Log Query Failures to Error Sheet – Records any Jira API or data retrieval issues in the “error log sheet” for monitoring and debugging. Prerequisites Jira account with API access Google Sheets for “Team Capacity Tracking” and “Error Log” Gmail credentials for automated email delivery Key Benefits ✅ Early detection of team over-allocation ✅ Automated data logging and historical tracking ✅ Real-time email alerts to prevent burnout ✅ Data-driven sprint planning and workload balancing ✅ Zero manual monitoring required Perfect For Project Managers and Scrum Masters tracking team load Engineering teams managing multiple active sprints Organizations looking to automate workload visibility HR and PMOs monitoring resource utilization trends

Curate daily tech news for Slack and Telegram using BrowserAct & OpenRouter This workflow automates the creation and delivery of a professional morning tech briefing. It scrapes headlines from major sources like The Verge and Product Hunt, uses parallel AI agents to format the content specifically for Telegram (HTML) and Slack (Markdown), and broadcasts the updates to your team or community channels. Target Audience Product managers, development teams, community managers, and tech enthusiasts who want a consolidated daily news digest without manual curation. How it works Daily Trigger: A Schedule Trigger starts the workflow every morning at 10:00 AM. Fetch News: A BrowserAct node executes a background task to scrape the latest headlines and links from defined sources (default: The Verge and Product Hunt). Parallel Formatting: The data splits into two paths: Telegram Path: The "Telegram Master" AI Agent formats the news into clean HTML, adding emojis and ensuring links work within Telegram's API constraints. Slack Path: The "Slack Master" AI Agent formats the same news into Slack-compatible Markdown, prioritizing developer tools and using Slack-specific syntax. Smart Splitting: Both AI agents automatically split the content into multiple message parts if the text exceeds the character limits of the respective platforms. Broadcast: The workflow iterates through the generated message parts and sends them sequentially to Telegram and Slack. How to set up Configure Credentials: Connect your BrowserAct, OpenRouter (for AI models), Telegram, and Slack accounts in n8n. Prepare BrowserAct: Ensure the Automated Multi-Site Morning Brief template is saved in your BrowserAct account. Configure Channels: Open the Send a text message (Telegram) node and enter your Chat ID. Open the Send a message (Slack) node and select your target channel. Activate: Turn on the workflow to start receiving daily briefs. Requirements BrowserAct* account with the *Automated Multi-Site Morning Brief** template. OpenRouter** account (or credentials for a specific LLM like Claude or Gemini). Telegram** Bot Token. Slack** account. How to customize the workflow Add News Sources: Update the BrowserAct node inputs to scrape different websites (e.g., Hacker News, TechCrunch). Change AI Persona: Modify the system prompts in the Telegram Master or Slack Master nodes to change the tone from "Professional" to "Casual" or "Sarcastic." Add More Platforms: Duplicate one of the formatting branches to create a version for Discord or Microsoft Teams. Need Help? How to Find Your BrowserAct API Key & Workflow ID How to Connect n8n to BrowserAct How to Use & Customize BrowserAct Templates Workflow Guidance and Showcase Video Keep Your Team Updated Automatically 🌅 n8n Morning Brief Workflow

Turn your Telegram bot into a real-time research assistant with this intelligent n8n workflow. Designed for founders, analysts, and knowledge workers, this automation uses Perplexity Sonar and Sonar Pro to deliver concise, citation-rich answers to complex queries — directly inside Telegram. 🔍 What It Does ✅ Smart Query Routing** Automatically selects the right tool based on query complexity — Sonar for fast lookups, Sonar Pro for multi-source synthesis. 📚 Cited Research Summaries** Includes clickable URLs from Perplexity’s source data for transparency and auditability. 🧠 Session Memory** Maintains chat context using Telegram chat ID for follow-up questions and threaded insight. 🔐 Secure Access Filter** Restricts bot usage to authorized Telegram users. ⚙️ Customizable Agent Behavior** Easily adjust tone, tool preferences, and citation style via system message. 🚀 Use Cases Market research & competitor analysis Academic and scientific deep-dives Legal and transcript summarization Podcast, video, and trend monitoring Personal AI assistant for founders and consultants 🛠 Setup Instructions Create a Telegram bot via @BotFather and add your token. Add your OpenAI and Perplexity API keys. Update the filter node with your Telegram user ID. Deploy and start chatting — responses appear in Telegram.

🔐 n8n Workflow: Access Control for Internal Chats or Chatbots This n8n workflow helps you restrict access to your internal chats or chatbots so that only authorized team members can interact with them. It's perfect for setups using Telegram, Slack, or other corporate messengers, where you need to prevent unauthorized users from triggering internal automations. 📌 Section 1: Trigger & Input ⚡ Receive Message (Telegram Trigger) Purpose: Captures every incoming message from a user interacting with your Telegram bot (or another messenger). How it works: When a user sends a message, it instantly triggers the workflow and passes their username or ID as input data. Benefit: Acts as the entry point for verifying whether a user is allowed to proceed. 📌 Section 2: Access Table Lookup 📋 User Access Table (Data Node / Spreadsheet / DB Query) Purpose: Stores all your team members and their current access status. Structure Example: | Username | Access Status | |----------|---------------| | user1 | granted | | user2 | denied | | user3 | granted | Benefit: Centralized access control — you can easily update user permissions without editing the workflow. 📌 Section 3: Permission Check 🧩 Check Access (IF Node) Purpose: Compares the incoming user's name or ID against the access table. Logic: If status = granted → Allow message to continue If status = denied → Stop workflow execution Benefit: Ensures only approved users can interact with your automations or receive responses. 📌 Section 4: Response Handling 💬 Send Reply (Telegram Node) Purpose: Sends a message back to the user depending on their access level. Paths: ✅ Granted: Sends the normal bot response or triggers the main process. ❌ Denied: Sends no reply (or an optional "Access denied" message). Benefit: Prevents unauthorized access while maintaining a seamless experience for approved users. 📊 Workflow Overview Table | Section | Node Name | Purpose | |---------|-----------|---------| | 1. Trigger | Receive Message | Captures incoming messages | | 2. Access Table | User Access Table | Stores usernames + permissions | | 3. Check | Check Access | Verifies if user has permission | | 4. Response | Send Reply | Sends or blocks response based on status | 🎯 Key Benefits 🔐 Secure access control: Only trusted users can trigger your internal automations. ⚙️ Dynamic management: Easily update user permissions from a table or database. 🧠 Lightweight setup: Just three nodes create a fully functional access gate. 🚀 Scalable foundation: Extend it with role-based access or activity logging later.

Transform your Telegram bot into a secure content analyzer: send any URL, and get safe, structured Q&A extractions with AI-powered safety checks and web search capabilities. 📋 What This Template Does This workflow activates when a user sends a valid URL to your Telegram bot. It extracts questions and answers from the webpage using Airtop, applies NSFW and PII guardrails to ensure safe content, then uses an OpenRouter AI agent (with optional Tavily search) to generate and send a concise response. If guardrails fail, it alerts the user instead. Filters for valid URLs only to prevent unnecessary processing Extracts structured Q&A from documents or forms Enforces safety checks for harmful or private content Supports web searches for enhanced responses when needed 🔧 Prerequisites A Telegram bot created via @BotFather Accounts with Airtop, OpenRouter, and Tavily 🔑 Required Credentials Telegram API Setup Open Telegram → Search @BotFather → Use /newbot command Follow prompts to create bot and obtain API token Add to n8n as Telegram API credential type Airtop API Setup Visit https://airtop.ai → Sign up or log in → Navigate to Dashboard → API Keys Generate a new API key with extraction permissions Add to n8n as Airtop API credential type OpenRouter API Setup Go to https://openrouter.ai → Sign up or log in → Navigate to API Keys section Generate and copy your API key (free tier sufficient for basic use) Add to n8n as OpenRouter API credential type Tavily API Setup Visit https://app.tavily.com → Sign up or log in → Go to API Keys Generate and copy your API key Add to n8n as Tavily API credential type ⚙️ Configuration Steps Import the workflow JSON into n8n Assign your Telegram, Airtop, OpenRouter, and Tavily credentials to the respective nodes Activate the workflow to register the Telegram trigger Test by sending a plain URL (no extra text) to your bot in Telegram Monitor the first execution and adjust guardrail thresholds if needed 🎯 Use Cases Researchers summarizing academic papers or reports while ensuring no sensitive data leaks Support teams extracting info from customer-submitted docs/forms with automatic safety filtering Content creators pulling Q&A from articles for bots, blocking inappropriate responses Educators analyzing educational resources safely for student-facing chat tools ⚠️ Troubleshooting No response from bot: Verify the message contains only a valid URL; adjust regex in Filter Only URLs node if needed Guardrail failures: Lower NSFW threshold (e.g., from 0.7 to 0.5) or disable PII checks in Apply Safety Guardrails node Extraction errors: Test with public, text-heavy URLs; some JS-heavy sites may require alternative extractors Rate limits hit: Check OpenRouter/Tavily dashboards for usage; upgrade to paid tiers for heavy traffic

Query personal finance data in Notion via Telegram and WhatsApp Who’s it for This workflow is for individuals who track their finances in Notion and want quick answers via chat. Entrepreneurs, freelancers, and professionals can use it to check expenses, income, or budgets instantly without opening Notion. How it works The workflow acts as an Accountant Agent powered by Claude AI through OpenRouter. When you send a query like “Total expenses for August 2025” through Telegram or WhatsApp, the agent identifies the right Notion database, applies filters, and retrieves the requested data. It then replies with a summarized result directly to your phone. How to set up Clone the Personal Finance System Notion template into your workspace. Create a Telegram bot with BotFather and collect the bot token and chat ID. Get an API key from OpenRouter. Create a Notion integration token and connect it with your duplicated finance template. Set up WhatsApp Business credentials via Meta (WABA ID, Phone Number ID, and permanent access token). Requirements n8n instance (self-hosted or cloud) Accounts on Telegram, OpenRouter, Notion, and WhatsApp Business Your duplicated Personal Finance System Notion template How to customize the workflow You can extend the workflow to handle assets, liabilities, or budgets. Add more Notion databases, adjust query filters, or configure WhatsApp templates for automated financial updates.

Add Upcoming Movies from TMDB to Your Google Calendar Via Telegram This n8n template demonstrates how to automatically fetch upcoming movie releases from TMDB and let users add selected movies to their Google Calendar directly from Telegram. How it works On a daily schedule, the workflow queries the TMDB API for upcoming movie releases. Each movie is checked against an n8n data table to avoid duplicates. New movies are stored in the data table for tracking. Movie details are sent to a Telegram chat with an inline “Add to calendar” button. When the button is pressed, the workflow retrieves the movie data from the table. A calendar event is created in Google Calendar using the movie’s release date. Use cases Tracking upcoming movie releases Personal or shared release calendars Telegram-based reminders for entertainment events Automating calendar updates from public APIs Requirements TMDB API access token Telegram bot token and user ID Google Calendar OAuth credentials One n8n data table for storing movie metadata

🚀 Telegram Google Trends Bot Workflow This workflow creates a powerful, multi-country Google Trends bot on Telegram. Users can request the top trending search queries for any country by simply sending its two-letter country code (e.g., EG, US, SA). The bot fetches the latest data, formats it into a clean report, and sends it back to the chat. ✨ Key Features 🌍 Dynamic Country Selection:** Get trends for any country on the fly by providing its geo code 📡 Automated RSS Fetching:** Pulls the latest data directly from Google's official daily trends RSS feed 📊 Clean, Formatted Reports:** Uses a custom code node to generate a beautiful, Markdown-formatted message that is easy to read on mobile 📈 Rich Information:** Each trend includes: 🔍 The search query title 📊 Approximate search traffic volume (e.g., "20K+ searches") 📰 Links to the top 2 related news articles, complete with their sources 🌟 Optimized for Arabic:** The report headers and labels are in Arabic, making it perfect for users in the MENA region, but can be easily adapted ⚙️ How It Works 💬 Telegram Trigger: A user sends a message containing a two-letter country code (e.g., EG) 🌐 HTTP Request: The workflow uses this code as the geo parameter in a request to the trends.google.com/trending/rss endpoint 📄 XML Parser: The native XML node converts the raw RSS feed data into a structured JSON format 💻 Code (Format Report): A JavaScript function processes the JSON data. It extracts the top 5 trends, formats the titles, traffic, and news items, and constructs the final Markdown text for the report 📤 Send to Telegram: The final, formatted report is sent back to the user who requested it 🛠️ Setup 🔐 Telegram Credentials: Add your Telegram API credentials to the Telegram Trigger and Send a text message nodes 🌐 (Optional) Customize Language: The text and labels in the Code node can be easily translated to any language you prefer

📄 What this workflow does Every 3 hours, the workflow fetches 3 random English words, asks Gemini to generate a short Vietnamese vocabulary digest (word, Vietnamese meaning, and an example sentence), and sends it to a Telegram chat. Perfect for steady, low-effort vocab exposure in groups. 👤 Who is this for English learners who want a gentle, automated learning cadence. Teachers/tutors who share daily vocab in Telegram groups. Community admins who want lightweight, useful content for members. Anyone who prefers bite-sized language learning on autopilot. ✅ Requirements Gemini API access (configured in n8n). Telegram Bot token + chat ID (the chat you want to receive messages). Internet access to Random Word API (no API key required). n8n instance with outbound HTTPS access. ⚙️ How to set up Add your Gemini credentials in n8n (the Google Gemini/PaLM node). Add your Telegram credentials and set the chatId in the “Send a text message” node. (Optional) Adjust the schedule interval (default: every 3 hours). (Optional) Change the number of words by updating the HTTP Request URL param words=3. (Optional) Edit the Gemini prompt language/content to fit your style (currently Vietnamese output). Run once to test; confirm the message arrives in Telegram. 🔁 How it works Schedule Trigger → runs every 3 hours. HTTP Request → calls random-word-api to get 3 words. Edit Fields (Set) → wraps the API response under word. Aggregate → prepares the word field for the LLM. Message a model (Gemini) → creates a Vietnamese digest: English word, Vietnamese meaning, and example sentence for each word. Send a text message (Telegram) → posts the digest to your specified chat. 💡 About Margin AI Margin AI is an AI-services agency that acts as your AI Service Companion. We design intelligent, human-centric automation solutions—turning your team’s best practices into scalable, automated workflows and tools. Industries like marketing, sales, and operations benefit from our tailored AI consulting, automation tools, chatbot development, and more.