The Jira Sheet by Agile Champion add-on combines the power of Jira with the flexibility of Google Sheets™. With this add-on, you can:
• get the summary of your jira issues
• get the status of your jira issues
• get the progress of child issue of your jira issues
• get all assignee of your jira issues including the subtask

How to Use:
• Install this application from Google Workspace Marketplace
• Connect to your jira project
• Then you can get Jira data using custom function ("=jira...")