Every growing team hits the same wall: you know you should be tracking channel mix, customer segments, or product lines, but your “reporting” lives in half-finished spreadsheets and screenshots from last month’s dashboard.
Donut charts in Google Sheets quietly fix that. Because each slice represents a portion of the whole, they’re perfect for questions like “Where did this week’s leads come from?” or “Which offers drove 80% of revenue?” Set up one sheet with labeled categories in the first column, metrics in the second, and Sheets turns that into a visual that even a distracted executive understands at a glance. You can quickly customize colors, labels, and titles so every stakeholder sees the story: what’s growing, what’s shrinking, and what needs attention.
Now imagine an AI agent handling the boring part: pulling in CRM exports, cleaning columns, inserting or updating the donut chart, and formatting labels before your Monday standup. Instead of chasing exports, you’re simply opening Google Sheets, where the AI computer agent has already refreshed your donut charts overnight, ready for decisions, not data janitorial work.
Picture this: it’s Monday morning, your CEO wants to see which campaigns actually drove revenue last week, and you’re still dragging CSVs into Google Sheets. Let’s walk through how to build donut charts the traditional way, then progressively automate them until an AI computer agent does the heavy lifting for you.
Use when: You need a quick view of how each channel contributes to total leads or revenue.
Google’s official instructions for pie and donut charts are here: https://support.google.com/docs/answer/9143036
Use when: You report revenue or users by region.
More detail on formatting and customizing: https://support.google.com/docs/answer/63824
Use when: You want to visualize survey or NPS outcomes.
This is almost identical to Google’s “Course feedback” example, just using a donut instead of a classic pie.
Manual works for a one‑off. But for an agency, sales team, or recurring weekly report, you want data flowing in automatically while Google Sheets updates the donut chart.
Good for: Teams already living in Sheets who just need less copy‑paste.
=IMPORTRANGE("source_spreadsheet_url","Tab!A1:B100").Reference on chart ranges and data: https://support.google.com/docs/answer/190718
Pros:
Cons:
Good for: Agencies and sales teams pulling from CRMs, ad platforms, or email tools.
Example: Automatically update a “Leads by Source” donut.
QUERY or PIVOT TABLE to aggregate by Source.
Pros:
Cons:
Technically code, but worth mentioning.
Docs for scripts managing Sheets objects: https://developers.google.com/apps-script/guides/sheets
Pros:
Cons:
At some point, your workflows spill beyond what APIs and zaps can touch: downloading CSVs, logging into dashboards, cleaning weird exports, or building one‑off donut charts for clients.
This is where Simular’s AI computer agents become your “reporting assistant” that actually uses your computer like a human.
Scenario: A performance agency creating weekly channel‑mix donut charts for 15 clients.
With Simular Pro:
Pros:
Cons:
Scenario: A SaaS founder wants a daily donut chart of MRR by plan and leads by source, ready before their morning coffee.
Your Simular agent can:
You can then trigger this via a webhook from your existing pipeline, or on a schedule, so the dashboard feels “alive” without you touching anything.
By starting with a single donut chart and gradually delegating the surrounding busywork to an AI computer agent, you turn reporting from a weekly time sink into a background process that simply delivers insight.