Follow up on open HubSpot deals using Webmetic, OpenAI and Microsoft Teams
Go to Workflow
Yannik Süß
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.
This workflow was created by Yannik Süß and shared publicly on the n8n community template library. n8nFind indexes it for discovery — the workflow remains the property of its original creator.