Notes to My Future Self - Published
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Simple Google Sheet to Email Notes to Your Future Self
2
3
Purpose: I find it helpful to coach myself by sending emails to myself in the future to reinforce a learning or reminde me of a new thing I wanted to consider in the future

Once set up the sheet will notes to yourself in the future at a random interval based on desired 'frequency' for each note. For example a note will frequency 7 will be sent on average every 7 days but maybe shorter or longer

This sheet was written by Shaun Clowes (Twitter: @ShaunMClowes) and documented in my blog, https://shaunclowes.com/essays/2019/how-i-coach-myself
4
5
Setup: To begin using this sheet, follow these instructions.

Step 1. Copy this sheet to your own Google Sheet using the File > Make a Copy menu option







6
Step 2. Wait up to 2 minutes for a 'Note to Self' menu to appear in the menu bar
7
Step 3. Choose the Note to Self > Reset / Create Reminder Sheet menu option to reset / validate the 'Notes' worksheet where you'll put notes to youself
8
Step 4. The script will require your permission to run. You can review the code to be sure it's safe in Tools > Script Editor menu item if you like
9
Step 5. Send yourself a test email with the Note to Self > Send Test Email menu item. Check that the email arrives in a minute or two
10
Step 6. Schedule notes to be sent each night with the Note to Self > Schedule Nightly Emails menu item
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...