Workflow Templates

5 nodes

AI-Powered Bank Statement Analysis & Transaction Categorization

by vinci-king-01

How it works This workflow automatically processes bank statements from various formats and extracts structured transaction data with intelligent categorization using AI. Key Steps File Upload - Accepts bank statements via webhook upload (PDF, Excel, CSV formats). Smart Format Detection - Automatically routes files to appropriate processors (PDF text extraction or spreadsheet parsing). AI-Powered Extraction - Uses GPT-4 to extract account details, transactions, and balances from statement data. Data Processing & Categorization - Cleans, validates, and automatically categorizes transactions into expense categories. Database Storage - Saves processed data to PostgreSQL database for analysis and reporting. API Response - Returns structured summary with transaction counts, expense totals, and category breakdowns. Set up steps Setup time: 8-12 minutes Configure OpenAI credentials - Add your OpenAI API key for AI-powered data extraction. Set up PostgreSQL database - Connect your PostgreSQL database and create the required table structure. Configure webhook endpoint - The workflow provides a /upload-statement endpoint for file uploads. Customize transaction categories - Modify the AI prompt to include your preferred expense categories. Test the workflow - Upload a sample bank statement to verify the extraction and categorization process. Set up database table - Ensure your PostgreSQL database has a bank_statements table with appropriate columns. Features Multi-format support**: PDF, Excel, CSV bank statements AI-powered extraction**: GPT-4 extracts account details and transactions Automatic categorization**: Expenses categorized as groceries, dining, gas, shopping, utilities, healthcare, entertainment, income, fees, or other Data validation**: Cleans and validates transaction data with error handling Database storage**: PostgreSQL integration for data persistence API responses**: Clean JSON responses with transaction summaries and category breakdowns Smart routing**: Automatic format detection and appropriate processing paths

Score and route qualified leads to Notion and Matrix

by vinci-king-01

Lead Scoring Pipeline – Matrix + Notion This workflow automatically enriches incoming form leads, applies a customizable scoring model, then routes high-value prospects to a Notion CRM database and a Matrix channel for instant sales notification. It streamlines lead qualification by combining third-party enrichment APIs, conditional logic, and asynchronous batching—eliminating manual research and ensuring your sales team focuses on the best opportunities. Pre-conditions/Requirements Prerequisites n8n instance (self-hosted or n8n cloud) ScrapeGraphAI community node installed Matrix community node installed Notion Integration (internal integration or Notion OAuth) Active third-party enrichment/validation APIs (e.g., Clearbit, Hunter, Kickbox) for scoring data A Notion database set up as your “Leads” table with fields: Name, Email, Company, Score, Status, Enrichment Required Credentials ScrapeGraphAI API Key** – For optional web-scraping based enrichment Notion OAuth2 / Integration Token** – To create & update pages in your CRM database Matrix Username & Password** – For sending room messages (Optional) Third-party API Keys** – Clearbit, Hunter, etc. Additional Setup Requirements | Setting | Example / Notes | |---------------------------------|----------------------------------------------------------| | Notion Database ID | 8f3d49e8c8f74e6f9d32e8e2bf7c1c46 | | Matrix Room ID | !aBcDeFgHiJ:matrix.org | | Scoring Threshold (env var) | LEAD_SCORE_MIN=70 | | Batch Size | SPLIT_IN_BATCHES=10 (controls parallel requests) | | Webhook URL for form submission | https://your-n8n-instance/webhook/leads | How it works This workflow automatically enriches incoming form leads, applies a customizable scoring model, then routes high-value prospects to a Notion CRM database and a Matrix channel for instant sales notification. It streamlines lead qualification by combining third-party enrichment APIs, conditional logic, and asynchronous batching—eliminating manual research and ensuring your sales team focuses on the best opportunities. Key Steps: Schedule / Webhook Trigger**: Starts on a schedule (daily) or via a form-submission webhook. Split in Batches**: Processes leads in manageable chunks to avoid rate limits. HTTP Requests**: Calls enrichment APIs (Clearbit, Hunter, etc.) to retrieve firmographic & technographic data. Code (Scoring Logic)**: Calculates a numeric lead score using weighted criteria (industry, employee count, email validity, etc.). If Node (Qualification)**: Checks if the computed score meets or exceeds the defined threshold. Notion Node**: Inserts or updates the qualified lead record in your Notion CRM database. Matrix Node**: Sends a rich-text message to the sales room with lead details and score. Wait + Merge**: Handles asynchronous API limits and merges enrichment data back into the main flow. Set up steps Setup Time: 15-25 minutes Clone the template in your n8n instance or import the JSON. Set environment variables (LEAD_SCORE_MIN, SPLIT_IN_BATCHES, API keys) in n8n Settings → Variables. Configure the Webhook/Schedule Trigger Webhook: copy the URL to your form provider Schedule: set cron (e.g., every hour). Update HTTP Request nodes with your enrichment API endpoints & headers. Map Notion fields: open the Notion node → choose your connection → select your Leads database → map data pins (Name, Email, etc.). Enter Matrix credentials & Room ID in the Matrix node. Adjust scoring weights in the Code node (weights object) to match your ICP (Ideal Customer Profile). Execute the workflow once with test data, verify Notion rows and Matrix messages. Activate the workflow and monitor via n8n’s execution list. Node Descriptions Core Workflow Nodes: Schedule Trigger / Webhook** – Initiates the workflow on time-based interval or form submission. SplitInBatches** – Limits API calls to avoid hitting rate caps. HTTP Request (Enrichment)** – Queries external services for company, domain, and email data. Set (Normalize)** – Formats API responses for scoring. Code (Score Calculator)** – JavaScript that assigns points based on business rules. If (Score ≥ Threshold?)** – Branches leads into “Qualified” or “Discard” paths. Notion (Create/Update Page)** – Inserts the qualified lead into Notion database. Matrix (Send Message)** – Notifies the sales team with lead context. Merge (Rejoin Streams)** – Consolidates asynchronous branches before completion. Sticky Note** – Documentation & config hints embedded directly in the canvas. Data Flow: Schedule/Webhook → SplitInBatches → HTTP Request (Enrichment) → Set → Code (Score) → If (Qualified?) → a. (Yes) Notion → Matrix b. (No) Wait (Cooldown) → Merge Customization Examples 1. Change Scoring Weights // Code node snippet const weights = { employeeCount: 0.4, // increase influence of company size emailDeliverability: 0.2, industryMatch: 0.25, techStack: 0.15, }; 2. Notify Different Matrix Rooms Based on Territory // If node expression {{ $json.country === 'US' ? '!usSales:matrix.org' : '!intlSales:matrix.org' }} Data Output Format The workflow outputs structured JSON data: { "name": "Jane Doe", "email": "jane@acme.co", "company": "Acme Co.", "enrichment": { "employeeCount": 120, "industry": "SaaS", "techStack": ["AWS", "React"] }, "score": 83, "qualified": true, "notionPageId": "9b2a4c09-0bf4-4b58-988a-1f361b0a2c20", "matrixEventId": "$15163622445EBvZJ:matrix.org" } Troubleshooting Common Issues Low or zero scores for valid leads – Review weighting logic and API response mapping in the Code node. Notion “Missing required property” error – Ensure all mandatory database fields are mapped and Notion token has write access. Matrix authentication failure – Double-check username/password or switch to an access token login method. Performance Tips Reduce SPLIT_IN_BATCHES size if you’re hitting API rate limits. Enable “Execute Once” during testing to prevent excess API usage. Pro Tips: Store enrichment API keys as n8n credentials, not hard-coded strings. Add a second If node to flag “Priority” leads (score > 90) for immediate follow-up. Use n8n’s built-in logging to create an audit trail by writing each execution to a Loggly/Datadog endpoint. This is a community template provided “as is.” Always test thoroughly in a non-production environment before activating in production.

Automate GitHub PRs & JIRA Updates from Git Commit Commands-Single Repo

by Intuz

This n8n template from Intuz delivers a complete and automated solution to streamline your development workflow for a single repository. By embedding specific keywords and a JIRA issue ID within your git commit commands, this workflow automatically creates a Pull Request in GitHub and simultaneously updates the corresponding JIRA ticket. This provides a complete, seamless integration that eliminates manual steps and keeps your project management perfectly in sync with your codebase. How it works This workflow acts as a powerful bridge between your Git repository and your project management tools, driven entirely by the structure of your commit messages. GitHub Webhook Trigger: The workflow starts when a developer pushes a new commit to a specified repository in GitHub. Parse Commit Message: A Code node extracts key information from the commit message: The JIRA Issue Key (e.g., FF-1196). The base branch for the PR (e.g., development). Action commands like [auto-pr] and [taskcompleted]. Conditional PR Creation: An IF node checks if the [auto-pr] command is present. If yes, it uses the GitHub node to automatically create a pull request from the developer's branch to the specified base branch. If no, this step is skipped, allowing for multiple commits before a PR is made. Conditional JIRA Update: Another IF node checks for the [taskcompleted] command. If yes, it uses the JIRA node to transition the corresponding issue to your "Done" status (e.g., "Task Completed" or "In Review"). If no, the JIRA issue remains in its current state, perfect for work-in-progress commits. How to Use: Quick Start Guide Click the "Use Template" button to import this workflow into your n8n instance. Configure the GitHub Trigger: Open the "GitHub Push Trigger" node. It will display a unique Webhook URL. Copy this URL. In your GitHub repository, go to Settings > Webhooks > Add webhook. Paste the URL into the Payload URL field. Set the Content type to application/json. Under "Which events would you like to trigger this webhook?", select Just the push event. Click Add webhook. Connect Your Accounts: GitHub: Select your GitHub API credential in the "Create Pull Request" node. JIRA : Select your JIRA API credential in the "Update JIRA Issue Status" node. Customize the JIRA Transition (Important): Open the "Update JIRA Issue Status" node. In the Transition parameter, you need to set the specific status you want to move the issue to (e.g., 'Done', 'Completed', 'In Review'). You can use the ID or the exact name of the transition from your JIRA project's workflow. Activate the Workflow: Save your changes and activate the workflow. You're ready to automate! Example Commit Message: git commit -m "FF-1196 Implement OAuth login [auto-pr,development,taskcompleted]" Key Requirements to Use Template An active n8n instance. A GitHub account with repository admin permissions to create webhooks. A JIRA Cloud account with permissions to update issues. Developers who can follow the specified git commit message format. Connect with us Website: https://www.intuz.com/services Email: getstarted@intuz.com LinkedIn: https://www.linkedin.com/company/intuz Get Started: https://n8n.partnerlinks.io/intuz For Custom Worflow Automation Click here- Get Started

Enterprise Contract Lifecycle Management with AI Risk Analysis

by PDF Vector

Overview Transform your contract management process with this enterprise-grade workflow that handles the complete contract lifecycle - from initial intake through execution, monitoring, and renewal. This comprehensive solution combines AI-powered contract analysis with automated risk scoring, clause comparison, obligation tracking, and proactive alerts. It integrates with multiple data sources including email, SharePoint, contract CLM systems, and creates a centralized contract intelligence hub that prevents revenue leakage, ensures compliance, and accelerates deal velocity. What You Can Do This advanced workflow orchestrates a complete contract management ecosystem that monitors multiple channels (email, Google Drive, SharePoint, APIs) for new contracts and amendments. It extracts and analyzes over 50 contract data points using AI, performs multi-dimensional risk assessment across legal, financial, and operational factors, compares clauses against your approved template library, tracks all obligations and key dates with automated reminders, integrates with Salesforce/CRM for deal alignment, routes contracts through dynamic approval workflows based on risk scores, generates executive dashboards with contract analytics, and maintains a searchable repository with version control. The system handles complex scenarios including multi-party agreements, framework contracts with statements of work, international contracts requiring jurisdiction analysis, and M&A due diligence requiring bulk contract review. Who It's For Designed for enterprise legal operations teams managing thousands of contracts annually, procurement departments negotiating complex vendor agreements, contract managers overseeing multi-million dollar portfolios, compliance teams ensuring regulatory adherence across jurisdictions, sales operations needing faster contract turnaround, and C-suite executives requiring contract intelligence for strategic decisions. Essential for organizations in regulated industries (healthcare, finance, government) and companies undergoing digital transformation of their legal operations. The Problem It Solves Manual contract management creates massive operational risks and inefficiencies. Organizations typically have contracts scattered across emails, shared drives, and filing cabinets with no central visibility. This leads to missed renewal deadlines costing 5-10% of contract value, unauthorized contract variations creating compliance risks, obligation failures resulting in penalties and damaged relationships, and inability to leverage favorable terms across similar contracts. Studies show that inefficient contract management costs organizations up to 9% of annual revenue. This workflow creates a single source of truth for all contracts, automates tracking and compliance, and provides predictive insights to prevent issues before they occur. Setup Instructions Multi-Channel Integration: Configure connectors for email (Office 365/Gmail), Google Drive, SharePoint, and contract management systems PDF Vector Setup: Install PDF Vector node and configure API with enterprise rate limits Database Configuration: Set up PostgreSQL/MySQL for contract repository with proper indexing Template Library: Upload your standard contract templates and approved clause library Risk Framework: Configure risk scoring matrix for your industry (legal, financial, operational risks) Approval Matrix: Define approval routing based on contract value, type, and risk score CRM Integration: Connect to Salesforce/HubSpot for opportunity and account alignment Notification Setup: Configure Slack/Teams channels and email distribution lists Dashboard Creation: Set up Tableau/PowerBI connectors for executive reporting Security Configuration: Enable encryption, audit logging, and role-based access controls Key Features Intelligent Intake System**: Monitor email attachments, shared folders, CRM uploads, and API submissions Advanced AI Extraction**: Extract 50+ data points including nested obligations and conditional terms Multi-Dimensional Risk Scoring**: Analyze legal, financial, operational, and reputational risks Clause Library Comparison**: Compare against approved templates and flag deviations Obligation Management**: Track deliverables, milestones, and SLAs with automated alerts Dynamic Approval Routing**: Route based on AI risk score, contract value, and deviation analysis Version Control & Redlining**: Track all changes and maintain complete audit trail Salesforce Integration**: Sync contract data with opportunities and accounts Predictive Analytics**: Forecast renewal likelihood and negotiation outcomes Bulk Processing**: Handle M&A due diligence with parallel processing of hundreds of contracts Multi-Language Support**: Process contracts in 15+ languages with automatic translation Executive Dashboards**: Real-time visibility into contract portfolio and risk exposure Customization Options Implement industry-specific modules for healthcare (BAAs, DPAs), financial services (ISDAs, loan agreements), technology (SaaS, licensing), or government contracting. Add AI models trained on your historical contracts for better extraction accuracy. Create custom risk factors for emerging regulations like AI governance or ESG compliance. Build integration with specific CLM systems (Ironclad, Docusign CLM, Icertis). Implement advanced analytics including contract similarity scoring, win-rate analysis by clause variations, and automatic playbook generation. Add blockchain integration for smart contract execution and configure automated contract assembly for standard agreements. Note: This workflow uses the PDF Vector community node. Make sure to install it from the n8n community nodes collection before using this template.

Create an AI-Powered Virtual Receptionist with Google Calendar & Sheets

by Risper

🤖AI-Powered Appointment Scheduling with Google Calendar & Sheets Virtual Receptionist Automate customer conversations with an AI-powered virtual receptionist. This workflow can chat naturally with clients, answer general business questions (like services, location, and hours), check availability in Google Calendar, book appointments, and save customer details in Google Sheets. Fully customizable for any business type — salons, clinics, agencies, consultants, and more. 📖 How It Works Welcome the customer when the customer says hi AI greets warmly: “Hello! I’m [AI name] from [Business name].” Answer general questions Provides instant replies about services, pricing, business location, hours, and availability. Understand their need Identifies the service requested and preferred time. Check availability Queries Google Calendar for open slots. Gather customer details Collects name, phone, and email (optional). Confirm booking Creates the appointment in Google Calendar. Save records Logs booking and customer info into Google Sheets. ⚙️ Setup Steps (Quick) Connect your Google Calendar and Google Sheets accounts. Add your business details (name, type, services, hours, policies) to the Business Info Sheet. Configure your OpenAI API key (or use n8n free credits). Optional: Connect Twilio WhatsApp for direct chat responses. 🏢 Example Business Info (Google Sheet) | business_id | business_name | business_type | location | phone | email | services | calendar_id | timezone | currency | working_hours | ai_name | ai_personality | ai_role | emergency_available | booking_advance_days | cancellation_hours | |-------------|-----------------|---------------------|----------------------------------|-----------------|---------------------------|----------|-----------------------|----------|----------|--------------------------------|---------|-----------------------------------|------------------------------------------------------------------------------------------------|----------------------|----------------------|-------------------| |001| Luxe Hair Studio | Hair & Beauty Salon | 123 Main Street, New York, NY 10001 | 1 (XXX) XXX-XXXX | yourbusiness@email.com | “Haircut & Styling (60 minutes, $3500…)Hair Coloring (120 minutes, $8000…)…” | calendar-id-here | GMT -3 | USD | Mon–Sat: 9:00 AM – 7:00 PM, Sun: Closed | bella | Friendly, Stylish, Professional | Manages bookings, answers FAQs, recommends services, gives beauty tips, sends reminders, etc. | no | 10 | 24 | ✅ Purpose: Supplies context (services, pricing, hours, AI personality, booking policies). 💡 The AI uses this sheet to answer general business questions (e.g., “Where are you located?”, “Do you do hair colouring?”, “What are your working hours?”). 📊 Appointments Sheet Example | client_number | client_name | event_id | summary | services | |----------------|-------------|-----------|----------------------------------|----------| | 001 | Sarah Lee | evt-10293 | Appointment with Sarah Lee – Haircut & Styling | Haircut & Styling | | 002 | John Smith | evt-10294 | Appointment with John Smith – Highlights | Highlights | ✅ Purpose: Logs confirmed bookings with service details and links back to Google Calendar. 💡 Features ✅ AI receptionist with conversation memory ✅ Answers FAQs – location, services, hours, pricing ✅ Google Calendar integration for real-time availability ✅ Google Sheets integration for customer records & reporting ✅ Customizable AI name, role, and personality 🔑 Who It’s For Salons & Spas** – Manage bookings and FAQs Clinics & Health Services** – Automated scheduling + patient info Agencies & Consultants** – Answer inquiries + schedule meetings Any Service Business** – Save time, improve customer experience

Track Excel 365 changes and approvals with Telegram and Google Sheets logging

by Ramdoni

Track changes and approvals in Excel 365 📌 Overview This workflow monitors an Excel 365 sheet every minute and detects new, updated, and deleted rows using a unique ID column. It compares the current dataset with the previous snapshot and identifies field-level differences. When changes are detected, the workflow filters rows that require approval (Status = “Waiting Approval”), sends structured notifications, and optionally logs every field-level change into an audit sheet (Excel or Google Sheets). The configuration layer allows you to define the ID column, ignored fields, and audit logging behavior without modifying the comparison logic. This template is suitable for approval tracking, operational monitoring, and lightweight compliance logging. How it works Runs every minute using a schedule trigger Reads rows from Excel 365 Normalizes and stores a snapshot Compares with the previous state Detects new, updated, and deleted rows Filters rows with “Waiting Approval” status Sends structured notifications Logs changes if audit logging is enabled Setup steps Configure Microsoft Excel credentials Ensure your sheet contains a unique ID column Update the Environment Config node 4.(Optional) Configure Google Sheets credentials for audit logging Activate the workflow 🚀 Features ⏱ Scheduled Monitoring Runs automatically every 1 minute Near real-time Excel monitoring Prevents unnecessary execution when no changes are detected 🔍 Row-Level Change Detection Detects: ✅ New rows ✏️ Updated rows ❌ Deleted rows Uses a unique ID field per row for accurate tracking. ⸻ 🧠 Field-Level Comparison Compares previous vs current values Identifies exactly which fields changed Outputs structured change data Prevents false positives via data normalization ⸻ ⚙️ Environment Configuration Layer Centralized configuration node allows easy customization without modifying core logic. Configurable options include: idField ignoreFields monitorOnly firstRunSilent enableAuditLog No hardcoded logic required. ⸻ 🛑 Approval Validation Layer Filters rows where Status = "Waiting Approval" Sends notifications only for relevant approval cases Prevents unnecessary alerts ⸻ 🔔 Smart Notification System Sends formatted change notifications Includes: Change Type (NEW / UPDATED / DELETED) Row ID Field-level old → new values Fully customizable message formatting. ⸻ 📊 Optional Audit Logging If enabled in the Environment Config: Converts each field-level change into structured audit rows Appends logs to: Excel 365 (Audit Sheet) Google Sheets (External Log) Audit Log Structure | Timestamp | ChangeType | RowID | Field | OldValue | New Value | |-------------|--------------|--------|------|----------|------------| Designed for compliance and tracking purposes. 📦 Use Cases Internal approval tracking Financial data monitoring Sales pipeline control Procurement workflows Excel-based compliance systems SME automation systems 🧩 Requirements Microsoft 365 (Excel Online – Business) n8n (Cloud or Self-hosted) Microsoft credentials configured in n8n Telegram Bot (Optional) Google Sheets credentials for audit logging 🔧 Configuration Guide All system behavior is controlled from the Environment Config node. Example configuration structure: { CONFIG: { idField: "ID", ignoreFields: ["UpdatedAt", "LastModified"], monitorOnly: null, firstRunSilent: true, enableAuditLog: true } } You can customize: Which column acts as unique ID Which fields to ignore Which fields to monitor exclusively Whether to enable audit logging Whether first run should be silent 🟢 First Run Behavior On first execution: The workflow initializes internal snapshot storage No mass notification is sent (if firstRunSilent = true) This prevents false “NEW row” alerts during setup. 🏢 Who Is This For? Operations teams Finance departments SMEs using Excel as core system Automation consultants Businesses requiring lightweight audit tracking ⸻ 💡 Why This Workflow? Unlike simple Excel polling workflows, this solution: Tracks changes at field level Supports approval-based filtering Includes structured audit logging Avoids duplicate alerts Is fully configurable Designed for production usage This is not just an Excel notifier — it is a structured Change Tracking & Approval Monitoring System built on n8n.

Generate Viral AI Motion Video 🤣🤖 using Kling 2.6 Kie AI & Auto-Post to TikTok

by Davide

💬Communication & Collaboration

This workflow automates the creation and publishing of AI-generated motion videos for TikTok. The process starts with an image and a reference motion video. Using the Kling v2.6 Motion Control AI model, the workflow generates a new animated video where the character from the image replicates the movements from the reference video. Once the AI-generated video is produced, the workflow automatically retrieves the result, uploads it to Postiz, and publishes it directly to TikTok with a predefined caption. Start: Watch the starting video Result: Watch the final video Key Advantages 1. ✅ Full Automation The workflow automates the entire pipeline from AI video generation to social media publishing, eliminating manual steps. 2. ✅ AI-Powered Content Creation By leveraging Kling Motion Control, the system creates dynamic animated content from a static image and motion reference video. 3. ✅ Scalable Content Production This setup enables rapid production of multiple AI-generated videos, making it ideal for automated social media content strategies. 4. ✅ Efficient Asynchronous Processing The workflow uses webhooks and wait nodes to handle long-running AI jobs efficiently without blocking the workflow. 5. ✅ Seamless Social Media Integration Direct integration with Postiz and TikTok allows automatic publishing, streamlining the content distribution process. 6. ✅ Modular and Customizable Each step (AI generation, parsing, upload, publishing) is modular, allowing easy modification for: different AI models other social platforms different prompts or media inputs 7. ✅ Reduced Manual Work Content creators can generate and publish AI-based videos with a single workflow execution. How it works Trigger & Input: The workflow is started manually. The initial "Set params" node defines the key inputs: an image_url, a video_url, and a tiktok_desc (caption). AI Video Generation: The "Run Kling v2.6 Motion Control" node sends a request to the Kie.ai API. It instructs the AI to make the character in the static image follow the movements from the reference video. Crucially, it includes a callBackUrl (the n8n webhook URL from the Wait node) so the API can notify the workflow when the video is ready. The workflow then pauses at the "Wait" node, holding its execution until it receives the callback from Kie.ai. Retrieve Result: Once the AI finishes processing, it sends a request to the "Wait" node's webhook, which resumes the workflow. The "Result" node then fetches the details of the completed job, including a link to the newly generated video (resultUrl). Process for Posting: The "Parsing" node extracts the resultUrl from the API's JSON response. A "Get ResulUrl" Code node formats this data to be passed to the next step. The "Get File Video" node uses the resultUrl to download the actual video file from the temporary URL. Upload & Schedule: The "Upload Video to Postiz" node takes the downloaded video file and uploads it to the Postiz platform using a multipart/form-data request. The final "TikTok" (Postiz) node creates a new post. It uses the video ID returned from the upload and the tiktok_desc from the initial parameters to schedule the post to the specified TikTok integration. Setup steps To make this workflow work for you, you need to configure the following: Set Input Parameters: In the "Set params" node, replace the example image_url, video_url, and tiktok_desc with your own values. image_url: Direct URL to the static character image. video_url: Direct URL to the reference movement video. tiktok_desc: The caption you want for the final TikTok post. Kie.ai API Credentials: Locate the "Run Kling v2.6 Motion Control" and "Result" nodes. You will need to provide credentials for httpBearerAuth. Replace the existing credential ID with your own Kie.ai API credentials. Ensure the credential is configured with a valid API Bearer Token. Postiz API Credentials: Locate the "Upload Video to Postiz" node. Provide credentials for httpHeaderAuth. Replace the existing credential ID with your own Postiz API key. This key must be set as a header for authentication. Postiz Integration ID: In the final "TikTok" (Postiz) node, look for the field integrationId inside the posts.post.value object. Replace the placeholder "XXX" with the actual Integration ID for your TikTok account from Postiz. 👉 Subscribe to my new YouTube channel. Here I’ll share videos and Shorts with practical tutorials and FREE templates for n8n. Need help customizing? Contact me for consulting and support or add me on Linkedin.

3 nodes

Generate PDF invoices with line item support from Airtable using Google Sheets

by Sergio Medina

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/

Triage and escalate HubSpot tickets to Jira with Slack SLA alerts

by PollupAI

This workflow automates the prioritization and escalation of customer support tickets. It acts as an intelligent triage system that identifies high-value customers and potential churn risks in HubSpot, syncs them to Jira, and enforces response times via Slack alerts. Who’s it for This workflow is ideal for Customer Success (CS) teams, Support Leads, and Account Managers who need to ensure VIP clients and critical issues receive immediate engineering or support attention without manual monitoring. How it works The workflow runs on a schedule to process new tickets: Monitor: Checks HubSpot every 10 minutes for newly created tickets. Enrich: Retrieves the associated Contact’s data, specifically looking for Annual Revenue and Lifecycle Stage. Analyze: A Code node evaluates the ticket content and customer value. It assigns a "Severity" level (Critical/High/Normal) based on revenue thresholds (>10k) or churn-risk keywords (e.g., "refund," "lawyer," "cancel"). Action: Creates a formatted Jira task with all context included and notifies a Slack channel. SLA Check: Waits 15 minutes to allow for a response. Escalate: If the Jira ticket status hasn't changed to "In Progress" or "Done" after the wait period, it triggers a high-priority "Churn Risk Escalation" alert in Slack. Requirements HubSpot** account (CRM and Service Hub). Jira Software Cloud** account. Slack** workspace. How to set up Configure your credentials for HubSpot, Jira Software, and Slack. In the HubSpot: Get Associations and Get Contact Data nodes, ensure the properties match your internal naming conventions. In the Jira: Create Triage Ticket node, select your specific Project and Issue Type from the dropdown lists. In the Slack nodes, select the channel where you want alerts to be posted. How to customize the workflow Integrate other tools:** This system is modular and works with any other tool (contact us for help). You can easily replace the nodes to use your specific stack: CRM: Pipedrive, WeClapp Ticketing System: Zendesk, Intercom, FreshDesk Modify Logic:* Open the *Code: Calculate Severity** node to change the revenue threshold (currently set to 10,000). You can also replace the manual keyword matching with an LLM (AI) node to intelligently analyze ticket sentiment and intent. Adjust SLA:* Change the duration in the *Wait: Response Timer** node if your Service Level Agreement (SLA) differs from the default 15 minutes. Change Status Check:* Update the *Check: Escalation Needed?** node if your team uses different Jira statuses (e.g., "Under Review" instead of "In Progress") to determine if a ticket is being handled.

⚙️Business Automation

5 nodes3 views

Enrich newsletter subscribers with social data and tag in Mailchimp

by Influencers Club

💬Communication & Collaboration

How it works: Get multi social platform data for newsletter subscribers with their email and tag them to enter organic creator, partner and ambassador workflows. Step by step workflow to enrich subscriber emails with multi social (Instagram, Tiktok, Youtube, Twitter, Onlyfans, Twitch and more) profiles, analytics and metrics using the influencers.club API and tagging them on Mailchimp to route campaigns. Set up: Mailchimp (can be swapped for any email marketing sender eg. ActiveCampaign) Influencers.club API

5 nodes15 views

Generate News Digest Videos from WordPress to YouTube with Shotstack

by Alexandru Burca