sheets – www.MrAddon.com ®: Jira & Confluence Administration Support Blog

June 4, 2023

Import Google Sheet in a Jira customfield with Scriptrunner

For this exercise we are going to base ourselves on 2 posts that we detail below: For the exercise, we will go to our personal Gmail account and create a Google Sheet Note that the name of the Sheet/Page is “people“ Now we are going to create the Google App Script, for this, we will…

March 9, 2019October 16, 2019

Tempo Timesheets for Jira Software SQL worklogs extraction query

We have talked about the Servlet extraction of worklogs: How to extract an Excel report from Tempo Timesheets using an URL We have talked also about the Tempo API REST worklog extraction using groovy: How to list your Jira Tempo Teams and members in a Confluence page Jira Groovy example script to get Tempo Teams…

May 17, 2018August 31, 2018

How to create a Heat World Map in Jira with eazyBI

In this example, we want to explain how we can create a Heatmap (Worldmap) using eazyBI (in this case for Jira). As prerequisite we need a CSV with at least 3 fields: one for the ID of the row and other two fields for the longitude and geographical latitude. We need a special dimension for the…

February 2, 2018February 2, 2018

Automatically Import Jira Backlog Into Google Spreadsheet

Amazing post of bluemonkey, see here

December 3, 2016December 3, 2016

How to publish a Google Sheets Chart in a Confluence page

Very easy, see this steps In the Google Sheets charts, click on “Publish Chart” –> “Publish” Copy the URL Then, in your Confluence page, insert a “New Macro” –> “HTML” Insert an with “src” attribute and fill it with the URL See this example: