Google Workspace and Apps Script Books

Google Workspace and Apps Script Books

Do you want to learn more about Google Workspace and/or Google Apps Script? I have a series of Google Workspace and Apps Script books just for you! All of them take you step-by-step through the apps or the code. I continually update these books to make sure they reflect the latest changes to Google Workspace.

A step-by-step guide to using Google Apps Script with Google Sheets. You will learn how to work with and automate Sheets.

This book assumes no knowledge of coding or of Apps Script or of JavaScript and will take you from writing your first script to using Apps Script with Sheets with confidence.

Every chapter contains numerous practical examples of scripts with every step explained along the way. It also contains links to the files used in the book. It also covers some Javascript fundamentals, like loops and arrays, relating them specifically to their use in Apps Script.

A step-by-step guide to using Google Apps Script with Google Forms. You will learn how to automatically create forms and quizzes, and how to use the responses from a form, and for example, automatically email the information when the form is submitted.

This book assumes little knowledge of coding or of Apps Script or of JavaScript, although some previous knowledge of Apps Script with Sheets is helpful but not essential. It will take you from writing your first form script to using Apps Script with Forms with confidence.

Every chapter contains numerous practical examples of scripts with every step explained along the way. It also contains links to the files used in the book. It also covers some JavaScript methods like forEach, slice, indexOf, relating them specifically to their use in Apps Script and working with Google Forms. Updated using the new Script Editor.

A step-by-step guide to using Google Apps Script with GOOGLE DRIVE. This book assumes no or little knowledge of coding or of Apps Script and will take you from writing your first script to using Apps Script with Drive with confidence.

Every chapter contains numerous practical examples of scripts with every step explained along the way. For example, creating multiple PDFs and folders, automatically sending brochures when a form is filled out, listing all the files in your Drive, and more.

It also contains links to the complete scripts, which can easily be copied and pasted into your own projects. Plus, it shows how the Drive service can be used with the Document, Spreadsheet, Slide, Map, and Form services.

Barrie Roberts has created, yet again, an easy to read, fully outlined, step-by-step guide to getting started with coding using Google Apps. If you are an educator, student, or other professional looking for a quick practical guide in using Google Apps Script, then this is your source.

Do you want to learn how to create documents automatically with Google Apps Script? This book shows you step-by-step how to use Apps Script to supercharge GOOGLE DOCS.

Every chapter contains a practical example of using Apps Script to create a wide range of documents, such as, invoices, sales quotes, student reports, and conference talk information.

It starts with relatively simple applications, like a master document copier which uses a Google Form to learning how to create web apps and making your own HTML forms to be able to email PDFs to potential customers. Each example builds on the previous ones, so you get to understand how to use the Document Service well.

As this is the fourth book in the series on Apps Script, it does assume a basic knowledge of Apps Script, JavaScript, and a little HTML. That said, every bit of code is explained with links provided to example Form, Sheet, and Document files.

This book is aimed at those who are learning Google Apps Script and also want to learn the key concepts of JavaScript (JS). Most examples on the web and in other books focus on the use of JS with websites, whereas, in this book all the explanations and examples are in the context of using JS with Apps Script.

It includes free access to a file containing all the code explained in the book. Every chapter contains clear explanations and examples focussing more on the use of it rather than the terminology. It also includes examples using the latest versions of JS.

Unlock the full potential of GOOGLE SHEETS FUNCTIONS: Your ultimate guide to mastering essential functions! Take your Google Sheets skills to a whole new level with my comprehensive guide on the most useful functions! Whether you’re a beginner or a seasoned user, this book is designed to empower you with the knowledge and confidence to make the most out of Sheets’ powerful functions.

As you progress, you’ll delve into more advanced areas like VLOOKUP, FILTER, IMPORTRANGE, and the incredibly versatile QUERY function. But don’t worry – I believe the best way to learn is through practical examples, and that’s exactly what I offer in every chapter! With a clear focus on hands-on learning, each chapter presents multiple examples that dive into the various facets of the function and its various applications.

Unlock the complete potential of GOOGLE SHEETS FUNCTIONS. Master advanced functions and elevate your spreadsheet skills! If you’re ready to take your spreadsheet expertise to new heights, this is your ultimate guide. I’ve carefully curated over 100 practical examples, showcasing the most useful functions in action.

Stay ahead of the game with the latest functions, including XLOOKUP, BYROW, and LAMBDA, introduced to Sheets in 2022. Each chapter centres around one or two functions, demonstrating their seamless integration with others. In fact, you’ll encounter more than 50 functions throughout the examples.

Unleash the true potential of your data with “Google Sheets Functions 2.” Whether you’re a seasoned pro or a curious learner, this book caters to all skill levels. So, what are you waiting for? Get your copy now and embark on an exciting journey of spreadsheet mastery.

Master Google Sheets with Ease: Your Ultimate Guide to Effortless Spreadsheets!

Google Sheets is undoubtedly a powerful tool, but for newcomers, it can be a maze of complexity. Fear not! In this comprehensive book, I’ll be your expert guide, leading you on a step-by-step journey through the vast landscape of Google Sheets – from its most basic features to its more advanced functionalities.

The 2024 edition is entirely revamped, reflecting the latest changes to Sheets, ensuring you’re up to speed with all the new enhancements. Discover how to create timelines, implement drop-down menus, and unleash the full potential of data validation like a pro. With up-to-date screenshots showcasing the latest Sheets interface, you’ll have all the tools at your fingertips.

Google Docs is a wonderfully user-friendly alternative to the likes of Microsoft Word. On the face of it, it is a simple word-processor but if you delve a little deeper it can do so much more.

In the 20 chapters of this book, I’ll take you step-by-step through the different areas of Google Docs, starting from the very basics to more advanced areas, so that you are able to use Google Docs with confidence.

Learn how to share a document to work on it with others. Learn how to connect charts and slides which can be updated at the click of a button. Learn how to action colleagues directly from the document via action comments. And more!

This book explains what Google Drive is and how it works. Taking you from knowing nothing to using it with confidence. 

I’ll take you step-by-step through the different areas of Google Drive, starting from the very basics to more advanced areas, so that you are able to use it well.

Learn how to: manage your files and folders, share them with specific people or the world,  set up Drive up so it’s easy to find your content, upload and download your files, and more!

Updated with the latest improvements, including the new sharing method, the new styling, and quick access.

Google Forms is part of Google Workspace and is a wonderful tool to use to easily collect data and information. This book takes you step-by-step from creating your very first form to producing more complex ones like quizzes. Learn how to personalize forms, add images and videos, and extend its functionality by installing add-ons.

Fully updated with all the latest changes including the new Settings menu. Plus, new sections added: Importing questions, and Installing an add-on.

Google Slides is a wonderfully user-friendly alternative to the likes of Microsoft PowerPoint. With this book, learn not just how to create great, professional-looking presentations but how to create animated comics, involve your audience via audience Q&A tool, and publish your slides on the web.

In the 30 chapters of this book, I’ll take you step-by-step through all the different areas of Google Slides, starting from the very basics to more advanced areas, so that you are able to use Google Slides with confidence.

Do you need to hold meetings or give classes online? Google Meet is Google’s video-calling app which allows you to do this and more. It’s part of the Google Workspace family of apps.

In this book, I’ll take you through step-by-step all the key features of Google Meet, from how to create meetings in seconds to setting up breakout rooms for your attendees.

It also includes dealing with technical problems, and suggestions on getting around some of the limitations in Meet.

Have you ever wanted to create a website but don’t know how? Have you ever wanted to create a website that’s really easy to do, is free, and you can set up in minutes?

This book will take you through step-by-step, how to create websites using Google Sites. We’ll cover all the areas you need from adding text, images, videos, maps, and buttons, to name but a few. I’ll take you through two real-world examples, so you can learn the practical skills to create wonderful websites!

Here are some of the wonderful things buyers have said about my books ☺️ – A big thank you!!

“I wish I had this before starting to learn. I would recommend this book to any one interested in learning GAS.” – KB (Google Apps Script Projects 1)

“I use this ebook all the time as a reference. It’s is easy to follow, and handles complex subjects like arrays in simple terms. Great book on Google App script.” – BE (Beginner’s Guide to Google Apps Script 1 – Sheets)

“Barrie shows us a lot with what we can do with Google Apps Script…. That’s the difference with Barrie’s books, you learn and repeat skills that may be integrated into other projects.” – SSF (Beginner’s Guide to Google Apps Script 3 – Drive)

“No fluff, just the information you want to get up and running with Google Sheets. There are plenty of examples and illustrations to explain the various ways to use the functions. This book seems to have all the functions you may want or need to use Sheets effectively. You can’t go wrong with Barrie Roberts’ book.” – A (Google Sheet Functions – A step-by-step guide)

“This book is really amazing. You can have a deep approach to Google equivalent of Excel. I learned a huge number of tricks that will increase my productivity. A great book that worth each dollar paid.” – D (Beginner’s Guide to Google Sheets)

This page contains Amazon affiliate links to my books, which basically means I get a couple of pennies extra if you buy one via the links. 🙂