You can use Awesome Table Connectors to export data from Jira to Google Sheets by logging in with the Jira connector.
In the Awesome Table add-on Home screen, click Create new request.
The list of available connectors is displayed.
Open the Jira connector.
On the Connect to Jira screen, click Sign in with Jira.
A new page opens.
Log in to Atlassian with your account.
Click Accept to accept the authorizations.Awesome Table informs you if your connection is successful.