Download the Quick Start Kit and create your first Quality Engineering Score in just 30 minutes flat!
- qescore
- Apr 12
- 3 min read
Updated: May 8
In just 30 minutes, you get your first automated QE Score, based on the critical bugs in your project. It’s simple, fast, and concrete.
🧩 Step-by-step summary
Step | Title | Time |
1 | Set up the Google Sheet | 5 min |
2 | Create the JIRA project | 10 min |
3 | Create a bug ticket | 3 min |
4 | Generate an API token | 2 min |
5 | Run the script | 5 min |
6 | Check your QE Score | 1 min |
7 | Test and play around | Bonus! |
🛠️ Step 1 – Set up your Data Collection (⏱️ 5 min)
Open the Google Sheet QESCORE_DataCollection_v1.0_starterkit.
Log in with a Gmail address (click the 'Sign in' button at the top right) to be able to make a copy of the file to your Drive.
Make a copy in your Drive: File > Make a copy.
Rename it as you wish.
In the "QESCORE" tab:
In column "Department" (B4): enter the name of your functional domain (e.g., Finance)
In column "Application" (C4): enter the name of your application (e.g., AppTrading)
In the "project_settings" tab:
Product column: same name as your application (e.g., AppTrading)
ToolName column: enter JIRA
toolID column: the email of the creator of the JIRA project (next step)
toolURL column: the URL of your JIRA site (e.g., qescorejira)
ToolKey column: the project key in JIRA (e.g., QESCORE2)
Label column: the label you'll use to link tickets to this app (e.g., AppTrading)
🧱 Step 2 – Create your JIRA project (⏱️ 10 min)
Create a free account with your email.
Follow the setup steps (code, name, password, etc.).
Give your JIRA instance a name (e.g., qescorejira).
Choose: “Software Development / Bug Tracking”
Project name: use the key you entered in the Google Sheet (e.g., QESCORE2)
Click Create.
🐞 Step 3 – Create your first JIRA ticket (⏱️ 3 min)
Click on “Create” in JIRA.
Ticket type: Bug
Priority: Highest
Label: use the same one defined in the Google Sheet (e.g., AppTrading)
Click Create.
✨ You’ve just created your first critical bug! You can create more if you want to play around with the score.
Note: If 'Priority' is not displayed, you need to add it from the menu on the right.
🔐 Step 4 – Generate your JIRA API Token (⏱️ 2 min)
Click on your profile icon > Manage account
Go to the Security tab
Click on Create an API token
Give it a name and click Create
Click Copy, make sure to do this before closing the window
📊 Step 5 – Set up and run the script (⏱️ 5 min)
Go back to your Google Sheet.
Check that everything is filled correctly in the project_settings tab.
Example: your URL should look like https://qescorejira.atlassian.net/browse/QESCORE2-1
So: toolURL = qescorejira and ToolKey = QESCORE2
Go to Extensions > Apps Script
In the Settings tab (⚙️ at the top):
Create a new parameter:
Name: token_jira
Value: paste your token here
Click Save
Close Apps Script.
In the Google Sheet, click on the QESCORE menu > Refresh Data
The first time, Google will ask for authorization:
Click Continue, choose your account.
Accept the permissions (you may need to click on Advanced Settings).
🎉 Step 6 – Congratulations! Your first Quality Engineering Score is calculated! (⏱️ 1 min)
Go to the QE Score tab.
You’ll see a score of “E”, as only JIRA is connected.
But you already have 9%, because fewer than 10 critical bugs were detected.
🧪 Step 7 – Play around with your QE Score!
Create 11 critical bugs → run the script again → you’ll see your score drop to 0%!
Create new applications, add their tickets, and run the script again.
Watch your quality management take shape 🔥
👉 You’re now ready to move on to the next article about creating your Quality Engineering Score dashboard.But if you want to go further right away, you can already connect other tools (Sonar, GitHub, etc.) by following the same data collection process.
It’s your move 💪
Tu en es où avec ton QE Score ?
C’est fait ✅
Je m’y mets 🔜
Besoin d’aide 🤔
Envie d’aller plus loin 🚀
Comments