How to Build Professional Dashboards & Reports in Minutes with Gemini in Google Docs & Sheets

The updated Gemini in Google Workspace transforms how you create documents and spreadsheets by pulling context from your files, emails, and the web so you start every project from a stronger foundation. In Google Docs, a new bottom bar lets you describe what you need and Gemini builds documents by connecting other documents like Google Sheets data from your Drive, Gmail, and chat history—rather than generating generic content that you then have to backfill with real data. You also get "Match writing style" to unify voice across a document and "Match doc format" to align a new document to the structure of a reference file, which is useful when you're producing recurring deliverables like client reports, coaching plans, or project briefs. 00:12 Preparing Google Sheets (Data) & Google Docs 01:10 Generating Complete Google Docs with Gemini 02:43 Creating Charts & Data Visualizations 05:24 Insights from Varying Datasets from Google Sheets 07:45 Dashboards in Google Sheets In Google Sheets, the update introduces a conversational setup flow where you describe an entire project, and Gemini creates the tables, charts, and dashboards from a natural language description, pulling in data from your emails, files, and real-time web sources to populate structured layouts automatically. The "Fill with Gemini" feature lets you populate entire columns using real-time data from Google Search. Google reports that this approach generates spreadsheets roughly 9x faster than building them manually, and its Gemini in Sheets model achieved a 70.48% success rate on the SpreadsheetBench dataset, which nears human expert performance on complex spreadsheet tasks. This is a meaningful gain when you're building trackers for college applications, vendor comparisons, or budget planning. You can also use plain-language instructions to categorize, summarize, and expand existing spreadsheet data without writing formulas or content in your Google Doc. For business users producing recurring rep