Automated Ticket Notification to Teams

somdn_product_page

This n8n workflow automates the process of fetching new support tickets from ConnectWise, filtering out already notified tickets, grouping them by company, and notifying a Microsoft Teams chat for dispatch. It runs on a scheduled basis from Monday to Friday between 8 AM and 4 PM, ensuring timely updates for support teams.

The workflow begins with a schedule trigger that activates every hour within business hours. It fetches new support tickets from the ConnectWise API that are in ‘New’ status. Each ticket is then enriched by adding a filterable parameter and checking if it has already been processed via a Redis database. Tickets not previously sent are grouped by company and site, aggregating their details for clarity. Finally, a formatted message with ticket summaries is dispatched to a specified Teams chat for the dispatch team to review and act upon.

This workflow is ideal for support teams who need to stay updated with new tickets in real-time, avoiding duplicate notifications, and streamlining their communication via Microsoft Teams.

Node Count

6 – 10 Nodes

Nodes Used

code, httpRequest, merge, microsoftTeams, redis, scheduleTrigger

Reviews

There are no reviews yet.

Be the first to review “Automated Ticket Notification to Teams”

Your email address will not be published. Required fields are marked *