We created a cloud http function that can run a screen using your API key
Simply copy/paste this address in your browser or anything can can call an http request, replace the parameters with your values and hit enter. It will run the screen and display the results in the browser or email the results.
Should work now. There’s lots more we can do with cloud functions that are callable via a URL but it did not generate much interest. It’s also time consuming to implement.
The fix is also using a free sendgrid smtp server at the moment limited to 100 emails/day (we had our own smtp server before we switch to google g-suite)
If there’s more interest we can review this method of calling the APIs. It’s very appealing of course since it’s just calling an http request, so it could be called from excel for example.
Please see my revised first post in this thread , I also added an image. I modified the function so that email is optional. If you do not enter an email it just prints the results in the browser. I also posted the source code of the google cloud function. Maybe it inspires someone to create other functions.
Thanks! Yes, it’s a really clever idea. I didn’t contemplate that possibility until I stumbled onto your old post. The idea of being able to run a screen or a ranking from a spreadsheet is very intriguing.
I personally use Google Sheets instead of Excel, so I wonder if there’s a direct way to connect a Google Cloud Function to Google Sheet, maybe via Apps Script.