Google on Monday, October 19, 2026, introduced a way to analyze BigQuery data with natural language prompts directly in Google Sheets. The feature builds on Connected Sheets, and Gemini's queries run against the full dataset in BigQuery, not just what is visible in the spreadsheet, according to the Google Workspace Updates blog .

Users first connect to BigQuery data with Connected Sheets, then open the Gemini side panel and ask questions conversationally. Google said this lets users ask questions on, analyze and create views over very large data sets without leaving Sheets.

Google's example prompt is "What were total sales in the Northeast last quarter?" Users can follow up with questions like "How does that compare to the same quarter last year?" or "Which products drove the increase?"

The feature can also go from analysis to dashboard.…