basically I want to use Google Sheets API on my React Native project to write some data there on a single sheet.
Here are the problems I'm facing after searching for hours:
- I want to be able to read and write, such as creating new sheets inside the spreadsheet, hence I can't use the public API or an API key.
- I don't need the user to login, so I can't use the Google sign in API. More like, I want my developer account to be signed in, as I wanna use my own single spreadsheet for all users. Think of it as using it as a database for my app (don't worry, I'm not).
- I found many wrappers but they're all meant for node and don't work on react native.
- I'm trying to use the vanilla google APIs, but I'm having trouble getting an "Access Token" as the only way i found to get it was by making a user sign in. I created a Service Account but I can't figure out how to use on react native. The npm module I found doesn't work on react native.
So I guess here is what I'm looking for: either
- A wrapper for Google Sheets API that takes care of authentication as well.
- How to get an access_token for my developer account, without prompting the user to sign in.
Thanks!