All Documentation
Data Sources

Connecting Google Sheets

Set up live data sync between Google Sheets and your charts.

Connecting Google Sheets

Pull live data from Google Sheets to keep your charts automatically updated.

Setup Steps

1. Prepare Your Sheet

Ensure your data is in a clean format:

| Category | Q1    | Q2    | Q3    | Q4    |
|----------|-------|-------|-------|-------|
| Product A| 12000 | 15000 | 18000 | 22000 |
| Product B| 8500  | 9200  | 11000 | 13500 |
| Product C| 6000  | 7500  | 8200  | 9800  |

Best practices:

  • Headers in row 1
  • No empty rows or columns in your data range
  • Consistent data types per column

2. Share the Sheet

Click Share in Google Sheets and choose one of:

Option A: Link sharing (Recommended)

  1. Click “Get link”
  2. Set to “Anyone with the link can view”
  3. Copy the link

Option B: Email sharing

  1. Add [email protected] as a viewer
  2. The sheet stays private but accessible to ChartPuppy

3. Connect in ChartPuppy

  1. Open your chart and go to Data Source
  2. Select Google Sheets
  3. Paste your sheet URL
  4. Choose the sheet tab (if multiple)
  5. Select your data range (or leave blank for entire sheet)

4. Map Your Data

ChartPuppy will preview your data. Configure:

  • Labels column - Which column contains category names
  • Data columns - Which columns to chart
  • Skip rows - Ignore header rows or notes

Range Selection

Specify a range to use only part of your sheet:

Format Example Description
Full sheet (leave blank) Uses all data
Columns A:D Columns A through D
Rows 1:100 First 100 rows
Specific A1:D50 Exact range
Named SalesData Named range in sheet

Refresh Behavior

Plan Refresh Frequency
Free Manual only
Pro Every 5 minutes
Team Every 1 minute

Force a refresh anytime by clicking Refresh Data in the chart editor.

Troubleshooting

“Cannot access sheet”

  • Verify the sheet is shared with link access or with [email protected]
  • Check that the URL is correct (should contain /spreadsheets/d/)

“No data found”

  • Ensure your range contains data
  • Check for hidden rows or columns
  • Verify the correct sheet tab is selected

“Data format error”

  • Remove merged cells from your data range
  • Ensure numeric columns contain only numbers
  • Check for special characters in headers

Example Use Cases

Weekly Sales Report

Connect a sheet that your team updates weekly. Schedule the chart to regenerate every Monday morning.

Live Dashboard

Link to a sheet with real-time data (via IMPORTDATA or apps script). Charts update automatically every few minutes.

Multi-Source Aggregation

Use Google Sheets as a hub that pulls from multiple sources. ChartPuppy charts the aggregated data.