AI WORLD HQ
You know that moment when a manager asks for a quick sales breakdown and the only person who can answer it is locked in meetings for two days? Google's latest Gemini integration is aimed squarely at that kind of pain.
What changed
The new feature, announced by Google, lets you talk to your BigQuery data the way you'd talk to a coworker sitting next to you. BigQuery is Google's data warehouse — think of it as a giant, well-organized storage locker for company data: sales records, app logs, customer events, and other very large datasets.
To use the new feature, you first connect BigQuery to Google Sheets through Connected Sheets, a Google feature that lets you treat BigQuery tables almost like normal spreadsheet data. Once connected, you can ask Gemini questions in everyday language. Type "What were total sales in the Northeast last quarter?" and Gemini writes and runs the actual BigQuery query behind the scenes — against the entire dataset, not just the slice you happen to be looking at.
That is the key difference from a regular spreadsheet formula. Your data can be enormous, and Gemini still handles it.
What you can actually do
According to Google's announcement, three workflows are front and center.
Ask plain-English questions. Instead of writing a SQL query (the programming language databases speak), you describe what you want. Gemini figures out the query.
Follow up in the same conversation. Ask "How does that compare to the same quarter last year?" and Gemini remembers the earlier answer. You can keep digging without restating the background.
Build a dashboard from a single sentence. Describe the report you need — say, "Build a quarterly sales review with revenue by region, a monthly trend, and our top 10 products." Google says Gemini will first show you its plan, then create a new tab in your spreadsheet with charts, pivot tables, and formulas that stay linked to BigQuery. Scheduled refreshes keep the data current.
For business users, Google says Gemini handles the legwork of completing an end-to-end analysis — from querying the data to pulling out insights and laying them out in a report.
Wrap-up
Gemini's new BigQuery-in-Sheets conversation is a practical step toward making large datasets more conversational. If your company already uses Connected Sheets, this could save real time on routine reporting. A good first move: pick one question you normally email your data team about, and try asking Gemini instead. If you don't see the Gemini option yet, your Workspace admin can confirm whether the feature has reached your account.