Create a Notion Style Life OS Dashboard in Google Sheets
836 بار بازدید -
7 ماه پیش
-
If you're a productivity junkie,
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: https://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
Get the code here: https://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
7 ماه پیش
در تاریخ 1402/09/19 منتشر شده
است.
836
بـار بازدید شده