Google Apps Script – Page 20 – By @mhawksey

AppSheet/PayPal integrated payment solutions and tips on handling data in Google Sheets

September 19, 2022

This post highlights how Google Apps Script can be used to enhance an AppSheet app and create integrations with third party services and APIs. More importantly it hopefully illustrates how Apps Script and use of the Sheets Advanced Service can be used to effectively manage data in Google Sheets, optimising calls for reading/writing data to reduce response times and preventing concurrent overwriting.

Creating a Google Drive report in Google Sheets using the Google Drive API

In this post I highlight a method ideal for scenarios when you want to index larger volumes of My Drive files and folders to a Google Sheet with calls directly to the Drive API. The post includes some sample code you can use which instead is able to reduce a 4 minute runtime to index 10,000 files and folders to one that can complete in under 40 seconds!

Google Apps Script Patterns: Keeping a gam generated users report up-to-date with Google Apps Script

In Google Workspace gam is probably the ‘go to’ tool command line tool which allows administrators to easily manage domain and user settings. Recently I was asked about how you can keep gam generated reports up-to-date using Google Apps Script. It’s worth remember that gam uses public Google Workspace APIs when it performs actions and reports. In this post I show you a pattern for building script to keep gam reports fresh.

Introducing AppSheetApp: A Google Apps Script library/helper class for the AppSheet API

In this post the worlds of AppSheet and Apps Script collide, the resulting fusion is a library which makes it easier to integrate external data and events into your AppSheet app. This solution hopefully makes it a lot easier for developers and low coders to do more with AppSheet creating the possibility to use one (or a couple) of lines of code to interact with your app and not worry which data source your app is using. This post has more details of how you can get started and an example of the impact its already making with an alternative Grab n Go Chromebook loaner solution I’ve been part of at CTS.

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

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.

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

October 2, 2023

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!