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

Question

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 · Answer

Hello @Syd Skaff,

Beyond any plugin, if you use Google Sheets you can use Google Apps Script connected to the sheet to update the custom field options through the API.

Apps Script is a cloud-based JavaScript platform powered by Google that lets you integrate with and automate tasks across Google products.

Google App Script Documentation: https://developers.google.com/apps-script

Atlassian 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 · Answer

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.