AppsScriptPulse

Modern Angular in Google Workspace Editor Add-ons

I intend this post for established Add-on developers who want to use Angular in Google Workspace editor Add-ons and Google Apps Script webapps. This does not attempt to show how to create Add-ons or Angular apps, but the tooling and build process to use Angular apps in Add-ons. I am also assuming familiarity with installing and using CLI tools in your development workflow.

We recently had the author of this post, Spencer Easton, on an episode of Totally Unscripted to talk about this topic. This companion post provides an overview of using Angular for Add-on development. There is a cost associated with this solution has separate hosting is required for the Webpacks, but as covered by Spencer the cost is low (for a 100K+ users add-on the cost is $8/month).

Source: Modern Angular in Google Workspace Editor Add-ons

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.

Source: A SyntaxHighlighter Evolved WordPress plugin for Google Apps Script contributors

Download Gmail Messages as EML Files in Google Drive – Digital Inspiration

This Google Script will help you download your email messages from Gmail to your Google Drive in the EML format.

Nice little snippet from Amit Agarwal for generating .eml files from Gmail messages using Google Apps Script. The post has all the code you need for this.

Source: Download Gmail Messages as EML Files in Google Drive – Digital Inspiration

Adding an unsubscribe link to the Google Workspace Solution Gallery ‘Mail merge using Gmail and Google Sheets’

Recently I came across a nice post from Ravgeet Dhillon, which looked at how to Add Unsubscribe link in emails using Google Apps Script. The solution uses a Google Sheet and a Google Apps Script web app to add an unsubscribe link to emails. As I noted when shared via AppsScriptPulse this is a useful addition if your mailing needs comply with PECR or similar electronic communications regulation compliance.

Having recently updated my ‘Create a mail merge using Gmail and Google Sheets’ in the Google Workspace Solution Gallery to handle inline images I thought it would be useful to show how this example can be extended to include a variation on Ravgeet’s post.

Source: Adding an unsubscribe link to the Google Workspace Solution Gallery ‘Mail merge using Gmail and Google Sheets’

Totally Unscripted: Modernize your Workspace Editor Add-ons development with Angular – Thur 25 Feb at at 1200 PST / 1500 EST / 2000 UTC

We all love the flexibility HTMLService gives us when developing Google Workspace Editor Add-ons, but what happens when you need to scale your production? Web application frameworks provide a way to deploy and develop your code in a structured way making it easier to maintain your code base. Angular is one open-source web application framework that can be used to modernize your Workspace Editor Add-on development. In this episode we are joined by Spencer Easton who will share how Amplified IT have adopted Angular for their Add-on development. As part of this we will explore the benefits using Angular including a component-based architecture, internationalization and performance.

Tune in live to contribute to the YouTube live chat (recording immediately available). – https://youtu.be/mtDsScbfRIU

For previous episodes, information and resources visit https://tu.appsscript.info/

Maintain Google Apps Script in an Enterprise environment – Google Apps Script deployment with Cloud Build

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. The instructions are high level, this article is not a codelab.

For those interested in scaling up their Google Apps Script development Jasper Duizendstra outlines how you can use Google Cloud Build for version control and Continuous Deployment (CD). As Jasper notes:

When the CD pipeline is in place it becomes easy to deploy the script, separate the responsibilities and support multiple versions and implementations of the code … the most important advantage of using CD is the mindset that it enables. It provides an environment where I feel confident and safe to create small incremental changes in my applications.

Source: Google Apps Script deployment with Cloud Build

Create a custom automated Table of Contents for your Google Sheets tabs with Google Apps Script – Yagisanatode

In this tutorial, we will cover creating a custom Table of Contents that lists your Google Sheets tabs on its own tab using Google Apps Script. This Table of Contents (TOC) will update whenever you open your sheet or choose to update it with a button.

As always a very detailed explanation of how this solution works from Scott ‘Yagi’ Donald.

Source: Create a custom automated Table of Contents for your Google Sheets tabs with Google Apps Script – Yagisanatode

Creating a book recommendation engine using Google Apps Script — Thoughts from a Technologist turned School Librarian

Don’t have time to get to all your library duties? Need more staff? Create them using code! I work in a school library and could definitely do with some help around here, so let’s write some programs to streamline a few library duties and add some “virtual staff”.

In this post, we’ll create a small tool to help get word out to the school community about book recommendations and new releases/purchases in the library. The plan is to make use of a Google Sheet to pre-populate a bunch of data as time goes on and then have a Google Apps Script pull that data periodically, display it on our digital displays using Google Slides as well as to send email updates to the community.

Nice example for creating Google Slides from Google Sheets for digital signage. The post has a useful explanation of what is going on in the code for those interested to learn more.

Source: Creating a book recommendation engine using Google Apps Script — Thoughts from a Technologist turned School Librarian

Use Google Cloud AI to find the right answers from the Calendar TV contest

I have programmed an application that searches for (or rather knows) the correct answers to the competition questions from the Kalendárium program, all using Google Cloud AI. I decided to write the entire application in Google Apps Script technology, which offers an online IDE editor, application operation in the cloud and the possibility of a quick connection to Google services. [auto-translated]

You’re going to have to hit Google Translate to read this post from Ivan Kutil, but it’s worth it is a nice example of how Google Apps Script can be used for orchestration. All the details are in the post and it’s also a nice reminder of the Parser library Ivan released in 2016, which makes it easy to scrape data from websites using UrlFetchApp (read more about the web scraping).

Source: Využití Google Cloud AI pro hledání správných odpovědí z televizní soutěže Kalendárium

Hackers abuse Google Apps Script to steal credit cards, bypass CSP

Image: Google

Attackers are abusing Google’s Apps Script business application development platform to steal credit card information submitted by customers of e-commerce websites while shopping online.

Interesting report highlighting how Google Apps Script is being exploited as a vector to skim card data. The post is worth reading for more details but in short the script.google.com address for webapps is being used as a trusted domain to avoid detection. The post also mentions how Google Analytics is being used for a similar exploit. How this will all play out is yet to be seen.

Source: Hackers abuse Google Apps Script to steal credit cards, bypass CSP

Everything you ever wanted to know about Gmail draft inline images and Google Apps Script but were afraid to ask

Image order in Gmail draft

A common workflow solution in Google Apps Script is to use a Gmail draft message as a template for sending emails. For the user the benefit is they can draft a message in a familiar environment adding formatting without having to worry about writing HTML. A problem often encountered is the inclusion of inline images. This post looks at solving the issue of missing inline images.

Source: Everything you ever wanted to know about Gmail draft inline images and Google Apps Script but were afraid to ask – MASHe

Learn how to build an image library with Google Drive and a little Google Apps Script

With Google Drive, Apps Script, Bootstrap, and a little jQuery, you can develop an Image Library web application with search and download functionality!

Useful little tutorial if you are interested in learning how to interact with Google Drive files. The post is also a nice introduction into using the Bootstrap framework for building responsive web apps.

Source: Image Library

Bulk create Google Calendar events with optional Google Meet from a Google Sheet

Bulk create Google Calendar events with optional video conferencing (Google Meet) all from a Google Sheet.

Google Sheet columns allow for event details to be added

Google Sheet columns allow for event details to be added

Features of the tool

  • Performs an initial check that you have access to the provided Calendar to create events on.
  • Allows for events to be created on another Calendar that you have suitable access to (not just your own).
  • Uses toast popups to inform you of the progress as each creates each event per row.
  • Fast and efficient for creating a large number of events in one go.
  • Will not duplicate events if re-run, so you can continue to append further if you wish.
  • Provides a direct link to the created event from within the Google Sheet for easy access.
  • Performs a check of any missing ‘required’ information and informs the user via a popup so they can resolve this.
  • Includes ‘Log’ sheet to help output any error messages.
  • Has a ‘Reset’ option in the menu bar to remove all entered data and start from scratch.
  • Replicates 90%+ of the settings you can adjust when directly creating an event in Google Calendar.

Source: The Gift of Script: Bulk create Google Calendar events with optional Google Meet

Add unsubscribe link in emails using Google Apps Script

Provide your subscribers an option to opt-out of mailing lists by adding unsubscribe link using Google Apps Script.

A useful post on creating a system to allow users to indicate they wish to opt-out of further mailings (useful for PECR or similar electronic communications regulation compliance). The post has the broad steps and code needed for this solution and you will need to fill in some of the blanks like how to record the unsubscribe_hash in the Google Sheet.

Source: Add Unsubscribe link in emails using Google Apps Script

Tweet formula for Google Sheets – Twitter Developer Blog

The new Twitter API brings a much better way to get a list of publicly available Tweets in Google Sheets to retrieve Tweets and their details, including the username of the author.

Always nice to see when other web services feature Google Apps Script. This is a great example from Daniele Bernardi (‎@i_am_daniele‎), DevRel at Twitter, highlighting how Google Sheets custom functions can be used to interact with the Twitter API. The post has everything you need to know plus a link to a gist with all the code.

Source: The Tweet formula for Google Sheets

Subscribe to Apps Script Pulse...