The complete guide to simple automation in Google Sheets, using Macros

Macros are small programs you create inside of Google Sheets without needing to write any code. They allow you to automate repetitive tasks. They work by recording your actions as you do something and saving these actions as a “recipe” that you can re-use again with a single click.

Sound good?

They sure are! Read on to learn how to use them, see some examples, discover their limitations and also see how they’re a great way into the wonderful world of Apps Script coding 😀

This video is the third lesson from my free Apps Script Blastoff! course: an online course teaching Google Apps Script from scratch.

Contents

  1. What are macros?
  2. Why should you use macros?
  3. How to create your first macro
  4. Other options
  5. A peek under the hood
  6. More macro examples!
  7. Resources

Continue reading The complete guide to simple automation in Google Sheets, using Macros