Follow up on open HubSpot deals using Webmetic, OpenAI and Microsoft Teams

Description

Quick Overview This workflow runs hourly to detect returning companies from Webmetic, checks HubSpot for an open deal by domain, uses OpenAI to generate a follow-up suggestion, then creates a HubSpot task for the deal owner and posts an alert to Microsoft Teams. How it works Runs every hour on a scheduled trigger. Pulls companies with at least two website visits in the last 7 days from Webmetic and deduplicates them to notify only once per company per day. Searches HubSpot Companies by the visiting company’s domain and continues only if the company has one or more open deals. Searches HubSpot Deals to find the most recently updated open deal associated with that company. Sends the deal and visit/page context to OpenAI to generate a short HTML follow-up recommendation. Creates a HubSpot task associated with the deal, company, and deal owner containing the AI suggestion, then posts a summary notification to a Microsoft Teams channel. Setup Add credentials for Webmetic (Visitor Intelligence API key), HubSpot (private app token/app token), OpenAI, and Microsoft Teams. In the Settings values, set your website domain, company name, what you sell, and preferred output language. In the Microsoft Teams step, select the target Team and Channel where notifications should be posted. An n8n automation workflow template by Yannik Süß.

Community Metrics

Categories

• Automation
• AI

Tags

• n8n
• workflow
• http-request
• hubspot
• microsoft-teams
• ai-agent
• openai-chat-model

Capabilities

• 5 nodes
• 1 views

Information