Multi-sheet workbooks to one channel, many tabs, one delivery

Multi-sheet workbooks to one channel, many tabs, one delivery

Most spreadsheet workbooks are not one tab. They're five, or fifteen, or fifty. The "Marketing 2026" sheet has a tab per channel. The "Finance Master" has a tab per region. The agency reporting template has a tab per client.

Chartcastr was built around the assumption that you keep your data exactly where it lives. That includes across tabs. When you connect a Google Sheets source, you pick the chart, wherever that chart lives in the workbook. You can pick a chart from one tab today and a chart from a different tab tomorrow.

How it works

Each Chartcastr source is one chart. If you have five charts you want to send, you create five sources, but they can all live in the same workbook.

Walking through it:

1. You have a workbook with tabs for Revenue, Spend, MAU, Retention, Pipeline.
2. Each tab has its own chart at the top.
3. You add five Chartcastr sources, one per tab, each pointing at its tab's chart.
4. You connect all five to the same Slack channel.
5. You set the same schedule on all five, say, Monday mornings.

Monday morning, five charts land in #metrics. Each from its own tab. One workbook, one channel.

Source groups make this cleaner

When you've got several charts that tell one story, group them. A source group lets you treat the five sources as a unit for AI analysis, so the Monday post doesn't just include five charts, it includes a summary that connects them.

Revenue is up 8% week-over-week. Spend is up 12%, both Meta and Google. MAU flat. The spend-to-revenue ratio is the thing to watch this week. We're paying more for the same audience size.

That's a summary that requires the AI to look at all five sources together. Source groups make that the default.

Patterns we see

A few common shapes:

• Department dashboards. One workbook, five tabs (sales / marketing / product / support / finance), one chart per tab, one Slack channel per audience.
• Client reporting (agencies). One workbook per client, multiple tabs (overview / paid / organic / email), all delivered to a Slack Connect channel shared with the client.
• Geo/region splits. One workbook with a tab per region, charts shipped to a regional channel.
• Cohort tracking. One tab per cohort or experiment, charts shipped on the cadence the cohort needs.

The workbook stays the source of truth. Chartcastr is the delivery layer.

The "different schedules per tab" trick

Sometimes you want different cadences for different charts in the same workbook. Revenue daily, MAU weekly, retention monthly. Each Chartcastr source has its own schedule, so this works without any extra setup, three sources, three schedules, all pointing at the same workbook.

Setting it up

1. In Chartcastr add a Google Sheets source. Pick the workbook, pick the chart from whichever tab.
2. Repeat for each chart. Each one is a separate source.
3. (Optional but recommended) Group the related sources together.
4. Connect destinations and schedules per source.

If you reorganise the workbook later, new tabs, renamed tabs, Chartcastr follows the chart, not the tab name. Reference: Premade Charts docs.

When to consolidate vs split

If your team is wading through five separate Slack messages and not reading any of them, the answer isn't fewer charts, it's a source group with a single AI summary on top. The charts can stay individual. The summary becomes the headline. That's the pattern that gets read.