Totally Unscripted

In this episode 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.

For show notes and resources visit https://tu.appsscript.info/previous-episodes/season-3/tu3-19

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

For additional information/resources visit https://tu.appsscript.info/previous-episodes/season-3/tu3-17

In this episode of Totally Unscripted we are joined by Christian Schalk (Developer Advocate, Google Cloud) to look at 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. In this episode find out everything a Google Workspace developer needs to know about this and other new features in AppSheet.

Managing applications in large enterprise environments has its own dynamics. In this episode of Totally Unscripted Niek Waarbroek (CTO & Partner at NextNovate) and Jasper Duizendstra (Google Cloud Architect at duizendstra.com) share their approaches to managing the design, development and support process for the applications they build for their customers

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, shares his team’s key takeaways on Alternate Runtimes and Steven will provide additional tips on getting started including the GWAO Card Builder.

For additional resources and links visit: https://tu.appsscript.info/previous-episodes/season-3/tu3-15

In this episode of Totally Unscripted we explore some of the ways you can extended your own knowledge in Google Apps Script as well as supporting others. We are joined by Chanel Greco (saperis, Founder & CEO) who has quickly established a reputation for producing informative and inspiring Google Workspace and Apps Script tutorial videos. We are also rejoined by Going GAS author 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.

For additional resources and links visit: https://tu.appsscript.info/previous-episodes/season-3/tu3-14

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. This episode will be broadcast live and you can join the conversation in the YouTube Live chat.

For additional content/resources visit: https://tu.appsscript.info/previous-episodes/season-3/tu3-13

For source code and other resources visit https://tu.appsscript.info/previous-episodes/season-3/tu3-12

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 shares how Amplified IT have adopted Angular for their Add-on development. As part of this we explore the benefits using Angular including a component-based architecture, internationalization and performance.

In this episode of Totally Unscripted we look at no-code solutions for Google Workspace automation. 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 see how zenphi can be used to automate processes from basic mail merge to more complicated approval workflows, all utilizing zenphi’s no-code drag and drop flow generator. We also learn how they have approached the challenge to support users in taking more ownership of their business processes and considerations for other Workspace developers.

For show notes and resources visit: https://tu.appsscript.info/previous-episodes/season-3/tu3-11

In this episode we discuss the Macro Converter Add-on, a tool developed by Google to support Enterprise users with the conversion of MS Excel files with Visual Basic for Applications (VBA) code to Google Sheets/Apps Script. For the episode we are joined by Apps Script PM, Keith Einstein, and Arijit De who is one of the Google Software Engineers behind the development of the Macro Converter. We are also joined by Bruce Mcpherson author of ‘Going GAS: From VBA to Google Apps Script’, who provides tips and insights on VBA to Apps Script migration.

For links and resources visit https://tu.appsscript.info/previous-episodes/season-3/tu3-10