We’re introducing a new way to analyze BigQuery data in Google Sheets. After connecting to BigQuery data with Connected Sheets, you can use Gemini to interact and analyze that data conversationally, right in Google Sheets. Gemini queries run against the full dataset in BigQuery, not just what’s visible in your spreadsheet. This means users can now ask questions on, analyze, and create views over super large data sets. Key use cases include:
- Ask questions in natural language: Ask something like “What were total sales in the Northeast last quarter?” and get an answer based on your complete BigQuery data.
- Dig deeper with follow-ups: Keep the conversation going with questions like “How does that compare to the same quarter last year?” or “Which products drove the increase?”
| | | Ask Gemini to analyze and pull insights from your largest datasets in BigQuery |
- Go from analysis to dashboard: Describe what you need, such as “Build a quarterly sales review with revenue by region, a monthly trend, and our top 10 products.” Gemini will share its plan for you to review, then build a new spreadsheet tab with native, connected, refreshable objects like database formulas, pivot tables, and charts.
| | | Gemini can create connected charts, pivot tables, and dashboards that are always up to date with scheduled refreshes |
For business users, Gemini handles the legwork of completing their end to end analysis, from querying the data to garnering complex and nuanced insights from the data, to laying out the final dashboard for review, allowing them to get their work done faster without ever leaving Google Sheets. For data teams, this means a shorter backlog of one-off requests for reports and data pulls from BigQuery.
Getting started
- Admins: This feature will be ON by default. There is no admin control for this feature.
- End users: This feature will be available by default in spreadsheets connected to BigQuery, for users with permission to query the connected data. To get started, open the Gemini side panel in a connected spreadsheet. Visit the Help Center tolearn more .
Rollout pace
Availability
- Business: Business Standard and Plus
- Enterprise: Enterprise Standard and Plus
- **Consumer:** Google AI Pro and Ultra
- **Education Add-ons:** Google AI Pro for Education
- **Other Add-ons:** AI Expanded Access