79% OFF online library of tutorials for mastering Google Sheets

One time purchase $149

This course is not available for free users. Please purchase a subscription to enroll in this course and view its contents.

Automating

34 Tutorials

1 hour and 46 minutes

You find yourself doing rote tasks. Again and again, day after day. While designing better sheets makes your life in the sheets better. There’s far more life outside the sheets. Here are the videos that help you record simple tasks and repeat them without fail.

34Tutorials

Learn to set text wrap, overflow, or clip. Great for designing better text in your sheets.
Learn to automate an email, with data, from a sheet.

2

Write an apps script to delete lines easily.
Member Richard asks this question. Answer: use Google Script and a Trigger.
Access the OpenAI API, walkthrough of the way we engineer the Apps Script so that we can play around with temperature and token length. Walk through UrlFectchApp as well and parsing JSON.
Create a sequence of numbers that magically appears as you type in each row. Put this in A1 and start typing in column B: =SEQUENCE(COUNTA(B:B),1,1,1)

7

Add labels to gmail emails you get from email addresses you put in a Google Sheet list. Great for tagging members, subscribers, users, when you want to prioritize them in your Gmail. Great to see a function laid out that interacts with Gmail inside of Google Sheets Apps Script.
A raw, 1 shot take of figuring out how to automatically delete all sheets not named on a whitelist of sheet names. Using the on Change Installable trigger. This video was tough to make!
I walk you through everything you may encounter along the way of coding in Google Apps Script. Discover the challenges and pitfalls before you fail. If you’ve never coded before, I’m right there with you all the way.
Find out how to automatically delete rows based on a cell's value. We do this in Apps Script
Now that we have a script that we wanna run every day, how do we run this? This is a key part of programming. It's like Cron Jobs in Apps Script
Send daily emails to yourself to master sales every single day. 100% completely free for Better Sheet members.
A short 10 minute video to get you started with Apps Script. Showing you menu: Extensions > Apps Script. And shows off how to write a function, do some math, manipulate some text. Members can get Spreadsheet Automation 101 in https://BetterSheets.co/courses

15

Google Sheets uses a scripting language called Google Apps Script, which is based on JavaScript. If you know how to code in JavaScript, you'll find Google Apps Script very familiar. To get started, open a new Google Sheet and go to the "Extensions" menu, then click "Apps Script".

16

we're going to be adding a very powerful script to our CRMs or any database in which you need to move rows between tabs.
Create a Log sheet in Google Sheets
Created a daily email with a motivational quote in the subject.
Create a click Edit: Google changed how the redirect is handled. It no longer automatically goes forward, so you will need to add a link for a user to click on again to go to the forwarded link.

22

Get this epic script that automatically edits two tabs and keeps them in sync.
Discover how to Save Your Sheets Every Week Automatically
Embed a little HTML into your site to capture Emails straight to a Google Sheet. I've written the apps script and the html and the javascript for you. As easy as copy and pasting. Use my referral link if you choose to use Carrd for this: https://try.carrd.co/kamphey
generate random numbers using Google Sheets. Fun ways to figure out how to get random characters. Great to use for creating IDs or Coupon Codes. Nice easy intro to some simple apps script.
One of the most requested videos, Ever. How to put data, a number, some text, from a Google Sheets onto a website without having to embed the entire Google Sheet. This is the way!
Get floor prices into your spreadsheet with URLFETCHAPP. Accessing OpenSea's API directly from google sheets. Get any data you want. from Market Cap to One Hour Volume
Record a macro, to Insert a column every day.
this completes learn to code in Google Sheets and I wanted to finish off by giving you a few more quick concepts that expands your mind of what Google Sheets can do.
Here are 5 advanced ways to manage projects inside of Google Sheets Manage Task Flow with IF() and a Checkbox Manage Data Inputs with IF() and ISBLANK() Create Quick Dashboard headers with: Transpose / Unique Create Pickers with Index / Match Email reports with Apps Script
Let’s talk about the IF formula and the differences. Learn how to insert a checkbox and all the other things it can do for you.
We code a little apps script to figure out the difference between two cells.

34