Write a weekly Jira progress page in Notion

Every Monday morning, this searches Jira for everything that reached a done status in the past week and everything still open that moved in the same week, and writes it up as one page in your Notion database. The page opens with a headline count, then a Completed and an Active section, each with a count per status and the newest issues listed with their keys, and ends with a line per person showing what they finished and what is still in progress.

Finished work is recognised by the group Jira files each status under, so a project whose last column is called Shipped or Closed is read correctly. Issues with nobody assigned are counted under 'Unassigned' rather than dropped. Up to 1,000 issues are counted each week; if more moved, the page says so at the top. A quiet week still gets a page saying nothing moved, so a missing page always means the run did not happen. Nothing in Jira is changed.

You need Jira and Notion connected, and the link to the Notion database the pages go into, shared with your Notion connection. Optionally, a Jira project key to cover one project instead of every project you can see.

Run every Monday at 08:00.Run every Monday at 08:00.

Set notionDatabaseId to blank.Set notionDatabaseId to blank.

Set notionTitleProperty to Name.Set notionTitleProperty to Name.

Set jiraProjectKey to blank.Set jiraProjectKey to blank.

Set lookbackDays to 7.Set lookbackDays to 7.

Set maxIssues to 1000.Set maxIssues to 1000.

Set highlightLimit to 15.Set highlightLimit to 15.

Extract the first match from notionDatabaseId and save it as databaseId.Extract the first match from notionDatabaseId and save it as databaseId.

If databaseId is emptyIf databaseId is empty

Yes

Stop and report a problem: The 'notionDatabaseId' setting needs the link to the Notion database these pages go into. In Notion, open the database as a full page, click Share, then Copy link, and paste that link (or the 32-character ID in it) into 'notionDatabaseId'. Share the database with your Notion connection too, then run it again.Stop and report a problem: The 'notionDatabaseId' setting needs the link to the Notion database these pages go into. In Notion, open the database as a full page, click Share, then Copy link, and paste that link (or the 32-character ID in it) into 'notionDatabaseId'. Share the database with your Notion connection too, then run it again.

No

No steps

Set projectFilter to blank.Set projectFilter to blank.

If jiraProjectKey isn't emptyIf jiraProjectKey isn't empty

Yes

Change projectFilter to project = jiraProjectKey AND .Change projectFilter to project = jiraProjectKey AND .

No

No steps

Set window to -lookbackDaysd.Set window to -lookbackDaysd.

Set issues to an empty list.Set issues to an empty list.

Set nextPage to blank.Set nextPage to blank.

Set morePages to true.Set morePages to true.

While morePages is yes and the length of issues is less than maxIssues:While morePages is yes and the length of issues is less than maxIssues:

JiraFind issues matching '@projectFilter((statusCategory = Done AND resolved >= window) OR (statusCategory != Done AND updated >= window)) ORDER BY updated DESC'. Save it as search.Find issues matching '@projectFilter((statusCategory = Done AND resolved >= window) OR (statusCategory != Done AND updated >= window)) ORDER BY updated DESC'. Save it as search.

Combine issues and search.issues into one list and save it as issues.Combine issues and search.issues into one list and save it as issues.

If search.next_page_token is empty or search.issues is emptyIf search.next_page_token is empty or search.issues is empty

Yes

Change morePages to false.Change morePages to false.

No

Change nextPage to search.next_page_token.Change nextPage to search.next_page_token.

Make today's date readable as “November 2, 2026” and save it as weekEnding.Make today's date readable as “November 2, 2026” and save it as weekEnding.

Run Python code on issues, weekEnding, lookbackDays, highlightLimit, and moreThanCounted and save it as overview.Run Python code on issues, weekEnding, lookbackDays, highlightLimit, and moreThanCounted and save it as overview.

NotionCreate the page 'Weekly Jira overview — weekEnding' in databaseId. Save it as page.Create the page 'Weekly Jira overview — weekEnding' in databaseId. Save it as page.

Show in the output: page.Show in the output: page.