I have been working CEP that can pull data from a public google sheet.
This works. The next part is the problem.
I want, after the data has been retrieved and the script has run to change a cell value so when it goes through the loop. It will skip anything that isn't specified.
This appears to require Oauth, which i've been testing with separately using a http://localhost . I got this all working really well.
Now importing the code back into my panel. I realised a few things. It's not a localhost. So it does react like the localhost webpage. Now I know it can be done, because there are a few jsx plugins that have this feature. So it's possible. I just can't for the love of me figure out how they have done it (They've also encrypted their plugins (rightfully so, but this does not help even more))
This isn't being sold and is bespoke for myself and the company I work for, so I don't need a webserver/website to run it off (Or do I?)
How can I get my CEP Panel to pass the Oauth so I can keep my sheets private and use the Google API (Unless anyone else has alternative suggestions)