> ## Documentation Index
> Fetch the complete documentation index at: https://docs.chartcastr.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Google Sheets source

> Connect Google Sheets to Chartcastr to share premade charts or build visualizations from raw data ranges. Automate delivery to Slack, Teams, or email.

## 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:

<CardGroup cols={2}>
  <Card title="Premade Charts" icon="chart-line" href="/integrations/sources/google-sheets/premade-charts">
    Use existing charts from your spreadsheet — Chartcastr reads the configuration and renders beautiful visuals
  </Card>

  <Card title="Custom Data Range" icon="table" href="/integrations/sources/google-sheets/custom-data-range">
    Select a data range and configure the chart settings directly in Chartcastr (Coming Soon)
  </Card>
</CardGroup>

| 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  |

<Note>
  **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.
</Note>

## 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.

<Note>
  This is the Google account you use to log in to Chartcastr.
</Note>

## Power Up with AI Context

Provide deep background information for AI analysis by linking external documents directly to your Google Sheets source.

<CardGroup cols={2}>
  <Card title="Analysis Context" icon="brain" href="/analysis/context/overview">
    Learn how to add custom notes and documents to improve AI insights.
  </Card>

  <Card title="Source Groups" icon="tags" href="/admin/sources/source-groups">
    Share context across multiple sheets efficiently.
  </Card>
</CardGroup>

## Common Pairings

Google Sheets data is most powerful when delivered to where your team already communicates.

<CardGroup cols={2}>
  <Card title="Slack" icon="slack" href="/integrations/destinations/slack">
    The perfect companion for high-frequency data pulses.
  </Card>

  <Card title="Microsoft Teams" icon="microsoft" href="/integrations/destinations/teams">
    Seamlessly deliver charts to your Teams channels.
  </Card>
</CardGroup>