HubSpot workflow
HubSpot Quote Template (Google Sheets)
Turn every HubSpot deal into a quote your finance team can actually trust, with the math done in Google Sheets. Portant merges deal data and line items into your pricing workbook, then exports a PDF customers can sign.
~5 min setup · Used by 100+ teams
Trusted by 40,000+ teams
Overview
Generate HubSpot quotes inside a Google Sheets pricing workbook
RevOps and finance teams who price in spreadsheets know the routine. The deal closes in HubSpot, then someone exports a CSV, retypes line items, and patches the discount logic in a workbook that's already two versions out of date. By the time the quote reaches the customer, the math doesn't match what HubSpot showed.
This workflow pushes HubSpot deal data and line items straight into your pricing Sheet, so the formulas you already trust do the math. Data merge handles field mapping, line items fill the table rows, and approval workflows route any non-standard discount before the quote leaves the building.
It fits RevOps, finance, and sales ops teams at companies with tiered, usage-based, or multi-currency pricing where the spreadsheet is the source of truth. Pair it with the rest of Portant's quotes workflows when sales needs a branded Doc and finance needs the live workbook from the same HubSpot deal.
Who is this for
Is this template right for you?
Sales reps and RevOps teams who generate quotes from CRM deals.
-
Pricing math runs itself in Sheets. Portant's data merge populates the rows the workbook needs and the existing Sheets formulas handle tiers, discounts, and totals, so reps stop rebuilding the pricing Sheet for every deal.
-
One pricing model, one source of truth. Portant's line items feature pushes every deal line item into the same rows your formulas reference, so finance and sales never argue about which workbook version is right.
-
Fewer discount surprises. Portant's approval workflows hold any quote with a non-standard discount until the right approver signs off, so unauthorised pricing never reaches the customer.
Setup
How to set up the Google Sheets quote workflow
-
01
Step 1: Connect HubSpot and Google Sheets
In Portant, link your HubSpot account and the Google Drive that hosts your pricing workbook. Pick the Sheet template that matches your pricing model.
-
02
Step 2: Map deal fields and line items
Tag every HubSpot field you want in the Sheet, including line item rows, deal totals, currency, and any custom pricing properties your formulas reference.
-
03
Step 3: Set the trigger and approval rules
Choose the HubSpot trigger (deal stage, custom property, or quote-ready flag) and add approval thresholds for discounts, total deal size, or non-standard terms.
-
04
Step 4: Test, then turn it on
Run a test deal end to end, confirm the totals on the merged Sheet, and roll it out so reps can generate quotes from any qualifying HubSpot deal.
Frequently asked questions
Connect HubSpot and Google Sheets in Portant, then map the line items association on the deal to a row range in your Sheet. Portant pulls every line item with its SKU, quantity, price, and discount into the Sheet whenever the workflow runs.
No. HubSpot's native quote tool generates branded HTML quotes inside HubSpot, not a working Google Sheets workbook. This Portant template fills that gap by merging HubSpot deal data and line items into a Google Sheet you control, so your pricing formulas drive the totals.
Yes. Portant writes HubSpot values into the named ranges and table rows you choose, so your existing formulas for tiers, discounts, taxes, and totals keep running untouched. You only map the input cells once, then every new HubSpot deal flows into the same model.
Use Portant's approval workflows to set discount, total, or term thresholds on the quote. When a deal trips a threshold, the workflow pauses, routes the merged Sheet to the named approver in HubSpot or via email, and only generates the customer PDF after sign-off.
Yes. Many teams pair this Sheets workflow with the Portant HubSpot quote workflow that outputs a Google Doc, using the same HubSpot deal as the source. Sales sends the branded Doc to the buyer while finance keeps the live workbook for internal review.
Customers see a PDF, not the live Sheet. Portant exports the merged Google Sheet as a PDF using your branded layout, files it to Drive, and attaches it to the HubSpot deal so the customer-facing artefact stays separate from the working pricing model.
Related templates
HubSpot Quote Workflow
Pull every HubSpot deal line item into a branded quote in Google Docs, then route it for approval and signature without leaving the CRM. Portant Line items, Data merge, and eSignatures handle the table, the fields, and the signing.
View template
Sales Quotes
Send sales quotes from your Google Sheet to a branded Google Doc without retyping a single line. Portant's data merge pulls customer details and line items into the quote, ready for eSignature.
View template
HubSpot Invoice Template
Generate a branded invoice from any HubSpot deal in Google Docs, with line items, totals, and billing details already filled. Portant's data merge pulls deal fields and HubSpot line items into the template, then saves the invoice back to the deal.
View templateJoin over 40k+ teams using Portant
Portant has been a game-changer for Clipboard! It's saved our sales team countless hours every week by generating order forms, proposals and contracts with info from HubSpot automatically filled in.
With Portant, I run documents directly from HubSpot. No jumping between platforms. No copying data.
Portant replaced three separate tools for us. One platform handles docs, signatures, and follow-ups without leaving HubSpot.
Portant was the simplest and quickest signing integration I've ever implemented, it works natively with HubSpot.
At RepCard, Portant gave us an end-to-end automated workflow inside HubSpot, we replaced manual agreement creation at scale.
We're seeing higher average closed revenue with Portant and faster days to close, it's showing us a material impact on sales velocity.
Love this product. Have been using it for over a year and the integration to Google Workspace is awesome. Lots of credit for listening to your users!
When the executive team asks for an extension document, Portant gets it to them in about an hour, it's empowered my whole team.
Truly a gamechanger! Portant streamlines these tasks and allows me to focus on the things that require my attention and problem-solving!
This software brilliantly takes over the tedious process of creating and sending invoices. This not only saves time but massively reduces errors of data entry.
This product is a gamechanger for all of those painful manual document merges. Love what you and the team have built!
Our reps used to spend 30 minutes per proposal. Now it’s under two minutes and the documents look better than ever.