Build interactive mini-apps with Sheets canvas

@googleworkspace

63.3K followers · usually 1.1K views a post

Views

1.4M

Likes

730

Comments

6

Shares

72

SoundTikTok sound · original sound - googleworkspace

Promoted product

Sheets canvas

Feature availability This feature is available in English. This feature requires an eligible Google Workspace or Google AI plan. Learn about Gemini features and

Why it worked

The video effectively solves a common pain point—spreadsheet clutter—by demonstrating a high-utility, visual transformation that makes complex data management feel effortless and modern.

Summary

The video demonstrates how to use the new Sheets canvas feature in Google Sheets to transform static data into interactive dashboards, event schedules, and Kanban boards. It highlights the integration with Gemini to automate the creation of these mini-apps.

Structure

1Introduction to Sheets canvas
2Creating a sentiment dashboard with Gemini
3Managing event logistics with a run of show
4Tracking press coverage with a Kanban board
5

Original caption

Break out of the grid with Sheets canvas. Turn spreadsheet data into powerful, interactive mini-apps right inside Google Sheets, no coding or third-party tools required. #sheetscanvas

More from @googleworkspace

Product placement

(a) Sheets canvas: ACTS; it is the primary tool demonstrated to turn spreadsheets into interactive mini-apps. (a) Google Sheets: ACTS; it is the platform where the Sheets canvas interface is operated. (a) Gemini: ACTS; it is used to generate the dashboard and Kanban board via prompts. (a) Google Workspace: APPEARS; it is the brand umbrella for the tools shown.

Call to action

Start building with Sheets canvas today.

On-screen text

Build interactive mini-apps with Sheets canvas Sheets Canvas Sentiment tracking dashboard Press event itinerary Press outreach tracker What would you like to create? Dashboard Roll over templates Data clean-up View all suggestions Ask Gemini Create canvas Create a dashboard based on this sentiment data Collecting info... Generating code... Sentiment Dashboard Interactive performance tracking dashboard and brand feedback monitor FILTER BY QUARTER All Quarters TOTAL MENTIONS 278,810 WEIGHTED POSITIVE % 59% Channel Sentiment Splits Social Media Web News Press event itinerary Press Event Run of Show Day 1 Day 2 Day 3 ACTIVE DAY Day 1 SESSIONS 0 EARLIEST START 9:00 AM LATEST WRAP 9:00 AM TIME BLOCK VIEW TIPS Add Run of Show Session ITEM ID DAY TAG (E.G. DAY 1) DATE START TIME END TIME EVENT SEGMENT / SESSION TITLE VENUE LOCATION / ZONE LEAD COORDINATOR TECHNICAL & AV NEEDS Create Session Press outreach tracker Tracker Outreach Kanban board JOURNALISTS 20 Total COVERAGE RATE 40% In Progress Published Google Workspace with Gemini Try it today in Google Sheets

Transcript

Sheets canvas lets you turn static spreadsheets into interactive mini apps with just a prompt right in Google Sheets. Maya is a communications manager leading a product launch. Usually that means drowning in a sea of data buried in spreadsheets. Here's how she uses sheets canvas to break out of the flat grid. First, Maya has raw sentiment data, but she needs to understand how past news cycles performed. In the side panel, she selects create canvas and asks Gemini to create a dashboard based on this sentiment data. In moments, Maya has a custom dashboard with interactive filters to isolate trends by channel and quarter. Next, Maya is coordinating a press event with dozens of speakers across multiple tracks, making it tough to see what's happening and when. So she builds a run of show right on top of her data, making it easy to manage event logistics and add new sessions inside this canvas. Finally, to track press coverage, Maya creates a Kanban board to help her track progress. As she drags a publication from in-progress to published, the underlying sheet updates instantly. From dashboards to Kanban boards, Sheets Canvas turned Maya's data into powerful custom mini apps. Now it's your turn. Start building with Sheets canvas today.