{"product_id":"crm-regional-sales-reports-in-excel-via-n8n-webhook-docmint","title":"CRM Regional Sales Reports in Excel via n8n Webhook \u0026 DocMint","description":"\u003ch3\u003eGenerate CRM regional sales reports as an .xlsx file—automatically—using an n8n Webhook and DocMint\u003c\/h3\u003e\n\u003cp\u003eThis workflow receives a CRM sales export via \u003cstrong\u003en8n Webhook\u003c\/strong\u003e, validates the payload, computes regional revenue totals, and then fills an \u003cstrong\u003eExcel template\u003c\/strong\u003e using \u003cstrong\u003eDocMint\u003c\/strong\u003e—returning the finished \u003cstrong\u003e.xlsx\u003c\/strong\u003e directly in the webhook response.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eBuilt for accuracy and template compatibility, the workflow follows this flow:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceive \u0026amp; validate:\u003c\/strong\u003e Accepts a POST webhook request containing a \u003cem\u003ereporting period\u003c\/em\u003e, \u003cem\u003esource\u003c\/em\u003e, and a flat array of \u003cem\u003esales rows\u003c\/em\u003e. If the \u003cstrong\u003erows array\u003c\/strong\u003e or \u003cstrong\u003eperiod\u003c\/strong\u003e is missing\/empty, it returns a \u003cstrong\u003e422 JSON error\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrepare report constants \u0026amp; mapping:\u003c\/strong\u003e Adds fixed constants (template name, company name, and currency) and maps incoming payload data to the fields required downstream.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfirm the Excel template:\u003c\/strong\u003e Uses \u003cstrong\u003en8n-nodes-docmint\u003c\/strong\u003e to read the Excel template fields, ensuring the template exists and determining which placeholders are required.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculate and aggregate regional totals:\u003c\/strong\u003e Computes revenue per row and aggregates totals by \u003cstrong\u003eregion\u003c\/strong\u003e, including reps, units, revenue, and prior revenue—matching the structure expected by the template.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRender \u0026amp; respond:\u003c\/strong\u003e Fills the workbook via DocMint and returns the rendered \u003cstrong\u003e.xlsx\u003c\/strong\u003e, or returns another \u003cstrong\u003e422\u003c\/strong\u003e if rendering fails.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTurn CRM sales exports into a standardized \u003cstrong\u003eregional sales report\u003c\/strong\u003e every reporting cycle.\u003c\/li\u003e\n  \u003cli\u003eCentralize report generation for SaaS operators who want consistent Excel outputs for leadership updates.\u003c\/li\u003e\n  \u003cli\u003eAutomate repeatable Excel reporting without manual spreadsheet calculations.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n Webhook\u003c\/strong\u003e (POST input + returns the generated \u003cstrong\u003e.xlsx\u003c\/strong\u003e)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n-nodes-docmint\u003c\/strong\u003e community node (\u003cstrong\u003eself-hosted n8n only\u003c\/strong\u003e) to read template fields and render the Excel workbook\u003c\/li\u003e\n  \u003cli\u003eWorkflow nodes including \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, and supporting \u003cstrong\u003esticky note\u003c\/strong\u003e documentation\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eCategory: \u003cstrong\u003en8n automation workflow\u003c\/strong\u003e. Target audience: \u003cstrong\u003en8n users, automation engineers, SaaS operators\u003c\/strong\u003e.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45916248670387,"sku":"N8N-18787","price":62.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/qqR1_O97bPrHU9hoPi7FM_QRscajTw.png?v=1788013761","url":"https:\/\/buyflowscripts.com\/products\/crm-regional-sales-reports-in-excel-via-n8n-webhook-docmint","provider":"N8N Commerce","version":"1.0","type":"link"}