Automated Sprint Reports from Jira to Stakeholders via Gmail

Description Automated workflow that generates a Sprint Report from Jira and delivers it by Gmail. The flow fetches sprint issues from Jira, validates and normalizes the data, calculates metrics (tickets, story points, blockers, completion rate), generates an HTML report, and sends it by email. Context This template helps teams keep stakeholders updated automatically of the current sprint. Instead of manually compiling Jira data, the report is generated and sent on schedule (e.g., every Friday at 17:00). It’s production-friendly, reusable, and works across Jira projects. Target Users Scrum Masters and Agile Coaches who need sprint reports for retrospectives. Product Owners who want a weekly o

Help me set up the n8n workflow "Automated Sprint Reports from Jira to Stakeholders via Gmail" (https://n8n.io/workflows/8932). It uses: Jira Software, Gmail, Code. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.