TU5.5: The Answer Is Always A Spreadsheet

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