AppsScriptPulse

Apps Script’s new V8 runtime | Google Cloud Blog

This update to Apps Script lets users take advantage of modern JavaScript features and enhances new or existing scripts with less verbose, more standardized code.

This post from Alexandrina Garcia-Verdin, better known in the community as AGV, highlights some of the benefits of the new Google Apps Script V8 runtime including succinct syntax and data processing operations: map(), filter() and reduce(). As part this AGV also highlights some of the resources from Ben Collins and Amit Agarwal put together to support the community transition to V8. A nice feature of this post from AGV is side-by-side comparisons of old and new JavaScript syntax:

Image source: Google

Source: Apps Script’s new V8 runtime | Google Cloud Blog

Google Developers Blog: Evolving automations into applications using Apps Script

Two years ago, our team began building custom software to automate the multi-stage and highly manual team staffing process. Building internal software has allowed the same-size Staffing Operations Team (3 members!) to enjoy a 60x reduction in time spent staffing each role.

The Apps Script ecosystem has emerged as the most critical component in our toolkit for building this internal software, due to its versatility and ease of deployment. We want to share how one piece of the staffing process has evolved to become more powerful over time thanks to Apps Script. Ultimately, we hope that sharing this journey enables all types of teams to build their own tools and unlock new possibilities.

Source: Google Developers Blog: Evolving automations into applications using Apps Script

Manage new employee equipment requests within Google Sheets – Sheets to Apps

In today’s episode of Sheets to Apps, @TechandEco will show you how to manage new employee equipment requests with Google Sheets.

See the video description for all the links you need including the reference documentation.

Why organizations build with Google Apps Script – YouTube

On the G Suite YouTube channel you’ll find a new playlist for “why organizations build with Google Apps Script” which contains contributions from Cleo Espiritu, Ivan Kutil, Niek Waarbroek and myself. Hopefully these clips are useful in encouraging users to look at Google Apps Script as a powerful and agile development solution.

How to track time with Google Calendar and sync to Google Sheets – Sheets to Apps

In this episode of Sheets to Apps, we will show you how to track your work time on projects via Google Calendar. More importantly, he’ll be showing you how you can sync Calendar events to Google Sheets, creating a spreadsheet that shows you the total time spent on your projects.

Short video highlighting Jasper Duizendstra’s G Suite Developer Solution Gallery contribution.  See the YouTube description for all the links you need.

V8 Runtime Overview  |  Apps Script  |  Google Developers

Historically, Apps Script has been powered by Mozilla’s Rhino JavaScript interpreter. While Rhino provided a convenient way for Apps Script to execute developer scripts, it also tied Apps Script to a specific JavaScript version (ES5). Apps Script developers can’t use more modern JavaScript syntax and features in scripts using the Rhino runtime.

To address this concern, Apps Script is now supported by the V8 runtime that powers Chrome and Node.js. You can migrate existing scripts to V8 in order to take advantage of the modern JavaScript syntax and features.

This page describes the new features enabled by V8 and how you can enable V8 for use in your scripts. Migrating scripts to V8 describes steps for migrating existing scripts to use the V8 runtime.

Developers have been waiting a while for the new Google Apps Script runtime, since 2018 in fact, but it’s now here. The new runtime not only allows developers to use modern JavaScript syntax but when announced in 2018 also comes with a a tenfold (x10) faster execution. Follow the link to the developer docs for the full migration guide.

Source: V8 Runtime Overview  |  Apps Script  |  Google Developers

App Maker will be shut down on January 19, 2021

Source image credit: Dana Fried @leftoblique

G Suite Admins have started to be notified that App Maker will be shutdown on January 19, 2021. In the turndown notification Google cited ‘low usage’ as the reason for the shutdown. This news comes shortly after the announcement of Google acquisition of no code platform AppSheet and AppSheet is identified as one of the alternative platforms:

Due to the specific source code used for App Maker, you can’t directly migrate your apps to another platform. Depending on your use case, we recommend these alternative tools:

  • If you use App Maker to automate business processes: Use AppSheet, a new addition to our app development portfolio that has capabilities similar to App Maker. App Maker data is stored in Cloud SQL, and App Sheet supports Cloud SQL databases. This allows you to build an application on the existing database tied to your App Maker app.
  • If you use App Maker to develop apps: Use App Engine to build and deploy applications on a fully managed platform. App Maker data is stored in Cloud SQL, allowing you to build an App Engine application on the existing Cloud SQL database tied to your App Maker app.
  • If you use App Maker for data collection: Use Google Forms, which has many new features that were not available when App Maker launched.

Google included the following schedule for turndown:

  • Today, existing apps continue to work. Though App Maker is no longer under active development, the service will continue to be maintained.
  • Starting April 15, 2020, you will no longer be able to create new App Maker apps. You will still be able to edit and deploy existing apps.
  • Starting January 19, 2021, App Maker apps will stop working and you will no longer have access to them. App Maker data stored in Cloud SQL will remain unchanged and continue to follow the policies established by your Google Cloud Platform (GCP) account.

Source: Google App Maker will be shut down on January 19, 2021

Create a mail merge using Gmail and Google Sheets | Sheets to Apps

Whether you are in sales, marketing, education, project management, data analysis, etc., it’s common for people to want to send emails to multiple recipients with information that is customized to each. In this episode, learn about Martin Hawksey’s mail merge solution, which helps anyone send emails with customized content from a Google spreadsheet, and Gmail.

See the YouTube description for all the links you need.

Release Notes  |  Apps Script  |  Google Developers – January 21, 2020

The first release notes in 2020 for Google Apps Script are mostly related to the announcement of general availability of G Suite Add-ons and cover:

  • Manifest file structure changes (Note: “Manifest fields that previously supported Gmail add-ons still exist, but are now deprecated”)
  • Extension of the Card service
  • A Conference Data service has been added to sync Google Calendar with 3rd part conferencing applications

Visit the source link for more details.

Source: Release Notes  |  Apps Script  |  Google Developers

G Suite Updates Blog: G Suite Add-ons now generally available in Calendar, Gmail, and Google Drive

Take action without leaving G Suite

Image credit: Google – Take action without leaving G Suite 

Last year we announced the beta of G Suite Add-ons, a new cross-suite platform that connects G Suite to your favorite workplace apps. Beginning today, G Suite Add-ons will begin rolling out to all users.

Whilst the Add-on ecosystem is being extended making them generally available to end users developers will have to wait until you can start developing new add-ons for G Suite:

Organizations can also build their own add-ons using Apps Script. Note that the developer feature will be fully available in early February

Source: G Suite Updates Blog: G Suite Add-ons now generally available in Calendar, Gmail, and Google Drive

Build it for G Suite – Everyone has their own superpowers | Sheets to Apps – YouTube

Everyone has their own superpowers. Whether you’re an Data Analyst, Data Scientist, Task Automater, or Programmer, you can use G Suite to support these talents. In this video, we’ll go over what tools you can use to support these different talents.

Send content automatically via a Google Sheet and an Apps Script | Sheets to Apps – YouTube

In this episode of Sheets to Apps, see why it can be handy to use a Google Form to help requestors receive assets like e-books or online white papers automatically by email using Apps Script.

Full tour of Google App Maker’s interface | Sheets to Apps – YouTube

We’ve gone over the basics of App Maker, but now it’s time to explore the interface further. Alexandrina Garcia-Verdin goes over how to utilize and modify tools and widgets, in this episode of Sheets to Apps!

Write Apps Script Offline with clasp

🗺️ Develop Locally: clasp allows you to develop your Apps Script projects locally. That means you can check-in your code into source control, collaborate with other developers, and use your favorite tools to develop Apps Script.

Source: google/clasp

The Apps Script IDE is great, but with larger projects, I know I’ve wanted to be able to use a more powerful IDE. clasp (Command Line Apps Script Projects) is a CLI that allows you to start, write, test, and deploy Apps Script projects from any text editor you want.

Getting started, quickly build a basic app on Google App Maker – Sheets to Apps – YouTube

In this episode, we give you some brief examples of what kind of apps you can create with App Maker. Learn how to get started and quickly build a basic app on App Maker!

G Suite Updates Blog: Goal Seek add-on now available for Google Sheets

You can use the Goal Seek add-on to calculate the required value of a cell to achieve a desired value in another cell. This is particularly useful when conducting break-even analysis or sensitivity calculations, like determining how changing one value affects other correlated values in your sheet.

Interesting to see Google extending the functionality of Google Sheets with this official add-on

Source: G Suite Updates Blog: Goal Seek add-on now available for Google Sheets

How To: Add add-ons in Google Sheets – YouTube

A short promo video from the official G Suite account showing users how to install add-ons in Google Sheets, which developers might find useful to reference or see how to structure their own add-on videos.

Example apps you can build on Google App Maker – Sheets to Apps – YouTube

In this episode, we give you some brief examples of what kind of apps you can create with App Maker. Learn how to build dashboards, human resource apps, and so much more!

The problems I can solve with App Maker – Sheets to Apps – YouTube

Welcome to the Sheets to Apps Show, where we talk about how to tame endless spreadsheets into productive applications. App Maker is a tool that empowers a wide range of individuals in an organization to turn important processes that live in spreadsheets. Join us and see how App Maker can help you in your everyday tasks!

Celebrating 10 years of Apps Script: looking back on how it started | Google Cloud Blog

10 years ago this week we introduced Google Apps Script, G Suite’s scripting platform. What started as a small experiment has grown into one of Google’s most popular developer products. To commemorate the moment, I sat down with Mike Harm, the creator of Apps Script, to reflect back on how it all got started.

Source: Celebrating 10 years of Apps Script: looking back on how it started | Google Cloud Blog

Subscribe to Apps Script Pulse...