---
title: "Connecting GCP Budget Alerts to AppSheet: A Step-by-Step Guide"
author: "Martin Hawksey"
date: 2026-06-16T19:40:59+00:00
modified: 2026-06-16T19:54:06+00:00
canonical_url: https://pulse.appsscript.info/p/2026/06/connecting-gcp-budget-alerts-to-appsheet-a-step-by-step-guide/
markdown_url: https://pulse.appsscript.info/p/2026/06/connecting-gcp-budget-alerts-to-appsheet-a-step-by-step-guide.md
categories:
  - "AppSheet"
  - "Cloud Run"
  - "Intermediate"
  - "No Code"
  - "Sheets"
  - "Solutions"
tags:
  - "@aryanirani123"
  - "dev.to"
  - "gde"
featured_image: https://pulse.appsscript.info/files/2026/06/https3A2F2Fdev-to-uploads.s3.amazonaws.com2Fuploads2Farticles2Forzh3f8zqojz34mvey9f.webp
description: "Learn how to connect GCP budget alerts to AppSheet and use Google Apps Script to programmatically shut down projects to prevent unwanted cloud spend."
---

# Connecting GCP Budget Alerts to AppSheet: A Step-by-Step Guide

![Connecting GCP Budget Alerts to AppSheet: A Step-by-Step Guide](https://pulse.appsscript.info/files/2026/06/https3A2F2Fdev-to-uploads.s3.amazonaws.com2Fuploads2Farticles2Forzh3f8zqojz34mvey9f.webp)

> Have you ever woken up to a massive Google Cloud bill because a developer accidentally left a cluster… Tagged with googlecloud, appsheet, finops, cloudbilling.

We’ve probably all been there, creating and forgetting a test Google Cloud project. Here is a nice solution published by Google Developer Expert Aryan Irani knitting together various Google Cloud / Workspace services. In a guide Aryan walks through how to set up an event-driven workflow, using Cloud Pub/Sub to help prevent unwanted Google Cloud spend right from your phone. Instead of waiting for an email notification, this system uses Google Sheets, AppSheet and Google Cloud Functions to monitor your budget and give you a push notification and easy way to shut down a project.

If you want to simplify this architecture further you can replace the webhook target with a Google Apps Script function. By using the auto-generated [Cloud Resource Manager client library**](https://github.com/mhawksey/Google-API-Client-Library-Generator-for-Apps-Script/tree/main/build/Cloudresourcemanager/v3) from the [Google API Client Library Generator for Apps Script**](https://github.com/mhawksey/Google-API-Client-Library-Generator-for-Apps-Script/), you can programmatically shut down the entire target project directly from your app. Configuring the single `cloud-platform` OAuth scope in your script manifest allows you to delegate security control directly to Google Cloud IAM roles. Moving the project to a soft-delete state instantly stops all active billing across all services, databases and compute instances, providing a complete emergency stop-switch.

This project is a fantastic example of using low-code tools to solve real infrastructure problems. You can read the full step-by-step tutorial and learn how to configure this for your own projects.

Source: [Connecting GCP Budget Alerts to AppSheet: A Step-by-Step Guide – DEV Community**](https://dev.to/gde/connecting-gcp-budget-alerts-to-appsheet-a-step-by-step-guide-4pda)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2026/06/connecting-gcp-budget-alerts-to-appsheet-a-step-by-step-guide/](https://pulse.appsscript.info/p/2026/06/connecting-gcp-budget-alerts-to-appsheet-a-step-by-step-guide/)*