Automation - export issue fields to Google Sheet

[Stuart Capel - London]

Hi,

Is there a simple way to export data from an issue and write it into a Google Sheet e.g. populate the columns with results from issue DO-1.

I'm building a process to generate and populate 5 different NDA's in a Google Doc ready to send.

I've set up automation rules that are triggered when a new service desk issue is created and the answers to the questions in that service desk ticket are used to decide which of the 5 template NDA's are required.

The SD ticket being created also triggers an issue creation in a separate jira project (Ops Docs) and the user who raised the SD ticket is sent a Slack message asking them to populate the required fields in the NDA issue. This issue will have only the fields required to be populated in the appropriate NDA template.

So then when the person who's asked for an NDA through the service desk fills in the required information and marks the ticket as 'done', another automation will trigger sending the smart values to the Google Sheet {this is the bit I'm trying to work out}.

I've got a macro set up using Google AppScript which will trigger when the row is updated. and it mail merges the fields into the template Google Doc ready for approval.

When I get it all working it'll mean users are guided through the process to decide which NDA they need, grab the info required to populate it, and ping out a pre-populated version ready for legal to approve and send. Should save the legal team a few weeks a year!

I'm developing this on a free cloud instance but it will be deployed on a Premium plan cloud instance.

Thanks for reading!

[Josh_Kochelek__Modus_Create · Accepted solution]

There's a few ways to do this, but have you considered the Google Sheets Add-On, Jira Cloud for Sheets? There's also a plugin for Jira Cloud - Jira Cloud for Google Sheets (official) . 

Also, you can always export issue data to CSV and manipulate it that way. 

[Stuart Capel - London]

Excellent point! I can't believe I didn't think of the sheets add-on, I recommend it all the time when people ask how to do a "report where...."

Yes that's genius 😂 new row, trigger appscripts. Like it, thanks very much.

Let me give it a try, might come back for some more ideas.

[Stuart Capel - London]

Ah - the issue with GSheets add-on is the refresh schedule only allows hourly as its most frequent refresh option. It'll mean it could take up to an hour to produce the correct NDA.

It's good but not fully awesome :)

There must be a way to do it with the 'send webhook' action in automation