The AI Playbook for Google Sheets

Learn how to use AI effectively with Google Sheets to work with formulas, data, and scripts.

Turbocharge your work with AI

Artificial intelligence (AI) is rapidly changing the world and making it possible for us to do things we could only dream of previously.

AI tools can bring inaccessible, complex formulas and automation scripts into the realm of everyday users.

This course — The AI Playbook for Google Sheets — is a concise guide that teaches you how to use artificial intelligence to work more effectively with Google Sheets.

It’s perfect for anyone who is new to this technology and wants to learn how to use AI in Google Sheets.

Whether you’re a skeptic or a believer, this course will show you how AI tools can improve your Google Sheets workflows.

AI is your superhero sidekick.

Use it to work faster and more accurately.

Do things you couldn't previously do.

In this course, you'll learn how to:

  • Use AI tools like ChatGPT, Google Bard, 3rd party add-ons, and Duet AI confidently
  • Write good prompts and understand Prompt Engineering
  • Explain, troubleshoot, and create formulas using AI tools
  • Work more effectively with data using AI tools
  • Use AI to explain, troubleshoot, and write scripts
  • Impress your boss with your newfound knowledge
  • And more!

My own AI journey

I was skeptical of AI initially. There was a lot of hype and "tech bros" selling AI-this and AI-that.

But the hype didn't fade away.

And I started to see folks sharing incredible demos of using AI tools with Google Sheets.

So I knew I needed to take a proper look. That was back in January of 2023.

It didn't take long for me to see the benefits.

Whenever I was writing Apps Script, I found myself reaching for ChatGPT to give me a headstart. I described my problem and ChatGPT generated useful code for me, saving me hours of research.

It's really transformed how I work with Google Sheets.

And best of all, using AI tools is not rocket science.

You don't need to delve into the weeds of how different models work or understand parameter tuning. You can use these AI tools just like you use any other online tool.

My takeaway: Don't put AI up on a pedestal. Anyone can use it.

Through experience, I've learned how to write good prompts to increase the chance of getting a useful response. I've found which workflows benefit from AI as well as which workflows don't. And I’ve figured out how to apply these tools to Google Sheets, to make my everyday work faster and more accurate.

In this course, I share all of these learnings so you can benefit from my months of research and avoid making the same mistakes.


Bring AI down to earth

The media is awash with articles proclaiming AI will take over the world alongside articles denouncing AI as nothing more than a hype-driven bubble with no real-world benefits.

It feels overwhelming and confusing.

That's where this course comes in.

It's your handy guide to cut through the noise and bring AI down to earth.

I've deliberately stuck to mature tools within the AI space so that they're likely to be around for a while.

This is not a course about the cutting edge of AI research. It's focused on practical applications using publicly available, easy-to-use tools.

So if you're not sure where to begin or even what the benefits of AI are, this course is a great place to start.

Benefits of using AI

There are many benefits to using AI in Google Sheets, including:

  • Increasing productivity: AI can automate tasks that would otherwise be time-consuming and tedious, freeing up your time for more important work.
  • Improving accuracy: AI can help you identify errors in your data and clean up your data.
  • Better decision-making: AI can provide you with insights that can help you make better decisions about your business.
  • Making expert-level features, like REGEX formulas or scripts, accessible to everyone.

The great promise of AI is to level the playing field and give everyone access to expert-level skills.

And whilst we're not there yet, the industry has made enormous strides in the past year. It's a great time to discover what all the fuss is about and add some expert spreadsheet skills to your toolset.

A better way to learn

We all have good intentions to learn new skills but finding the time can be a challenge.

Life is busy. I have two young children so I know firsthand how difficult it can be to find time for new projects.

Online courses with hundreds of videos feel overwhelming. And despite all that initial enthusiasm, we never get around to mastering that new skill.

So that's why I've deliberately kept this course concise and to the point. It only takes about 2.5 hours to watch the 16 videos, so you could complete this course over a couple of lunch breaks.

My goal is not to teach you everything there is to know about AI. (That would be impossible anyway!)

Instead, my goal is to give you a launchpad and a set of recipes that you can immediately apply.

I want you to watch this course and immediately benefit from these AI tools.

What's included in this course

  • 16 video lessons between 4 and 14 minutes long
  • 12 Google Sheets templates (unlimited copies)
  • 5 Google Slides templates (unlimited copies)
  • 10 Google Docs prompt templates (unlimited copies)
  • Resource guide for further study
  • Access to our private student community for Q&A
  • Certificate upon completion

Who is this course for?

This course is perfect for you if:

  • You're new to AI, looking to take your first steps
  • You've dabbled with AI before, but lack the confidence to use it
  • You know the basics but want to see examples of AI and Google Sheets workflows
  • You have experience but want to fill any gaps in your knowledge

What customers say about Ben's courses

You can’t afford to ignore AI

AI technology is coming to an office near you soon, whether you like it or not.

So you have to make a choice.

If you ignore it and hope for the best, you will gradually become disadvantaged as others leverage AI to work more efficiently than you.

Luckily for us though, you don't have to. Integrating AI into your workflows is fun and easy.

Will AI reshape work? Research says YES

A recent research study performed by Harvard University and the Boston Consulting Group [1] showed a clear upside for consultants using AI to perform knowledge tasks. Not only were they more productive, but they produced work of higher quality.

I don't think there's much doubt now that these AI tools are here to stay and knowledge workers will be expected to know how to use them.


Your Instructor

Ben Collins
Ben Collins

Hi! I'm an experienced data analytics instructor and freelance spreadsheet developer.

I help individuals and businesses better understand their data through analytical insights and visualizations.

Over 50,000 professionals from 1,000+ companies have enrolled in my training courses, including employees from PwC, Netflix, Verizon, Google, Capital One, and other Fortune 500 companies.

My training has helped 1,000’s of people advance their careers. I’ve also helped small and large organizations migrate from Microsoft Excel and Office to Google Sheets and Google Workspace.

Google recognized me as a Google Developer Expert for Google Workspace Technology in 2019, one of only a handful worldwide.

I work primarily with Google Sheets and Apps Script, and also have extensive experience with Google Looker Studio, Microsoft Excel, BigQuery, SQL, and Tableau. I've previously taught data courses and workshops for General Assembly in Washington, D.C..

Frequently Asked Questions

When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 14 days and we will give you a full refund.
Will I get copies of the datasets and solutions?
Yes! All the templates and solutions are provided, so you can download your own copies. Clicking on the template links will open the files so you can make a copy on your Drive account.
How do I access the private course community group?
When you enroll, you’ll receive the link in the last lesson of the introduction chapter. Once you’ve joined, feel free to introduce yourself and let us know how you plan to use your newfound knowledge.
What if I can’t figure out something on my own?
You can ask for help in the private community group for students! As a member of this group, you can ask questions, share your ideas and knowledge, and connect with other students.
What if I don’t have a technical background?
Don't worry, you won't be alone! This course focuses on practical techniques and teaches concepts through real-world examples, so that you won’t get lost in abstract theories and dense lectures. As long as you aren’t afraid to roll up your sleeves and put some effort in, then you’ll be able to grasp the content of this course. You’re free to watch the lessons in any order and as many times as you like, so you can take as long as you want!
Is this course suitable for complete beginners?
Yes! I've designed it without assuming any prior knowledge of AI. And it covers topics in depth to really explain what's going on.
Is this course suitable for intermediate users?
Yes, it's a useful guide for intermediate users. If you're self-taught you probably have some gaps in your knowledge. This course will help you plug those gaps.
Do you offer Parity Purchasing Power discounts?
Yes, I want my courses to be affordable to folks overseas in developing countries, who would otherwise not be able to purchase them. How does it work? Drop me a line with proof of where you're based and I'll be glad to offer you a PPP discount on the course.
Can you provide an invoice for my company?
Yes, of course! You’ll receive a receipt after you purchase, but if you need something additional, please contact us and we can provide an invoice.
My company is interested in a bulk order. Do you have enterprise deals?
Yes, please email us at [email protected] and we can discuss details.
Does the course have closed captions available?
Yes! Every video has closed captions in English, which can be toggled on/off by the video controls.

Get started now!