AppsScriptPulse

Totally Unscripted – Wholly Sheets: Tips for building productivity solutions with Google Sheets 15 September at 1200 PDT / 1500 EDT / 2000 GMT+1

The Google Workspace developer community show, Totally Unscripted, is back this Wednesday! We’ll be broadcasting live at the usual time 1200 PDT / 1500 EDT / 2000 GMT+1 with Wednesday’s targeted as our new ‘day’.

For our return we’ll be bringing you an episode on ‘Wholly Sheets: Tips for building productivity solutions with Google Sheets’. Tune in live to ask questions or immediately watch the recording on demand.

Full show description below:

Spreadsheets are the swiss army knife of productivity tools where they are used (and sometimes misused) as databases, workflow engines, project management tools, custom calculators, and oh yeah… spreadsheets. In this episode of Totally Unscripted, we will chat with Jonathan Butler, Software Engineer at Viriya Consulting, and Spencer Farris, a Google Sheets & Apps Script Consultant, about how they are build spreadsheet solutions that range from small problem-solving automations to full blown critical applications.

Guests:

Mergo – Mail Merge for Gmail – A free lifetime subscription for Google Workspace for Education users

As teachers gear up for the new school year, we’re glad to offer a free lifetime subscription to your school, college or university. 🥳

I’m sure many of you have come across Romain Vialard who has been contributing to the Google Apps Script community since the product was in beta.

Mergo, Mail Merge for Gmail, is one of the latest products to be developed by Romain and for Google Workspace for Education users the great news is that until the 20 September 2021 there is an offer for a free lifetime subscription! Follow the source link for more details.

Source: Mergo – Mail Merge for Gmail – Back to school

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/