Blog

Delegated Power: Showcasing a Google Workspace Admin Toolbox Concept in AppSheet and Apps Script

The Google Admin Console is a powerful engine, but it often becomes a bottleneck for delegated tasks. IT teams frequently find themselves trapped in “Admin Debt,” repeating manual steps because granting full administrative access to others is a security risk. At the Google for Education IT Admin Summit in London, I shared a session on […]

Unlocking Google’s Full API Universe and Authentication Flows in Google Apps Script

Excited to share a project I’ve been working on to solve a common headache for Google Apps Script developers: accessing the full universe of Google APIs.
Ever hit a wall because the API you need isn’t built-in, or found it impossible to use a service account with standard services?

The Google API Client Library Generator for Apps Script is an open source repository containing pre-built Google Apps Script client libraries for over 400 Google APIs.

Key features include:
✅ Complete API Coverage: From Firebase to Cloud Billing, if it’s in the Discovery Service, there’s a library for it.
🔧 Flexible Authentication: Unlocks professional workflows with support for service accounts and custom OAuth clients.
⚙️ Robust Features: Built-in automatic exponential backoff for handling API errors gracefully.

I’ve written this article that walks through the “why” and shows a practical example of using a service account with the generated Drive library.

Streamlining Google Workspace Development: Editing JSON files in Google Drive with Apps Script (and a little help from AI)

Storing JSON files in Google Drive offers a practical approach for Google Workspace developers, especially when combined with Google Apps Script. While Drive lacks a built-in JSON editor, AI tools like Gemini can rapidly prototype solutions, such as web-based editors. However, creating a robust application requires more than just a quick fix. It involves understanding syntax highlighting, managing dependencies, and navigating the constraints of the Apps Script platform, highlighting the importance of both rapid prototyping and robust engineering skills.

Google Workspace Flows: A Developer’s First Look After Cloud Next ’25

Google Workspace Flows was the standout announcement for me at hashtag#GoogleCloudNext ’25. My key takeaway is they are more than just simple automation; Flows brings AI agents into the loop to tackle complex workflows requiring context and reasoning.

The aspect I most excited about is the potential for developers to extend Flows. Whilst there are still limited details I dive into what Workspace Flows offers now and, crucially for developers, the exciting roadmap ahead:

✨ Apps Script extensibility
✨ A new Connector Platform
✨ Potential for custom Vertex AI models

GeminiApp Gets a Major Upgrade: Seamless Transition Between Google AI Studio and Vertex AI, Enhanced Functionality, Multimodal Input, and More!

The GeminiApp library, designed to bring Google’s Gemini AI models into your Google Apps Script projects, has just received a major update. This new release, version 2025.01, introduces significant enhancements that expand the library’s capabilities for building sophisticated AI-powered applications within Google Workspace. This update marks a step forward for developers integrating Gemini into Google Workspace.

Gemini for Google Workspace: Empowering Enterprise Productivity While Preserving Critical Thinking

With the recent announcement that Google is bringing the latest generative AI capabilities to business customers without the need to purchase Gemini for Google Workspace, I thought I would look at the wider implications of this and specifically empowering enterprise productivity while preserving critical thinking.

The Transformative Power of Generative AI: Reimagining the Enterprise with Gemini for Google Workspace

Sharing some thoughts I’ve had exploring the transformative potential of Generative AI tools like Gemini for Google Workspace. As part of this (with the help of Gemini as a co-author), I’ve tried to capture some of my learnings and observations from the last 12 months supporting our customers with their GenAI journeys.

Some key takeaways talked about include:

* The importance of change management in adopting GenAI.
* Mastering the art of prompting and interaction.
* The need for continuous learning in a rapidly evolving landscape.
* The future of human-AI collaboration.
One Comment
Google Workspace Summit, Berlin

Google Workspace Developer Summit, Berlin 2024 Highlights

A recap of the Google Workspace Developer Summit in Berlin, highlighting key sessions on AppSheet, Apps Script, and AI integrations, with insights on monetization and community engagement.

Automate Google Drive test data creation with Google Apps Script

This post describes a Google Apps Script function to create a dummy folder structure in Google Drive, including nested folders and files (Documents, Sheets, Slides).

It highlights some useful features beginners might find useful such as recursion, randomness, and the use of Google Apps Script services for Drive interactions.

The post also discusses specific challenges encountered, like using Drive.Files.create for file creation and ensuring compatibility with Shared Drives.

Upload and download files from Google Cloud Storage with Google Apps Script without using a service account

A key feature of Google Apps Script is its integration into Google Cloud. The default behaviour when any Apps Script project is created is that an associated Google Cloud project is created and configured. This default project is not accessible to the user and for most scripts, the user doesn’t need to worry about any […]
Next Page »
css.php