nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Jira Form data to Google Sheets

Bobby Arvanitakis

As Jira forms are submitted, I want a copy of the form data sent to Google Sheets. That's it.

Tried the Jira Cloud for Sheets addon in Google Sheets, but I can't for the life of me figure out how to export any form data, not even using customfields (can't even find them using <sitename>.atlassian.net/rest/api/2/issue/<issueid>?expand=names).

Accepted answers

All comments

Mikael Sandberg

You can either download the form answers manually in xlsx format, or you can use the REST API for forms to get the answers. You can find the documentation for the API here.

Samuel Gatica _ServiceRocket_

Hi @Bobby Arvanitakis

The easiest way is using the Jira Cloud for Sheets addon in Google Sheets.

Create a Filter in your Jira instance with all the fields that you want ti import to Google Sheet.
Connect your Jira instance with Jira Cloud for Sheets
Get issues from Jira selecting thee Import Type "Filter"
Hope this helps!
Best regards
Sam

Joseph Chung Yin

@Bobby Arvanitakis -

I agreed with @Mikael Sandberg suggestion. To supplement their response, please note that FORM's elements (if they are not mapped to actual Jira/JSM issue fields), those elements are exclusively reside in the FORM which are associated with your issues if you setup issue creation using FORMs.

I have to say that my experience of using FORMS REST APIs are not easy and straight forward.

Hope this also helps.

Best, Joseph Chung Yin

Josh_Unito

You can sync JSM issues to Google Sheets with Unito. So if the form details are in an issue, you can then replicate it as a spreadsheet row with 2-way updates (so any changes on either end appear in the other). Here's a guide on how to sync Jira Service Management + Google Sheets.

Mikael Sandberg

The question is about Forms, does Unito sync form answers to Google? If not then Unito is not an option.

jason.duplock

Hi Sam

Your response does not give what was originally asked for. Using JKIRA Cloud for Google sheets will only let you pull the fields that exist as part of the issue, it will not allow you to pull any fields from your forms within that issue.

Thanks

Jason

jason.duplock

Bobby

I am trying to do the same thing... did you ever get to manage it?

Thanks

Jason

jason.duplock

Hi Samuel

Using JIRA Cloud for sheets does not do what was Bobby asked. Using cloud, you can only get the issue fields and not the form responses.

I am trying to do the same thing, have a google sheet populated with the form responses, when that form is submitted in JSM.

Exporting the Form as an .XLSX file is an option but it is a new file every time and if you want to integrate with an existing worksheet that is formatted and may have columns in a different order and so on, that is not really workable, for me at least!

Still hoping!

Jason

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

forms

jira-service-management-cloud

jira-service-management