Overview
Use Google Sheets as a data source for Chartcastr. Your Google Drive houses your spreadsheets, and Chartcastr can access them to fetch charts and create visualizations to connect with your destinations.Methods
Chartcastr offers two ways to use Google Sheets as a source:Premade Charts
Use existing charts from your spreadsheet — Chartcastr reads the configuration and renders beautiful visuals
Custom Data Range
Select a data range and configure the chart settings directly in Chartcastr (Coming Soon)
| Method | Best For | Data Privacy | Flexibility |
|---|---|---|---|
| Premade Charts | Already have charts in Google Sheets | ✅ Private (OAuth) | High - Changes in Sheet auto-reflect |
| Custom Data Range | Want to create charts from raw data | ✅ Private (OAuth) | Medium - May require manual updates |
Pro Tip: Premade Charts are highly flexible. If you change labels, data ranges, grouping, or titles in Google Sheets, Chartcastr will automatically register and reflect those changes in your next pulse. Custom Data Ranges are less flexible and may require more manual configuration effort if your source data structure changes significantly.
Authentication
Connect your Google account to Chartcastr with OAuth. The authenticated account must have at least Viewer permissions on the sheets you want to access.This is the Google account you use to log in to Chartcastr.
Power Up with AI Context
Provide deep background information for AI analysis by linking external documents directly to your Google Sheets source.Analysis Context
Learn how to add custom notes and documents to improve AI insights.
Source Groups
Share context across multiple sheets efficiently.