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

# Premade Google Sheets charts

> Import existing charts from your Google Sheets spreadsheets into Chartcastr. Select specific charts and schedule automated delivery to your team.

## Overview

Extract existing chart configurations from your Google Sheets and render them beautifully with Chartcastr's advanced charting engine. Your data stays private and secure.

<Info>
  **Recommended** — This is the best option for most use cases. Reuses your existing chart configurations while keeping data private.
</Info>

## How It Works

1. Connect your Google account to Chartcastr
2. Select a spreadsheet from your Google Drive
3. Choose an existing chart from the spreadsheet
4. Chartcastr automatically:
   * Extracts the chart configuration (type, colors, axes, series, etc.)
   * Pulls the data from the specified ranges
   * Renders a beautiful chart using Recharts
5. Save as a source and connect to your destinations

## Features

* ✅ **Private Data**: Keep your spreadsheets private — no need to publish publicly
* ✅ **Full Configuration**: Preserves chart type, colors, axis titles, legends, and stacking
* ✅ **Multiple Chart Types**: Supports bar, line, area, pie, and scatter charts
* ✅ **Live Preview**: See exactly how your chart will look before saving
* ✅ **OAuth Authentication**: Secure access using your Google account
* ✅ **Auto-sync**: Data, ranges, grouping, and styling update automatically when your spreadsheet changes

## Automatic Reflection of Changes

One of the key benefits of using **Premade Charts** is that Chartcastr automatically registers changes made within your spreadsheet. If you perform any of the following in Google Sheets:

* **Update Data**: Add new rows or change existing values
* **Adjust Ranges**: Expand or shrink the data ranges assigned to the chart
* **Change Grouping**: Modify how data is aggregated or categorized
* **Formatting**: Update chart titles, legend positions, or series colors

These changes will be automatically detected and reflected in Chartcastr. This provides a much more flexible experience than **Custom Data Ranges**, which may require manual adjustments if your data structure changes significantly.

## Supported Chart Types

Chartcastr supports the following Google Sheets chart types:

| Google Sheets Type | Rendered As | Notes             |
| ------------------ | ----------- | ----------------- |
| Column Chart       | Bar Chart   | Vertical bars     |
| Bar Chart          | Bar Chart   | Horizontal bars   |
| Line Chart         | Line Chart  | Standard lines    |
| Area Chart         | Area Chart  | Filled areas      |
| Stepped Area Chart | Area Chart  | Unified with area |
| Scatter Chart      | Scatter     | Scatter plot      |
| Pie Chart          | Pie Chart   | Pie/donut charts  |
| Combo Chart        | Line Chart  | Defaults to line  |

### Unsupported Chart Types

The following are detected but not currently supported:

* Candlestick, Histogram, Bubble, Waterfall
* Treemap, Org Chart, Scorecard
* Geographic/region charts

<Note>
  Let us know if you'd like to see a specific chart type supported.
</Note>

## Setup Steps

<Steps>
  <Step title="Create a chart in Google Sheets">
    If you haven't already, create the chart you want to share in your spreadsheet.
  </Step>

  <Step title="Add source in Chartcastr">
    Go to [Sources](https://chartcastr.com/admin/sources), select **Google Sheets**, and search for your spreadsheet.
  </Step>

  <Step title="Select your chart">
    Choose the chart you want to use from the Charts section.
  </Step>

  <Step title="Preview and save">
    Review the chart preview, then save as a source and connect to destinations.
  </Step>
</Steps>

## Published Chart URLs (Alternative)

If you prefer, you can also use a published chart URL. This requires making the chart publicly accessible.

<iframe className="w-full aspect-video rounded-xl" src="https://www.youtube.com/embed/CWvzTORGcsQ" title="How to add a Google Sheets source with a custom URL" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />

<Accordion title="Using Published Chart URLs">
  1. Open your Google Sheet and select the chart
  2. Click the three-dot menu → **Publish chart**
  3. Set to **Image** format and **Anyone on the internet can view**
  4. Copy the URL and paste into Chartcastr

  <Warning>
    Published charts must be fully public. Restricted charts (requiring sign-in) are not supported due to Google limitations.
  </Warning>

  ```bash Example URL theme={null}
  https://docs.google.com/spreadsheets/d/e/2PACX-.../pubchart?oid=123456789&format=image
  ```
</Accordion>

## Next Steps

<CardGroup cols={2}>
  <Card title="Connect to Slack" icon="slack" href="/integrations/destinations/slack">
    Send your charts to Slack channels
  </Card>

  <Card title="Create Connections" icon="link" href="/admin/connections">
    Link sources to destinations
  </Card>
</CardGroup>