Every Monday, writes a Notion page of the week's finished and in-progress Jira issues, counted by status and by person.

RGRicky Grannis-Vu · 1 workflow · Updated Nov 13, 2026

UsesJiraNotion

Write a weekly Jira progress page in Notion

ScheduleRun every Monday at 08:00.Run every Monday at 08:00.
ValuesSet notionDatabaseId to blank.Set notionDatabaseId to blank.
ValuesSet notionTitleProperty to Name.Set notionTitleProperty to Name.
ValuesSet jiraProjectKey to blank.Set jiraProjectKey to blank.
ValuesSet lookbackDays to 7.Set lookbackDays to 7.
ValuesSet maxIssues to 1000.Set maxIssues to 1000.
ValuesSet highlightLimit to 15.Set highlightLimit to 15.
TextExtract the first match from notionDatabaseId and save it as databaseId.Extract the first match from notionDatabaseId and save it as databaseId.
Decisions & LoopsIf databaseId is emptyIf databaseId is empty
Yes
Decisions & LoopsStop 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
ValuesSet projectFilter to blank.Set projectFilter to blank.
Decisions & LoopsIf jiraProjectKey isn't emptyIf jiraProjectKey isn't empty
Yes
ValuesChange projectFilter to project = jiraProjectKey AND .Change projectFilter to project = jiraProjectKey AND .
No
No steps
ValuesSet window to -lookbackDaysd.Set window to -lookbackDaysd.
ValuesSet issues to an empty list.Set issues to an empty list.
ValuesSet nextPage to blank.Set nextPage to blank.
ValuesSet morePages to true.Set morePages to true.
Decisions & LoopsWhile 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:
JiraJiraFind 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.
ListsCombine 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.
Decisions & LoopsIf search.next_page_token is empty or search.issues is emptyIf search.next_page_token is empty or search.issues is empty
Yes
ValuesChange morePages to false.Change morePages to false.
No
ValuesChange nextPage to search.next_page_token.Change nextPage to search.next_page_token.
Dates & TimesMake 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.
CodeRun 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.
NotionNotionCreate 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.
ValuesShow in the output: page.Show in the output: page.