Automated New Ticket Alerts to Microsoft Teams
detail.loadingPreview
This workflow automatically pulls new tickets from ConnectWise and sends consolidated alerts to your Microsoft Teams channel. It ensures your dispatch team is always informed of urgent new requests without manual intervention.
About This Workflow
Streamline your IT support operations with this powerful n8n workflow. It's designed to monitor ConnectWise for newly created tickets across specified boards and statuses. Once identified, the workflow intelligently filters out tickets that have already been processed and then consolidates them by company for a cleaner alert. Finally, these aggregated notifications are sent directly to a dedicated Microsoft Teams channel, providing your dispatch team with essential information at a glance. This automation reduces response times, improves team coordination, and ensures no critical ticket goes unnoticed.
Key Features
- Real-time New Ticket Detection: Automatically identifies tickets with 'New' or similar statuses.
- Smart Filtering: Prevents duplicate alerts by tracking processed tickets.
- Company-Based Consolidation: Groups tickets by company for concise reporting.
- Direct Microsoft Teams Integration: Delivers immediate notifications to your team's preferred communication channel.
- Configurable Scheduling: Runs at set intervals during business hours (defaulting to hourly from 8 AM to 4 PM, Monday to Friday).
How To Use
- Schedule Trigger: Configure the cron expression to define how often the workflow runs (e.g.,
*/1 8-16 * * 1-5for hourly checks during business hours). - Get New Tickets: Input your ConnectWise API URL and authentication details. Customize the
conditionsandboard/idparameters to match your specific ticket criteria. - Add Filterable Parameter: This node prepares the ConnectWise ticket IDs for subsequent filtering by ensuring they are string types.
- Query Database: Configure this node to use Redis to store and retrieve ticket IDs that have already been sent.
- Filter Out Tickets that have already been sent: Set up the merge node to compare incoming tickets against those stored in Redis, keeping only the new, unsent tickets.
- Combine like Companies: Adapt the JavaScript code to group tickets by company name and format them for the Teams message. Ensure
siteName,company, andrecordTypepaths are correct for your ConnectWise data. - Log in Redis: Configure this node to store the ID of each ticket that is successfully processed and sent to Teams, preventing future duplicates.
- Teams to Dispatch: Enter your Microsoft Teams chat ID and customize the message template to display ticket details, company name, and ticket type. Ensure your Microsoft Teams OAuth2 credentials are set up.
Apps Used
Workflow JSON
{
"id": "4900252f-84af-45c4-8837-44f3aa8cce24",
"name": "Automated New Ticket Alerts to Microsoft Teams",
"nodes": 9,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 4900252f-84af...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.