notion burndown

Generates burndown charts based on Notion databases.

This goes out to all of us who chose to put our scrum boards on Notion even though it doesn't have proper scrum features... Just because it's *~aesthetic~*.

Usage

Step 1. One-time setup on Notion

1. Create a Notion integration.
   1. Copy down the secret token and store it somewhere safe.
2. You should have one database for your product backlog. On top of that, you need to create two other databases:
   1. Sprint Summary: List of sprints and their information. For the integration to retrieve the latest sprint's information.
      1. Compulsory fields: Sprint (number), Start (Date), End (Date)
   2. Daily Summary: How many points are left in the latest sprint every day.
      1. Compulsory fields: Sprint (number), Date (Date), Points (number)
3. Give your integration access to all 3 databases.

You may refer to this template for setting up your own databases.

Step 2. Schedule the integration to run daily

This project is published as a GitHub action in the marketplace. You can make use of scheduled GitHub workflows to run it for free.

uses: szenius/[email protected]
with:
  NOTION_KEY: "Notion integration access token"
  NOTION_DB_BACKLOG: "Notion Database ID of Sprint Backlog"
  NOTION_DB_SPRINT_SUMMARY: "Notion Database ID of Sprint Summary"
  NOTION_DB_DAILY_SUMMARY: "Notion Database ID of Daily Summary"
  NOTION_PROPERTY_SPRINT: "Name of the property with the sprint number"
  NOTION_PROPERTY_ESTIMATE: "Name of the property with the estimate"
  NOTION_PROPERTY_PATTERN_STATUS_EXCLUDE: "Regex of the statuses of stories which are done"
  INCLUDE_WEEKENDS: "True if weekends should be included in the chart, false otherwise."
  SPRINT_START: "True if it is the start of a new sprint, false otherwise. When true, a new entry will be created in the Sprint Summary database, and the sprint end date will be 14 days later (sprint start day excluded). Note that new sprint summary will not be created if today is still in the middle of the last sprint."

You should set up two workflows:

1. Workflow that runs at the start of each sprint - refer to this workflow for setting up your own
2. Workflow that runs daily during the sprint - refer to this workflow for setting up your own