My organization uses this integration all the time, but if they need to force a refresh sooner than an hour, they have to ping me (the person who set it up) to click the button. I've have 5 separate people this week ask why I couldn't add an Apps Script button to allow them to force refresh themselves. Please!

Sounds like this would be a massive + for the Jira Cloud for Google Sheets integration. This would make people's lives so much easier. +1

Same here. Would like a script code for the macro to refresh Jira rows from Jira extension in google sheet as needed. Don't want to go to the Jira extension to manually refresh it or to set it up for every 1 hour. Bigquery data extracted to google sheet got this option to refresh as needed via macro script, please create this option for data in google sheet taken from Jira extension

Not sure if this is the same ask. I am looking for a way to tell the sheet to tell the Jira pull to update itself., 

Context: Embed the sheet in Confluence. Provide confluence-reading user a link they can click to make the sheet update itself - without making the sheet editable by the confluence user. Confluence blocks activation of google sheet buttons (I have one in the sheet that triggers the Jira update via a google script) . 

Current workaround experiment : have a teeny google form iframed into Confluence. Spreadsheet detects responses and activates Jira refresh via a script.

(the script just adds/removes a space from the JIRA query string to fool into firing - this was someone else's idea - but lost the link/name - but, thanks)

Same here. Would be great to allow a manual refresh within a cell in GSheets. It is much easier than having to open the add on, and find the button to do a refresh.

I'd really like to know how to call it. It would ease up so many issues for us.