{"product_id":"webmetic-openai-weekly-b2b-campaign-reports-via-outlook-n8n","title":"Webmetic + OpenAI Weekly B2B Campaign Reports via Outlook (n8n)","description":"\u003ch3\u003eGet weekly Webmetic B2B campaign reporting—automatically, and delivered via Outlook\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls first-time company visits from Webmetic for the past 7 days, uses OpenAI to turn the data into a clean HTML campaign performance report, and emails it every Monday morning through \u003cstrong\u003eMicrosoft Outlook\u003c\/strong\u003e—so your team gets actionable B2B insights without manual work.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e Executes every Monday at \u003cstrong\u003e08:00\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls Webmetic Visitor Intelligence data:\u003c\/strong\u003e Uses your Webmetic Visitor Intelligence API credentials to request \u003cstrong\u003efirst-time company visits\u003c\/strong\u003e for the last 7 days.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEnriches each company record:\u003c\/strong\u003e Extracts the company’s \u003cstrong\u003elead score\u003c\/strong\u003e plus first-touch \u003cstrong\u003eUTM source\/medium\u003c\/strong\u003e and \u003cstrong\u003ecampaign\u003c\/strong\u003e, using \u003cstrong\u003e(direct)\u003c\/strong\u003e and \u003cstrong\u003e(none)\u003c\/strong\u003e when values are missing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGroups and summarizes:\u003c\/strong\u003e Sorts companies by lead score, then groups results by UTM source and campaign, including counts and a concatenated company list per row.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates an HTML report with OpenAI:\u003c\/strong\u003e Sends grouped data to OpenAI to produce a short HTML summary, a source\/campaign table with readable channel names, notable companies per paid campaign, and a budget recommendation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends via Microsoft Outlook:\u003c\/strong\u003e Emails the generated HTML report to your configured recipients, with a subject line that includes the total number of new companies.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS marketing teams who want \u003cstrong\u003eweekly B2B campaign performance\u003c\/strong\u003e summaries from real first-touch visits.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers and n8n users building repeatable reporting for \u003cstrong\u003eUTM-driven acquisition\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eOperators who need a simple way to review \u003cstrong\u003elead scores\u003c\/strong\u003e and notable companies by source\/campaign.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled trigger:\u003c\/strong\u003e Monday 08:00\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeb integration:\u003c\/strong\u003e \u003ccode\u003en8n-nodes-webmetic\u003c\/code\u003e (Webmetic Visitor Intelligence API for first-time company visits)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData handling:\u003c\/strong\u003e \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003esort\u003c\/code\u003e, \u003ccode\u003eaggregate\u003c\/code\u003e, \u003ccode\u003esummarize\u003c\/code\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI reporting:\u003c\/strong\u003e OpenAI Chat Model to generate the HTML report\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail delivery:\u003c\/strong\u003e Microsoft Outlook with workflow settings for recipients and report language\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAdd your \u003cstrong\u003eWebmetic\u003c\/strong\u003e API key and set the workflow domain value.\u003c\/li\u003e\n  \u003cli\u003eAdd your \u003cstrong\u003eOpenAI\u003c\/strong\u003e API credential for the Chat Model used in report generation.\u003c\/li\u003e\n  \u003cli\u003eAdd your \u003cstrong\u003eMicrosoft Outlook\u003c\/strong\u003e credential, and set recipient emails + preferred report language in the workflow settings.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46232389583027,"sku":"N8N-21065","price":49.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/jQJKyWnci-AfIswtLwxCf_AxhFdK9y.png?v=1792141637","url":"https:\/\/buyflowscripts.com\/products\/webmetic-openai-weekly-b2b-campaign-reports-via-outlook-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}