AppsScriptPulse

Google Workspace Developers can now connect in the Google Cloud Communities

Welcome to the developer form for Google Workspace. … I am hoping this will become a great space for sharing developer tips and tricks amongst each other.

Google Cloud Communities is a space hosted by Google designed to allow people using Google Cloud technologies to “meet industry peers, ask questions, collaborate to find answers, and connect with Googlers who are making the products you use every day”. There is now a new Google Workspace Developers space where you can:

“Connect with other Google Workspace Developers, the Google Workspace Developer Experts (GDEs) and the Google team to share and learn from each other”

The new discussion space includes an area to highlight relevant events and will be run to supplement discussions and connections in existing forums.

Source: Google Workspace Developers 

Top tech blogger Amit Agarwal on building a global content business for over 15 years

In a conversation with YourStory, top tech blogger Amit Agarwal shares the secrets to building a global content business from Bharat.

Many of you will no doubt seen and used Amit’s Google Apps Script contributions published on labnol.org. This interview with Amit is an opportunity to hear/read more about his background and motivations.

Source: Top tech blogger Amit Agarwal on building a global content business for over 15 years

Google Apps Script: A Beginner’s Guide

With Apps Script, you can do cool stuff like automating repetitive tasks, creating documents, emailing people automatically and connecting your Google Sheets to other services you use.

This Google Apps Script introductory post from Ben Collins has been around for a while, but worth keeping in the old link locker as it summarises lots of useful information and links. Click through to the source for more details.

Source: Google Apps Script: A Beginner’s Guide

Totally Unscripted – Automation for Admins: Command line management for Google Workspace with GAM Thur 15 July at 1200 PDT / 1500 EDT / 2000 GMT+1

In this episode of Totally Unscripted we are joined by Jay Lee, creator of Google Apps Manager (GAM). GAM is an open source command line tool for Linux, MacOS and Windows which allows administrators to easily manage domain and user settings in Google Workspace. GAM is particularly useful for running bulk operations running commands in parallel from a text or .csv file. This episode will be an opportunity to find out how you can start automating your Google Workspace administration as well as some of the newer GAM features including creating a GAM powered Google Chat Bot.

Join the conversation on Thursday 15 July 2021 at 1200 PDT / 1500 EDT / 2000 GMT+1 – https://youtu.be/7lPGbScRNk8

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

Google Apps Script – What a difference 5 years make – Episode 2 [Property Service and Spreadsheet Service updates] – Desktop Liberation

Image credit: Bruce Mcpherson

Image credit: Bruce Mcpherson

How google apps script has changed over the past 5 years. Episode 2 in a series of post covers the Properties Service and the Spreadsheet service

Bruce Mcpherson continues his look at changes in Google Apps Script over the last 5 years, this time looking at PropertiesService and SpreadsheetApp . This post is worth a read just to check you’ve not missed any new methods for working with Google Sheets, because over the last 5 years there have been many!

Source: Google Apps Script – What a difference 5 years make – Episode 2 – Desktop Liberation

Google Apps Script – What a difference 5 years make – Desktop Liberation

It’s been over 5 years since my book ‘Going Gas‘ was published, and Apps Script evolution means that a number of sections of it is now pretty out of date. I don’t think I have the energy to do a rewrite – so I’m going to do a critique, chapter by chapter, of where it’s now wrong as a way to show how much Apps Script has improved (or otherewise) over the years.

We recently highlighted how you could preview excerpts from Bruce Mcpherson’s ‘Going GAS’ book. Bruce has now followed up by using the book contents from 2016 to highlight differences in the current version of Google Apps Script.

Source: Google Apps Script – What a difference 5 years make – Desktop Liberation

Going GAS – Book preview on Google Books

Image credit: O'Reilly

Whether you’re moving from Microsoft Office to Google Docs or simply want to learn how to automate Docs with Google Apps Script, this practical guide shows you by example how to work with each of the major Apps Script services.

Bruce Mcpherson the author of Going Gas has recently highlighted in the Google Apps Script Community that a chuck of his book is currently available for free in the Google Books preview (133 of the 456 pages are available). Bruce highlights that since publication in 2016 there have been a number of changes in Google Apps Script most notably the move to modern JavaScript syntax in the V8 engine, but much of the content may still be of interest.

Source: Going GAS

Totally Unscripted: Developing a market leading Google Workspace Add-on – Behind the scenes @Supermetrics Thur 10 June at 1200 PDT / 1500 EDT / 2000 GMT+1

Over half a million people, including marketers, data analysts, and data engineers, use Supermetrics to move data from popular marketing platforms (such as Facebook, Google Ads, and HubSpot) to Google Sheets, Google Data Studio and other destinations. With 10% of global online ad spend reported through Supermetrics and a growing distributed product engineering team, management and testing of their Apps Script deployments is key. In this episode of Totally Unscripted we speak to Supermetrics founder, CEO (and Apps Script developer), Mikael Thuneberg, and Supermetrics senior software developer James Elderfield to find out about Supermetrics development infrastructure and approaches to testing and monitoring.

Find out how to developing a market leading Google Workspace Add-on at 1200 PDT / 1500 EDT / 2000 GMT+1 on Thursday 10 June 2021 and tune in live to join the conversation with our guest!

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

Totally Unscripted: Developing Google Workspace workflows with AppSheet Automation Thur 27 May at 1200 PDT / 1500 EDT / 2000 GMT+1

We are back and for the next episode of Totally Unscripted revisiting Google no/low code application development platform AppSheet. We are joined by Christian Schalk (Developer Advocate, Google Cloud) to look at the new AppSheet Automation, which uses Google AI to make it easier to automate business processes.

By making it easier to automate processes, AppSheet Automation helps users reduce IT overheads and save money. Automation also includes the ability to build and embed rich AppSheet views in Gmail to perform approvals on the go.

Tune in live to find out everything a Google Workspace developer needs to know about this and other new features in AppSheet.

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

Totally Unscripted: Managing Google Apps Script applications in large enterprise environments Thur 13 May at 1200 PDT / 1500 EDT / 2000 GMT+1

Totally Unscripted is back on the 13 May at the usual time (1200 PDT / 1500 EDT / 2000 GMT+1) and in this episode we look at Managing Google Apps Script applications in large enterprise environments. In this episode we are joined by Niek Waarbroek (CTO & Partner at NextNovate) and Jasper Duizendstra (Google Cloud Architect at duizendstra.com) who will share their approaches for managing the design, development and support process for the applications they build for their customers. As part of this show Jasper will also demonstrate his fully serverless, continuous delivery pipeline based on the Cloud IDE, Cloud Source Repositories, Cloud Build, git and clasp.

You can tune in live to ask questions via https://youtu.be/N5zmeEsG2uw

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

A new approach for limiting access to a part of a Google Apps Script Web App

I’ve noticed that several Google Apps Script users are looking for a secure way to restrict access to their Web App. In my case I am looking for a way to let everyone have access to some functions of the web app, while a control panel must be reserved for the administrator (me).

I wanted to share my approach that makes use of the novelty introduced in GAS on March 15, 2021.

Interesting thread in the Google Apps Script Google Group community discussing approaches to creating Web Apps with admin interfaces. Follow the source link for more information and the full discussion.

Source: A new approach for limiting access to a part of a Google Apps Script Web App – Google Groups

Totally Unscripted: Hello Alternate Runtimes – How to build Google Workspace Add-ons without using Apps Script – Thur 22 April at at 1200 PDT / 1500 EDT / 2000 GMT+1

Last month Google announced the general availability of alternate runtimes for Google Workspace Add-ons. With alternative runtimes, developers can write Add-ons in any language and on any infrastructure, and then publish them to the Google Workspace Marketplace. In this episode we are joined by Riël Notermans, owner of Zzapps (and Google Developer Expert) and Steven Bazyl (Developer Relations, Google Cloud). Riël, whose teams have been developing on Google Workspace for over a decade, will share his team’s key takeaways on Alternate Runtimes and Steven will provide additional tips on getting started including the GWAO Card Builder.

Tune in live to ask questions via the YouTube chat https://youtu.be/zDZqENU4B6s

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

Totally Unscripted: Google Apps Script – Discover, Learn and Share Thur 15 April at at 1200 PDT / 1500 EDT / 2000 GMT+1

In this episode we are going to delve into the topic of how you discover, learn and can share Google Apps Script projects, tips and tricks. We hope we can give you some useful advice if you, friends and colleagues are just starting out coding with Apps Script, or tips if you have been coding for a while and want to improve your Apps Script knowledge. For this episode we’ve got two great guest Chanel Greco – saperis (Founder & CEO) and regular Apps Script contributor Bruce Mcpherson, who’s recent work on the visual Google Apps Script explorer tool, scrviz, is providing developers with new ways to explore and replicate existing Apps Script projects.

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

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

Totally Unscripted: Chatting with the community – Google Chat tips from GDEs Laura Taylor and Denis Valášek – Thur 08 April at at 1200 PDT / 1500 EDT / 2000 GMT+1

In this episode of Totally Unscripted we are joined by Google Developers Experts Laura Taylor and Denis Valášek to talk about Google Chat and opportunities to develop Google Chat bots and conversational interfaces with Google Dialogflow. We’ll cover everything that you need to know to get started, opportunities and pitfalls.

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/

🎂 Happy anniversary Google add-ons! 🎂 Long live MERGO the new mail merge add-on from @romain_vialard

Ain’t no party like a mail merge party and Romain Vialard knows how to celebrate!

Find and clone Apps Script projects from GitHub directly into the IDE with scrviz – Desktop Liberation

I thought it might be useful if you are learning Apps Script to be able to pull in examples to play around with. This latest release adds the ability to configure and clone projects from github directly into the Apps Script IDE.

We’ve previously highlighted Bruce Mcpherson’s visual Google Apps Script explorer tool, ‘scrviz’. If you are not familiar with this it is Bruce has figured a way to search and identify Google Apps Script projects publicly shared on GitHub. In this latest update to the tool you can now clone public Google Apps Script projects from scrviz straight into the Apps Script IDE.

The source link explains more about how you can do this:

Source: Find and clone Apps Script projects from github directly into the IDE with scrviz – Desktop Liberation

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

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/

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

Totally Unscripted: No-Code Workflow Automation in Google Workspace – Thur 11 Feb at at 1200 PST / 1500 EST / 2000 UTC

Totally Unscripted is back on Thur 11 Feb at 1200 PST / 1500 EST / 2000 UTC and in this episode we we look at no-code solutions for Google Workspace automation. As part of this we are joined by no-code and automation experts Vahid Taslimi and Aravin Srinivasan from zenphi. Zenphi is a no-code business process automation platform, designed from the ground up for Google Workspace. With Vahid and Aravin we will see how zenphi can be used to automate processes such as Mail Merge to more advanced multi-step approval processes. As part of the show we will learn how they have approached the challenge to support users in taking more ownership of their business processes.

Tune in live to contribute to the YouTube live chat (recording immediately available).

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

Totally Unscripted: Preaching to the Converted – Convert Microsoft Excel files with macros to Google Sheets – Thur 04 Feb at 0800 PST / 1100 EST / 1600 UTC

Totally Unscripted is back on 04 Feb at the slightly earlier time of 0800 PST / 1100 EST / 1600 UTC.

In this episode we are joined by some of the team at Google behind the development of the Macro Converter. The Macro Converter is an add-on that makes it easier to convert Excel files that have Visual Basic for Applications (VBA) code to Google Sheets files and Apps Script. You can use the Macro Converter add-on to determine the compatibility of your files and automatically convert them.

This show is your opportunity to learn more about Macro Converter and get your questions in to the developers. Tune in live to contribute to the YouTube live chat (recording immediately available).

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

Totally Unscripted: Getting Schooled on Apps Script – Using Automation in EDU – Thur 28 Jan at 1200 PST / 1500 EST / 2000 UTC

Totally Unscripted is back on Thur 28 Jan at 1200 PST / 1500 EST / 2000 UTC and in this episode we will explore how Google Apps Script is supporting educators around the world to become more productive and efficient. From grading quizzes to administering class rosters and everything in between, Apps Script can be used to help educators save time in the administration of teaching and learning and spend more time with their students.

For this episode we are joined by noted teacher and Apps Script creator Alice Keeler (alicekeeler.com) as well as Dave Abouav who is a Google Employee and part-time physics teacher and the creator of the popular grading tool Flubaroo. With Alice and Dave we will discover some of the opportunities for using Google Apps Script in education as an end user and developer.

Tune in live to contribute to the YouTube live chat (recording immediately available).

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

Every Google Apps Script project on Github visualized – Desktop Liberation

Visualization of apps script projects

There are so many Apps Script projects out there where the source code is published on Github, but it’s hard to find what you want. Whether it’s a library, an example of an add-on, how to use an advanced service, or just see who is working on what. I figured it would be nice if we had a searchable visualization of everything that’s public.

Source: Every Google Apps Script project on Github visualized – Desktop Liberation

Totally Unscripted: Get AMPed about Email – Thur 21 Jan at 1200 PST / 1500 EST / 2000 UTC

Totally Unscripted is back again on Thur 21 Jan at 1200 PST / 1500 EST / 2000 GMT. This time we will be joined by Jon Harmer (Product Manager, Google Workspace) and Steve Bazyl (Developer Relations, Google Cloud) who will give an overview of how you can start using AMP with your Google Workspace Gmail users and beyond.

Unfamiliar with AMP for email? This “allows senders to include AMP components inside rich engaging emails, making modern app functionality available within email. This dynamic email format provides a subset of AMPHTML components for use in email messages, that allows recipients of AMP emails to interact dynamically with content directly in the message” [ref]

Tune in live to contribute to the YouTube live chat (recording immediately available)

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

Trend of google-apps-script Tag on Stackoverflow 2021

Year vs. number of Questioners and Answerers. These all questions include the tag of "google-apps-script" in the tags

Year vs. number of Questioners and Answerers. These all questions include the tag of “google-apps-script” in the tags

Trend of google-apps-script Tag on Stackoverflow 2021

Kanshi Tanaike returns with an updated look at trends in the [ google-apps-script ] tag on Stackoverflow. A highlight from the report is the continued growth in new questioners, indicating that the Google Apps Script community is continuing to grow.

Source: Trend of google-apps-script Tag on Stackoverflow 2021

Workspace Devs Directory – a new community initiative to help Google Workspace and Apps Script developers connect

Directory | Workspace Devs

A directory of Google Workspace and Apps Script Developers.

This space is to help bridge that gap within the Google Workspace (previously, G Suite) Developers community and mostly geared towards users who work within the Apps Script ecosystem.

Sourabh Choraria has created a new initiative to help Google Workspace and Apps Script developers connect. Anyone can submit their profile to be included in the directory.

Source: Directory | Workspace Devs

Google to offer free training courses in AI, Kubernetes and multi-cloud | IT PRO

Image: © Google Cloud

The cloud giant is offering 30 days of free training and routes to certification.

Budding learners can access all of these through a set of ‘skills challenges’ which give participants greater knowledge of each subject and a chance to earn a Google skill badge to prove their competency.

Participants will have 30 days of free access to Google Cloud Labs to work their way through four skill challenges: ‘Getting Started’, ‘Data Analytics’, Hybrid and Multi-cloud’ and finally ‘Machine learning and Artificial Intelligence’.

The Data Analytics course is for more experienced participants to expand their skills into AI and machine learning with a chance to demonstrate an understanding of BigQuery. They can learn how to do everything from writing and troubleshooting SQL queries and using Apps Script, to building classification and forecasting models.

IT PRO has picked up on some free training from Google, which includes an opportunity to use your Google Apps Script knowledge in the Data Analytics course. To start the challenges you need to register by January 31, 2021, 11:59 PT.

Source: Google to offer free training courses in AI, Kubernetes and multi-cloud | IT PRO

Subscribe to Apps Script Pulse...