Vtiger Support Ticket Alert System to Telegram - n8n Workflow

• Support and HelpDesk Managers who need real-time notification of new support requests.


• Operations teams utilizing Vtiger CRM who require immediate cross-platform alerting.


• Developers looking for practical examples of how to build scheduled, conditional n8n templates for CRM integration.

Effective customer support hinges on rapid response times. This specialized n8n workflow ensures that no new Vtiger support ticket is missed.

It operates using a scheduled n8n trigger that constantly monitors your CRM for tickets flagged as 'Open'. When a new ticket is detected, the full details—including title, priority, and description—are immediately forwarded to a designated Telegram chat. Crucially, the workflow then uses the powerful VtigerCRM n8n node to update the ticket status to 'In Progress'. This update prevents the system from generating repeated alerts for the same ticket in subsequent runs, creating a clean, efficient, and reliable automation loop. This n8n workflow is one of the most useful n8n templates for integrating legacy systems with modern communication tools.

This automation operates on a strict schedule to provide near real-time alerting:

1. Scheduled Polling (n8n Trigger): The n8n workflow starts with the Schedule Trigger Every n Minutes n8n trigger, configured to run every minute.


2. Fetch Open Tickets: The VtigerCRM get Tickets n8n node executes a query (select * from HelpDesk where ticketstatus='Open' order by id desc limit 1;) to retrieve the single most recent ticket that still has an 'Open' status.


3. Conditional Check (IF Node): The workflow moves to the If there's a data returned n8n node, which verifies if the CRM returned a valid ticket ID. If a ticket is found, the True path executes; otherwise, the workflow terminates via the 'No Operation' n8n node.


4. Send Telegram Alert: If a ticket is found, the Send a Ticket detail to Telegram n8n node constructs a detailed message containing the ticket number, title, priority, severity, and full description, sending it immediately to the target Telegram chat.


5. Update Status: Finally, the VtigerCRM Update Ticket Status n8n node executes, using the retrieved WebService ID to update the ticketstatus field from 'Open' to 'In Progress'. This action prevents the scheduled n8n trigger from alerting on this ticket again.

To deploy this powerful n8n workflow, follow these steps:

1. Import: Copy the provided JSON data and import it directly into your n8n instance as a new n8n workflow.


2. Vtiger CRM Node Setup: This specific n8n workflow requires the custom n8n-nodes-vtiger-crm community n8n node. If you are using a self-hosted instance, install it via the Community Nodes settings.


3. Vtiger Credentials: Locate the VtigerCRM get Tickets and VtigerCRM Update Ticket Status n8n nodes and set up your Vtiger API credentials (Username/Access Key).


4. Telegram Credentials: Open the Send a Ticket detail to Telegram n8n node. Connect your existing Telegram credentials (API Token) and ensure the Chat ID field is correctly set to the ID of the group or user you wish to receive the alerts.


5. Activation: Once all credentials are configured, activate the n8n workflow to start scheduled execution.

Schedule Trigger Every n Minutes (n8n Trigger)
Function: Acts as the primary n8n trigger, initiating the automation every 1 minute.
Key Configuration: Interval set to 1 minute.
VtigerCRM get Tickets (VtigerCRM n8n node)
Function: Queries the Vtiger HelpDesk module for the newest ticket where the ticketstatus is 'Open'.
Key Configuration: Custom query: select from HelpDesk where ticketstatus='Open' order by id desc limit 1;
If there's a data returned (n8n node)
Function: Ensures subsequent steps only run if the Vtiger query actually returned data (i.e., a new open ticket exists).
Key Configuration: Checks if the expression {{ $json.result[0].id }} is not empty.
Send a Ticket detail to Telegram (Telegram n8n node)
Function: Sends a richly formatted alert message containing critical ticket metadata to Telegram.
Key Configuration: Text is dynamically built using expressions to include all ticket fields (Title, Priority, Description, etc.) retrieved from the previous n8n node output.
VtigerCRM Update Ticket Status (VtigerCRM n8n node)
Function: Updates the status of the alerted ticket in Vtiger CRM to 'In Progress'.
Key Configuration: Operation set to 'update', targeting the specific webserviceidfield retrieved in step 2, and setting the ticketstatus element field to 'In Progress'.