You can do it directly using just 'google-spreadsheet' npm package. I built this[1] mini-HR portal using that. 95+ lighthouse score :)
[1]: <a href="https://www.wildcardjobs.com" rel="nofollow">https://www.wildcardjobs.com</a>
Creator of Apico here. This is a tiny example of how to use SaaS apps as backend for your small projects. As folks outlined in other comments I will clarify a few things.<p>> How is this different from using the SDKs, or APIs directly from Google?
Honestly it's very similar, the APIs offered by this app and Google are very similar. The only difference is that you get the APIs literally within a single click and added benefit of fine-grained access control over individual endpoints. You can make endpoints public (access to anyone) vs private (only be accessed with an auth token)<p>> Why don't just use Google APIs then?
Most of the APIs are server side considering security, you cannot expose these credentials to the client side, unless you only allow specific scopes that can be exposed. And then create a different set of credentials to be used on your server side to handle other actions. With this app, it acts as a proxy and firewall on top of the Google APIs, so you can expose specific endpoints to be public and rest to be private.<p>Adding to that you need to spend more time looking through docs and setting up Postman or similar tool to test the APIs, the app literally gives everything you need, APIs, Playground and a proxy for you to play around.<p>> Rate limits?
Right now, I haven't looked into this, but hopefully soon :)
How does this solution compare to creating a google project for yourself? It seems if you are already developing a react app, setting up a project in google is straightforward. The direct method also enables sharing of sheets via email. Example implementation: <a href="https://thenewstack.io/how-to-use-google-sheets-as-a-database-with-react-and-ssr/" rel="nofollow">https://thenewstack.io/how-to-use-google-sheets-as-a-databas...</a>