Sales dashboard from a shared Google Sheet
“turn the deals sheet my sales team keeps editing into a monthly dashboard table: total closed amount and deal count by month and rep, and flag rows the dashboard has to leave out because the close date is not a date, the amount is blank or not a number, or the rep is not on the team list”
Turn the Closed deals my sales team keeps editing into a monthly dashboard table: total closed amount and deal count by month and rep, and flag rows the dashboard has to leave out because the close date is not a date, the amount is blank or not a number, or the rep is not on the Team list.
What the agent built
2 steps, each one an ordinary Mammoth step you can open and change.
- FileClosed dealsCSV export · 45 rows
- FileTeam listCSV export · 5 rows
- JoinAdd team list reps38 of 45 paired
- StepSummarize deals and flag exclusionsStep 2
- ResultMonthly Deal Dashboard28 rows · 28 flagged
- ScheduleRuns when you sayProposed
On the sample files, every step runs and the result has 28 rows.
- Download Closed deals sample (45 rows)Google Sheets: Deals tab > File > Download > CSV
- Download Team list sample (5 rows)Google Sheets: Team list tab > File > Download > CSV
What you get back
The result of that run, the rows to look at first.
| Month | Rep | Status | Closed amount (USD) | Deal count | Deal | Close date | Amount (USD) |
|---|---|---|---|---|---|---|---|
| · | Maya Patel | Amount blank or not a number | · | · | Oakridge Foods expansion | 2026-09-30 | · |
| · | Liam Brooks | Rep not on team list | · | · | Falcon Retail deal | 2026-07-18 | 6,700 |
| · | Liam Brooks | Rep not on team list | · | · | Lumen Hospitality renewal | 2026-07-26 | 15,250 |
| · | Liam Brooks | Rep not on team list | · | · | Riverview Logistics renewal | 2026-08-14 | 13,800 |
| · | Liam Brooks | Rep not on team list | · | · | Apex Retail expansion | 2026-08-09 | 10,100 |
| · | Liam Brooks | Rep not on team list | · | · | Granite Systems pilot | 2026-09-12 | 7,800 |
| · | Liam Brooks | Rep not on team list | · | · | Monarch Tech renewal | 2026-09-26 | 17,600 |
| · | Liam Brooks | Rep not on team list | · | · | Suncrest Health pilot | 2026-10-07 | 9,600 |
| 2026-07-01 | Jordan Lee | Included | 33,800 | 2 | · | · | · |
| 2026-07-01 | Maya Patel | Included | 29,000 | 2 | · | · | · |
| 2026-07-01 | Noah Kim | Included | 15,700 | 2 | · | · | · |
| 2026-07-01 | Priya Shah | Included | 21,700 | 2 | · | · | · |
How it works
How to use the Monthly Deal Dashboard 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.
Monthly Deal Dashboard: questions
How do you turn a shared Google Sheet into a sales dashboard?
What export should you use from Google Sheets?
What happens to rows that do not match the rules?
How do you change the rules later?
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
Schedules, commissions, costing and margins, worked out the same way from every new export.
- 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
- Real estate commission splitWork out real estate commission on each closed sale and split it between the listing agent, buying agent and brokerage.See the workflow Built by the agent
- Loan amortization from statementsBuild a monthly loan amortization schedule from an Excel export, with interest, principal, and remaining balance for each loan.See the workflow Built by the agent
- Accrued expenses scheduleBuild an accrued expenses schedule from QuickBooks exports. Match purchase orders to vendor bills, calculate unbilled amounts, and flag items that need accrual.See the workflow Built by the agent
- RFM segmentsEvery customer scored 1-5 on recency, frequency and spend, with a segmentSee the workflow Template
- Sales velocityEach rep's open deals, win rate, deal size, sales cycle and velocity, and the team'sSee the workflow Template