Label JQL script of Google Sheet

[Leron Mellon]

I added the Jira Cloud to my Google Sheets, I'm looking to only pull in tickets with the label "biz intel" and it looks like I can only do that with JQL. Can I please get assistance with a script on how to do that?

[Luis Machado · Accepted solution]

Hi @Leron Mellon ,

If you're using Jira Cloud for Sheets you should be able to set the JQL in the side panel. There's a section on how in this documentation.

As for the JQL, labels can't have spaces in them so "biz intel" won't be possible, but if you're using the "bizintel" label from your screenshot then it would simply be:

labels = bizintel

[Leron Mellon]

Thank you!