Automating Custom Reports from JIRA to GoogleSheets

on YouTube ↗22m

" summary

Demonstrates automating custom reports from JIRA into Google Sheets to avoid manual work — examples include a product quality report and other bespoke visualizations useful for managing software projects. Describes a Google Sheets–based automation approach used at Ciklum and provides resources to adopt it with minimal effort.

AI-written summary · about

" chapters (11)

1. 0:00Introduction
2. 1:08Manual JIRA reporting problems
3. 2:58Google Sheets for reporting
4. 4:03Google Apps Script automation
5. 6:31JIRA API functions
6. 8:40Dynamic queries and formulas
7. 10:30Tool demo
8. 12:54Automatic charts and reports
9. 15:29Google Apps Script limits
10. 17:18Google Sheets limits
11. 18:27Q&A

" related talks

• 32mWork Less and Do More: Google Sheets for JavaScript DevelopersFranziska Hinkelmann, Leah Cole · Node+JS Interactive 2019
• 51m30 Ways Google Sheets Can Help Your Company Uncover and Share Data InsightsDaniel Gundrum, Ryan Weber · Google Cloud Next '18
• 16mDo It For Yourself: Creating a data input platform using RHezi Buba · rstudio::conf 2019
• 33mWork Less and Do More: Sheets for Node.js DevelopersFranziska Hinkelmann, Anu Srivastava · Google I/O 2019
• 43mHow to Simplify Business Processes with G SuiteAllen Yang · Google Cloud Next '18
• 45mAutomate with Google Workspace Low Code and No CodeDararath BEAUVOIR · DevFest Toulouse 2024
• 20mAutomatise everyday workSara Krk · Data Science Conference 4.0
• 50mDigitizing Business with Jira: From Sales to AccountingDarya Petrova · Saint HighLoad++ 2022