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.

Sheet Code

54 Tutorials

5 hours and 44 minutes

how to set up web apps, how to create APIs in sheets. How to access APIs in google sheets without plugins/add-ons. 

54Tutorials

We fix the problem of OpenAI's API not remembering our last questions. And we label the text as Human and AI. I also add an archive Chat and new Chat function to create a new chat fresh.
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

3

It's healthy programming. I'll show you some common errors you will encounter when you first start programming in Apps Script
It's hard to code. It's even harder to learn to code. This is my thought process to help you become resilient enough to learn, and continue to learn to code.
Creating a ChatGPT-like interface to interact with the OpenAI GPT-3 API. We style a sheet like ChatGPT, and we add Apps Script functions to add new rows to record the questions we send, and answers we get from OpenAI API.
Ever wanted to display some data from a google sheet on your site? Without using 3rd party tools here is the javascript, html and the sheet you will need. and step by step instructions on how to use it.
A pretty cool script I came up with to click and set active the next tab. No matter how many tabs/sheets you have. Makes a book-like page turning action. At the end of the video I say you have to wait, but now you can get the sheet and the script only. Spreadsheet Alchemy is still a work in progress.
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.

9

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!
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
Use the power of OpenAI's GPT-3 inside of Google Sheets. In this quick start tutorial I show you how to take OpenAI's curl commands and change them into Apps Script to use GPT-3 inside of sheets. We write a tweet, we ask questions. And now you can use this power for greater good!
Get a random winner from a list of names. Also great to randomize tasks to do.
Create the Apps Script to create a new sheet from some data inside your sheet. Script included in the sheet below.
Learn to automate an email, with data, from a sheet.

16

I built a twitter clone in Google Sheets

17

From scratch we're going to build a calculator, with some functions and some custom functions in apps script. We'll also design the sheet like a funky dashboard.
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
Find out how to automatically delete rows based on a cell's value. We do this in Apps Script
Checking data? This script changes bg color of entire row as you move your cell selection.
Create a start time and end time and duration of that, with a little bit of Apps Script.
This tool will allows you to share multiple links on your social media.
A funky way to password protect some data in a sheet, 3 ways to do it: with IF(), Apps Script, and Encoding
Discover how to Save Your Sheets Every Week Automatically
this is gonna be fun because we get to create a calculator with Apps Script.
Get this epic script that automatically edits two tabs and keeps them in sync.
Covering some of the basics I skipped over in the part 1 video.
How can I use this function, lower, upper, or proper as a conditional formatting? And then the other question is, how can I use this to apply on a bunch of cells without having to double the cells?
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".

33

Made this really quick dark mode click button. And I wanted to show you how I did it because it's dead simple, super simple. It's literally just using conditional formatting
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.
Create a quick search dropdown to find keywords in any column.
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.
Curate a newsletter. Collect YouTube videos. Research competitors. All with this one line of javascript. Build your own web clipper. Use the Bookmarklet to clip web content to your Google Sheet. Clip text and links directly from the web to your Google Sheet with just a few clicks.
Exclusive video only for Better Sheets members. This is, uh, troubleshooting your click tracking web app or slash sheet.
We're gonna talk about some features that we're gonna be using that might be new to you, or, just remind you that we're gonna use them to make 'em very interesting and unique to, using dashboards.
Enable your apps script functions be auto completed while you're using Google Sheets.
We code a little apps script to figure out the difference between two cells.

47

revisiting the "what changed" custom function I built in a past video. Showing you more apps script

48

Record a macro, to Insert a column every day.
Write an apps script to delete lines easily.
Go inside this apps script and sheet. See how it's designed and created.
Generate Coupon codes in Google Sheets 5 different ways.
Let's code a Radio button that turns off all checkboxes except the one clicked.