HubSpot deals to Excel with line items
“join the hubspot deals to the line items by deal id, make one row per line item or a blank product row when none, show deal details, product, qty, line total, and status: No line items, Amount differs, Discount over 30%, Agrees”
Join the HubSpot closed won deals to the Excel line items by deal id, make one row per line item or a blank product row when none, show deal details, product, qty, line total, and status: No line items, Amount differs, Discount over 30%, Agrees, with Discount % treated as whole percents (30 means 30%).
What the agent built
2 steps, each one an ordinary Mammoth step you can open and change.
- FileHubSpot closed won dealsCSV export · 15 rows
- FileExcel line itemsCSV export · 40 rows
- JoinBring in line items13 of 15 paired
- StepSet status using whole percentsStep 2
- ResultDeal Line Item Check42 rows · 11 flagged
- ScheduleRuns when you sayProposed
On the sample files, every step runs and the result has 42 rows.
- Download HubSpot closed won deals sample (15 rows)HubSpot: CRM > Deals > List view filtered to Closed Won this quarter > Export
- Download Excel line items sample (40 rows)Excel: File > Open workbook with deal line items > Export sheet as .xlsx/csv
What you get back
The result of that run, the rows to look at first.
| Deal ID | Deal name | Product | Quantity | Line total | Status | Company | Owner | Close date | Deal amount |
|---|---|---|---|---|---|---|---|---|---|
| 1014 | Orbit Training Bundle | · | · | · | No line items | Maple Street Media | Caleb Foster | 2026-09-23 | 9,200 |
| 1009 | Summit Starter Package | · | · | · | No line items | Harborview Finance | Chloe Nguyen | 2026-09-02 | 15,000 |
| 1013 | Pulse API Extension | Integration Support | 5 | 3,600 | Amount differs | Canyon Automotive | Zoe Turner | 2026-09-19 | 11,100 |
| 1013 | Pulse API Extension | API Extension | 7 | 3,500 | Amount differs | Canyon Automotive | Zoe Turner | 2026-09-19 | 11,100 |
| 1006 | Vertex Platform Expansion | Executive Training | 4 | 6,000 | Amount differs | Keystone Manufacturing | Jordan Price | 2026-08-08 | 19,800 |
| 1006 | Vertex Platform Expansion | Automation Pack | 3 | 3,000 | Amount differs | Keystone Manufacturing | Jordan Price | 2026-08-08 | 19,800 |
| 1006 | Vertex Platform Expansion | Implementation Services | 2 | 4,000 | Amount differs | Keystone Manufacturing | Jordan Price | 2026-08-08 | 19,800 |
| 1006 | Vertex Platform Expansion | Core Licenses | 5 | 5,000 | Amount differs | Keystone Manufacturing | Jordan Price | 2026-08-08 | 19,800 |
| 1003 | Atlas Renewal 2026 | Advisory Hours | 5 | 1,500 | Amount differs | SummitWorks | Priya Shah | 2026-07-18 | 15,600 |
| 1003 | Atlas Renewal 2026 | Analytics Bundle | 4 | 6,000 | Amount differs | SummitWorks | Priya Shah | 2026-07-18 | 15,600 |
| 1003 | Atlas Renewal 2026 | Core Platform | 6 | 6,000 | Amount differs | SummitWorks | Priya Shah | 2026-07-18 | 15,600 |
| 1001 | Northstar Q3 Expansion | Implementation Package | 1 | 4,000 | Agrees | Aster Cloud | Nora Blake | 2026-07-03 | 12,000 |
How it works
How to use the Deal Line Item Check workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Deal Line Item Check: questions
How do you export HubSpot deals to Excel with line items?
Which export should I use from HubSpot?
What happens to deals that do not match any line items?
How do I change the status rules?
Get early access to this workflow
It opens already built and working on sample files. Swap in your own exports to see your result.
Workflows like this
Remove duplicates, tidy names and addresses, fill the blanks, and merge files into one.
- Pivot table from raw dataTurn a raw sales export into a pivot table of revenue by region and month.See the workflow Built by the agent
- Merge Excel or CSV filesOne tidy table with every file's rows, re-sent rows dropped, and a Period columnSee the workflow Template
- Remove duplicatesOne row of each, with a Copies column saying how many there wereSee the workflow Template
- Remove blank rowsRemove rows that are empty or only contain spaces from an Excel export, while keeping the rest of the sheet unchanged.See the workflow Built by the agent
- Match names to a master listEach record with its master name (and ID), and how it matchedSee the workflow Template
- Multi-entity consolidationEvery entity's balances in one currency, by accountSee the workflow Template