Creating Jira task via Google Spreadsheet event

[Benjamin Edwards]

Hi,

We use a google form to launch some processes internally. Is it possible to use a google trigger to send a ping to our JIRA project to create a relevant task automagically? Currently we do this manually once we get an email saying X form has been submitted, but this seems like it should be scriptable.

[Nic Brough -Adaptavist-]

With a little code, yes.

Broadly, I'd go with one of two options:

1. Send the email directly to JIRA as well as your users and handle it with a "create or comment" email handler.
2. On the google side, write a script that turns the data in the form into a format that the JIRA REST API can handle, and post it.

Option 1 is very easy to set up, but won't do any clever processing - it will just process the body of the email into the description, set a user, project and issue type and take a stab at priority if there's one on the email.

Option 2 is far more flexible, you can translate your form into any set of fields in JIRA, but it does require a login to JIRA to do the work.