Video summary

Canvas w Google Sheets - analiza danych bez formuł

Main summary

Key takeaways

Technology

Summary (Technological Concepts / Product Features)

  • Problem being addressed: Many employees waste 1–3 hours daily on manual data processing. The video argues that users who aren’t experts in formulas/macros need easier ways to visualize and analyze data.

  • Core tool: Google Sheets “Canvas” functionality (new feature), which can generate dashboards and applications from natural-language prompts.

Prerequisites / Language Limitation

  • Canvas may still be available in English.
  • To use English prompting effectively, the user should have a Google account set to English.

Workflow (Tutorial Steps)

  1. Open a spreadsheet containing a database of transactions (example dataset: random store transactions for food products).

  2. Open the side panel and select the data source for the canvas.

  3. In the Build tab, choose Canvas and enter a prompt (example: “dashboard comparing sales before and after 2015”).

  4. Gemini:

    • Analyzes the prompt and desired output,
    • Breaks the task into components,
    • Generates code to create a dynamic, functional dashboard.
  5. After generation, Gemini shows the dashboard.
  6. Use follow-up prompts to:
    • Modify dashboard content,
    • Make corrections,
    • Add elements like photos, charts, and visualizations,
    • Add advanced data filtering.

Dashboard Interaction Features

  • The generated dashboard includes charts and lists (e.g., number of transactions before/after 2015, average sales, etc.).
  • It is filterable: users can change filters, run searches, and click Create entry to add new records.
  • Additional prompts can add filtering by dimensions such as city, store name, or product.
  • Gemini can build on existing generated code, filling in missing pieces.

Non-Deterministic Outputs (Variation Across Canvases)

  • Canvas results won’t always look the same.
  • The video demonstrates a different spreadsheet example for holiday destinations, producing a different dashboard that includes:
    • Summaries (local/global ideas),
    • Filtering,
    • Trend/booking insights,
    • Possible trip ideas (e.g., Krakow, cost estimates),
    • Another version that includes photos.

Key Takeaway

The system is designed for iteration: the first output is not final. Users can repeatedly refine what the canvas should do by adjusting prompts and adding new requirements.

Main Speakers / Sources

  • Gemini (AI): Generates and updates the Canvas dashboards based on prompts.
  • Video presenter: Walks through creating dashboards in Google Sheets using Canvas.

Original video