AppsScriptPulse

Deploy easily with the new Google Apps Script IDE

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

Source: Deploy easily with the new Google Apps Script IDE

Google Apps Script deployment with Cloud Build

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

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

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

Check Twilio Balance using Google Apps Script

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.

Source: Check Twilio Balance using Apps Script

Content generation with Google Workspace Add-ons

Google Workspace Add-ons

Image credit: Google

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…

Source: Content generation with Google Workspace Add-ons

Send Charts In Email Using Google Apps Script

… 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).

Source: Send Charts In Email Using Google Apps Script

Create PDF from a Google Form submission using Google Apps Script

In this blog post , we will cover how to create a PDF from the responses of Google Form using Google Apps Script.

If you are looking for some guidance on creating and sending PDF Documents from Google Form responses this post has all you need to get started.

Source: Create PDF Using GoogleApps Script

Google Apps Script: Air Quality Index Slack bot

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.

Source: Google Apps Script: AQI Slack bot

Develop My First Gmail Add-on via Google Apps Script: My Software Engineer Internship at dialoggBox

I’m a teacher-turned-developer actively searching my first software engineer job during the pandemic after graduating from Hackbright Academy. As a bootcamp new grad, I am lucky to get an internship opportunity to develop a gmail add-on product at dialoggBox to gain my first industry experience and learn how to work with stakeholders.

My article will be composed of three parts:

  • What service do dialoggBox and this gmail add-on provide?
  • What was my experience using Google Apps Script to build an add-on product?
  • How did I develop each section of the gmail add-on?

The actual details of the add-on developed by the author, Nancy Dai, are promised in a follow-up post but this post serves as a useful insight into the main things to look out for when developing Gmail Add-ons.

Bonus: Following the link to the dialoggBox website I spotted they were using icons from freepik.com which also took me their sister site flaticon.com, which in turn took me to their ‘Icons for Slides and Docs’ add-on.

Source: Develop My First Gmail Add-on via Google Apps Script: My Software Engineer Internship at dialoggBox

Use the Google Cloud Identity API for Google Groups with some Google Apps Script helper functions

Use the new Google Cloud Identity API to manage your Google Groups on your G Suite domain. Find in this article some REST and Apps Script code to query the Cloud Identity API.

Stéphane Giron summaries some helpful Google Apps Script code for interacting with the Google Cloud Identity API via REST. In this post you’ll find functions for listing both Google Groups in your domain and the members of each of those groups.

Source: Use the Google Cloud Identity API for Google Groups

Automatically backup Google Apps Script projects using Github Actions

Image: Copyright 2020 RavSam

Google Apps Scripts are amazing. Without setting any servers, we can do a lot of things like collecting form responses, email marketing campaigns, etc. But as a developer, we like our code to be on Version Control System like Github. In this blog, we will discuss how can you setup Github Actions to automatically backup your Google Apps Scripts to Github.

For Google Apps Script developers who use clasp this is a great post on how you can setup Github Actions as part of your dev flow. Click through to the source for all the details.

Source: Backup Google Apps Scripts using Github Actions

Send Tweets from Google Sheets using a Google Apps Script

In this post, you will learn how to send automated tweets from Google Sheets to Twitter using Google Apps Script.

This post includes everything you need to get started sending tweets for Google Sheets. This tutorial uses the community contributed Twitterlib library from Bradley Momberger, which has some implemented methods for sending and fetching tweets.

Source: Send Tweets from Google Sheets using a Google Apps Script

Control responses in Google Forms in 4 lines of Google Apps Script

If you are using Google Forms to handle sign-ups for an upcoming event, and you want to control the number of responses (Limit responses), guess what! you can do it using Google apps script (only in 4 Lines of Code)

Nice little snippet highlighted by Aya Sayed, click through to the source for the code snippet.

Source: Control responses in Google Forms! | by Aya Sayed | Jul, 2020 | Medium

Sync RingCentral Call Log into Google Sheets with Google Apps Script | by Embbnux Ji | RingCentral Developers | Medium

In this article, I would like to show you to how to create a Google Sheets add-on to help people sync RingCentral call log into spreadsheets.

Nice post highlighting how you can integrate the RingCentral service into a Sheets Add-on. The post includes more general information about setting up access to the RingCentral API which might be useful in your other projects.

Source: Sync RingCentral Call Log into Google Sheets with Google Apps Script | by Embbnux Ji | RingCentral Developers | Medium

Google Apps Script – Stack Overflow growth trends and predictions

Stack Overflow in 2023: Predicting with ARIMA and BigQuery – Can you predict the top Stack Overflow tags of 2023? BigQuery makes this easy, with its new support for training time-series analysis models with ARIMA.

Felipe Hoffa has prepared an interesting post looking at current Stack Overflow tag usage and future trends. You can read more details about the trends for the big hitters like Python and JavaScript in the source blogpost. Felipe’s post also gives you the opportunity for a little ‘exploratory analyses’ as he has also provided a link for you to play with an interactive dashboard on Data Studio.

Felipe mentioned in a tweet that  the prediction was Google Apps Script was to continue to grow:

Given this I decided to have a look at the google-apps-script tag and a couple around it in the Data Studio dashboard and came up with this:

Stack Overflow tag trends: Historic + predictions

Stack Overflow tag trends: Historic + predictions
By @felipehoffa
Read more: bit.ly/arima_so

So Google Apps Script, continuing to grow, currently more viewed than Google Cloud Platform and on a par with FFmpeg ;)

Source: Stack Overflow in 2023: Predicting with ARIMA and BigQuery

Subscribe to Apps Script Pulse...