To wrap up the first half of season 5, the Totally Unscripted crew will 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’ll 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!
In this TU Special, we dive into the exciting new features coming to Google AppSheet and take a first look at the new Google Forms integration. For this special our co-host, Martin Hawksey is joined by Steve Franks (Head of Workspace Engineering, CTS Appsbroker). The discussion/demo was originally presented as an internal tech talk conducted at CTS Appsbroker – warning the episode contains some ‘passionate’ language.
Initial key takeaways which we discuss are:
Seamless Data Collection: Google Forms now acts as a first-class data source for AppSheet, eliminating the need for workarounds and additional add-ons. Data collected through forms automatically flows into AppSheet, creating a smooth and efficient workflow.
External Participation: The integration allows external parties to interact with your apps by simply filling out a Google Form. This opens up new possibilities for data collection and process involvement.
Powerful Automations: AppSheet’s automation capabilities can be triggered by form submissions, enabling you to create sophisticated workflows. The example discussed involves sending an email with an embedded AppSheet view upon form completion, allowing for approvals or further actions within the email itself.
Simplified Development: The integration makes building apps even easier, especially for those already familiar with Google Forms. The need for complex configurations or AppScripts is minimized, empowering users to focus on the business logic and desired outcomes.
Versatility: AppSheet has increased functionality, opening up a wider range of possibilities for app development and automation for Google Workspace customers. It can be used to create full-fledged apps with user interfaces or simply act as a behind-the-scenes automation engine.
Overall, the integration of Google Forms and AppSheet should significantly help empower users to build powerful solutions without coding expertise. Read more about “Build AppSheet automations using Google Forms” on the Google Workspace Updates blog.
AI is changing everything and AppSheet is no exception! In this episode, we will welcome Engineering Lead Mike Procopio from the Google AppSheet team to hear how AI is driving innovation, enabling assisted app development, automated insights, smart workflows, and more! So whether you are no-code, low-code or “what’s code?”, join us to find out what the future holds for AppSheet for building powerful, intelligent apps with Google Workspace
In the next episode of Totally Unscripted*, 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.
You can join the live stream on YouTube and ask your own questions for Mike during the session. If you miss the live event, you can always watch the recording on the same link:https://www.youtube.com/watch?v=N3Rl7DTekMM
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.
Totally Unscripted* returns live on 03 April, 2024 at 1200 PDT / 1500 EDT / 1900UTC / 2000 BST!
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.
Join this exclusive session with Comeen’s CTO, Simon Cleriot, to discover the potential of Google Workspace APIs. He’ll share insights into Comeen’s philosophy toward API integrations and how they build solutions that transform the hybrid workplace.
Totally Unscripted* returns live on 20 March 2024 at 1200 PST / 1500 EST and because of the crazy daylight saving time in the United States will be for many non-US viewers the earlier time of 1900 UTC/GMT.
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’ and regular contributor to AppScriptPulse.
Phil 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 also 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.
So if you are asking yourself how can you supercharge your productivity with Google Apps Script? Then this episode of Totally Unscripted is hopefully for you!
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! Joining us live is 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 will talk and answer your questions 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!
As always the show is broadcast live and you can ask questions via the YouTube chat, but also feel free to get your questions in early using the comments.
Totally Unscripted returns on 21 February 2024 at at 1200 PT / 1500 ET / 2000 GMT with an episode exploring how you can unleash the power of intelligent assistants and apps in Google Chat.
Say goodbye to simple chatbots and hello to intelligent assistants and apps! On 21 February 2024 at at 1200 PT / 1500 ET / 2000 GMT on 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 will be exploring 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.
As always the show is broadcast live and you can ask questions via the YouTube chat, but also interested to hear in advance any of your burning questions for our panel using the comments section below.
Totally Unscripted is back on 07 February 2024, 2024 at 1200 PT / 1500 ET / 2000 GMT. 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 this episode we will be joined by some of the Google team behind Smart Chips with guests Allison Hodsdon (Technical Writer at Google) and Pierrick Voulet (Developer Relations Engineer (Google Workspace) at Google.
As always the show is broadcast live and you can ask questions via the YouTube chat, but also interested to hear in advance any of your burning questions for our panel using the comments section below.
For the next live broadcast of Totally Unscripted we will be exploring 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!
In this episode we will be joined by a panel of expert 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).
As always the show is broadcast live and you can ask questions via the YouTube chat, but also interested to hear in advance any of your burning questions for our panel using the comments section below.
We will be LIVE on 24 January, 2024 at 1200 PT / 1500 ET / 2000 GMT
