Hi,

Have you tried automating your sheets yet?

You might want to. Or you've attempted to write your first automation. Maybe you've tried recording a macro.

The key is to learn to code. Learning to code in Google Sheets is so easy!

And if you disagree. you think it's not easy for you, I want to make it so easy for you.

I want to make it faster for you to get to your first line of code. The first time I sat down to write code in Google Sheets even after 3 years of using Excel VBA, it took me 2 weeks to write my first line of useful code. Learn to Code is 1 hour. Even as I change it around and update it and add to it, I want the core to stay at just under 1 hour.

But there's more than just video to share with you. I think learning to code doesn't have to be just you sit and I show you. There's other ways to learn, right?

That's why I'm writing a little workbook for my course "Learn to Code in Google Sheets"

I need your help

It'll be 10 simple automations. I've outlined them below.

I have one question for you at the end.

Read through this outline first, then go ahead and check out the one question I have for you.

Read through this no matter if you're a Better Sheets member or not.

I guarantee it's worth the time.

10 Simple Automations

Custom Menu Adds custom menu options to the Google Sheets. Allows users to run specific script functions directly from the menu. Useful for streamlining workflows and making scripts easily accessible to non-technical users.

Pop Up Messages Uses dialog or alert boxes to display information, warnings, or prompts the user. Makes better user interaction within a document by providing immediate feedback.

Copy Template Duplicates a tab /template for reuse with new content. Saves time and ensures consistency across spreadsheet files created for similar purposes.

Trigger to Copy Automatically creates a copy of a document or spreadsheet based on specific triggers, such as a date/time event. Streamlines repetitive tasks and ensures timely creation of necessary documents.

Email Yourself Sends automated emails to your own email address, typically used for notifications, reminders, or logging purposes. Helps keep track of important events or changes within a document or spreadsheet without manual oversight.

Trigger Email Sends emails automatically in response to specific triggers, like form submissions or spreadsheet updates. Makes better communication and ensures stakeholders are promptly informed about important updates or actions required.

Move Row Automatically moves a row from one spreadsheet to another based on certain criteria, such as the completion of a task. Useful for organizing information and managing workflows across multiple stages of a process.

Move and Time Similar to Move Row but includes adding a timestamp. Enhances data organization and tracking by marking the exact time of data transitions or actions.

Add Timestamp Inserts the current date and time into a spreadsheet cell automatically when certain conditions are met. Useful for tracking changes, submissions, or updates without manual timekeeping.

Calculate Automatically Performs calculations automatically in response to changes within a spreadsheet. Ensures data is always up-to-date and reduces manual calculation errors, ideal for financial, inventory, or analytics.

​

The Question

Here is where you step in and help me, help you.

What automation was missing?

You read through 10 simple automations up there. Now tell me what you want to automate that I didn't cover. Maybe it's not moving rows, or emails, or making templates, or calculations.

I want to know.

Worth It!

I told you it would be worth the read.

Here's a coupon code to get "Learn to Code" for free on Udemy.

Use coupon code: 76B6234E2B172DE8523D​

If you're already a Better Sheets member than you can share this code with a family member, a colleague, an employee. Anyone.

It's good for up to 1,000 uses or 8 PM on May 10th. Whichever comes first.

-Andrew

Your Resident Google Sheets Wizard at BetterSheets.co​

P.S. I dropped a tiktok compilation over on YouTube. Thought you might like it. It's got some fun little tricks in it.

​

​

​

​

​

​

​

​

​

​

​

​