(Online) Excel-Driven Jira Story Creator using Jira REST API
Budget: $30 – $250 USD
I want a small, reliable automation that reads an Excel file and pushes each row into my Enterprise-level Jira instance as a new User Story through the Jira REST API. The spreadsheet should capture the full set of details we track—Title, Description, Assignee, Due Date, Priority, and Status—and the script must map every column cleanly to the equivalent Jira fields.
Although I’m comfortable with the API itself, I need you to handle the end-to-end flow: designing a clear Excel template, writing the code, and packaging it so I can drop the file in, run, and watch the stories appear. A straightforward command-line Python script (pandas + requests or jira-python) is fine, but I’m open to Node.js if you prefer—clarity and easy maintenance matter more than the language.
Deliverables:
• Blank Excel template with the required columns and a few example rows
• Well-commented script that authenticates against an Atlassian cloud enterprise tenant (token-based auth), reads the sheet, and creates or updates stories accordingly
• README with setup steps, API token instructions, and a quick demo gif or screenshot
Acceptance criteria: running the script on my machine with a sample file creates the correct number of stories, each with the exact field values and no duplicates on re-run.
If any field-to-Jira mapping needs clarification, let’s discuss early so the first pass works smoothly.
Although I’m comfortable with the API itself, I need you to handle the end-to-end flow: designing a clear Excel template, writing the code, and packaging it so I can drop the file in, run, and watch the stories appear. A straightforward command-line Python script (pandas + requests or jira-python) is fine, but I’m open to Node.js if you prefer—clarity and easy maintenance matter more than the language.
Deliverables:
• Blank Excel template with the required columns and a few example rows
• Well-commented script that authenticates against an Atlassian cloud enterprise tenant (token-based auth), reads the sheet, and creates or updates stories accordingly
• README with setup steps, API token instructions, and a quick demo gif or screenshot
Acceptance criteria: running the script on my machine with a sample file creates the correct number of stories, each with the exact field values and no duplicates on re-run.
If any field-to-Jira mapping needs clarification, let’s discuss early so the first pass works smoothly.