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.

Project
Issue Type
Key
Summary
Priority
Date Started
Username
Display Name
Estimated
Remaining
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 showcase
Posted in Jira

Calling all Jira Cloud users! Give us feedback on our exploration of a new navigation.

Hi everyone! My name’s Matt and I’m a product manager at Atlassian. I work in the navigation & findability space for all our Jira Cloud products. We’ve been working on trying to improve the exp...

1,060 views 16 12
Join discussion

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