Skip to content

Technology and money in plain English · Since 2012

Tech
Guide

Sheets Canvas: How to Turn Google Sheets Data Into Mini-Apps

Google's Sheets canvas turns spreadsheet data into Kanban boards, calendars and dashboards from a prompt. Who can use it, the steps, six examples from Google and the limits in its help article.

Key facts

  • Google announced Sheets canvas on Aug. 13, 2026; it builds interactive mini-apps from a prompt and writes changes back to the sheet. As of
  • Listed plans: Workspace Business and Enterprise Standard and Plus, Google AI Pro and Ultra, and the AI Pro for Education add-on. As of
  • The feature is English only and works on Google Sheets files in Google Drive, not on the mobile app. As of
  • Each canvas uses data from one tab; source data over 1 million cells can make a canvas unavailable. As of
In this story7 sections
Person reviewing data on a laptop, illustrating a Sheets canvas built from spreadsheet data
Image: Yan Krukau / Pexels
Listen to this article
6 min listenTech

Last checked . Picks are based on the prices, rates, fees and terms each provider publishes, checked at the source. We never rank products by commission. See how we’re funded.

Sheets canvas is a Gemini feature in Google Sheets that turns spreadsheet data into an interactive mini-app, such as a Kanban board, a calendar or a dashboard, from a plain-language prompt. Google announced it on Aug. 13, 2026, and its help article now lists three ways to start one. Changes made in the canvas write back to the sheet. This guide covers who can use it, the steps, six example mini-apps from Google, and the limits the help page states.

What Sheets canvas does

Google’s announcement, written by the Sheets director of product management Eric Birnbaum, describes the feature as “a dynamic, read-write layer that sits directly on top of your spreadsheet data.” A Sheets canvas appears as a tab in the spreadsheet. It can be shared like any other sheet, and changes sync in real time between the canvas and the underlying data. The post says no formulas or coding are needed. According to the help article, users with edit access can add, edit or delete data directly in the canvas, while people with comment or view access cannot change it.

Who can use the feature

Availability is limited by plan and language. The table below combines Google’s announcement, its Workspace blog and the help article.

Advertisement
Item What Google says
Workspace plans Business and Enterprise Standard and Plus
Personal plans Google AI Pro and Google AI Ultra
Education Google AI Pro for Education add-on
Language English only
File type Google Sheets files stored in Google Drive

The help article adds that personal accounts can reach Sheets canvas through Workspace Experiments, a trusted tester program, with up to three uses of Canvas and Build a month. It does not say whether that route is open to every personal account. Excel files need to be converted first with File, then Save as Google Sheets. The Jolt Journal’s report on Google AI Plus losing Gemini Pro explains how the plan tiers are changing, and the feature is listed for AI Pro and Ultra, not AI Plus.

How to create a Sheets canvas

Google’s help article gives these steps:

  1. Open a spreadsheet in Google Sheets on the web.
  2. Start a Sheets canvas from one of three places: Tools then Create canvas in the side panel, Insert then Create a canvas in the menu bar, or the Canvas menu in the bottom bar.
  3. Describe the layout or visualization in the prompt box.
  4. Optionally enter another prompt to change it, such as switching to dark mode.
  5. Optionally select Copy link to share it. Access matches the spreadsheet’s access.
  6. Optionally select the Gemini icon to ask for further edits.

The announcement describes a shorter path through the Ask Gemini side panel, where Create canvas opens the same prompt. To rename a Sheets canvas, edit the name in the toolbar. To remove one, select Delete canvas. View data shows the underlying rows, and the bottom bar menu lists existing canvases.

A prompt can be short and specific. The Jolt Journal’s own example, not one from Google, would be: “Create a Kanban board that groups the rows by the Status column and shows the Owner on each card.” Naming the columns in the prompt gives the canvas less to guess, and a follow-up prompt can then adjust colors, layout or sorting.

Six mini-apps from Google

Google’s Workspace blog, published Sept. 10, 2026, lists six examples. Each one is a type of mini-app and not a template, since the canvas builds from the prompt and the data on the tab.

Mini-app What Google says it does
Kanban board Turns a task tracker into columns such as Not Started, In Progress, Need Input and Done; moving a card updates the sheet
Executive dashboard Builds scorecards, trend lines and filters from raw reporting data
Financial scenario model Turns a forecast into an interactive model where assumptions can be adjusted
Event schedule Maps agenda items onto a timeline or run-of-show calendar that can be edited by dragging
2×2 priority matrix Plots backlog items by priority and effort so scores can be adjusted on the grid
Workshop board Organizes brainstorm output into categorized cards with voting columns

The help article lists other formats as well, including gallery views with sortable cards, calendars and heat maps. Google’s pages describe these as examples. They do not publish accuracy tests or promise that a prompt will produce a given layout on the first try.

Limits and cautions for canvases

The help article says a canvas may be unavailable in several cases. The list below repeats them.

  • The Sheets mobile app is in use.
  • Source data across tabs exceeds 1 million cells.
  • Downloading, copying or printing is turned off in the spreadsheet.
  • The file is in third-party storage or is an offline document.

Each canvas uses data from only one tab, so a model that draws on several tabs may need the data combined first. Because users with edit access can change data inside a Sheets canvas, a spreadsheet that holds financial or customer records deserves the same access review it would get without one. The help article also warns that feedback may be read by humans and should not include personal, confidential or sensitive information. For Workspace Experiments, Google says it may use data and metrics to improve its products and models.

Where Sheets canvas fits among Google’s AI tools

Sheets canvas is one of several Gemini features that have reached Google’s apps in the past few months. The Jolt Journal covered Gemini’s in-chat file editing, which works on PDFs, Docs and Sheets from the chat window. A competing add-on, covered in the Jolt Journal’s guide to Grok in Google Workspace, answers questions about spreadsheet ranges but does not build mini-apps in the reports reviewed. The two Google features differ in focus: file editing changes the document, while a Sheets canvas adds a visual layer over the same data.

Editor’s take

The feature is a practical answer to a familiar spreadsheet problem, which is that a tracker works until someone needs a board or a calendar view of it. The feature’s value depends on how well the prompt matches the data, and Google publishes no quality figures. A careful first use of Sheets canvas is a copy of a spreadsheet with non-sensitive data, a short prompt, and a check of the resulting Sheets canvas against the sheet. Teams that share the file should decide who gets edit access before adding a canvas.

This is general information. Google’s Help Center and plan pages have the final word on availability, steps and limits.

See something that needs fixing? Report an error

Get The Jolt Journal in your inbox

The day’s top stories in tech, finance and AI, picked by our editors. Free.

Up next

Keep reading

Add The Jolt Journal as a preferred source on Google

Add The Jolt Journal to your Home Screen to get alerts

  • 89 Stories published

Jolt Journal Tech covers artificial intelligence, software, devices, cybersecurity and the platforms that shape how we live and work. Every story is checked against its sources and reviewed by our editor before publication.

Covers

Most Popular

More in Tech

See all

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Breaking-news alerts

We’ll send a notification to this device when a big story breaks. Choose what you want, then allow notifications when your browser asks. You can change this or turn alerts off any time.

Send me