Generate PDF pricing proposals from Excel with Gotenberg and Outlook

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.