n8n SharePoint DOCX Generator: Outlook Emails + OpenAI + Pandoc

Generate DOCX documents from Outlook requests—automatically

This n8n workflow watches your Microsoft Outlook mailbox for document-generation requests, matches each email to the right SharePoint template using OpenAI, fills it, converts it to DOCX with Pandoc, uploads the result back to SharePoint, and emails the finished file to the requester.

What this workflow does

• Detects incoming requests: Triggers on every new email received in Microsoft Outlook.
• Validates the request: Extracts sender, subject, and body text, then authorizes the request by checking the sender domain and a required subject/body keyword.
• Builds a template catalog from SharePoint: Retrieves template metadata from a SharePoint list using the Microsoft Graph API and prepares a condensed catalog for matching.
• Selects the best template with OpenAI: Uses OpenAI to choose the most suitable template and extract structured fields (e.g., party names and dates) from the email.
• Handles unmatched requests: If no template fits, replies in Outlook with available document types and why it could not match.
• Generates filled content and converts to DOCX: Downloads the template from SharePoint, recreates it as filled GitHub-flavored Markdown, then sends the Markdown to a Pandoc HTTP service to produce a DOCX.
• Uploads and responds: Uploads the generated DOCX back to SharePoint via Microsoft Graph and replies to the original Outlook email with the DOCX attached and a SharePoint link.

Use cases

• Automate document creation (letters, forms, agreements) when users email request details.
• Centralize template management in SharePoint while letting OpenAI map email text to the correct template and fields.
• Provide a self-service “email → DOCX → SharePoint link” workflow for internal teams.

Technical details

• Microsoft Outlook (read new emails, reply with attachments)
• Microsoft Graph API (list templates, upload generated DOCX)
• OpenAI (template matching + structured field extraction)
• Pandoc HTTP service (Markdown → DOCX conversion)
• n8n nodes/tools: if, set, code, no op, sticky note, http request

Category: n8n automation workflow. Built for n8n users, automation engineers, and SaaS operators who need reliable, template-driven DOCX generation.