Premade Charts from Google Sheets, the deep tour

Premade Charts from Google Sheets, the deep tour

Most teams already have charts in Google Sheets. They built them once, the data is wired up correctly, and people occasionally remember to look at the tab. The problem isn't the chart. It's the trip to the chart.

The Google Sheets source in Chartcastr was built around that observation. You don't rebuild the chart. You point us at the one you already have, and we render and deliver it on a schedule, to Slack, email, Google Chat, or WhatsApp.

This is the full tour of what's in there.

What "premade chart" actually means

When you select a Google Sheets source in Chartcastr, you pick an existing chart from one of your spreadsheets. We read the chart's configuration directly out of the sheet, the type, the colour palette, the axis titles, the legend position, the series, the ranges. None of that is reconstructed. It's pulled from the same chart object Sheets uses to render the chart for you.

Then we render it ourselves with our charting engine, send it to your destination, and move on.

The benefit of this approach is that you don't have a second source of truth. Change the chart in Sheets, colours, ranges, grouping, titles, and the next pulse picks up your changes. There's nothing to re-sync, nothing to re-import.

The chart types we support

Stacking, including 100% stacked, is preserved when the chart is set up that way in Sheets. So is the legend position, the axis titles, and any series-level colour overrides.

What auto-syncs when you change the sheet

The point of Premade Charts is that it follows your sheet, not a snapshot of it. Concretely:

• New rows or values, picked up on the next pulse.
• Range changes, if you expand the chart's range in Sheets, the new rows are included automatically.
• Grouping changes, if you change how data is aggregated or categorised, the chart redraws.
• Cosmetic changes, title, colours, legend, axis labels.

You don't have to come back to Chartcastr to confirm anything. The next scheduled pulse uses whatever the chart looks like at that moment.

Where it lives in your workflow

The most common pattern is a Slack channel that gets the chart at a fixed cadence:

• Daily revenue for finance, every morning.
• Weekly active users for product, Monday at 9.
• Monthly campaign performance for marketing, first of the month.

Each pulse can include an AI-written summary that explains what changed and what to do about it. The summary is optional, useful when the chart doesn't speak for itself, and it's the part that makes the difference between "another graph in the channel" and "an actual report".

Privacy

The Google Sheets source uses OAuth, the account you log into Chartcastr with is the account that needs view access to the sheet. Your sheets stay private. Nothing has to be published to the web. There's an alternate path that uses a published chart URL if you want it, but most teams don't.

What it doesn't do

We don't (yet) support candlestick, histogram, bubble, waterfall, treemap, org chart, scorecard, or geographic charts. We detect them in your spreadsheet and tell you up front rather than rendering something misleading. There's a separate post on why we hold the line on those.

Getting started

1. Go to Sources and pick Google Sheets.
2. Search for the spreadsheet, pick the chart you want.
3. Connect a destination, Slack channel, email distribution, Google Chat space.
4. Set a schedule.

The first delivery goes out at the next scheduled run. Full setup notes live in the Premade Charts docs.

The rest of this series goes deeper on individual chart types and patterns, start with bar charts or jump to whichever shape your team uses most.