Category: Google Apps Script
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.
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.
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!
AppSheet/PayPal integrated payment solutions and tips on handling data in Google Sheets
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.
Working with the Google Drive API Revisions history: Tips for handling revision merges
Having spent quite a bit of time working with the Google Drive API Revisions resource in this post I thought it would be useful to share some of the lessons and solutions I’ve picked up along the way. For this I’ll be sharing code snippets for interacting with the Revisions resource with Google Apps Script, but the solutions discussed could easily be applied to your programming language of choice.
[Repost] How to automate Google Apps Script deployments and workflows with GitHub Actions
Managing code particularly in container bound projects can be a real headache for Apps Script developers. The Script REST API has made this a lot easier both is terms of managing scripts but also opening up options for different development environments, including local development using clasp and your preferred IDE.
My experience is Google Apps Script developers generally like automation and a lot of their Google Workspace solutions are automation problems. Using GitHub Actions is a great way you can also automate your software workflows. This contribution from Goran Kukurin is an excellent example of how you can make your Google Apps Script development less cumbersome and error-prone using GitHub Actions.
Formatting date/time values using the user’s timezone for Google Workspace Add-ons using Google Apps Script [repost]
Working with dates, times and time zones can often be a bit of a headache. In a recent App Script project I encountered an issue with display date/times returned from an API in the users local time setting. Here are a couple of solutions I came across for getting the user’s time zone and handling ‘big balls of wibbly-wobbly, timey-wimey… stuff’
Tips, tricks and scripts for automating your Gmail inbox with Google Apps Script
This is a repost of an editorial piece I shared on AppsScriptPulse One the powerful features of Google Apps Script is with a couple of lines of code you can quickly start automating and organising your inbox. For people just getting started with Apps Script Google provide a introductory codelab ‘Accessing Google Sheets, Maps, and Gmail […]
Google Apps Script developer notes on using the new Google Forms REST API
Google recently announced the general availability of the new Google Forms API. For developers familiar with Google Apps Script for some time it has been possible to create, access, and modify Google Forms through the Forms Service. In this post I will highlight why Google Apps Script developers might want to use the new Forms API and some resources I’ve found useful for working with the new API in Apps Script projects. As part of this I’d like to share my experience of using the Forms API within a Google Forms Add-on and some factors to consider if you are particularly interested in watching for Google Form edits.
A SyntaxHighlighter Evolved WordPress plugin for Google Apps Script contributors
With my published content I like to include useful code snippets. As I published on a self-hosted WordPress blog I’ve used plugins to help format the code to make it easier to understand and also aesthetically look nice. In this post I share a WordPress plugin I’ve developed for Google Apps Script syntax highlighting.