Leading Virtual Teams with Dr Maren Deepwell Guest Episode
I was recently delighted to to receive an invite from Maren Deepwell to appear on the ‘Leading Virtual Teams’ podcast. Not only was it great to have a chance to revisit some old conversations we’ve had around this topic, but also wonderful to drop back in to conversational blogging.
In our conversation, Maren and I discussed the challenges and opportunities of hybrid working. One of the key challenges we discussed is how to replicate some of the benefits of being co-located when employees are hundreds of miles apart. We also discussed the importance of leadership in creating and sustaining employee engagement in online spaces. We also looked ahead to the future of hybrid working and the potential for new technologies to shape how we work.
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 […]
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.