HumationHuman + Automation
Back to Catalog

Auto-generate FAQ answers in Vtiger CRM with DeepSeek LLM and LangChain

Ahmed SaadawiAhmed Saadawi
466 views
2/3/2026
Data ProcessingStock MarketAlpha VantageSchedulingAPI Integration
Official Page

This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

🧠 Vtiger CRM – Auto-Answer FAQs with DeepSeek AI

Description:

This workflow automates the process of answering FAQ drafts in Vtiger CRM using DeepSeek LLM via LangChain. It's perfect for teams who want to accelerate knowledge base creation, improve support response consistency, or reduce the manual effort of writing FAQ content.

Every 1 minute, this workflow:

  • 📥 Retrieves the most recent FAQ record marked as Draft in Vtiger CRM
  • 🧠 Sends the question to a LangChain agent powered by DeepSeek AI
  • 📝 Receives a plain-text answer
  • 📤 Updates the original FAQ with the generated answer and changes its status to Published

⚙️ How It Works

  • Trigger: Scheduled to run every 1 minute
  • Query: Pulls the latest FAQ from Vtiger where faqstatus = 'Draft'
  • AI Agent: Uses LangChain + DeepSeek to generate a natural-language answer
  • Memory Buffer: Keeps context using LangChain memory
  • Update: Pushes the answer back to Vtiger and marks it as Published

🛠️ Setup Instructions

  1. Connect Credentials for:

    • Vtiger CRM API
    • DeepSeek API

  2. Ensure your Vtiger CRM has a Faq module with fields:

    • question
    • faq_answer
    • faqstatus

  3. Install the required Community Node:

    • Go to Settings → Community Nodes

    • Click Install Node and enter:

      n8n-nodes-vtiger-crm

    • Restart your instance when prompted.

  4. Optionally customize the schedule or field names as needed.

👤 Who Is This For?

  • Customer support teams building a knowledge base
  • Businesses using Vtiger as a CRM or internal helpdesk
  • Teams looking to automate repetitive content creation using LLMs

🔐 Credentials Required

  • ✅ Vtiger CRM API credentials
  • ✅ DeepSeek AI API key

✅ Highlights

  • Fully automated LLM-powered FAQ generation
  • Uses custom community node for Vtiger support
  • Lightweight and runs on a short interval (1 min)
  • Includes sticky note for clarity and onboarding
  • Clean conditional logic and memory context built-in

🏷 Tags

vtiger, crm, faq automation, ai automation, deepseek, langchain, llm, open source crm,
faq generation, customer support, n8n, n8n community nodes, workflow automation,
ai generated answers, vtiger integration, deepseek ai, langchain integration

n8n Workflow: Auto-Generate FAQ Answers with DeepSeek LLM

This n8n workflow demonstrates how to leverage the DeepSeek Large Language Model (LLM) within an AI Agent to generate content. While the provided JSON is a foundational setup for an AI agent with DeepSeek, it outlines the core components for building an automated FAQ answer generation system.

What it does

This workflow sets up a basic AI agent that can interact with the DeepSeek Chat Model. It includes:

  1. Scheduled Trigger: The workflow is initiated on a schedule, allowing for periodic execution.
  2. AI Agent Initialization: An AI Agent node is configured, acting as the orchestrator for the language model and memory.
  3. Simple Memory: A "Simple Memory" (Buffer Window Memory) is integrated to provide conversational context to the AI Agent.
  4. DeepSeek Chat Model: The DeepSeek Chat Model is connected as the core language model for the AI Agent, responsible for generating responses.
  5. Conditional Logic (Placeholder): An "If" node is included, indicating a potential branching point for further processing based on the AI agent's output. This could be used to filter, validate, or route the generated answers.
  6. Sticky Note: A sticky note is present, likely for documentation or temporary notes within the workflow design.

Prerequisites/Requirements

  • n8n Instance: A running instance of n8n.
  • DeepSeek API Key: Access to the DeepSeek API and a corresponding API key for authentication. This will need to be configured as an n8n credential for the "DeepSeek Chat Model" node.
  • LangChain Nodes: Ensure the @n8n/n8n-nodes-langchain package is installed in your n8n instance.

Setup/Usage

  1. Import the Workflow: Import the provided JSON into your n8n instance.
  2. Configure Credentials:
    • Locate the "DeepSeek Chat Model" node.
    • Create or select an existing n8n credential for DeepSeek, providing your API key.
  3. Configure AI Agent:
    • Review the "AI Agent" node settings. You might need to define the agent's prompt, tools, and other parameters depending on your specific FAQ generation requirements.
  4. Configure Schedule Trigger:
    • Adjust the "Schedule Trigger" node to your desired execution frequency (e.g., daily, weekly, or manually for testing).
  5. Expand Conditional Logic:
    • The "If" node is currently a placeholder. You will need to define its conditions and connect subsequent nodes to handle the AI agent's output (e.g., update a vTiger CRM, save to a database, send notifications).
  6. Activate the Workflow: Once configured, activate the workflow to start generating FAQ answers automatically.

Related Templates

AI-powered code review with linting, red-marked corrections in Google Sheets & Slack

Advanced Code Review Automation (AI + Lint + Slack) Who’s it for For software engineers, QA teams, and tech leads who want to automate intelligent code reviews with both AI-driven suggestions and rule-based linting — all managed in Google Sheets with instant Slack summaries. How it works This workflow performs a two-layer review system: Lint Check: Runs a lightweight static analysis to find common issues (e.g., use of var, console.log, unbalanced braces). AI Review: Sends valid code to Gemini AI, which provides human-like review feedback with severity classification (Critical, Major, Minor) and visual highlights (red/orange tags). Formatter: Combines lint and AI results, calculating an overall score (0–10). Aggregator: Summarizes results for quick comparison. Google Sheets Writer: Appends results to your review log. Slack Notification: Posts a concise summary (e.g., number of issues and average score) to your team’s channel. How to set up Connect Google Sheets and Slack credentials in n8n. Replace placeholders (<YOURSPREADSHEETID>, <YOURSHEETGIDORNAME>, <YOURSLACKCHANNEL_ID>). Adjust the AI review prompt or lint rules as needed. Activate the workflow — reviews will start automatically whenever new code is added to the sheet. Requirements Google Sheets and Slack integrations enabled A configured AI node (Gemini, OpenAI, or compatible) Proper permissions to write to your target Google Sheet How to customize Add more linting rules (naming conventions, spacing, forbidden APIs) Extend the AI prompt for project-specific guidelines Customize the Slack message formatting Export analytics to a dashboard (e.g., Notion or Data Studio) Why it’s valuable This workflow brings realistic, team-oriented AI-assisted code review to n8n — combining the speed of automated linting with the nuance of human-style feedback. It saves time, improves code quality, and keeps your team’s review history transparent and centralized.

higashiyama By higashiyama
90

AI-powered candidate nurturing with scheduled WhatsApp & Gmail follow-ups

What This Workflow Does This workflow automates the candidate nurturing process, solving the common problem of candidates losing interest or "ghosting" after an application. It keeps them engaged and informed by sending a personalized, multi-channel (WhatsApp & Gmail) sequence of follow-up messages over their first week. The automation triggers when a new candidate is added to your ATS (e.g., via a Recrutei webhook). It then uses AI to generate a custom 3-part message (for Day 1, Day 3, and Day 7) tailored to the candidate's age and the specific job they applied for, ensuring a professional and empathetic experience that strengthens your employer brand. How it Works Trigger: A Webhook node captures the new candidate data from your Applicant Tracking System (ATS) or form. Data Preparation: Two Code nodes clean the incoming data. The first (Separating information) extracts key fields and formats the phone number. The second (Extract age) calculates the candidate's age from their birthday to be used by the AI. AI Content Generation: The workflow sends the candidate's details (name, age, job title) to an AI model (AI Recruitment Assistant). The AI has a detailed system prompt to generate three distinct messages for Day 1 (Thank You), Day 3 (Friendly Reminder), and Day 7 (Final Reinforcement), adapting its tone based on the candidate's age. Split Messages: A Code node (Separating messages per days) receives the single text block from the AI and splits it into three separate variables (day1, day3, day7). Day 1 Send: The workflow immediately sends the day1 message via both Gmail and WhatsApp (configured for Evolution API). Day 3 Send: A "Wait" node pauses the workflow for 2 days, after which it sends the day3 message. Day 7 Send: Another "Wait" node pauses for 4 more days, then sends the final day7 message, completing the 7-day nurturing sequence. Setup Instructions This workflow is plug-and-play once you configure the following 5 steps: Webhook Node: Copy the Test URL from the Webhook node and configure it in your ATS (e.g., Recrutei) or form builder to trigger whenever a new candidate is added. Run one test submission to make the data structure visible to n8n. AI Credentials: In the AI Recruitment Assistant node, select or create your OpenAI API credential. MCP Credential (Optional): If you use a Recrutei MCP, paste your endpoint URL into the MCP Recrutei node. Gmail Credentials: In all three Message Gmail nodes (Day 1, 3, 7), select or create your Gmail (OAuth2) credential. Optional:* In the same nodes, go to Options and change the Sender Name from your_company to your actual company name. WhatsApp (Evolution API): This template is pre-configured for the Evolution API. In all three Message WhatsApp nodes (Day 1, 3, 7), you must: URL: Replace {server-url} and {instance} with your Evolution API details. Headers: In the "Header Parameters" section, replace yourapikey with your actual Evolution API key.

Recrutei Automações By Recrutei Automações
54

Daily cash flow reports with Google Sheets, Slack & Email for finance teams

Simplify financial oversight with this automated n8n workflow. Triggered daily, it fetches cash flow and expense data from a Google Sheet, analyzes inflows and outflows, validates records, and generates a comprehensive daily report. The workflow sends multi-channel notifications via email and Slack, ensuring finance professionals stay updated with real-time financial insights. 💸📧 Key Features Daily automation keeps cash flow tracking current. Analyzes inflows and outflows for actionable insights. Multi-channel alerts enhance team visibility. Logs maintain a detailed record in Google Sheets. Workflow Process The Every Day node triggers a daily check at a set time. Get Cash Flow Data retrieves financial data from a Google Sheet. Analyze Inflows & Outflows processes the data to identify trends and totals. Validate Records ensures all entries are complete and accurate. If records are valid, it branches to: Sends Email Daily Report to finance team members. Send Slack Alert to notify the team instantly. Logs to Sheet appends the summary data to a Google Sheet for tracking. Setup Instructions Import the workflow into n8n and configure Google Sheets OAuth2 for data access. Set the daily trigger time (e.g., 9:00 AM IST) in the "Every Day" node. Test the workflow by adding sample cash flow data and verifying reports. Adjust analysis parameters as needed for specific financial metrics. Prerequisites Google Sheets OAuth2 credentials Gmail API Key for email reports Slack Bot Token (with chat:write permissions) Structured financial data in a Google Sheet Google Sheet Structure: Create a sheet with columns: Date Cash Inflow Cash Outflow Category Notes Updated At Modification Options Customize the "Analyze Inflows & Outflows" node to include custom financial ratios. Adjust the "Validate Records" filter to flag anomalies or missing data. Modify email and Slack templates with branded formatting. Integrate with accounting tools (e.g., Xero) for live data feeds. Set different trigger times to align with your financial review schedule. Discover more workflows – Get in touch with us

Oneclick AI SquadBy Oneclick AI Squad
619