Databricks Connector for Google Sheets

Databricks Connector for Google Sheets is a Databricks developer experience capability, introduced March 2025.

A Google Sheets add-on that connects to a Databricks workspace so you can import governed Unity Catalog tables, SQL query results and pivot tables into a sheet, refresh them on a schedule, ask Genie One for data, and write ranges back to Unity Catalog tables.

• The sheet's name is load-bearing - rename or delete a sheet tied to an import and it can no longer refresh, and one documented fix is to recreate a sheet with the exact same name. 🔗
• The ceiling is set by Google, not Databricks - imports go up to the Google Sheets limit of 10 million cells. 🔗
• Scheduled refreshes only work once a metastore admin creates a Unity Catalog connection with one very specific name - databricks_google_connection. 🔗

⚠ Limitations: Runs on SQL warehouses only (all-purpose compute is not supported) and queries time out after 15 minutes. Write-back is table-level only - no row-level updates, appends or merges, and no views or materialized views. Scheduled refreshes can't be edited (delete and recreate), don't pick up edited queries, can't target pivot tables, hold at most 20 imports per schedule and cap query text at 4,096 characters. Renaming or deleting a sheet breaks its import's refresh, and Viewer or Commenter recipients of a shared sheet can't use the add-on. 🔗

Category

Developer experience

Introduced

March 2025🔗

Announced at

Launch blog post (General Availability)🔗

Also known as

Google Sheets connector, Google Sheets add-on, Databricks for Google Sheets

Verified

2026-09-27