Create a Notion Style Life OS Dashboard in Google Sheets

Поделиться
HTML-код
  • Опубликовано: 19 июл 2024
  • If you're a productivity junkie, like me, you've probably heard of or used Notion. But you've probably also run into some of Notion's limitations. In this video, I show you how to build a basic Notion-style life tracker dashboard using Google Sheets and App Script.
    Get the code here: gist.github.com/palumbo/197e2...
    Chapters
    0:00 Dashboard Overview
    2:22 Setting up a new Sheet
    2:38 Adding a custom menu
    4:18 Getting quotes using IMPORTHTML
    6:22 Building random quote generator
    11:39 Adding a habit tracker
    13:56 Adding journal entries
    15:17 Creating date and month variables
    17:00 Getting the last row of a section
    19:15 Preventing duplicate journal entries
    27:31 Adding task tracking
    30:54 Splitting Project, Tasks, and Due Dates
    36:17 Using QUERY to group project tasks
  • НаукаНаука

Комментарии • 2

  • @hammockmonk
    @hammockmonk 3 месяца назад

    I love the sheet and I appreciate all the work. But I get the error: "TypeError: Cannot read properties of undefined (reading 'range') onEdit @ Code.gs:81" This happens both when I type the code myself and when I copy/paste from your linked code. Can you see the problem?