Skip to main content

News · Operations

Gemini in Google Sheets can now analyze BigQuery data via natural language

Google Sheets now lets users query BigQuery data with Gemini in natural language and build connected dashboards; rolling out gradually from October 19, 2026, on by default.

1 min read Source: workspaceupdates.googleblog.com

Audio summary 0:19

Headline and summary, read by a synthetic voice.

What changed: Google announced that Gemini in Google Sheets, when connected to BigQuery via Connected Sheets, can now answer conversational questions, handle follow-ups, and build new tabs with connected, refreshable formulas, pivot tables, and charts. Gemini queries run against the full BigQuery dataset, not just what's visible in the sheet.

Who is affected

Users with a Google Sheets file connected to BigQuery via Connected Sheets and permission to query that data; per the source this covers Business Standard and Plus, Enterprise Standard and Plus, Google AI Pro and Ultra, Google AI Pro for Education (Education Add-ons), and AI Expanded Access (Other Add-ons).

What it means for your business

For businesses using Google Sheets with BigQuery, this means analyzing large datasets by asking questions in the Gemini side panel instead of writing queries, and getting dashboards and pivot tables built automatically.

What to do

If your spreadsheet is connected to BigQuery via Connected Sheets, open the Gemini side panel in that sheet and try asking a question in natural language; no admin action is needed since the feature is on by default.

When it takes effect

Gradual rollout up to 15 days for feature visibility, starting October 19, 2026, across Rapid Release and Scheduled Release domains.

Source: https://workspaceupdates.googleblog.com/2026/10/analyze-bigquery-data-using-natural-language-with-Gemini-in-Google-Sheets.html

Related reading

First conversation

Tell us what you want to do, and we will work out together where to start.

In the first call we talk through your business, where things stand and what matters most. We say plainly which parts make sense for us to take on and which you should run yourself.

Cookie preferences

We use measurement and advertising tools (Google Analytics, Microsoft Clarity, Google Ads, Meta Pixel) to improve the site and measure the results of our ads, only with your consent. Necessary records are always on. Details in our cookie policy.