Key Moments:

Common Apps Script Uses & Challenges (01:19)

We discuss common themes and challenges faced by Apps Script developers, including the frequent need for spreadsheet automation and connecting to external APIs.

Introducing Phil Banbridge and his Apps Script Journey (04:43)

We meet guest Phil Banbridge, an IT specialist and Apps Script expert from the University of York. Phil shares his background, his passion for Apps Script, and how he uses it to develop automation solutions for the university.

Measuring Time Saved with Apps Script (16:08)

Phil showcases his dashboard that tracks the time saved through his Apps Script solutions. He explains his methodology for measuring and reporting time saved, demonstrating the significant impact of his work.

Building & Sharing Apps Script Solutions (19:52)

Phil discusses his process for evaluating project proposals and ensuring their effectiveness. He emphasizes the importance of open communication and collaboration with stakeholders. He also shares his strategies for training users and making his solutions self-sufficient.

Apps Script Community & Future Trends (26:12)

Phil highlights the importance of community in learning and troubleshooting Apps Script. He discusses the University of York's internal Apps Script community and resources like AppsScriptPulse. He also shares his thoughts on emerging trends and his own future goals in the Apps Script world.

Challenges with AppScript Add-ons (35:31)

We find out about the challenges Phil faces when developing and deploying Google Workspace add-ons. Phil shares some of his experiences when it comes to navigating the Google Cloud Platform and Google Workspace Marketplace. 

Broadcast Date: 20 March 2024

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.

Episode Links

• Phil Bainbridge: The Gift of Script

• DISC : Digital Inclusion, Skills & Creativity - University of York

• Google Apps Script Subject Guide - University of York

Google Next

• Google Cloud Next ‘24 Apr. 9-11, 2024 Las Vegas

• Apps Script and Gemini: Build custom AI-powered Google Workspace solutions (Charles, Kara & Martin)

• Duet Your Data (Alice)