HubSpot and Microsoft Outlook integration

Who’s it for Marketing, growth, and automation teams that need to ship polished bilingual newsletters—complete with images, optional video, and multi-channel distribution—without writing a line of code. How it works / What it does A Webhook receives a plain-language request (e.g. “Create a newsletter about XYZ and store it in SharePoint”). The Webhook can be changed to another trigger, fr example Manual Trigger. An AI Agent (OpenAI GPT-4o) drafts German & English newsletter copy following a strict JSON schema. SharePoint fetches an HTML template; a Code node injects AI copy into the placeholders. Optional creative assets: Pollinations AI → image (resolution check & frame overlay) FAL AI → short video + Lyria2 audio → merged via FFmpeg API A Gmail Approval step sends the draft to an approver; the flow continues only on “Approve”. Depending on user intent the workflow: Emails the newsletter to HubSpot contacts, and/or Saves HTML (+ JPG/Video URL) to a SharePoint library. How to set up Import the template Open the yellow sticky note and follow the checklist Create credentials for OpenAI, HubSpot (App Token), Microsoft 365, Gmail, and FAL AI. Enter them in n8n Credential Manager (never in the HTTP node). Edit the Configuration Settings Set node with your ENV_* variables. Activate the workflow, copy the production Webhook URL, and trigger it with JSON body { "text": "…" } or with a desired trigger. Requirements OpenAI account Microsoft 365 tenant (SharePoint & Outlook) HubSpot App Token FAL AI API Key (video & audio generation) How to customize Want a different language? Tweak the AI prompt inside AI Agent. Want a different storage provider? Change the SharePoint nodes to Google Drive or Dropbox. Skip video generation: set include_video to false in the incoming prompt. Change the distribution logic by adjusting the WF Result Switch node. Add more channels (e.g. Slack) by inserting additional branches after the Switch and modifying the intent determination at the beginning of the workflow.

Who is this for? This template is perfect for Gumroad creators, solopreneurs, digital product sellers, and freelancers who want to track and thank customers automatically — without spending time on manual work. What problem does this solve? Every sale is a moment to build trust. But manually checking your inbox for new orders, logging clients, and remembering to send a thank-you note? It’s time-consuming and inconsistent. This workflow handles it all: From sale → to sheet → to ping → to personalized “thank you” — all fully automated. What this workflow does: ✅ Triggers on each new sale on Gumroad 📋 Extracts buyer details, amount paid, and product purchased 📈 Logs the sale to a Google Sheet for tracking 📲 Sends a Telegram approval message to notify you 💌 (Optional) Sends a Gmail thank-you email to the buyer 🔁 Keeps your workflow organized with color-coded notes and sample data ⚙️ Setup Instructions: Create Gumroad API and connect the trigger node Authenticate with Google Sheets to store each client Connect your Telegram bot for real-time alerts (Optional) Setup Gmail API for sending thank-you emails Customize the email copy & sheet headers (e.g. % cut, timestamps) 🗒 Color-coded workflow notes: To make customization smooth, the workflow includes a color-coded sticky note system: 🟩 Green Notes – Main building blocks (trigger, logging, ping, email) 🟦 Blue Notes – Setup guidance and editable fields (e.g. your email or brand name) 🟨 Yellow Notes – Optional upgrades (e.g. swap Gmail, use AI email generator, change to WhatsApp) Each step has comments or hints to make your setup easy — whether you're new to n8n or a seasoned automator. 🔧 How to customize this workflow? 🎯 Swap Gmail with Outlook, SMTP, or Mailgun 🤖 Use AI (e.g. OpenAI or Claude) to draft personalized emails dynamically 📞 Replace Telegram with WhatsApp, Discord, or Slack 🗃️ Log to Airtable or Notion instead of Google Sheets 🧠 Add approval logic or advanced tagging in Gmail 🧾 Licensing & Support This template is built by Velebit from Innovatio. External links (Gumroad store or support email) are included in the notes for optional help and upgrades. A separate license applies to the paid version on Gumroad, which includes additional modules and commercial use rights. 📩 Support & customization: [email protected]