Notion
Notion

How to Write a Letter to Your Future Self in Notion

How to Write a Letter to Your Future Self in Notion

How to Write a Letter to Your Future Self in Notion

How to Write a Letter to Your Future Self in Notion

How to Write a Letter to Your Future Self in Notion

Have you ever wondered what your past self would say to you if you could have a conversation with them today?

What were you worried about? What were you trying to achieve? Did things turn out the way you expected?

I wanted to write a letter to my future self, but I didn't see the point of giving some random website my email address just to do that.

So, as usual, I built it inside Notion.

It's a surprisingly simple system, and here's how you can build your own.

1. Create your database

Start by creating a new database called Future Letter.

You'll need four properties in addition to the name of your letter:

  • Written On: The date you wrote the letter.

  • Open On: The date you want to read it.

  • Opened: A checkbox to mark the letter as read.

  • Ready to Open: A formula that checks whether the opening date has arrived.

2. Add the formula

Inside your Ready to Open formula property, paste the following formula:

let(
  openDate, prop("Open Date"),
  days, dateBetween(
    parseDate(formatDate(openDate, "YYYY-MM-DD")),
    today(),
    "days"
  ),

  ifs(
    prop("Open"), style("📖 Opened", "green"),
    empty(openDate), style("Set your open date", "gray"),
    days > 0, style("🔒 Sealed — opens in " + format(days) + " days", "red"),
    days == 0, style("📬 Today is the day — open your letter", "purple"),
    style("📬 Ready to read — " + format(abs(days)) + " days overdue", "orange")
  )
)

This will automatically return true once the opening date arrives.

You could write a letter today, set the opening date three years from now, and the formula would take care of the date check for you.

3. Create three views

Now comes the fun part. Create three gallery views inside your database, each with its own filters.

Sealed

This is where all the letters you're not supposed to read yet will live.

  • Ready to Open is unchecked.

  • Opened is unchecked.


Ready to Open

Once the opening date arrives, your letter will automatically appear here.

  • Ready to Open is checked.

  • Opened is unchecked.

Opened

Once you've read a letter, simply check the Opened property. It'll move here, where you can revisit it whenever you want.

  • Opened is checked.

I'd also recommend turning off the card preview in your gallery settings so you don't accidentally read parts of your letters before their opening date.

4. Write your first letter

You don't need to overthink what to write.

Talk about what's happening in your life right now. Your goals, your struggles, the things you're afraid of, or even the small things that make you happy these days.

Ask your future self a few questions.

Did you achieve that goal you've been working so hard on? Are you still doing the things you promised yourself you'd do?

Then pick a date, close the letter, and forget about it.

Get the free template

If you don't feel like building this from scratch, I've made the template available for free.

Just duplicate it into your Notion workspace, write your first letter, and pick a date.

[Duplicate Future Letter for free]

Want to take it further?

Future Letter is just one of the many things I've built inside Notion over the years.

If you want a complete system where you can manage your tasks, track your habits, work towards your goals, journal, manage your finances, and even write letters to your future self, that's exactly what I've built with Second Brain 7.0.

It's the system I use every single day to manage my life.

Explore Second Brain 7.0 →

Have you ever wondered what your past self would say to you if you could have a conversation with them today?

What were you worried about? What were you trying to achieve? Did things turn out the way you expected?

I wanted to write a letter to my future self, but I didn't see the point of giving some random website my email address just to do that.

So, as usual, I built it inside Notion.

It's a surprisingly simple system, and here's how you can build your own.

1. Create your database

Start by creating a new database called Future Letter.

You'll need four properties in addition to the name of your letter:

  • Written On: The date you wrote the letter.

  • Open On: The date you want to read it.

  • Opened: A checkbox to mark the letter as read.

  • Ready to Open: A formula that checks whether the opening date has arrived.

2. Add the formula

Inside your Ready to Open formula property, paste the following formula:

let(
  openDate, prop("Open Date"),
  days, dateBetween(
    parseDate(formatDate(openDate, "YYYY-MM-DD")),
    today(),
    "days"
  ),

  ifs(
    prop("Open"), style("📖 Opened", "green"),
    empty(openDate), style("Set your open date", "gray"),
    days > 0, style("🔒 Sealed — opens in " + format(days) + " days", "red"),
    days == 0, style("📬 Today is the day — open your letter", "purple"),
    style("📬 Ready to read — " + format(abs(days)) + " days overdue", "orange")
  )
)

This will automatically return true once the opening date arrives.

You could write a letter today, set the opening date three years from now, and the formula would take care of the date check for you.

3. Create three views

Now comes the fun part. Create three gallery views inside your database, each with its own filters.

Sealed

This is where all the letters you're not supposed to read yet will live.

  • Ready to Open is unchecked.

  • Opened is unchecked.


Ready to Open

Once the opening date arrives, your letter will automatically appear here.

  • Ready to Open is checked.

  • Opened is unchecked.

Opened

Once you've read a letter, simply check the Opened property. It'll move here, where you can revisit it whenever you want.

  • Opened is checked.

I'd also recommend turning off the card preview in your gallery settings so you don't accidentally read parts of your letters before their opening date.

4. Write your first letter

You don't need to overthink what to write.

Talk about what's happening in your life right now. Your goals, your struggles, the things you're afraid of, or even the small things that make you happy these days.

Ask your future self a few questions.

Did you achieve that goal you've been working so hard on? Are you still doing the things you promised yourself you'd do?

Then pick a date, close the letter, and forget about it.

Get the free template

If you don't feel like building this from scratch, I've made the template available for free.

Just duplicate it into your Notion workspace, write your first letter, and pick a date.

[Duplicate Future Letter for free]

Want to take it further?

Future Letter is just one of the many things I've built inside Notion over the years.

If you want a complete system where you can manage your tasks, track your habits, work towards your goals, journal, manage your finances, and even write letters to your future self, that's exactly what I've built with Second Brain 7.0.

It's the system I use every single day to manage my life.

Explore Second Brain 7.0 →

Have you ever wondered what your past self would say to you if you could have a conversation with them today?

What were you worried about? What were you trying to achieve? Did things turn out the way you expected?

I wanted to write a letter to my future self, but I didn't see the point of giving some random website my email address just to do that.

So, as usual, I built it inside Notion.

It's a surprisingly simple system, and here's how you can build your own.

1. Create your database

Start by creating a new database called Future Letter.

You'll need four properties in addition to the name of your letter:

  • Written On: The date you wrote the letter.

  • Open On: The date you want to read it.

  • Opened: A checkbox to mark the letter as read.

  • Ready to Open: A formula that checks whether the opening date has arrived.

2. Add the formula

Inside your Ready to Open formula property, paste the following formula:

let(
  openDate, prop("Open Date"),
  days, dateBetween(
    parseDate(formatDate(openDate, "YYYY-MM-DD")),
    today(),
    "days"
  ),

  ifs(
    prop("Open"), style("📖 Opened", "green"),
    empty(openDate), style("Set your open date", "gray"),
    days > 0, style("🔒 Sealed — opens in " + format(days) + " days", "red"),
    days == 0, style("📬 Today is the day — open your letter", "purple"),
    style("📬 Ready to read — " + format(abs(days)) + " days overdue", "orange")
  )
)

This will automatically return true once the opening date arrives.

You could write a letter today, set the opening date three years from now, and the formula would take care of the date check for you.

3. Create three views

Now comes the fun part. Create three gallery views inside your database, each with its own filters.

Sealed

This is where all the letters you're not supposed to read yet will live.

  • Ready to Open is unchecked.

  • Opened is unchecked.


Ready to Open

Once the opening date arrives, your letter will automatically appear here.

  • Ready to Open is checked.

  • Opened is unchecked.

Opened

Once you've read a letter, simply check the Opened property. It'll move here, where you can revisit it whenever you want.

  • Opened is checked.

I'd also recommend turning off the card preview in your gallery settings so you don't accidentally read parts of your letters before their opening date.

4. Write your first letter

You don't need to overthink what to write.

Talk about what's happening in your life right now. Your goals, your struggles, the things you're afraid of, or even the small things that make you happy these days.

Ask your future self a few questions.

Did you achieve that goal you've been working so hard on? Are you still doing the things you promised yourself you'd do?

Then pick a date, close the letter, and forget about it.

Get the free template

If you don't feel like building this from scratch, I've made the template available for free.

Just duplicate it into your Notion workspace, write your first letter, and pick a date.

[Duplicate Future Letter for free]

Want to take it further?

Future Letter is just one of the many things I've built inside Notion over the years.

If you want a complete system where you can manage your tasks, track your habits, work towards your goals, journal, manage your finances, and even write letters to your future self, that's exactly what I've built with Second Brain 7.0.

It's the system I use every single day to manage my life.

Explore Second Brain 7.0 →

Have you ever wondered what your past self would say to you if you could have a conversation with them today?

What were you worried about? What were you trying to achieve? Did things turn out the way you expected?

I wanted to write a letter to my future self, but I didn't see the point of giving some random website my email address just to do that.

So, as usual, I built it inside Notion.

It's a surprisingly simple system, and here's how you can build your own.

1. Create your database

Start by creating a new database called Future Letter.

You'll need four properties in addition to the name of your letter:

  • Written On: The date you wrote the letter.

  • Open On: The date you want to read it.

  • Opened: A checkbox to mark the letter as read.

  • Ready to Open: A formula that checks whether the opening date has arrived.

2. Add the formula

Inside your Ready to Open formula property, paste the following formula:

let(
  openDate, prop("Open Date"),
  days, dateBetween(
    parseDate(formatDate(openDate, "YYYY-MM-DD")),
    today(),
    "days"
  ),

  ifs(
    prop("Open"), style("📖 Opened", "green"),
    empty(openDate), style("Set your open date", "gray"),
    days > 0, style("🔒 Sealed — opens in " + format(days) + " days", "red"),
    days == 0, style("📬 Today is the day — open your letter", "purple"),
    style("📬 Ready to read — " + format(abs(days)) + " days overdue", "orange")
  )
)

This will automatically return true once the opening date arrives.

You could write a letter today, set the opening date three years from now, and the formula would take care of the date check for you.

3. Create three views

Now comes the fun part. Create three gallery views inside your database, each with its own filters.

Sealed

This is where all the letters you're not supposed to read yet will live.

  • Ready to Open is unchecked.

  • Opened is unchecked.


Ready to Open

Once the opening date arrives, your letter will automatically appear here.

  • Ready to Open is checked.

  • Opened is unchecked.

Opened

Once you've read a letter, simply check the Opened property. It'll move here, where you can revisit it whenever you want.

  • Opened is checked.

I'd also recommend turning off the card preview in your gallery settings so you don't accidentally read parts of your letters before their opening date.

4. Write your first letter

You don't need to overthink what to write.

Talk about what's happening in your life right now. Your goals, your struggles, the things you're afraid of, or even the small things that make you happy these days.

Ask your future self a few questions.

Did you achieve that goal you've been working so hard on? Are you still doing the things you promised yourself you'd do?

Then pick a date, close the letter, and forget about it.

Get the free template

If you don't feel like building this from scratch, I've made the template available for free.

Just duplicate it into your Notion workspace, write your first letter, and pick a date.

[Duplicate Future Letter for free]

Want to take it further?

Future Letter is just one of the many things I've built inside Notion over the years.

If you want a complete system where you can manage your tasks, track your habits, work towards your goals, journal, manage your finances, and even write letters to your future self, that's exactly what I've built with Second Brain 7.0.

It's the system I use every single day to manage my life.

Explore Second Brain 7.0 →

You may also want to read

You may also want to read

OLSNOTION

When you join my email list, it’s not just about free products or premium offers. Every time my email pops up, you know it’s packed with value, something to elevate your day beyond anything else

© 2025 OLSNOTION. All rights reserved.

OLSNOTION

When you join my email list, it’s not just about free products or premium offers. Every time my email pops up, you know it’s packed with value, something to elevate your day beyond anything else

© 2025 OLSNOTION. All rights reserved.

OLSNOTION

When you join my email list, it’s not just about free products or premium offers. Every time my email pops up, you know it’s packed with value, something to elevate your day beyond anything else

© 2025 OLSNOTION. All rights reserved.