I'm trying to use Google Sheets document as read-only database for my angular application. I tried some methods to do that, but the problem with all of these methods is that they require the Sheet to be shared publicly (anyone with the link can access the sheet). But what I want is to share it with specific user using Service Account through credentials.
- I'm using Angular 14
- There is no reference to Angular in Google Sheets for Developers.
If you know any solution or come across an article about this topic, please share it with me. Thank you.