Run a screen by simply going to an web address (URL) and show results in browser or get an email

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.

https ://us-central1-p123-dns.cloudfunctions.net/email-screen-run?api_id=YOUR_API_ID&screen_id=SCREEN_ID&email=YOUR_EMAIL_OPTIONAL&api_key=YOUR_API_KEY

Simply put in your values and remove the space at the beginning. Remove the email if you want the output in the browser instead of emailed to you.

Sample output in the browser is below

Also attached is the revised source code used in google cloud function

We’ll be adding more URL address that do different things if there is interest. We welcome your suggestions.

Thanks!



email-screen-run.py (1.8 KB)

Awesome!

Is this still meant to work? I tried it and got “Error: could not handle the request”

Should have attached a screenshot. Here it is: https://i.imgur.com/IbEECBT.png

Cheers,
Matt

Hi Marco,

Thanks this is a very welcome and a great idea. Some feedback/questions …

  1. I too am getting an error message.
  2. I assume the Screen ID is the 6-digit numerical code seen in each unique Screen URL?
  3. As far as ideas, please extend this to the content in the Strategies & Books. That would be very helpful.

Thanks,
Ed

There’s a problem with the mail server setup in the cloud function . Thanks for reporting this

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.

If any programmers want to help out let us know.

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

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.