July, 2024



Google Workspace Developer Summit

Join the Google Workspace developer community, in Boston or Berlin, for a day of deep dives into building solutions for Google Workspace. Whether you are a seasoned Workspace developer, just getting started, or somewhere in between, the Google Workspace Developer Summit is a great opportunity to learn more about how you build creative and unique solutions for your business or even the world.


The Summit is a full day event led by the Google Workspace Developer Relations team. Together, we will explore both the opportunity and the technologies that make up the Google Workspace platform, with a focus on what’s new and emerging in the types of solutions you and your teams can build.


Register now to join us in person at the Google offices to further unlock your potential as a Google Workspace solution developer.


Boston, September 12


Berlin, September 17



Developer News



Guide: Test and debug HTTP Google Workspace Add-ons

As a Google Workspace Add-on developer you might need to debug code to test changes or troubleshoot complex issues. Debugging Google Workspace Add-ons can be done in many different ways depending on your app's architecture, what the app does, how your app is deployed, and your preferences. In this guide, you test code changes in a local environment and troubleshoot issues in a remote environment.


Learn more


Workspace Developer News on YouTube

In the latest episode of the Google Workspace Developer News on YouTube we cover the new features in the Google Workspace Marketplace, Chat API, Meet SDK, and more.


Watch now



Guide: Debug Google Chat apps

Learn how to debug Google Chat apps whether you’re looking to test changes or troubleshoot complex issues. We’ll share various debugging approaches that address the ways you configure your app's architecture, what the app does, how your app is deployed, and your preferences. In this guide, you can test code changes in a local environment and troubleshoot issues in a remote environment.



Learn more


Preview: Manage grading periods using the Classroom API

Grading periods management using the Classroom API is in public preview. To use Classroom preview endpoints, you must be part of the Developer Preview Program and perform additional setup beyond typical Classroom API usage.



Learn more


Community Spotlight


Getting started using Google APIs: Workspace & OAuth client IDs (1/3)

by Wesley Chun

Are you a developer but a complete beginner using Google APIs? Then this series is for you, because I'm showing you how to get started from scratch. Each API family differs from others, so while it would be great if the user experience was completely consistent across all APIs, this isn't the case, so my goal is to help developers understand how their use differs between product families.



Unlock Smart Invoice Management: Gemini, Gmail, and Google Apps Script Integration

by Kanshi Tanaike

This post describes an invoice processing application built with Google Apps Script. It leverages Gemini, a large language model, to automatically parse invoices received as email attachments and automates the process using time-driven triggers.




Deploying an Apps Script Library Part 1

by Dmitry Kostyuk

Throughout this series, we’re going to cover everything from A to Z to ensure you’re equipped to use and perhaps even contribute to this tool that enhances Google Apps Script logging capabilities. We’ll pore over the source code, providing you with a clear understanding of the inner workings of the library. We’ll also explore the cool dev tools I leveraged during development. These insights could be a game changer for your own projects!




Tutorial: Vertex AI Agent Builder for Developers

by Aryan Irani

I recently had a client that brought to me a problem that focussed on talking with your data. Every time a resident wanted to search inside a document for a particular topic, they had to search through the entire document. To reduce time spent on searching, I came up with a solution where you can talk with your Data using Vertex AI’s Agent Builder. In this blog, we will be building a Chat app with Vertex AI Agent Builder that allows us to talk to our data.




Solutions Spotlight


File Management: Generate & send PDFs from Google Sheets

Automatically create PDFs with information from sheets in a Google Sheets spreadsheet. Once the PDFs are generated, you can email them out directly from Sheets. This solution focuses on creating custom invoices, but you can update the template and script to fit your needs. The script uses the Invoice template sheet as a template to generate PDFs. Information is sourced from the other sheets to fill in specific cells on the template. To email the PDFs, the script iterates through the Invoices sheet to get the PDF link and associated email address. The script creates a generic email subject and body, and attaches the PDF before sending.





The Ultimate Guide Connecting AppSheet to Google Cloud SQL and MySQL database

by Vo Tu Duc

This comprehensive guide walks you through connecting AppSheet to Google Cloud SQL, step-by-step. Unlock the power of a scalable and secure database to build powerful, data-driven mobile applications. Learn everything you need to know, from setting up Google Cloud SQL server, setting up the MySQL database as the datasource for AppSheet Apps, the connection to leveraging Cloud SQL for seamless data management in your AppSheet projects. If you are an AppSheet app creator or developer, this tutorial will likely be the best practice for you during the process of working with Google Cloud SQL.