How to write data to google sheets

[SAn4Es_TV]

Hello! I want to ask if, when changing issues in the board, it is possible to write their data in a Google sheet.
It is necessary that the data remains in the table, even when they are deleted in the jira.
I would like to do it through a web request so as not to waste money.

I use Jira Work Management.

[Aron Gombas _Midori_]

What is the actual problem you're trying to solve with it?

Do you need an audit log (what field was change from what old value to what new value) about the issue in the Google Sheet?

[SAn4Es_TV]

When the state of the issue changes, write its data to the table.
The problem is that I don't know how to do it via web request. It gives me an authorization error