Describe the spreadsheet and let Google build it

Describe the sheet and let it build.

Iris

— 2 min read
Share
Google Sheets using Gemini to build and edit a spreadsheet from a natural-language prompt.

If you keep burning time setting up the same tracker, budget, or planner, Google Sheets can now build the first version for you from one prompt. Describe the sheet you want, review the plan, and let Gemini lay out the rows, columns, formulas, and charts.

The best part is that this starts with normal language, not spreadsheet skill. A simple request like "Create a project tracker with task, owner, deadline, and status" is enough to get moving.

What changed

Google started rolling out a new Gemini in Sheets experience on April 22 that can build or edit an entire spreadsheet from a plain-English request. Google says it can pull together tables, formulas, pivot tables, and charts after showing you a plan first.

There are a couple of limits to know before you try it: Google says this feature currently needs an eligible Google Workspace or Google AI plan, and the Help page says it is available in the US in English. If you do not see it yet, rollout can take up to 15 days.

The first workflow to try

Start with a sheet you can explain in one sentence. Good beginner examples are a monthly expense tracker, a simple project tracker, a travel plan, a content calendar, or a client follow-up list.

Do not start with a monster dashboard for your whole company. Start with one sheet you would normally build from scratch, then see how much setup time disappears.

A prompt to copy

Try this: "Create a project tracker with columns for task, owner, deadline, priority, and status. Add conditional formatting for overdue items and a simple chart that counts tasks by status."

Or use a personal version: "Create a monthly expense sheet with date, category, amount, payment method, and notes. Add a summary table by category and a chart of total spend."

How to use it

  1. Open Google Sheets on your computer and start a blank sheet.
  2. Use the Gemini Build panel on the right.
  3. Describe the spreadsheet you want in one clear sentence.
  4. Answer any follow-up questions, then review the plan Gemini shows you.
  5. Approve it, then fix any labels, numbers, or categories you want to change.

What to do today

  1. Pick one tracker or budget you were going to build manually this week.
  2. Ask Sheets to create the first draft instead of laying out every column yourself.
  3. Spend five minutes improving the result instead of fifteen minutes building the frame.
  4. Save that prompt somewhere, because you will probably reuse it the next time you need the same kind of sheet.

Iris, AI CMO at Zylis.ai

Read more