Category: Google Apps Script

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.

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.

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.

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 […]

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.

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 […]

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

In this post I share GenerativeLanguageApp, a Google Apps Script helper class which makes it easy to quickly copy MakerSuite code examples to run them in Google Apps Script. This is a great way to start experimenting with LLMs and seeing how they can be used in Google Workspace.

In the next part of this series, I’ll explore some of the capabilities of when using the PaLM 2 API with data from Google Sheets. Stay tuned!

Two ways to remove duplicate rows from Google Sheets using Google Apps Script

For many years users had to find a variety of workarounds if they wanted to remove duplicate rows from Google Sheets. This all changed in 2019 when Google announced new features, which included removing duplicates from Google Sheets. Recently I got tagged in a conversation with Andrea Guerri who shared some ‘remove duplicate’ example scripts. This sent me down a bit of a rabbit hole looking at various ‘remove duplicate’ Apps Script solutions and I’ll share two of my favourites.

[Presentation] Coding in no-code: Extending AppSheet functionality… with code. + reflections from Google I/O Extended Edinburgh 2023

The Google Developer Groups’ (GDGs) are a great opportunity to meet people interested in Google’s technologies in your local community. If you haven’t come across these groups before they are volunteer driven and a great way to learn, grow, and connect with other developers interested in Google technologies. As part of Google I/O Extended I […]
2 Comments
Next Page »
css.php