CRM Regional Sales Reports in Excel via n8n Webhook & DocMint

Generate CRM regional sales reports as an .xlsx file—automatically—using an n8n Webhook and DocMint

This workflow receives a CRM sales export via n8n Webhook, validates the payload, computes regional revenue totals, and then fills an Excel template using DocMint—returning the finished .xlsx directly in the webhook response.

What this workflow does

Built for accuracy and template compatibility, the workflow follows this flow:

• Receive & validate: Accepts a POST webhook request containing a reporting period, source, and a flat array of sales rows. If the rows array or period is missing/empty, it returns a 422 JSON error.
• Prepare report constants & mapping: Adds fixed constants (template name, company name, and currency) and maps incoming payload data to the fields required downstream.
• Confirm the Excel template: Uses n8n-nodes-docmint to read the Excel template fields, ensuring the template exists and determining which placeholders are required.
• Calculate and aggregate regional totals: Computes revenue per row and aggregates totals by region, including reps, units, revenue, and prior revenue—matching the structure expected by the template.
• Render & respond: Fills the workbook via DocMint and returns the rendered .xlsx, or returns another 422 if rendering fails.

Use cases

• Turn CRM sales exports into a standardized regional sales report every reporting cycle.
• Centralize report generation for SaaS operators who want consistent Excel outputs for leadership updates.
• Automate repeatable Excel reporting without manual spreadsheet calculations.

Technical details

• n8n Webhook (POST input + returns the generated .xlsx)
• n8n-nodes-docmint community node (self-hosted n8n only) to read template fields and render the Excel workbook
• Workflow nodes including if, set, code, and supporting sticky note documentation

Category: n8n automation workflow. Target audience: n8n users, automation engineers, SaaS operators.