"State mismatch" while using "Open in Sheets" functionality

Issue Summary

While using the "Open in Sheets" buttons, it asks to authorize into Microsoft or Google and then asks to authorize in Jira and after that, it shows a "State mismatch" error.

Steps to Reproduce

1. Open advanced issue search page
2. Click the "Open in Sheets" button
3. Follow authorization prompts
4. In the end, it will show a "State mismatch" error

Expected Results

It should allow exporting data to Excel or Sheets and authorization should work

Actual Results

State mismatch error

Workaround

If you get a "State mismatch" error, close the window with the error, close the dialog the verification code, wait 30-40 seconds and then try again.

You can also use a standalone Jira Cloud for Sheets app. Also, you can use a Jira native export.