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"

Cleberton Antunes Feb 07, 2019

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
Petterson Goncalves Atlassian Team Feb 12, 2019

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
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Jira

Try Jira Cloud for Outlook: Organize your work without leaving your inbox

Hi Atlassian community, My name is Max and I work on the product integration team at Atlassian. I am pleased to announce the early access program for the Jira Cloud add-in for Outlook. This add-in...

795 views 0 12
Read article

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