Blog

Image

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.

0 Comments
Image

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.

0 Comments
Image

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

0 Comments
Image

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.

0 Comments
Image

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.

0 Comments
Image

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.

0 Comments
Image

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.

0 Comments
Image

GenAI for Google Workspace: Exploring Gemini API Function Calling with Google Apps Script — Part 3

Google latest generative AI solution, Gemini, includes the capability to declare functions that the LLM can use in it’s response. The response includes the name of the function and the parameters the script needs to run the function.

The function isn’t executed by the LLM, but run with your code, which creates really interesting opportunities for Google Apps Script solutions. In particular, given user identity and authorisation is an integral part of Apps Script and how it integrates with other Google services it means solutions like personalised mail merges can be created in a couple of lines of code.

0 Comments
Image

GenAI for Google Workspace: Exploring the PaLM 2 API and LLM capabilities in Google Sheets with Google Apps Script — Part 2

This is the second part in my series exploring the GenAI capabilities of the PaLM 2 API in Google Sheets. In the first part you can read how to set up Google MakerSuite to use Large Language Models (LLMs) with Google Apps Script. In this post I’ll show you how the GenerativeLanguageApp helper class introduced in […]

0 Comments
Next Page »
css.php