Jira to Google Sheets, and Forms to Word
Scripts that move bugs and features from Jira into Sheets, plus VBA that turns Google Forms answers into mail-merge-ready Word documents.
- Year
- 2024
- Tools
- Python, Jira API, Google Sheets, VBA, Word
The aim
Automate the flow of tasks (bugs and features) from Jira into Google Sheets. Separately, use VBA to move Google Forms responses into Word, ready for mail merge.
What we did
- Wrote automation scripts that pull Jira task data into Google Sheets.
- Built VBA macros that transfer Google Forms data into Word templates.
- Kept both compatible with future use cases, so they can grow with the team.
What we delivered
- A Python script for Jira-to-Sheets automation.
- VBA macros for Forms-to-Word integration.
- Setup documentation and user guides.
The outcome
Simpler task management and document generation. Less copy and paste, fewer manual errors, more time back.