Jira Cloud Extension

To add the extension, go to Extensions in the menu, select ‘Add-ons’ then ‘Get add-ons’.

Search for Jira Cloud for Sheets

Go back to ‘Extensions’ on the menu, click on ‘Jira Cloud for Sheets’, and ‘Open’

This tab should open up. Select ‘Get Issues from Jira’

From here, set the necessary filters to find the issues you need to import. ‘Basic’ and ‘JQL’ import type would be the easiest to use. Make sure your issues can be filtered. The best way is to add in ‘Client Code’ to all the issues.

Using JQL as an example, I’m importing all my open issues to the Google Sheet. Paste the JQL in the box, then click ‘Get Issues Now’.

The sheet will be populated with all my open issues

The fields tab let’s you control which columns to import

The ‘Schedule’ tab allows you to schedule how often the data will be pulled from Jira.

Once the issues are imported, it’s up to you how to import these lines to a new sheet with Vlookup.

The issues will be updated automatically based on the schedule you set so no manual updating is required.

If there are new issues, make sure that the new issues can be filtered with the JQL or the basic pull instructions set so you won’t need to manually update the extension.

Good luck and please reach out if you need help.