My Blog

R-Powered Services that are Simple, Scalabale, and Secure

Part 1: Getting Started with Cloud Run and Plumber

R-powered services running on Google Cloud Run can act as webooks, APIs, apps, and even dashboards. Now that Github offers continuous integration and deployment with Cloud Run, publishing and updating these services has never been easier. This post outlines a minimal setup which will get you going. Future posts will cover using secrets securely, making interactive Slack apps, and more.

R and Python Plotting in Google Sheets

Now you can use R and Python to create beautiful graphs on the fly inside Google Sheets by using techniques developed previously. In fact, many functions that produce image files can be used inside Google Sheets formulas with minimal additional set up.

Using R and Python in Google Sheets Formulas

With a bit of setup, you can create spreadsheet formulas for others to use that execute R, Python, or practically any programming language code! While Shiny and Dash are great ways to share your work, following the instructions in this article, you will be able to create R and Python dashboards directly inside Google Sheets. As a bonus, these same methods allow you to insert R and Python functionality into other Google services such as Docs, Forms and Slides!