Skip to content
Workflow · Calculate · Opening soon

Sales dashboard from a shared Google Sheet

Export the deals sheet from Google Sheets and load it into Mammoth. Add the team list, then group the valid deals by month and rep to get total closed amount and deal count.

Early access opens shortly. Check back soon.

Someone typed

“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”

The agent read it as

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.

  1. File
    Closed deals
    CSV export · 45 rows
  2. File
    Team list
    CSV export · 5 rows
  3. Join
    Add team list reps
    38 of 45 paired
  4. Step
    Summarize deals and flag exclusions
    Step 2
  5. Result
    Monthly Deal Dashboard
    28 rows · 28 flagged
  6. Schedule
    Runs when you say
    Proposed

On the sample files, every step runs and the result has 28 rows.

What you get back

The result of that run, the rows to look at first.

Monthly Deal DashboardSample data28 rows
20 included7 rep not on team list1 amount blank or not a number
MonthRepStatusClosed amount (USD)Deal countDealClose dateAmount (USD)
·Maya PatelAmount blank or not a number··Oakridge Foods expansion2026-09-30·
·Liam BrooksRep not on team list··Falcon Retail deal2026-07-186,700
·Liam BrooksRep not on team list··Lumen Hospitality renewal2026-07-2615,250
·Liam BrooksRep not on team list··Riverview Logistics renewal2026-08-1413,800
·Liam BrooksRep not on team list··Apex Retail expansion2026-08-0910,100
·Liam BrooksRep not on team list··Granite Systems pilot2026-09-127,800
·Liam BrooksRep not on team list··Monarch Tech renewal2026-09-2617,600
·Liam BrooksRep not on team list··Suncrest Health pilot2026-10-079,600
2026-07-01Jordan LeeIncluded33,8002···
2026-07-01Maya PatelIncluded29,0002···
2026-07-01Noah KimIncluded15,7002···
2026-07-01Priya ShahIncluded21,7002···
28 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the Monthly Deal Dashboard workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 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?
Export the deals sheet from Google Sheets and load it into Mammoth. Add the team list, then group the valid deals by month and rep to get total closed amount and deal count. Rows stay flagged if 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 export should you use from Google Sheets?
Use a file export of the sheet with the deal rows you want to summarize. Make sure it includes the columns you need for the rules and the dashboard, such as close date, amount, and rep.
What happens to rows that do not match the rules?
They are left out of the summary table and flagged so you can review them. The flagged reason can show which rule failed, such as a bad date, a blank amount, or a rep that is not on the list.
How do you change the rules later?
Edit the rule text in plain words, then run the workflow again. You can change which columns are checked, which values count as valid, and how the summary groups the rows.

Get early access to this workflow

It opens already built and working on sample files. Swap in your own exports to see your result.

Early access opens shortly. Check back soon.

Workflows like this

Schedules, commissions, costing and margins, worked out the same way from every new export.

All calculate workflows →