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

Season 3

TU3.14: Google Apps Script - Discover, Learn and Share

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

TU3.16: Managing Google Apps Script applications in large enterprise environments

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.

TU3.17: Developing Google Workspace workflows with AppSheet Automation

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

TU 3.18: Developing a market leading Google Workspace Add-on - Behind the scenes at Supermetrics

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

TU3.19: Automation for Admins: Command line management for Google Workspace with GAM

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.

For show links: https://tu.appsscript.info/previous-episodes/season-4/tu4-1

Season 4

TU4.1: Wholly Sheets: Tips for building productivity solutions with Google Sheets

Document AI uses machine learning on a scalable cloud-based platform to help your organization efficiently scan, analyze, and understand documents. Manually inputting invoices, receipts, and expenses can be time-consuming, but it doesn’t have to be. The Procurement Document AI is a tool that allows you to digitize unstructured content into structured data. This is just one of the many scenarios where Document AI can be used to develop smart workflows. In this episode of Totally Unscripted we are joined by Anu Srivastava, Applied AI Engineer, Google Cloud, who will show how Document AI can be used to automate a range of workflows.

For show links: https://tu.appsscript.info/previous-episodes/season-4/tu4-2

TU4.2: Automating your workflows with Document AI

If you have had to electronically sign a document before you are likely to be one of the 200+ million users who have used DocuSign. DocuSign provides a suite of services to support the entire contract lifecycle from eSignature to automation to analysis. Whilst DocuSign has its own full range of services and integrations DocuSign developers and partners build the customized and integrated experiences that account for roughly 60% of all of DocuSign’s transactions. In this episode of Totally Unscripted we are joined by Jeremy Glassenberg, Lead Product Manager and Nima Poulad, Senior Software Engineer both at DocuSign. Jermey and Nima will provide an overview of DocuSign APIs and opportunities to integrate with Google Workspace.

Show notes and resources https://tu.appsscript.info/previous-episodes/season-4/tu4-3

Show contents:
04:30 Overview of DocuSign service 
09:15 Overview of DocuSign Developer APIs 
14:33 Development and release of a DocuSign Google Apps Script client library
21:40 Support available to developers using DocuSign APIs
27:10 Discussion around the customer ecosystem
47:40 Views on Google Workspace and future development for Google Apps Script

TU4.3: Create your approvals hub by bringing DocuSign into Google Workspace

Imagine trying to be a successful developer without good documentation? Yet as developers, we often don’t admit how lost we would be without it. Truth is, creating and maintaining developer documentation is an art; Developers demand content that is concise, but thorough; simple to find and up to date, while covering every obscure feature ever released. If developing a solution is a journey for developers, it’s technical writers who are the unsung heroes who guide us to success with their thoughtful art. In this episode of Totally Unscripted, Kara Ireland and Nathan Gammie will join us from the Google Workspace Developers documentation team, who will give a glimpse into how their team creates the content that keeps Workspace developers on a journey to success.

TU4.4: Never lost for Words - The art of building Google Workspace Developer Documentation

Google Workspace offers developers REST APIs to interact programmatically with nearly every product and feature within the suite. In this episode of Totally Unscripted, we are going to take a first look at a BRAND NEW Google Forms API for Workspace which was recently announced  at Google Cloud Next 2021. We were delighted to have Christian Schalk (Developer Advocate, Google) and Hannah Pho (Software Engineer, Google) as well as early Forms API partners Charles Kemp (Strategic Alliances Manager, Zapier) and Charles Wiles (CEO, Zzish), talk about the new Forms API and how to get started.

TU4.5: Introducing the new Google Workspace Forms API!

In this episode of Totally Unscripted, we will catch up with Eric Koleda who has been a well known fixture to Google Workspace Developers for the better part of a decade. Now that his legendary career as a Google Workspace Developer Relations Engineer has come to a close, we will reminisce with Eric about the impact of Apps Script and how Workspace development has evolved.  We will also take a look at the future and get some insights about his new role and the breakthrough technology at Coda, where he’s begun his new life after Apps Script.

TU4.6: Life After Apps Script - A chat with Eric Koleda, Developer Advocate @ Coda

The AppsScriptPulse website (https://pulse.appsscript.info) was launched in 2019, providing a curated collection of the latest Google Apps Script contributions from both Google, but focusing on community contributions.  The site now has over 600 solutions, snippets, tutorials and resources updated almost daily. In this episode of Totally Unscripted we are joined by Romain Vialard, Phil Bainbridge and Scott ‘Yagi’ Donald who have individually provided the top 3 Pulse contributions for 2021. We will discuss the solutions they have created which range from offline Apps Script development with VS Code/clasp to document automation to creating games in Google Slides.

TU4.7: The Pulse of the Google Apps Script Community

Chat bots (aka Chat Apps) offer developers a framework for building solutions within conversations and direct messages inside of Google Chat. As Google Chat has become a more integral part of Google Workspace, Chat Apps have evolved to offer developers new capabilities which in turn creates opportunities for richer interactions, integrations and workflows. In this episode, we will discuss “What’s new in the world of Chat Apps” with Aidha Shaikh, Product Manager on the Google Workspace Platform team, who leads the Chat App strategy at Google.

TU4.9: What's new in the world of Chat Apps?

The Google Workspace Marketplace offers users and administrators alike a wide variety of third party solutions that extend Google Workspace. Creating a successful add-on for the Marketplace takes more than a bit of luck to stand out from the crowd. In this episode we will chat with two purveyors of well-known add-ons Romain Vialard, Founder of Scriptit & John McGowan, CEO of Unicorn Magic, to hear what it takes to create a thriving business in the world of Workspace Add-ons. Also joining us will be Elena Kingbo, Program Manager on the Google Workspace Platform team, who helps guide developers through their Add-on journey.

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

TU4.10: Building successful Add-ons for Google Workspace

WE ARE BACK!!! Totally Unscripted returns for more Google Workspace Developer community chat about new features, popular solution trends, best practices, the Google Workspace Marketplace and everything else related to Google Workspace development.  In this episode we take a look back at some of the more significant updates and additions involving the Google Workspace Platform "Since they've been gone!"

For show resources visit https://tu.appsscript.info/previous-episodes/season-5/tu5-1

TU5.1 - Since We Ve Been Gone  A Recap

Google Workspace provides developers and partners a platform to build world class solutions. In this episode we will show how Vertex AI and other GenAI solutions can be used to extend the capabilities of Google Workspace with targeted solutions that integrate seamlessly with Google Workspace Add-ons, Editor Add-ons, Chat apps, Drive apps, and more! 

For this episode we will be joined by guests:  Donato Meli (Workspace Go-To-Market at Google), Mohammad Al-Ansari (Developer Advocate (Partnerships) at  Google), and Allen Firstenberg (Project Guru at Objective Consulting, Inc)

For show links and resources visit https://tu.appsscript.info/previous-episodes/season-5/tu5-2

TU5.2 - How developers are shaping the future with Google Workspace and GenAI

There have been a number of saucy updates and announcements around Smart Chips and other integrations to Google Docs, as well as Sheets and Slides. In this episode we review how you can start to create Google Workspace Add-ons for Google Docs, Sheets, and Slides users which let you preview links from your third-party services. In addition we will be dipping into how you can let users of Google Docs add third-party resources from the @ menu.

For shows links and resources visit https://tu.appsscript.info/previous-episodes/season-5/tu5-3

TU5.3 - Google Workspace Development: Now with a Side of Smart Chips!

Say goodbye to simple chatbots and hello to intelligent assistants and apps! In this episode of Totally Unscripted, we dive into the world of building advanced enterprise apps and assistants using interactive dialogs and Vertex AI in Google Chat. 

As part of this, we explored how you can harness the capabilities of the Google Chat platform to promote collaborative work within Chat spaces, taking advantage of Google's advanced machine learning models to create assistants that can help with complex tasks, such as summarizing conversations and generating complete task descriptions from simple titles. 

Get ready to go beyond the basics and learn how to build sophisticated assistants that help you get more work done, collaborate with your team, and revolutionize the way you work with Google Chat and Google Workspace.

For show notes and resources visit: https://tu.appsscript.info/previous-episodes/season-5/tu5-4

TU5.4 - Beyond Basic Bots  Building Intelligent Assistants With Google Chat And Vertex AI

Whether you are managing projects, calculating budgets, forecasting sales, or just tracking your own to-do lists, there is almost always a spreadsheet involved.  

In this episode of Totally Unscripted, we get back to basics and discuss the versatility and pure power (and joy) of spreadsheets! We are joined by guest Ben Collins, who is a renowned spreadsheet educator, Google Developer Expert and Google Sheets master, and someone who has earned the honorary title of "King of Functions". 

Ben talks about trends, best practices, and of course demonstrate a few of his favourite functions that will confirm that "The Answer is Always a Spreadsheet" still rings true!

For show links and resources visit https://tu.appsscript.info/previous-episodes/season-5/tu5-5

TU5.5: The Answer Is Always A Spreadsheet

Are you looking for ways to supercharge your productivity with Google Apps Script? Then this episode of Totally Unscripted is for you!

Join us as we explore how Google Apps Script is being used to make a real impact in productivity. Our guest speaker, Phil Bainbridge, is an experienced IT specialist at the University of York and author of 'The Gift of Script.' He will share his insights on how Google Apps Script can be used to automate tasks, create custom solutions, and enhance your workflow. As part of this episode we will discover how Phil and other members of York’s Digital Inclusion, Skills & Creativity team support digital literacy development in Google Workspace and Apps Script as well as the solutions they have created to improve productivity.

For show links and resources visit https://tu.appsscript.info/previous-episodes/season-5/tu5-6

TU5.6: Level Up Your Productivity: Unboxing the Gift of Apps Script

The shift to hybrid work models presents unique challenges for businesses.  How do you create a seamless, productive experience for employees in this new environment? These challenges also create opportunities for third parties like Comeen to develop solutions that surface new functionality for Google Workspace customers with deep integrations into services like Google Meet and Google Chat,as well as other platforms like Slack. 

In this episode with Comeen's CTO, Simon Cleriot, we explore the potential of Google Workspace APIs. Simon shares insights into Comeen's philosophy toward API integrations and how they build solutions that transform the hybrid workplace. 

For show resources and links visit https://tu.appsscript.info/previous-episodes/season-5/tu5-7

TU5.7 - API Mastery in Action: Creating powerful Google Workspace 3P solutions with guest Comeen

Join the TU team as we delve into the world of custom generative AI solutions for Google Workspace using Apps Script. Discover how developers are seamlessly integrating Gemini's large language models to revolutionize productivity and automation. We'll explore real-world examples demonstrating how AI can supercharge your Workspace experience. Imagine having Gemini as your Apps Script coding assistant, intelligently naming untitled documents, crafting next-generation mail merges, and so much more. 

Get ready to learn, be inspired, and unlock the full potential of intelligent automation within Google Workspace.

For show notes and resources visit: https://tu.appsscript.info/previous-episodes/season-5/tu5-8

TU5.8 - Apps Script and Gemini Next '24 Redux: Build custom AI-powered Google Workspace solutions

In this episode, we will welcome Engineering Lead Mike Procopio from the Google AppSheet team. Mike has in-depth knowledge of Google Workspace, you can thank Mike for simpler file upload in Google Drive launched in 2011.

As part of the session we will be asking Mike about implementing lightweight governance strategies using AppSheet policies, ensuring security and control while enabling creativity and fostering a thriving citizen development culture.
We’ll also take a look at some of the new features that are coming soon to AppSheet, including a new admin console which will be available to Core and Enterprise customers for monitoring app usage, manage user roles, and refine governance policies, as well as AppSheet’s new Google Forms integration which will soon be in public preview.

Finally, and not least, we will explore how you can harness the power of AI in AppSheet, looking at the latest AI features, including AI-assisted app creation and the “extract” capability with Gemini, to streamline development and enhance functionality.

For episode resources visit: https://tu.appsscript.info/previous-episodes/season-5/tu5-9

TU5.9 - What's new in the AppSheet world? A chat with AppSheet Engineering Lead Mike Procopio

To wrap up the first half of season 5, the Totally Unscripted crew go back to basics and talk about the perhaps the best-kept secret in the Google Workspace universe, and that’s of course Google Apps Script! While many of our regular viewers surely know how powerful Apps Script can be, we wanted to ask the rest of the Workspace world “Why aren’t you Apps Scripting?!?”

Join us for a fun and whimsical exploration of Google Apps Script, where we uncover why Apps Script is the ultimate productivity sidekick, ready to rescue you from repetitive chores and unleash your creative superpowers. No coding experience? No problem! We'll break it down in a way that's easy to understand, even if you're a tech newbie.

It's time to unlock the full potential of Google Workspace and join the Apps Script revolution. Let's spread the word and empower everyone to automate their way to a more productive and joyful work life!

For show link and resources visit https://tu.appsscript.info/previous-episodes/season-5/tu5-10

TU5.10 - Stop clicking, start Apps Scripting; The case for automating Google Workspace for EVERYONE!

Totally Unscripted is back! We begin our reboot with an opportunity to meet some of the new Google Developers Experts (GDE) in Google Apps Script. The show is also an opportunity to find out if you've got what it takes to become our next newest GDEs.

TU3.1: TU Returns! Meet the new Google Workspace Developers Experts

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 comments to share any Marketplace and Workspace Add-on questions before the show or email  them to tu@appsscript.info

How-to convert Editor add-on to Google Workspace add-on slide deck:
https://docs.google.com/presentation/d/1Fw7P7CMoN3VqU2lWpn3L8ZwBVvnSt4B7UgxgCA3DgSw/edit?usp=sharing

Unofficial and experimental Card Builder tool: https://gsao-card-builder.web.app/

TU3.2: Getting Started with Google Workspace Add-ons Development

Guests: Praveen Seshadri, Distinguished Software Engineer, Google
Christian Schalk, Developer Advocate, Google Cloud

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. 

For additional show links and resources including Q&A doc visit https://tu.appsscript.info/previous-episodes/season-3/tu3-3

TU3.3: Getting hooked on AppSheet

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.

For additional resources visit https://tu.appsscript.info/previous-episodes/specials/tu-special-using-the-google-video-intelligence-api

TU Special: Using the Google Video Intelligence API to index and disambiguate films by content

Guests:  Romain Vailard, Scott 'Yagi' Donald and Olaf Hubel

We kick off the year on Totally Unscripted looking at some of the highlights and developments for Google Workspace solution builders you may have missed in 2020. 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.

For more show details visit https://tu.appsscript.info/previous-episodes/season-3/tu3-7

TU3.7: A 2020 Google Apps Script recap for Google Workspace solution builders

AMP for Email enables developers to deliver rich, interactive, app like functionality in emails. In this episode of Totally Unscripted we are joined by Jon Harmer (Product Manager, Google Workspace) and Steven Bazyl (Developer Relations, Google Cloud) who give use an overview of the opportunities when adding AMP for Email and how you can start using it with your Google Workspace Gmail users and beyond.

For more show resources/links visit: https://tu.appsscript.info/previous-episodes/season-3/tu3-8

TU3.8: Get AMPed about Email

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

TU3.11: No-Code Workflow Automation in Google Workspace

Totally Unscripted is a Google Workspace 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

Popular tracks