AppsScriptPulse

Solutions, Advanced

Google Apps Script deployment with Cloud Build

Tags:
| | 0 Comments |

Photo by David Gilbertson on Unsplash

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.

Source: Google Apps Script deployment with Cloud Build

New IDE, Advanced, Beginner, Intermediate

16 secrets tips, tricks and features for new Google Apps Script Editor (v2020)

Tags:
| | 0 Comments |

Google Apps Script has a new editor, which is better, nicer, and completed ready for future new features. Today, I would like to introduce you to several dirty and secret tricks, what you can do.

If you like a keyboard shortcut you’ll love this post from Ivan Kutil! For those less keen on keyboard commands there is still plenty of other productivity tips from Ivan shared in this post.

Source: 16 secrets tips, tricks and features for new Google Apps Script Editor (v2020)

New IDE, Official News, Advanced, Beginner, Intermediate

Get ready to up your Apps Script! – Google Developers Blog

Tags:
| | 0 Comments |

The new Apps Script IDE features the same rich integration with Google Workspace as it did before, allowing you to get started building solutions without having to install or configure anything. If you are working on a standalone script project application, you can use the Apps Script Dashboard to launch your project directly, or if you are working on a container bound project in Sheets, Slides or Docs, you can do so from selecting Tools > Script editor from their top menus.

Charles Maxson, Developer Advocate Google Cloud, has highlighted some features Google Apps Script developers new and old should keep an eye out for. I think one of the big ones for experienced Apps Script developers who work mostly in the online editor is going to be the context menu options and the Command Palette. Find out more in the source post.

Source: Get ready to up your Apps Script! – Google Developers Blog

New IDE, Advanced, Beginner, Intermediate

How to get the most out of the new Google Apps Script debugger and logging

Tags:
| | 0 Comments |

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.

Source: How to get the most out of the new Google Apps Script debugger & logging

New IDE, Advanced, Beginner, Intermediate

Guide To The New Google Apps Script IDE Covering 135 Features

Tags:
| | 0 Comments |

Explore the fantastic new Google Apps Script IDE and see features that will make your life easier, whether you’re a beginner or pro developer.

Ben Collins can never be accused of slacking off and this post is the perfect example. As announced on Totally Unscripted the new Apps Script IDE is rolling out and Ben lists 135 features for developers to look out for. View the source post for these features plus a video of Ben highlighting his favorites.

Source: Guide To The New Google Apps Script IDE Covering 135 Features

Solutions, Sheets, Web App, V8, Advanced

Creating an embedded interactive Chain Story app with Google Apps Script and Google Sheets – Yagisanatode

Tags:
| | 0 Comments |

In this tutorial, we are going to create an interactive story chain app that we can embed into a Google Site or your own site like WordPress.

Yagi uses a simple but very effective interactive story chain app to explore and explain some very powerful Apps Script functionality all developers should know about. This includes using the LockService which can be used to prevent concurrent access to sections of code. Yagi also highlights some recent discussions around the limitations of Web Apps and concurrent users. Click through to the source for all this and more.

Source: Creating an embedded interactive Chain Story app with Google Apps Script and Google Sheets – Yagisanatode

Solutions, Sheets, V8, Advanced

Creating Unique Ranges from 2D Arrays in Google Apps Script – Yagisanatode

Tags:
| | 0 Comments |

If you have ever done any work in Google Sheets you might have come across the incredibly useful UNIQUE function. This function can take a single row or multiple rows and generate a list of unique cell values.

Sometime you might have a use case where you need to replicate the UNIQUE functionality in Google Apps Script. … Whatever the case, knowing how to to create a unique array from a 1-dimensional array or a 2-dimensional array is an important part of your toolkit as a coding goat 🐐.

This tutorial will look at how to create this with modern Javascript that is incorporated into the Google Apps Script language.

Source: Creating Unique Ranges from 2D Arrays in Google Apps Script – Yagisanatode

Solutions, Tables, Advanced

Sentiment Analysis For Google Tables Using Goole Apps Script – Ben Collins

Tags:
| | 0 Comments |

Learn how to use Google Cloud’s Natural Language API to do sentiment analysis on tickets submitted to a Google Tables Support Issue Tracker. We’ll use Google Tables as the platform for our Support Tracker and Apps Script to connect to the Cloud Natural Language API.

Great example from Ben Collins building on the work of Alicia Williams which shows how you can interact with your Google Tables with Google Apps Script. As part of this solution Ben uses the new Tables Service, which is the latest Advanced Service to hit Google Apps Script, connecting to the Google Cloud Natural Language API. Click through to the source for all the details you need to get started.

Note: Google Tables beta is currently only available in the U.S.

Source: Sentiment Analysis For Google Tables Using Apps Script –