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 COURSE!!

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.

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

• Transform Your Spreadsheets with Google Sheets TablesMay 19, 2025
  Google Sheets’ Tables feature is a powerful tool for managing data. It provides an intuitive way to organise information, making it easier to input data, filter, sort, and group it. Whether you’re tracking projects, sales, or content calendars, using Tables can significantly improve your productivity. This guide will walk you through the key features of… Continue reading Transform Your Spreadsheets with Google Sheets Tables
• How to Share, Download & Email Files in Google SheetsApril 6, 2025
  Google Sheets makes collaboration easy with features to share, download, and email spreadsheets. Whether you’re working on a group project, sending a snapshot of data, or sharing editing access, Sheets has the tools you need. Here’s how to use these features effectively. Sharing a spreadsheet One of the best things about using Sheets is the… Continue reading How to Share, Download & Email Files in Google Sheets
• How to use Cell & Version History in Google SheetsMarch 30, 2025
  Google Sheets automatically saves every change, ensuring you never lose your work. More importantly, it provides tools to revisit past versions and track edits. This feature is invaluable when collaborating or correcting errors. This post explores how to use Version History, name specific versions, and track edits in individual cells. Version history This is where… Continue reading How to use Cell & Version History in Google Sheets
• How to merge cells in Google Sheets for clearer dataFebruary 16, 2025
  Merging cells in Google Sheets is a simple feature that improves the presentation and clarity of your data. By combining cells, you can create clean headers or group related information, making your spreadsheet easier to understand. In this post, we’ll explore the different ways to merge cells and how to apply this to your data… Continue reading How to merge cells in Google Sheets for clearer data

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