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.