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 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?