Welcome to Atlassian Community!
I understand that you want to integrate your Google Sheets with your JIRA Cloud Application in a way that changes performed in one application are reflected in the other in real-time. Is that correct?
You can try the following options to achieve your need:
1 - If you are familiar with JSON language, you can create your own code using Jira REST API to integrate your google sheets with JIRA like mentioned in the thread below:
2 - You can use a paid add-on to properly integrate both applications without any code. Check below a few options:
Let me know if you have any questions.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event