Totally Unscripted

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

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

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

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

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

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

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

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

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

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

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

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.

SADA is a Google Cloud Premier Partner that focuses on Google Cloud consulting, migration and deployment, custom development, user adoption, and change management services. As an industry leader in helping organizations implement Google Workspace, SADA has developed a practice area that builds custom solutions as unique as their customers. In this episode of Totally Unscripted, we will hear from Kelly Wright, Director of Google Workspace, and Kevin Tuuri, Engineering Pod Lead, about how they help customers get more out of Google Workspace by customizing they way they use it.

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.

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.

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.

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.

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

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

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