Workflows that pause and wait for human approvals from Google Sheets

I’ve been writing a series of posts to showcase Google Workspace and Google Cloud Workflows integration. In my first post, I showed an IT automation use case in which a Google Sheets spreadsheet triggers a workflow to create virtual machines in Google Cloud. In the second post, I showed how to feed a Google Sheets spreadsheet with data from BigQuery using a workflow. In this third and final post of the series, I show how to design a workflow that pauses and waits for human approvals from Google Sheets. [Read More]

Writing to Google Sheets from Workflows

In my previous post, I showed how to trigger a workflow in Google Cloud from a Google Sheets spreadsheet using Apps Script. In this post, I show how to do the reverse: write to Google Sheets from a workflow in Google Cloud. Use case Imagine you have some dataset in BigQuery. Periodically, you want to query and extract a subset of the dataset and save it to a Google Sheets spreadsheet. [Read More]