How to build a more perfect workflow for data updates and changes by coding in Apps Script between the Sheets
Thought provoking post by Max Brawer exploring the utility and fragility of using spreadsheets as part of a decision making processes and how Apps Script can be used to overcome some of these shortcomings.
In this article I will showcase one of the many ways you can customize your Google Workspace environment. We will implement two custom functions in Google Sheets. With these functions as an example I will demonstrate how to use Google Apps Script Libraries to organise and distribute your solution. There are multiple ways to distribute your Apps Script code within the Google Workspace, and this article will help you decide if this library method is right for you.
Always nice to have some advanced techniques in your toolbox. In this example from Jasper Duizendstra he explores how custom functions in Google Sheets can be packaged and used in Libraries.
Source: How to write a custom function library for Google Sheets
A week ago Google announced the availability of an improved code editor for Google Apps Script. … In this article, I’ll focus on the changes related to Versions and Deployments in Apps Script.
Post from Romain Vialard unpicking deployments with the new Apps Script IDE. Romain highlights lots of very useful tips and things to be aware of when deploying Apps Script projects, in particular:
For existing scripts, deploying from the new IDE will create a new deployment with a different url for your web app
Google Apps Script can go way beyond a simple script that solves a problem. In this article I will showcase the way I deploy Google Apps Script code in an Enterprise environment. I will share the actual build file and the necessary steps and tools to reproduce my workflow. This approach does require Google Cloud Platform knowledge and a credit card.
Jasper Duizendstra has a passion for technology. As a freelance Google Cloud architect he handles the architecture choices. He is driven by a desire to understand the pros and cons of available platforms and languages.
Jasper worked in multiple countries in many roles. He is a specialist on the Google Cloud Platform and G Suite. He manages or participates in migrations to G Suite or the Google Cloud Platform. He likes hands on work like coding and creating apps or ELT data processing pipelines.
As a motivated educator he also coaches developers and supports offshore teams. He is also an App Script GDE and Google Mentor.
Building and maintaining code can be hard. There are multiple phases in the livecycle of the code, each phase with its own challenges. Being able to easily retrieve information about the execution of your code in each phase is key. This is where the new Google Apps Script IDE debugging and logging features can help. In this article I will show you what you can do with the new debugging and logging features.
Some great tips from Jasper Duizendstra on using the logging and debugging features of the new Apps Script IDE.
In this post, we will learn how to check the Twilio Balance using Apps Script and send an email to the user when the threshold level meets.
Nice post that introduces interacting with the Twilio service using Google Apps Script. The post includes lots of useful screenshots and illustrations to help you create you own billing alert system.
Back when G Suite, err… Google Workspace Add-ons launched, support for Docs, Sheets, and Slides was conspicuously absent. Sure, they’ve long supported their own flavor of add-ons, but the idea of building an add-on two different ways didn’t sit well with me. Thankfully I didn’t have to wait too long for the editors to catch up. … Now that add-ons work in the editors I had the chance to build a few small demos to try them out.
Recently it was announced that Google Workspace Add-ons now support the extension of the Editors (Docs, Sheets and Slides). Steven Bazyl (Google, DevRel) has shared an overview to help you get started with Workspace Add-ons. The examples Steven shares are particularly useful if you want to start developing add-ons that work across editors as well as in Gmail. This post is particularly useful for tips on handling different host applications. Follow the link to the source for all the code and more details…
… how to send Charts in Email using Google Apps Script. Sending charts on Email can be used to send the attendance charts of the students, sales chart for the week, share price charts, etc.
Always nice to see others in the Apps Script community use the work of others for inspiration and reshare the results. In this post latest post from Aryan Irani you can learn how to send charts from Google Sheets. This post covers a basic technique that you can easily expand on (if you are having issues with the charts rendered in your emails using this solution check out my referenced post for an alternative method).
Rather than manually update my team hourly, I used a slack bot that grabs the AQI from the air now API every hour. So I thought I’d share how I did it, and maybe if you use G Suite and Slack in your workplace you could set one up too.
Nice post describing how you can use Google Apps Script to develop a Slack bot that is setup to post messages to a Slack channel at regular intervals. Click through to the source to find out more.
