JIRA service management assigning ticket based on google sheet value

[fhasan]

Hello,

I would like to know how to lookup a value in a Google Sheet based on another value in a JIRA service management ticket.

For example, my JIRA service management project has a ticket containing the following field:

Item code = 123

And suppose I have a Google Sheet containing a mapping of item codes to assignees.

If I look at the sheet, I see that item 123 should be assigned to assignee XYZ. However, how can I specify this in an automation rule? I have tried using smart values and checking whether the item code falls in a list of values. However as the list of item codes grows, I don't think it will be a good approach to copy the entire list into my automation rule.

[Juan José Marchal Gómez]

Hello,

If I've understood correct you want to assign something based of some external source.

I think that you need to prepare REST END point what give you the information of external source and create an automation that update the value in the issue.

You can do it out of the box. Do you have any 3party software for automations?

Best regards.