Generate a Notion database with all days of the year

README.md

This is a simple Node.JS script to generate a .CSV file to merge with a previously created Notion database.

It's supposed to be used with a Habit Tracker of sorts. It generates all days of the specified year, naming each page "Day #".

It also includes the week day (sunday, monday, ...)

It's easier to generate this from a script, and then use Notion to add the rest, like all the habits and database relationships there.

Packages

It only requires 1 package, @js-temporal/polyfill, an implementation of the Temporal API for Node.JS.

Since it's an .mjs file, the Node repository has to be of type module (set "type": "module" in package.json)

index.mjs

import fs from 'node:fs'
import { Temporal } from '@js-temporal/polyfill'

let date = Temporal.PlainDate.from({ year: 2022, month: 1, day: 1 })

const dates = []
const header = 'Name,Date,Weekday\n'

for (let i = 0; i < 365; i++) {
    dates.push(
        `"Day ${date.dayOfYear}",` + // page name
        `"${date.toString().replace(/-/g, '/')}",` + // Date
        `"${date.toLocaleString('en-US', { weekday: 'long' })}"` // Weekday
    )

    date = date.add({ days: 1 })
}

fs.writeFileSync('habits.csv', `${header}${dates.join('\n')}`)