Email weekly B2B campaign reports from Webmetic visits via OpenAI and Outlook

## Show which campaigns bring which companies Which campaign brought which companies? Every Monday, this workflow collects the companies that visited your website for the first time last week, groups them by source and campaign, lets OpenAI write a short report and e-mails it to marketing and sales with Microsoft Outlook. ### Who's it for B2B marketing teams who want to show which campaigns bring real companies, not just clicks. ### How it works 1. Get new visits returns the companies Webmetic identified for the first time in the last 7 days. 2. Each company gets the source and campaign of its first visit, from the UTM parameters. 3. Companies are counted per source and campaign, best lead scores first. 4. OpenAI writes the report: summary, table, notable companies per paid campaign and a budget tip. 5. Outlook sends it to the recipients in Settings. ### Setup 1. Copy the Visitor Intelligence API key from Webmetic API keys. 2. Fill in Settings: domain, recipients and report language. 3. Connect OpenAI and Microsoft Outlook. About 5 minutes. ### Requirements - A Webmetic account. This workflow uses no credits. - The Webmetic node, verified by n8n, on n8n Cloud or self-hosted. - OpenAI and an e-mail account. ### Customize Change day and time in Every Monday at 8, or swap Outlook for Gmail or Teams. Campaign names come from the UTM parameters of your ads. More Webmetic workflows