Learn Google Workspace & Apps Script

Here you will find a comprehensive resource hub for mastering Google Workspace and Google Apps Script! Whether you’re new to Google Workspace or intrigued by Apps Script’s automation potential, you’re in the right place.

Explore tutorials on Google Drive, Docs, Forms, Meet, Sheets, Slides, Sites and Apps Script. From basics to advanced topics, the pages cater to all levels.

Discover user-friendly Apps Script to automate Google Apps, with real-world use cases. Follow me on X, BlueSky, Medium, or Instagram for updates. Your journey to Workspace efficiency starts here!

Over a million people have visited this site!! 😊 I’m soo happy to have helped so many people! Thanks for visiting! 😀

Do you want to know about the latest features in Google Workspace? And / or want to receive my latest posts and videos straight to your inbox? Sign up to my free regular newsletter below and get a list of 50 lesser-known yet highly useful features in Google Workspace.

Form not shown if you’ve already signed up. I 100% respect your data privacy and you will only receive news and posts related to Google Workspace and Apps Script and of course you can cancel at any time.

NEW VIDEO COURSES!!

Do you use Google Sheets but would like to learn how to use it better without the effort? This is the video course is for you!!

GOOGLE SHEETS – FROM NOVICE TO NINJA – This comprehensive course on Google Sheets equips you with the skills to effortlessly organize, analyze, and visualize your data. We’ll begin with the fundamentals, covering data input and formatting, before moving on to more advanced topics like data validation and automation. This course is fully up-to-date, incorporating the latest features in Google Sheets, including AI-powered tools like Gemini, structured data with tables, and time-saving features like Conditional Notifications.

GOOGLE SHEETS FUNCTIONS – BE THE HERO IN THE OFFICE – This practical course on Google Sheets Functions is designed to equip you with the skills to effortlessly organise and analyse your data. It’s fully up-to-date, even incorporating the latest functions like XLOOKUP and AI, ensuring you learn the most relevant and powerful tools available.

Don’t worry we’ll start with the basic functions, like SUM and COUNT and then progress to more advanced ones like IMPORTRANGE and the incredibly powerful QUERY. Possess a robust toolkit of Google Sheets functions. This course is all about giving you the practical skills and confidence to solve real-world problems and take complete control over your spreadsheets.

By the end of this course, you’ll be able to use Google Sheets with confidence, saving time and effort, and impressing your boss and colleagues! You’ll enhance your professional and academic prospects and open doors to new opportunities.

Reflection – One of the things that set me off on my Google Workspace journey was learning spreadsheet functions. If you’re new to them, they are things like =SUM(A1:A100), which would add figures in column A.

I’m always surprised that even though so many people use spreadsheets every day in their work that they only know the basics, and learning things like functions would make their lives so much easier.

It was certainly also the springboard for making a number massive improvements in my department and then it led to me learning Google Apps Script, which is the easy-to-learn code that sits behind the Workspace apps. That basically changed everything and over the years I’ve been amazed what you can do with it.

So, my advice for this year? Learn spreadsheets, spreadsheet functions and / or Google Apps Script! You won’t regret it! 😎 GOOGLE SHEET FUNCTIONS BOOK

• Create Timelines in Google Sheets with EaseNovember 24, 2025
  Timelines in Google Sheets offer a simple yet effective way to organise date-related data visually. They are perfect for event planning, task management, and other projects involving actions over time. This quick guide will walk you through creating and customising timelines to fit your needs. Creating a timeline Let’s look at creating a timeline for… Continue reading Create Timelines in Google Sheets with Ease
• Quickly turn Images into Dynamic Videos with Gemini & Veo 3November 12, 2025
  Following on from my last post, where we looked at how we can quickly create and edit videos using Gemini and Nano Banana, here we’ll look at how we can convert images into short videos using Gemini and Veo 3. Let’s use one of the images I created in the last post, the one where… Continue reading Quickly turn Images into Dynamic Videos with Gemini & Veo 3
• Quick Image Editing with Nano Banana in GeminiNovember 4, 2025
  In today’s fast-paced digital world, captivating visuals are no longer a luxury—they’re a necessity. But for many businesses, creating and customizing those visuals is a time-consuming and expensive bottleneck. What if you could generate and edit images with simple text commands? Enter Nano Banana in Gemini! From Idea to Image: Generating Your First Visual Let’s… Continue reading Quick Image Editing with Nano Banana in Gemini
• Become a Master Baker with Gemini’s Guided Learning!October 21, 2025
  Have you ever followed a recipe to the letter only to find your results were… less than perfect? Gemini’s Guided Learning feature is here to change that, transforming the way you approach new skills and complex tasks. It acts as your step-by-step personal tutor for any topic, moving you beyond just reading instructions to truly… Continue reading Become a Master Baker with Gemini’s Guided Learning!

My intention is to keep this site ad-free, so you can find the information you want easily and without distracting ads. If you would like to support this site, then you can find book links at the end of every post. Just click on a book to open the page on Amazon. I update the books periodically to reflect the latest changes to Google Workspace and Apps Script. They are all available on Amazon HERE.

Your help is very much appreciated. I hope you find this site useful – please share it. Thank you! – Baz