Posts

How to Set Up Google Apps Script Deployment from GitHub Actions

-
Image
🚀 Project Repository: shivajibodkhe/google-apps-script-cicd-template This public GitHub repository serves as a sanitized and detailed example for the workflow explained below. In this project, the goal was to build a clean and practical CI/CD setup for Google Apps Script using GitHub Actions. The goal was simple: ✅ Write Apps Script code locally ✅ Version it in GitHub ✅ Push code to Apps Script with clasp ✅ Optionally redeploy an existing Apps Script deployment from GitHub Actions ✅ Keep secrets out of the repository Instead of stopping at a minimal demo, the project was developed into a working example with a real Apps Script automation flow, a GitHub Actions pipeline, a validation step before deployment, a web app health response, and spreadsheet bootstrap logic. This post walks through the setup from start to finish, including the mistakes encountered and subse...
Post a Comment
Read more

Beyond Basic Prompts: Architecting Enterprise AI with Vertex AI and Google Apps Script

-
Image
Beyond Basic Prompts: Architecting Enterprise AI with Vertex AI and Google Apps Script If you spend enough time building collaboration infrastructure, you eventually hit the ceiling of standard automation. Triggering a basic script to send an email or format a spreadsheet is like building a modern car it’s efficient, but it still requires a driver. The real architectural shift happens when you transition to building a self-driving car : an autonomous system that can process massive datasets, make complex decisions, and route insights without human intervention. Recently, Google introduced the Gemini =AI() function for Workspace, which is fantastic for lightweight, user-facing data enrichment. But if you look under the hood of Google Apps Script, there is a much more powerful, barely documented feature that changes the game for platform engineers: The Vertex AI Advanced Service. This isn't just about sending a prompt to an LLM. By enabling this Advanced Service, Apps Script exposes...
Post a Comment
Read more