Accessing an API through Glitch

Good day,

First of all, I’m not a programmer, I’m a reverse Engineer that takes what exist already and turn it around to get what I need :wink: But this time around I want to make a better project and help some people get a proper result…

So what I’m trying to do is to access an API from a site that needs credentials, but I need those credentials to be hidden, and I know you can do this through Glitch so here is the “complete” project.

First a Google Sheet that acquires data through an API and then parsing it to give my result. It’s as simple as that, but I need to hide the credentials so I don’t have to enter in the google sheet.

So from what I understood I can create some kind of a pipe through glitch to call the API to have the result I need without declaring the username / password in my google sheet but still get the JSON result to parse in my google sheet.

How would I do that?

Does the Google Sheet have to be locked down? This project shows you how to access a shared sheet:!/data-dashboard.

If it does, then the docs for the modules that it uses has more info about authenticated access:

Or you can achieve it using OAuth as in the this project:!/google-sheets