Gemini in Google Sheets reads BigQuery: when the sheet is enough and when I suggest a database

Gemini in Google Sheets now answers questions about the data in BigQuery, where before it only saw what was on the sheet. That is the main item among five Google Workspace updates from a single week in October. To a business owner it sounds like “we don't need a separate system.” I've worked with spreadsheets since 2021, so I'll tell you where I draw the line.

What Google released between October 19 and 22

On October 19, Google Workspace Updates described the new combination: once BigQuery is connected through Connected Sheets, you can ask Gemini in the side panel “what were sales in the Northeast last quarter” and get an answer based on the full dataset in BigQuery, rather than the part loaded into the sheet. For a request like “build a quarterly revenue report by region,” Gemini shows a plan and, once you approve it, creates a tab with pivot tables and charts that refresh on a schedule. The feature is on by default, and an admin can't turn it off. The rollout is gradual from October 19 for Business and Enterprise plans at the Standard and Plus tiers, and for Google AI Pro and Ultra subscriptions.

In the same blog, box and whisker charts arrived on October 22: you select a range of numbers, and Sheets calculates the quartiles and outliers itself, with no helper formulas. Before, this chart type was lost when you imported an Excel file; now it survives. Available to everyone, including personal accounts, from October 22.

Three more items from the same week on the same Google Workspace Updates blog. Gemini in Sheets came to iOS on October 19: from a phone you can ask it to “summarize this spreadsheet” or build a chart, as you already could on Android. Docs Live, October 21, lets you dictate a document in mobile Google Docs; by Google's description, it pulls context from Gmail and Drive and assembles a draft, for example a report after a meeting. And on October 19, interactive apps from Gemini learned to export to Google Sites in one click, as a draft of a private site. I haven't turned any of these on myself yet; I'm going by Google's descriptions.

Why a business owner should care

Take a service company where requests and payments have lived in one Google Sheet for three years. The owner wants revenue per technician for the month and the share of repeat customers. Before, someone built him a pivot table or a script; now he asks Gemini and gets a tab with a chart. For that kind of question the spreadsheet is enough, and I wouldn't sell him a database.

The trouble starts at data entry. Two managers edit the same row, and one erases the other's visit date. The “paid” mark is set by hand, and nobody knows whether anyone checked that the money came in. Gemini won't help here: the data has already drifted apart. My rule: I leave the spreadsheet where one person enters the data and what's needed is reports, and I suggest a database where several people change the same rows and a request has statuses and permissions.

What I've seen on both sides of the line

From 2021 to 2025, jobs around Google Sheets came to me through Upwork: a contact from a new row shows up in Google Contacts on its own, emails go out straight from the sheet. In every case the spreadsheet stayed the team's working tool. Moving the process into a separate system would have been premature, and I didn't propose it.

The car rental in Cape Town was different. When I joined in October 2024, 17 cars, bookings and handovers were tracked in one Google Sheet, and the first task was small: connect AmoCRM to the sheet. I was responsible for the website and integrations, and I proposed setting up our own server and building the logic there. The idea was approved, and over 2025 the integration grew into a system with a booking website and an app for managers. Cars are now handed over 3 times faster, the average check grew by 30%, and maintenance costs fell by 25%. A spreadsheet couldn't have delivered that: a calendar that shows the cars with a suitable free window first doesn't live in a sheet.

The third case is recent: the “Coffee Together” service, which I built in September and October 2026. Employees at an IT company were pooling coffee orders through a shared Google Sheet, and the organizer put the cart together by hand in the Tasty Coffee wholesale account and reconciled the payments. The service ties each request to the exact catalog variant from the supplier and fills the cart itself. I handled the move from the old spreadsheet with an import that has a preview, where an error in a row blocks the transfer. The service saves employees and administrators more than 100 hours of working time a month.

What I would do

Count how many people change the same rows. If it's one, a spreadsheet plus Gemini will last a long time. If it's three or more, count how often someone's edits get overwritten.

Write down the marks that are set by hand, like “paid” and “handed over.” If a mark has a rule about who sets it and after what, that's already business logic, and it belongs on a server, not in a column.

Check access. Gemini with BigQuery is on by default and answers anyone with permission to query the connected data. If salaries sit next to sales, sort out the permissions ahead of time.

On the signs that make me propose a system instead of a spreadsheet: when a business needs a system instead of spreadsheets. By area: Google Workspace as a connected work environment and spreadsheet automation and reporting. Cases: Google Sheets jobs on Upwork, car rental in South Africa and the “Coffee Together” service. From other reviews: low-code versus your own code and three database decisions people regret later; earlier I wrote about document automation in Google Workspace. If your spreadsheet is already cracking, tell me who enters what into it: Discuss your task.