Skip to main content

Generate PDF pricing proposals from Excel with Gotenberg and Outlook

Workflow preview

Generate PDF pricing proposals from Excel with Gotenberg and Outlook preview
Open on n8n.io

Overview

How it works

  1. Webhook Trigger — A web form POSTs prospect details, selected services, discount level, and requestor info to the webhook endpoint.
  2. Fetch Pricing Sheet — Retrieves all rows from your pricing_request.xlsx Excel table in OneDrive/SharePoint.
  3. Process & Price — Filters the pricing rows to the selected services, applies the correct Discount / Retail / Premium price tier, and calculates the total.
  4. Build HTML — Renders a fully branded HTML proposal document with cover info, line-item pricing table, terms, and a signature block.
  5. Convert to PDF — Sends the HTML to a self-hosted Gotenberg instance, which returns a print-ready PDF.
  6. Email Proposal — Delivers the PDF as an attachment via Gmail OAuth2 to the requester and any internal recipients you configure.