Cloud Run for Google Sheets

The author uses Google Sheets to track various aspects of their life and prefers Google Sheets due to its free cost, great documentation, and cross-device accessibility. However, they find that Google Apps Script doesn't provide all the functionalities they want and choose to use Cloud Run to control Google Sheets using Python.

In this part (part 1) of the tutorial, they set up a Cloud Run service in GCP via Terraform and scaffolded a Python API application using FastAPI. They also created a basic CI/CD pipeline using GitHub actions to automatically build and deploy the application when changes are pushed to the repository.

In part 2, they plan to cover how to authenticate the Cloud Run service to a Google Sheet, create a custom UI for a Google Sheet, and get input from, and push output to, the Google Sheet based on the UI.