<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Miranda Htike on Medium]]></title>
        <description><![CDATA[Stories by Miranda Htike on Medium]]></description>
        <link>https://medium.com/@mirandahtike?source=rss-48354960c1ae------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*il50ZSCBMki9amM-AQw1Tg@2x.jpeg</url>
            <title>Stories by Miranda Htike on Medium</title>
            <link>https://medium.com/@mirandahtike?source=rss-48354960c1ae------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Thu, 19 Nov 2026 09:42:11 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@mirandahtike/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[How to Generate Jira Tickets from a Google Spreadsheet Using Google Apps Script]]></title>
            <link>https://medium.com/@mirandahtike/how-to-generate-jira-tickets-from-a-google-spreadsheet-using-google-apps-script-383ccfe6efcf?source=rss-48354960c1ae------2</link>
            <guid isPermaLink="false">https://medium.com/p/383ccfe6efcf</guid>
            <category><![CDATA[jira-automation]]></category>
            <category><![CDATA[google-appscript]]></category>
            <category><![CDATA[jira]]></category>
            <dc:creator><![CDATA[Miranda Htike]]></dc:creator>
            <pubDate>Mon, 06 May 2024 10:29:15 GMT</pubDate>
            <atom:updated>2024-05-06T14:13:11.099Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*qMqjdHYjCtbdSqL9E-wTcA.jpeg" /><figcaption>Photo by <a href="https://unsplash.com/@afgprogrammer?utm_content=creditCopyText&amp;utm_medium=referral&amp;utm_source=unsplash">Mohammad Rahmani</a> on <a href="https://unsplash.com/photos/black-laptop-computer-turned-on-displaying-blue-screen-cY1SvvEfRwk?utm_content=creditCopyText&amp;utm_medium=referral&amp;utm_source=unsplash">Unsplash</a></figcaption></figure><p>This step-by-step guide will show you how to import data from Google Sheets into Jira using Google Apps Script, without the need for third-party software. To follow this tutorial, you’ll need:</p><ul><li>A Google spreadsheet</li><li>A Jira account</li><li>Basic knowledge of JavaScript and REST APIs</li></ul><h3>Step 1: Prepare Your Data</h3><p>Create a Google spreadsheet and input issue details such as summary, description, issue type, and any other necessary variables.</p><p>Below is a sample of what the spreadsheet looks like.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/901/1*k5bxRfIaPjMUOyDt1AL0eA.png" /></figure><h3>Step 2: Obtain an API Token</h3><p>Navigate to your Jira account settings and generate an API token.</p><ul><li>Log into Jira Software or Confluence and click on your profile image, then select “Profile” from the menu.</li><li>Click “Manage Your Account.”</li><li>Navigate to “Security” and select “Create and manage API tokens.”</li><li>Click “Create API token.” You will see a model.</li><li>Enter a label for your token and click “Create.”</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/455/1*yX6CcdCod9LEHSCdYTcEKg.png" /></figure><ul><li>Once your token is generated, you can copy the token to the clipboard. Make sure to save it somewhere as you won&#39;t be able to see this token again.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/456/1*3nIPwH950_g-SSKL-AsuoQ.png" /></figure><h3>Step 3: Set Up the Apps Script</h3><p>Now goto your spreadsheet to access the script editor. Click on the Extensions &gt; Apps Script.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/861/1*5jTTTx0uEfsCIekGecUNOg.png" /></figure><p>Paste the following script:</p><pre>function createJiraTickets() {<br>  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();<br>  var rows = sheet.getDataRange().getValues();<br>  <br>  // Replace &#39;your-jira-domain&#39; with your actual Jira domain<br>  var jiraUrl = &#39;https://your-jira-domain.atlassian.net/rest/api/3/issue/bulk&#39;; // your company domain <br>  var username = &#39;your-jira-gmail@gmail.com&#39;; // your Jira username or email<br>  var apiToken = &#39;your-jira-api-token&#39;; // your Jira API token<br>  <br>  var headers = {<br>    &quot;Authorization&quot; : &quot;Basic &quot; + Utilities.base64Encode(username + &#39;:&#39; + apiToken),<br>    &quot;Content-Type&quot;: &quot;application/json&quot;<br>  };<br><br>  // Starting from row 2 to skip the header<br>  for (var i = 1; i &lt; rows.length; i++) {<br>    var row = rows[i];<br>    var payload = JSON.stringify({<br>      &quot;issueUpdates&quot;: [{<br>        &quot;fields&quot;: {<br>          &quot;project&quot;: {<br>            &quot;key&quot;: &quot;&lt;your-project-key&gt;&quot; // Replace PROJECTKEY with your actual project key<br>          },<br>          &quot;parent&quot;: {<br>            &quot;key&quot;: row[0] // Parent Issue ID from the first column<br>          },<br>          &quot;summary&quot;: row[1], // Summary from the second column<br>          &quot;description&quot;: row[2], // Description from the third column<br>          &quot;issuetype&quot;: {<br>            &quot;name&quot;: row[3]// Issue type from the fourth column<br>          }<br>          // Add other fields as needed<br>        }<br>      }]<br>    });<br><br>    var options = {<br>      &quot;method&quot;: &quot;post&quot;,<br>      &quot;headers&quot;: headers,<br>      &quot;payload&quot;: payload,<br>      &quot;muteHttpExceptions&quot;: true<br>    };<br><br>    var response = UrlFetchApp.fetch(jiraUrl, options);<br>    Logger.log(response.getContentText()); // Log the response for debugging<br>  }<br>}</pre><p>Replace placeholders such as your-jira-domain, your-jira-email@gmail.com, and your-jira-api-token with your actual Jira domain, email, and API token.</p><h3>Step 4: Run the Script</h3><p>After making the necessary replacements and configurations, run the script to start creating Jira issues based on the details provided in your spreadsheet.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/980/1*5CZOg7TadExuUyiW0YcEoQ.png" /></figure><h3>Step 5: Handle the Response</h3><p>The script logs the response from the Jira server. If an issue is created successfully, it displays the JSON response. Any errors will be logged with the error message.</p><p>Sample Success Response</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Fd8arTYPuiQvv_p7pZwCWw.png" /></figure><p>Sample Error Response</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*yuSU0H7-jLYXSFdKRhnLIQ.png" /></figure><h3>Step 6: Sit down and enjoy the results!</h3><p>With my most recent run, I managed to create 31 tasks in just 46 seconds — that’s about 1.4 seconds per ticket! This setup seriously speeds things up. Instead of manually entering each task, you can sit back and watch as they’re automatically populated in Jira. Give it a try and see how much time you can save!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/912/1*8H7flp-zfFPakhgg-WNZUQ.gif" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=383ccfe6efcf" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How I Use ChatGPT for Project Planning]]></title>
            <link>https://medium.com/@mirandahtike/how-i-use-chatgpt-for-project-planning-2258f4070e2d?source=rss-48354960c1ae------2</link>
            <guid isPermaLink="false">https://medium.com/p/2258f4070e2d</guid>
            <category><![CDATA[chatgpt]]></category>
            <category><![CDATA[work-breakdown-structure]]></category>
            <category><![CDATA[project-manager]]></category>
            <category><![CDATA[project-management]]></category>
            <category><![CDATA[ai]]></category>
            <dc:creator><![CDATA[Miranda Htike]]></dc:creator>
            <pubDate>Sat, 20 Apr 2024 08:58:22 GMT</pubDate>
            <atom:updated>2024-04-20T08:58:22.061Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*e315f2gHpeoR0kv5Ep_JIg.jpeg" /><figcaption>Photo by <a href="https://unsplash.com/@domenicoloia?utm_content=creditCopyText&amp;utm_medium=referral&amp;utm_source=unsplash">Domenico Loia</a> on <a href="https://unsplash.com/photos/macbook-pro-on-table-beside-white-imac-and-magic-mouse-hGV2TfOh0ns?utm_content=creditCopyText&amp;utm_medium=referral&amp;utm_source=unsplash">Unsplash</a></figcaption></figure><p>Picture this: you’ve just wrapped up a marathon of meetings, digesting all those product requirements until your brain feels like mush. But then comes the real kicker — translating those ideas into a tangible plan, complete with timelines and tasks. As a project manager, it’s a familiar headache, often leaving you drowning in spreadsheets and notes.</p><p>With the help of ChatGPT, I’ve discovered ways to address my challenges and optimize my time. This article shares my experiences in the hopes of aiding those facing similar challenges. Before diving into the details, let me walk you through my typical routine.</p><h3>My day-to-day</h3><p>Like many project managers, I tackle a range of responsibilities — from kick-offs and task estimations to timeline management, facilitating daily standups, and compiling project results. Juggling multiple projects and teams as a solo project manager at a startup is demanding. For this article, I will focus primarily on what I’ve optimized during the planning phase.</p><h4>The Planning Phase</h4><p>This starts when the product managers share the product requirement document (PRD) with the wider team. What I do next is to</p><ol><li>break down the requirements into actionable items in a Work Breakdown Structure (WBS)</li><li>have technical discussions with the engineers to break down the tasks further and gather estimations</li><li>translate estimated tasks into Jira tickets</li></ol><p>As you can see, anything that can help me optimize my time and streamline the workflow is a win.</p><h3>Creating Work Breakdown Structure (WBS)</h3><p>While some companies delegate the engineers to break down the tasks, in my case, I initiate the process by providing a high-level breakdown to kickstart estimations, which are then refined further based on the team’s inputs. Tedious, right? That’s exactly where I knew I needed to do something about it.</p><p>To craft the WBS using ChatGPT from the PRD, I first summarize and remove sensitive information. <strong><em>This step is crucial, especially if the details are mission-critical. It’s important to ensure that the content uploaded to ChatGPT is appropriate and doesn’t contain any sensitive information.</em></strong> After normalizing the requirements, I upload the cleaned-up version to ChatGPT using its file upload feature in ChatGPT 4. For those using ChatGPT 3.5, you can simply copy and paste your requirements into the prompt. Following this, I use the prompt below to breakdown the requirements into the WBS.</p><blockquote>I’m a project manager currently planning for a task estimation session. The project involves adding a new feature to the existing shopping cart system. I have attached the PRD. Could you break it down into a WBS for the tech team? The team consists of Backend, Frontend, Android, iOS, and QA. I would like to see the result in table format.</blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9Yu2MPlhgT3PkKqKiGHl1g.png" /></figure><p>Within seconds, ChatGPT provides me with a comprehensive WBS. I wasn’t expecting such detailed breakdowns. You can see the level of detail in the following screenshot.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*HfC9V5JqHA16n8vUCG__iw.png" /></figure><p>Keep in mind that ChatGPT does not have the same background and context as you and your team. <strong><em>Always review</em></strong> and fine-tune the WBS to align with your project or organization’s specific requirements. You can provide additional prompts until you’re satisfied with the results. Once finalized, I request ChatGPT to generate a downloadable Excel file.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*YyAYjo02gfPiTsg8SP7QnA.png" /></figure><p>Now that I have this Excel file, I’m ready to share it with the broader team to gather their feedback.</p><h4>How has this benefited me and the team?</h4><p>With this change, I’ve managed to reduce the amount of time needed to generate the WBS from about a day to within an hour. This time saved has allowed me to get this document into the hands of tech leads for review before the actual technical discussion with the engineers involved.</p><h3>Automating Tasks Imports</h3><p>After having technical discussions with the engineers, I put the estimations, assignees, and priorities into the WBS file. My next step is to import the tasks from WBS into Jira. Previously, setting up Jira tickets manually was eating up a lot of my time. I decided to automate this process to make life easier. So here’s how I ask for help from ChatGPT.</p><blockquote>How can I import tasks from a Google Spreadsheet to Jira without having to manually enter the data?</blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*UL_ltyo9KPYHSARydKsaTA.png" /></figure><p>With some tips from ChatGPT, I decided to go with Google Apps Scripts. I got the automation up and running in just 15 minutes, and all tasks were in Jira in no time. If you’re curious about how to set it up, make sure to follow my page. I’m currently working on an article that will guide you through the process.</p><h3>Closing thoughts</h3><p>In the past, creating and refining the WBS could take up a whole day. But now, with the power of AI, I can make a solid WBS in about an hour or even less. Similarly, creating tasks in Jira used to take anywhere from 20 to 45 minutes, but with the automation in place, I can create tickets in less than 5 minutes. With its assistance, tasks that used to take days can now be finished in just minutes, giving me more time to focus on other things.</p><p>Remember, don’t fear that AI will replace you as project managers. Instead, be the ones who leverage AI to enhance your work. Skill up and innovate to create new opportunities, ensuring that you stay ahead and continue to evolve in your role.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2258f4070e2d" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>