AppsScriptPulse

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/

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/

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/

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/

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/

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/

Totally Unscripted: A 2020 Google Apps Script recap for Google Workspace solution builders – Thur 14 Jan at 1200 PST / 1500 EST / 2000 UTC

Totally Unscripted returns and we kick off the year looking at some of the highlights and developments you may have missed in 2020 for Google Workspace solution builders. Our panel includes Olaf Hubel, Google Workspace Developer Relations Manager, and other noted experts from the community. As well as looking at Workspace highlights from 2020 we’ll look at what might be in store for 2021. Tune in live to contribute to the live chat.

Totally Unscripted: Becoming a Google Workspace Solutions Gallery contributor – Thur 17 Dec at 1200 PST / 1500 EST / 2000 UTC

In this session we will have a look at the Google Workspace Solutions Gallery. “The Google Workspace Solutions Gallery is a collection of sample solutions that demonstrates how you can solve common business challenges with Google Workspace Developer technologies. These samples showcase different ways to integrate and customize the productivity tools you’re already using.” – https://developers.google.com/gsuite/solutions

As part of the Gallery anyone can suggest new solutions and we speak Jasper Duizendstra who has contributed the Record time and activities in Calendar and Sheets solution. We speak to Jasper about his experience summitting and getting a solution published.

Totally Unscripted: New workflow solutions with Tables and Google Apps Script – Thur 10 Dec at 1200 PST / 1500 EST / 2000 UTC

In this episode we’ll be joined by Carlin Yuen Co-founder & Product Lead, Tables (Google, Area 120) and Ben Collins Educator at benlcollins.com and Google Developer Expert. The Tables beta is the latest product to emerge from Google’s Area 120. Currently Tables is only available to US customers so this show is an opportunity to have an expert tour from the co-founder/product lead Carlin Yuen. We’ll also be joined by Ben Collins who has been using Tables and he’ll be sharing some insight into how Tables can be used with Google Apps Script.

Totally Unscripted: “The State of Script” address from Google – Fri 04 Dec at 1200 PST / 1500 EST / 2000 UTC

In this episode of Totally Unscripted we are joined by Keith Einstein Product Manager for Apps Script and Charles Maxson (TU host and Developer Advocate at Google). As part of this show Keith will review the current state of Apps Script and also exclusively reveal some forthcoming soon to be released features.

The show is also an opportunity to get your Apps Script related questions in which can be emailed to [email protected] or asked live via YouTube chat.

TU Special: Using the Google Video Intelligence API to index and disambiguate films by content – 24 Nov at 0800 PST / 1000 EST / 1600 UTC

In this TU special we are joined by Bruce Mcpherson who will share work on detecting similarities and duplication between films digitally using the trained ML models in the Google Video Intelligence API. With this the video content itself can be identified, tracked, searched, visualized and compared.

Totally Unscripted: Getting hooked on AppSheet – 19 Nov at 1200 PST / 1500 EST / 2000 UTC

In this episode of Totally Unscripted we are joined by Praveen Seshadri co-founder of AppSheet, the no-code mobile-application-building platform recently acquired by Google. Joining Praveen will be Christian Schalk, Developer Advocate at Google and long time advocate of entry level application development tools. In this session we will discuss the AppSheet philosophy and how the platform can be used to help deliver Google Workspace based solutions.

If you have any questions for this episode they can be emailed to [email protected] or tweeted @AppsScriptInfo

Totally Unscripted: Getting Started with Google Workspace Add-ons Development – 12 Nov at 1200 PST / 1500 EST / 2000 UTC

Thursday, 12 November 2020 at 1200 PST / 1500 EST / 2000 UTC

Guests – Mike Rhemtulla (Product Manager, Google Workspace), Steven Bazyl (Developer Relations, Google Cloud) and Steve Webster (SW gApps LLC, President)

In this episode we are joined by Mike Rhemtulla and Steven Bazyl exploring Google Workspace Add-on development. As part of this with Mike will share the impact and opportunity of being of contributing to the Google Workspace Marketplace, while Steven will share tips on building Add-ons. Finally, Steve will share tips on migrating existing HTMLService based Add-ons to the new Card Service

Use the YouTube comments to share any Marketplace and Workspace Add-on questions before the show or email them to [email protected]

‘Totally Unscripted’ the Google Workspace and Apps Script developer show is back!

Totally Unscripted is a Google Workspace and Apps Script developer show organized by the community for the community. We invite members of the community to share their Google Workspace developer tips, tricks and triumphs.

Totally Unscripted the Google Workspace and Apps Script developer community show returns! The shows are an opportunity to learn about the very latest Google Workspace and Apps Script updates from both the community and Google. We are returning with a series of six weekly shows starting with ‘Meet the new Google Workspace Developers Experts‘ on 05 November 2020 at 20:00 UTC (TZ conversion).

In this show you have an opportunity to meet some of the new Google Developers Experts (GDE) in Google Apps Script. As well as finding out how our experts got involved in Apps Script, we find out why they think it is different to other platforms, their favourite killer app and why you should learn Apps Script. The show is also an opportunity to find out if you’ve got what it takes to become our next newest GDEs. For this episode we are joined by:

Below is a calendar with a summary of the other show dates and topics:

Source: Totally Unscripted

Subscribe to Apps Script Pulse...