Summary  
This chapter explains how to automatically generate structured tables and associated logic from plain-text descriptions, enabling rapid creation and refinement of table schemas through code.

General domain of usage  
Expense tracking


Creating tables manually takes time, especially when you need to think about structure and columns.
Gemini helps you turn a simple description into a ready table.




## Situation

You are asked to prepare a simple expense tracker for your team.
You need to include categories, planned budget, and actual spending.
You know what the table should contain, but you do not want to build it from scratch.







Inside Google Sheets, you describe what you need.




Create an expense tracking table with categories: Rent, Food, Transport, Marketing, Office supplies. Include columns for planned budget, actual spending, and difference.

Prompt

Gemini generates a structured table directly in the sheet.

You can refine it:

Add a total row that sums all categories.

You receive a prepared table with structure and basic logic. You only need to adjust values instead of building everything manually. You won't spend time creating columns and formulas.

Discover how to use Gemini across Google Workspace to handle everyday work tasks faster. Write emails, create documents, analyze data, build presentations, manage meetings, and find information across files using practical workflows. Focus on real scenarios and clear results while reducing manual work and saving time.

Explore how Gemini works inside Google Workspace and where it appears across your daily tools.
Understand how access and pricing work, and what affects availability in your account.

Explore how to write, reply, and manage emails faster using Gemini inside Gmail.
Turn notes into structured messages, respond using thread context, and summarize long conversations. Focus on communication, not formatting, while keeping emails clear and professional.


Generate, improve, and structure documents faster using Gemini inside Google Docs. Rewrite messy content, summarize long text, and adjust tone and structure for professional results. Focus on clarity and readability while reducing manual writing and editing.

Create tables, clean data, and build formulas faster using Gemini in Google Sheets. Analyze datasets, extract insights, and turn numbers into clear reports.
Focus on decisions and results instead of manual data work.

Generate slide content, convert existing text into slides, and simplify presentation content using Gemini in Google Slides. 

Capture conversations, summarize meetings, and extract action items using Gemini in Google Meet. Turn discussions into clear notes, tasks, and follow-ups without manual note-taking. Focus on participation during meetings while Gemini handles documentation and next steps.

Find files, ask questions, and extract key information using Gemini in Google Drive. Compare documents, summarize content, and combine insights from multiple sources. Focus on getting answers and building clear outputs instead of searching through files.

Generating Tables from Text

Situation