Connect to Google Sheets Google Sheets integration

Turn Google Sheets into interactive dashboards—no SQL required

Connect your Google Drive or Sheets and create live, shareable dashboards in minutes. Simple enough for anyone in the team to set up in 5 minutes and self-serve in-depth analytics, without a data expert or a single line of code.

How real teams use Google Sheets + Metabase

Curved Arrow Here are a few use case examples

For finance teams

Track monthly budgets and expenses with polished dashboards for shareable monthly snapshots that you can isolate by date range and categories.

For sales leaders

Bring your pipeline and performance data to life with live visualizations. Slice by region, rep, or deal stage, and let your team explore the “why” behind the numbers with data from your CRM exports in Google Sheets.

For HR or operations managers

Centralize and visualize data from your work management platforms. Click into a spike in underutilized hours to see what’s going on by person, project, or week. Then set up a dashboard subscription to send to team leads every Monday.

How to connect Google Sheets to Metabase

1

Start a free trial of Metabase Cloud with storage.

Or if you already have a Metabase Cloud instance, you can get the Google Sheets integration with a storage add-on

2
Open your Metabase and click the Add data button (top‑left sidebar), then choose Connect Google Sheets.
3

Pick a sync type:

  • Entire Folder — syncs all Sheets within a Google Drive folder (including subfolders).
  • Single sheet — syncs all tabs of just that one spreadsheet.
4
Share the folder or sheet with Metabase’s service account. In Google Drive, right‑click the folder or sheet → Share, add the provided service‑account email with Viewer access, then click Send.
5
Paste the sharing link back into Metabase’s setup form.
6
Click Import to initiate the sync.
7
Metabase will import all Sheets as tables in the Metabase Cloud Storage database, found under Browse → Database. For multi-tab Sheets, each tab becomes a separate table.
8
Auto-refresh occurs every ~15 minutes, ensuring your data stays up to date for live dashboards and vizualizations.

How to sync Google Sheets with Metabase documentation

Frequently asked questions

Can I create a dashboard from Google Sheets without using SQL?
Chevron Blue

Yes. With Metabase, you don’t need to write a single line of SQL. Just connect your Google Sheets, and you can create interactive dashboards and analyze data using the visual query builder, a point-and-click interface.

How often does Metabase update the data from Google Sheets?
Chevron Blue

Metabase syncs your Google Sheets data every 15 minutes by default. This means your dashboards stay up-to-date without manual refreshes or reimports.

Do I need to install anything to use Metabase with Google Sheets?
Chevron Blue

The Google Sheets integration only works on Metabase Cloud instances with storage. If you already have a cloud-hosted Metabase instance, you can get the storage add-on in you store account and enable the Google Sheets integration. If you're not already on Metabase Cloud, you can try it for free.

Is it safe to connect sensitive data from Google Sheets?
Chevron Blue

Yes. Metabase uses secure service accounts and follows industry best practices for access control and data handling. You choose which Sheets or folders to share.

I’ve never built a dashboard before. Is Metabase beginner-friendly?
Chevron Blue

Yep, that's our whole thing. Metabase is built for non-technical people to get answers from data. You’ll get click-to-explore functionality, drag-and-drop tools, and guided setup to go from Sheets to dashboards in minutes.

is-metabase-right-for-you

Join our weekly 15-minute overview of Metabase

Register now