How can I create and edit template google sheets from jira?

Question

I'd like to be able to create and edit google sheets from jira automatically (i.e on creation of a subtask/issue)

These google sheets will not contain any jira fields - they will contain other data.

I'd also like to display the link of said sheet in the jira issue.

How can I do this?

Ravi Sagar _Sparxsys_ · Answer

Hi @Ayelet Blass

It may be possible to create a sheet using existing apps on the marketplace but I am quite sure you can also do that using Google APIs. Take a look at this page, now you will have to write a script whether within Jira using an app like ScriptRunner or outside Jira and trigger this sheet creation using a webhook. These are some possibilities, I hope it helps.

Ravi

Ayelet Blass · Answer

I'd like to copy a spreadsheet and possibly edit it.
I'd also like to get the link to said spreadsheet.

Gonchik Tsymzhitov · Answer

Yes.

So you main idea, is create from ticket a new spreadsheet, is that right?