Turn your BigQuery views into Slack reports. No dashboards.
Connect a SQL view to Chartcastr and schedule it as a Slack pulse — your team sees the numbers without logging into anything.
You've done the hard part: the data is in BigQuery, the views are clean, the rollups run on schedule. The missing piece is getting those numbers in front of the people who need them — without asking everyone to bookmark yet another dashboard.
Data sits in BigQuery. Nobody sees it without logging in.
You've built a solid data pipeline. The problem isn't the data — it's distribution.
Dashboards Nobody Checks
Looker, Data Studio, Metabase — they require your team to remember to log in. Most don't, even when the data matters.
Manual Screenshot Rituals
Someone runs the query, screenshots the chart, pastes it into Slack. Every week. It takes longer than it looks and breaks when that person is away.
Context Arrives Too Late
By the time someone notices a metric has moved, the moment to act has passed. Weekly reviews discuss last week's problems.
The pipeline
Chartcastr connects to Google Sheets as a data source. Google Sheets connects to BigQuery via Connected Sheets (the BigQuery Data Connector). This gives you a clean, no-code path from your SQL views to Slack.
BigQuery SQL view
Write the query that shapes your data — rollups, aggregations, period comparisons. This is where your SQL expertise pays off.
A simple SELECT with GROUP BY and date filters is all you need. Chartcastr will visualize whatever columns you expose.
Google Sheets Connected Sheets
In a Google Sheet, go to Data → Data Connectors → Connect to BigQuery. Point it at your view. The sheet stays in sync with BigQuery automatically.
Connected Sheets queries BigQuery on refresh — no data export, no stale snapshots. Alternatively, use a Scheduled Query to write results into a sheet on a recurring schedule.
Chartcastr source
Connect the Google Sheet as a Chartcastr data source. Select the data range — Chartcastr detects your columns and suggests chart types.
Paste the sheet URL, select the tab and range, done. No API keys, no service accounts on the Chartcastr side.
Connection + pulse schedule
Pick the Slack channel, set the cadence (daily, weekly, custom), and Chartcastr delivers a chart with an AI-written summary explaining what moved.
Your team sees the chart in Slack, can ask follow-up questions in-thread, and never needs to log into BigQuery or a dashboard.
Step-by-step setup
Assumes you already have a BigQuery project with data. Total time: ~15 minutes.
Create or identify your BigQuery view
Write a SQL view (or use an existing one) that returns the data you want to share. Keep columns human-readable — column names become chart labels.
Connect BigQuery to Google Sheets
Open a new Google Sheet → Data → Data Connectors → Connect to BigQuery. Select your project, dataset, and view. Click "Apply" to run the query and pull results into the sheet.
Set up Chartcastr
In Chartcastr, add a new Google Sheets source. Paste the sheet URL, select the Connected Sheets tab, choose your data range.
Connect Slack and create a connection
Authorize Chartcastr to post to your Slack workspace. Create a connection: pick the data source you just set up, choose a channel, confirm the chart preview.
Set a schedule and activate
Choose your delivery cadence — daily at 9am, every Monday at 8am, or a custom schedule. Activate the connection. Your team gets the first pulse at the next scheduled time.
What your team sees in Slack
A Chartcastr pulse lands in your chosen Slack channel as a rich message — not a raw data dump.
📊 Weekly Revenue by Region — BigQuery pulse
APAC up 18% week-over-week, driven by a strong close in AU enterprise deals. EMEA flat. Americas down 6% — three large deals pushed to next week per CRM notes. Overall revenue $2.1M, 4% above weekly target.
Chart image
High-res bar, line, or area chart generated from your data — no chart builder, no manual formatting.
AI summary
A plain-English explanation of what moved and why — trend detection, anomaly flags, period comparisons.
In-thread Q&A
Reply to the pulse to ask follow-up questions. Chartcastr already has your data in context and answers immediately.
Frequently Asked Questions
Frequently Asked Questions
Related
BigQuery Integration
How Chartcastr connects to BigQuery as a data source
BigQuery → Slack Integration Path
Technical overview of the BigQuery to Slack connection
Loading Google Sheets into BigQuery (2026 Guide)
Step-by-step: External Tables, Dataform, and Scheduled Queries
Best Data Integration Tools: Sheets to BigQuery
Fivetran, Airbyte, Dataform, and 6 other tools compared
BigQuery → Slack
Ready to get BigQuery data into Slack?
Connect your BigQuery view via Google Sheets, pick a channel, set a schedule. Your team gets clean data pulses with AI analysis — without logging into anything.
No card required. Setup in 3 minutes.
