It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Import Jira Issues into Google Sheets - individual "logged work" and "work description/comment"

Hello guys,

I'd like to ask for help. I need a Jira (Atlassian) connection with the Google Sheets to import issues, time record data into sundry projects. This way when updating an issue in Jira the data is automatically updated in the worksheet.

Issue Type
Date Started
Display Name
Alt Advertising advertising
Time Spent (h)
Work Description

The filter to bring the Jira data comes from the project field

There are several plugins that do this service, however, I need one that is free, or for a java script as well. My greatest difficulty is to bring the "Work Description".

In the spreadsheet image, it attaches an example of how data needs to be imported.

Thank you for your help.Screen Shot 056.JPGScreen Shot 055.JPG

1 answer

0 votes

Hello Cleberton,

Unfortunately, JAVA Script is a restricted function on JIRA Cloud and there is no free solution in the marketplace to integrate both Google Sheets with JIRA in real time.

That being said, the cheaper and most efficient solution that I was able to find to achieve your goal would be by using the add-on:

Google Sheets Integration

Please, check if its price would fit for you and start a free trial to check if it has the functionality you are looking for, Cleberton.

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you