Voltar aos vídeos

Google Workspace

How to create interactive dashboards and apps in Google Sheets

Plataforma
YouTube
Duração
2:34
Idioma falado
inglês
Visualizações
20,5 mil
Corte mediano
8.24s
Rosto em cena
92%
Quadros escuros
0%
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:00
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:00
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:00medium presenter
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:00
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:01medium presenter
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:01
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:05medium presenter
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:05
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:06medium presenter
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:06
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:07corner inset
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:07
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:08corner inset
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:08
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:11
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:11
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:12medium presenter
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:12
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:15medium presenter
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:15
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:17medium presenter
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:17
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:18
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:18
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:19medium presenter
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:19
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:21medium presenter
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:21
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:23medium presenter
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:23
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:26corner inset
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:26
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:26corner inset
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:26
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:39corner inset
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:39
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:39corner inset
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:39
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:40corner inset
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:40
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:41corner inset
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:41
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:44corner inset
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:44
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:45corner inset
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:45
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:46corner inset
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:46
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:53corner inset
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:53
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:53corner inset
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:53
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:54corner inset
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:54
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:58
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:58
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:58
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:58
Google Workspace How to create interactive dashboards and apps in Google Sheets at 0:59medium presenter
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
0:59
Google Workspace How to create interactive dashboards and apps in Google Sheets at 1:09corner inset
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
1:09
Google Workspace How to create interactive dashboards and apps in Google Sheets at 1:18corner inset
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
1:18
Google Workspace How to create interactive dashboards and apps in Google Sheets at 1:22corner inset
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
1:22
Google Workspace How to create interactive dashboards and apps in Google Sheets at 1:22corner inset
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
1:22
Google Workspace How to create interactive dashboards and apps in Google Sheets at 1:29
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
1:29
Google Workspace How to create interactive dashboards and apps in Google Sheets at 1:30medium presenter
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
1:30
Google Workspace How to create interactive dashboards and apps in Google Sheets at 1:35corner inset
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
1:35
Google Workspace How to create interactive dashboards and apps in Google Sheets at 1:38corner inset
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
1:38
Google Workspace How to create interactive dashboards and apps in Google Sheets at 1:46medium presenter
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
1:46
Google Workspace How to create interactive dashboards and apps in Google Sheets at 1:50corner inset
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
1:50
Google Workspace How to create interactive dashboards and apps in Google Sheets at 1:54corner inset
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
1:54
Google Workspace How to create interactive dashboards and apps in Google Sheets at 1:58corner inset
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
1:58
Google Workspace How to create interactive dashboards and apps in Google Sheets at 2:02corner inset
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
2:02
Google Workspace How to create interactive dashboards and apps in Google Sheets at 2:06corner inset
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
2:06
Google Workspace How to create interactive dashboards and apps in Google Sheets at 2:08
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
2:08
Google Workspace How to create interactive dashboards and apps in Google Sheets at 2:10medium presenter
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
2:10
Google Workspace How to create interactive dashboards and apps in Google Sheets at 2:18corner inset
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
2:18
Google Workspace How to create interactive dashboards and apps in Google Sheets at 2:22corner inset
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
2:22
Google Workspace How to create interactive dashboards and apps in Google Sheets at 2:24
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
2:24
Google Workspace How to create interactive dashboards and apps in Google Sheets at 2:26medium presenter
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
2:26
Google Workspace How to create interactive dashboards and apps in Google Sheets at 2:34
Google WorkspaceHow to create interactive dashboards and apps in Google Sheets
2:34

Transcrição de How to create interactive dashboards and apps in Google Sheets

Transcrito por um modelo de fala a partir do áudio do próprio vídeo, não escrito pela marca. Clique em qualquer linha para ir até aquele momento.

  1. 0:00Today you'll learn how to transform a Google Sheets spreadsheet into an interactive dashboard,
  2. 0:05real-time project tracker, or basically anything else you can imagine with just one prompt to
  3. 0:10Gemini.
  4. 0:11In this video, I'll show you how to create a Sheets Canvas, which is a custom mini-app
  5. 0:16based on the data in your spreadsheet.
  6. 0:18To create a Sheets Canvas, you must have access to Google Workspace with Gemini and edit access
  7. 0:23to the spreadsheet you're working on.
  8. 0:25Let's look at an example of when you might want to create a canvas.
  9. 0:28Here in my spreadsheet, I'm managing a complex project.
  10. 0:32Each row represents a task that our team needs to complete, with details about its due date
  11. 0:37and status.
  12. 0:39Currently, I have to manually filter through this sheet to understand how the project is
  13. 0:44progressing.
  14. 0:45To better visualize and understand the project's status, let's prompt Gemini and Sheets to
  15. 0:50create an interactive Kanban board, like the one you see here.
  16. 0:53To create my Sheets canvas, I go to my spreadsheet and click the canvas icon at the bottom.
  17. 0:58This opens the Gemini side panel and selects the Canvas tool automatically.
  18. 1:03Next, I can type a prompt to Gemini, such as create a project tracker or create a Kanban board, and press enter.
  19. 1:09From there, Gemini takes a few minutes to review the request and create the Canvas for me.
  20. 1:14And it's ready! The Sheets Canvas appears as a new tab right in my spreadsheet.
  21. 1:19The Sheets Canvas always stays in sync with my underlying spreadsheet data,
  22. 1:22which means I can create and update project tasks directly from the canvas or back in the original dataset.
  23. 1:29To make edits to the Sheets canvas, I can open the Canvas tool again and prompt Gemini with any desired updates.
  24. 1:36To share a Sheets canvas with others, you can give the person view, comment, or edit access to the spreadsheet.
  25. 1:42Now that you know how to create a Sheets canvas, you can prompt Gemini to create apps for all kinds of spreadsheets.
  26. 1:48For example, you can create a canvas that tracks sales in a live dashboard, helps you analyze data, such as customer reviews, for keywords or trends, visualizes information, like a seating chart.
  27. 2:02You can even create a canvas to gamify a process, such as an employee onboarding experience or training.
  28. 2:08To get the most out of Canvas, it's best to be specific and descriptive about what you want Gemini to build for you or what you want to learn from your spreadsheet.
  29. 2:15As an example, rather than just prompting create a dashboard, you could have details
  30. 2:20about the purpose of the dashboard, whether you want interactive filters, and more.
  31. 2:24And that's it!
  32. 2:25Now you know how to instantly transform how you use spreadsheets with the help of Sheets
  33. 2:30Canvas.
33 linhas · 467 palavras

More from Google Workspace

All of Google Workspace →

The rest of their work we have taken apart.

Introducing Google VidsLaunch1.5M views
Google Workspace
Introducing Google Vids
1:2750 frames2.6s cut20% face
Supercharge your workflow: Summarize, rephrase, and rewrite documents with Gemini in Google Docs2K views
Google Workspace
Supercharge your workflow: Summarize, rephrase, and rewrite documents with Gemini in Google Docs
1:4053 frames2.8s cut30% face
Kärcher goes from AI Assistants to AI Agents with Google Workspace and Gemini Enterprise2K views
Google Workspace
Kärcher goes from AI Assistants to AI Agents with Google Workspace and Gemini Enterprise
3:23191 frames1.8s cut64% face
The proper presentation mode. (Popcorn not included) 🍿2K views
Google Workspace
The proper presentation mode. (Popcorn not included) 🍿
0:094 frames0% face
Cognizant reinvents how technology is built and delivered with Gemini Enterprise2K views
Google Workspace
Cognizant reinvents how technology is built and delivered with Gemini Enterprise
3:02178 frames1.7s cut66% face

Cut at the same speed

Films whose median shot runs closest to 8.24s.

Today we're releasing Personal Computer. Personal Computer integrate...14M views
Perplexity
Today we're releasing Personal Computer. Personal Computer integrate...
1:3937 frames8.2s cut0% face
getting started with DLAM on rabbit r15K views
rabbit
getting started with DLAM on rabbit r1
3:41120 frames8.3s cut68% face
Dario Amodei (Anthropic), Satya Nadella (Microsoft), and Jensen Huang...108K views
Anthropic
Dario Amodei (Anthropic), Satya Nadella (Microsoft), and Jensen Huang...
9:58720 frames8.2s cut100% face
"Not having a coding experience is becoming an advantage." Replit CE...2.6M views
a16z
"Not having a coding experience is becoming an advantage." Replit CE...
0:5923 frames8.2s cut100% face
WorkOS Pipes | The OAuth Integration You've Been Missing389 views
WorkOS
WorkOS Pipes | The OAuth Integration You've Been Missing
4:48151 frames8.2s cut73% face
Ideate And Create Quickly With Generative Ai In Adobe Express | Generative AI | Adobe1.9M views
Adobe
Ideate And Create Quickly With Generative Ai In Adobe Express | Generative AI | Adobe
2:0199 frames8.1s cut44% face
In her first Ask Me Anything, @amandaaskell answers your philosophica...740K views
Anthropic
In her first Ask Me Anything, @amandaaskell answers your philosophica...
36:092498 frames8.3s cut99% face
Cloud agents now start 3x faster so you can hand them ambitious, long...688K views
Cursor
Cloud agents now start 3x faster so you can hand them ambitious, long...
0:209 frames8.1s cut0% face
We’re Gridmaxxing → Drag to reorder columns/rows → Automatic positio...154K views
Figma
We’re Gridmaxxing → Drag to reorder columns/rows → Automatic positio...
0:4218 frames8.1s cut0% face
ARLOOPA App - Live on ProductHunt on Feb 151K views
ARLOOPA Augmented Reality / Virtual Reality
ARLOOPA App - Live on ProductHunt on Feb 15
0:5421 frames8.4s cut5% face
ty for the love on this. insane... i wanna keep telling the story. i...38K views
Farza
ty for the love on this. insane... i wanna keep telling the story. i...
2:16180 frames8.4s cut92% face
AIの動画アウトプットを『前景/キャラクターの単色バック』『背景のみ』の動画に分解するcomfyuiのワークフローを作っていた 厳密にはボ...55K views
852話(hakoniwa)
AIの動画アウトプットを『前景/キャラクターの単色バック』『背景のみ』の動画に分解するcomfyuiのワークフローを作っていた 厳密にはボ...
0:4821 frames8.1s cut62% face

Lit and framed like this

Closest on how much of the running time has a face in it and how dark the frames are.

we just launched agent-to-agent hiring at @hyperspell we're hiring ...45K views
conor brennan-burke
we just launched agent-to-agent hiring at @hyperspell we're hiring ...
1:3437 frames17.3s cut92% face
NOTHING (MILLI)5.4M views
Nothing
NOTHING (MILLI)
0:3313 frames92% face
Agency is a muscle. Tools can strengthen it — or let it atrophy. @...91K views
Notion
Agency is a muscle. Tools can strengthen it — or let it atrophy. @...
1:0642 frames3.0s cut93% face
5 things @FarzaTV does differently236K views
jules
5 things @FarzaTV does differently
15:421286 frames2.4s cut92% face
How does Basecamp work?1K views
37signals
How does Basecamp work?
3:26122 frames18.1s cut93% face
Today, we're releasing Claude Code for marketing. It does a marketer...3.6M views
Savannah
Today, we're releasing Claude Code for marketing. It does a marketer...
1:5746 frames14.4s cut93% face
Wispr Flow + Cursor: Dictation Built for Developers1K views
Wispr Flow
Wispr Flow + Cursor: Dictation Built for Developers
1:2933 frames14.7s cut94% face
Introducing Project Luxo: a new initiative exploring how AI-generated...Launch99K views
Runway
Introducing Project Luxo: a new initiative exploring how AI-generated...
10:02814 frames2.2s cut90% face
Benchling cuts migration time by 75% with cloud agents4K views
Cursor
Benchling cuts migration time by 75% with cloud agents
2:38134 frames4.7s cut95% face
introducing... a brand new pally 👋 pally is an ai assistant that liv...Launch72K views
Haz Hubble
introducing... a brand new pally 👋 pally is an ai assistant that liv...
1:5844 frames36.7s cut89% face
Your agent skills should improve themselves800 views
Warp
Your agent skills should improve themselves
3:24113 frames89% face
Make information visual with ChatGPT65K views
OpenAI
Make information visual with ChatGPT
1:2645 frames5.6s cut89% face

More social

Same category, other makers, most watched first.

Your ideas, your apps—Base44622M views
Base44
Your ideas, your apps—Base44
0:5651 frames1.1s cut6% face
Turn any idea into an app with Base44538M views
Base44
Turn any idea into an app with Base44
0:5538 frames2.2s cut50% face
Build Your Website with One Sentence | Base44154M views
Base44
Build Your Website with One Sentence | Base44
0:4835 frames0.9s cut31% face
Rip The Script | Nike Football81M views
Nike Football
Rip The Script | Nike Football
6:00310 frames1.1s cut60% face
PetSmart | "Pickup in...STORE!"75M views
PetSmart
PetSmart | "Pickup in...STORE!"
0:1511 frames1.4s cut64% face
NEO The Home Robot Order Today69M views
1X
NEO The Home Robot Order Today
9:53271 frames2.8s cut25% face
Apple Education: Ready for every learning opportunity69M views
Apple
Apple Education: Ready for every learning opportunity
1:4687 frames1.3s cut40% face
Phone calls suck. So, we bought a giant telephone car, raised $65,00...64M views
Bland
Phone calls suck. So, we bought a giant telephone car, raised $65,00...
1:4854 frames4.3s cut81% face
The Impossible Return – OIKOS 15s Commercial 202646M views
OIKOS Protein
The Impossible Return – OIKOS 15s Commercial 2026
0:1517 frames1.0s cut65% face
Oh wait there’s more: we’re building 3D Transforms, here’s a preview ...39M views
Figma
Oh wait there’s more: we’re building 3D Transforms, here’s a preview ...
1:0423 frames4.0s cut78% face
Getting Help is Simple, With Hims36M views
hims
Getting Help is Simple, With Hims
0:3023 frames2.0s cut70% face
Made in Figma (2025) Like this ❤️ we designed it for you36M views
Figma
Made in Figma (2025) Like this ❤️ we designed it for you
0:3872 frames0.5s cut7% face
Browse every frame in the library