Need to sync the options in a dropdown field with a list in google sheets or excel

[Syd Skaff]

I have a list of vendors in a Google sheet. I need the entries in this list to be synced with the options in a single-select drop down field in Jira. There are new entries added to the list all the time automatically via an integration, and it's not reasonable for someone to monitor new entries and add them to our field on a regular cadence. It would also be fine if the sync occurred at some regular time interval, it doesn't have to be instant! Also, the list can easily be in excel instead of Google Sheets.

Any advice would be helpful!

[Gerusa Lobo]

Hello @Syd Skaff 

If you use GoogleSheets, you can use Google Script Apps connecting at the sheet and updating the custom field options thought API.

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-custom-field-options/#api-rest-api-3-field-fieldid-context-contextid-option-put

[Mikael Sandberg]

You have a couple of options, one is to use a Marketplace app that allows you to take external data and show that in a drop down field. I have used Elements Connect in the passed. Your other option would be to update the field via the API, but that can be complicated if your data is changing often.