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).

[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.

[jason_duplock]

Bobby

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

Thanks

Jason

[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

[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.

[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

[Samuel Gatica _ServiceRocket_]

Hi @Bobby Arvanitakis 

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

1. Create a Filter in your Jira instance with all the fields that you want ti import to Google Sheet.
2. Connect your Jira instance with Jira Cloud for Sheets
3. Get issues from Jira selecting thee Import Type "Filter"

   

   Hope this helps!

   Best regards

   Sam

[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