Webhook and Microsoft SharePoint integration

Who's it for Content creators, SEO specialists, and marketing teams who want to automatically generate SEO-optimized content based on trending topics—complete with AI-generated images, optional videos, and ready-to-publish HTML. How it works / What it does Webhook receives a request with use case and video preferences. Get Trends XLSX downloads a spreadsheet (created by the Social Media Trends workflow) from SharePoint. Select Topic from Trends randomly picks one trending topic from the spreadsheet. AI Agent (GPT-4o) generates bilingual newsletter content about the selected trend. Get Newsletter Template fetches your HTML template; Build Newsletter injects the AI content. Optional creative assets: • Pollinations AI → generates a 1080 × 1350 image. • FAL AI → creates video from the image + Lyria2 audio → merged via FFmpeg. Gmail Approval sends the draft for review; continues only on approval. Upload all files (HTML + JPG + video URL) to your chosen storage provider. How to set up Import the template into n8n (cloud or self-hosted). Create credentials: OpenAI, Microsoft 365 (SharePoint), Gmail, and FAL AI. Upload your HTML newsletter template to SharePoint (see yellow sticky note for required placeholders). Ensure you have a trends spreadsheet (from the Social Media Trends workflow) in your SharePoint folder. Update Configuration Settings with your ENV_* variables. Activate the workflow and POST to the webhook: { "text": "usecase: blog post, include_video: true" }. Requirements n8n 1.33 + OpenAI account Microsoft 365 tenant (SharePoint) Gmail account FAL AI API Key (for video generation) A trends spreadsheet (from the Social Media Trends workflow) How to customize Change storage provider: replace SharePoint upload nodes with Google Drive, Dropbox, or S3. Modify topic selection: edit Select Topic from Trends for different selection logic. Adjust content tone: tweak the prompt in Prepare Newsletter Data. Skip video generation: set include_video: false in the webhook request.

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.

What this template does Receives meeting data via a webform, cleans/structures it, fills a Word docx template, uploads the file to SharePoint, appends a row to Excel 365, and sends an Outlook email with the document attached. Good to know Uses a community node: DocxTemplater to render the DOCX from a template. Install it from the Community Nodes catalog. The template context is the workflow item JSON. In your docx file, use placeholders. Includes a minimal HTML form snippet (outside n8n) you can host anywhere. Replace the placeholder WEBHOOK_URL with your Webhook URL before testing. Microsoft nodes require Azure app credentials with correct permissions (SharePoint, Excel/Graph, Outlook). How it works Webhook — Receives meeting form JSON (POST). Code (Parse Meeting Data) — Parses/normalizes fields, builds semicolon‑separated strings for attendees/absentees, and flattens discussion points / action items. SharePoint (Download) — Fetches the DOCX template (e.g., meeting_minutes_template.docx). Merge — Combines template binary + JSON context by position. DocxTemplater — Renders meeting_{{now:yyyy-MM-dd}}.docx using the JSON context. SharePoint (Upload) — Saves the generated DOCX to a target folder (e.g., /Meetings). Microsoft Excel 365 (Append) — Appends a row to your sheet (Date, Time, Attendees, etc.). Microsoft Outlook (Send message) — Emails the generated DOCX as an attachment. Requirements Community node DocxTemplater installed Microsoft 365 access with credentials for: SharePoint (download template + upload output) Excel 365 (append to table/worksheet) Outlook (send email) A Word template with placeholders matching the JSON keys Need Help 🔗 LinkedIn – Wessel Bulte