Connect a Google Sheet

In your workspace sidebar, click New. ChartBrick takes you to the data source picker, where you choose Google Sheets from the list of source types.

You'll land on the Google Sheets import page. If you haven't connected a Google account yet, you'll see a Connect to Google Sheets button; if you already have one, you'll see a New account button to add another.

Click Connect to Google Sheets. ChartBrick redirects you to Google, where you sign in and grant access to the files you pick:

• See, edit, create, and delete only the specific Google Drive files you use with this app — this is Google's per-file access. ChartBrick only ever reads the spreadsheets you choose in the next step; it never touches the rest of your Drive.

The grant is scoped tightly: ChartBrick only sees files you explicitly select, and it only reads them. You can revoke access any time from your Google Account settings.

After authorizing, Google redirects you back to ChartBrick and the account appears in the Account selector.

With an account selected, click Browse spreadsheets under the Spreadsheet field. Google's file picker opens directly inside ChartBrick — search by name, browse Drive, or paste a sheet URL.

Select one spreadsheet and confirm. The picker closes and the chosen spreadsheet's name replaces the Browse spreadsheets button label.

A spreadsheet can have several sheets (tabs). Use the Select sheet (tab) dropdown to pick the tab that holds the data you want to chart.

Optionally fill the Range (optional) field in A1 notation — e.g. A1:Z100 — to limit the import to a specific block. Leave it empty to use the whole sheet.

Use a range when the tab has summary rows, totals, or extra columns you don't want pulled in.

The First row is header (column names) toggle is on by default. Leave it on if row 1 of your range contains column names (most common). Uncheck it if the data starts on row 1 and ChartBrick should generate generic column names.

Click Import. ChartBrick reads the rows, detects column types (numbers, dates, text), generates AI-suggested charts, and opens the result — a single chart, or a dashboard when it suggests several. You can open the underlying dataset any time from the sidebar.

Google Sheets is a live source. When the underlying spreadsheet changes, your dataset doesn't update automatically — refresh it on demand:

• Open the dataset and click Update data in the header
• Or refresh every dataset on a dashboard at once from the dashboard's ⋮ menu → Refresh all datasets

Every refresh creates a new snapshot, so old charts keep working even if the spreadsheet schema changes.