Sheet Code

ChatGPT Clone in Google Sheets Part 2

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.

Getting Started Coding in Apps Script

FREE

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

Seek Errors When Coding Apps Script

It's healthy programming. I'll show you some common errors you will encounter when you first start programming in Apps Script

Think Like a Programmer: Develop The Mindset of an Apps Script Coder

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.

ChatGPT Clone in Google Sheets Part 1

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.

Embed a Number in a Website from a Google Sheet

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.

Create Navigation Like A Book or Presentation

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.

Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet

FREE

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.

Bjarne Asks: Can I show the Last Time of the Last Edit in a sheet?

Embed a Headline in a Website from Google Sheets

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!

Capture Emails from Website Form to a Google Sheet (Without Zapier)

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

Quickstart Tutorial OpenAI API in Google Sheets

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!

Hold a Giveaway Raffle in a Google Sheet

Get a random winner from a list of names. Also great to randomize tasks to do.

Create a new Spreadsheet from just a Name in a Sheet.

Create the Apps Script to create a new sheet from some data inside your sheet. Script included in the sheet below.

Email Yourself a Cell from a Google Sheet, Every Day

FREE

Learn to automate an email, with data, from a sheet.

Shwitter | Twitter in a Google Sheet

FREE

I built a twitter clone in Google Sheets

Create an Email Campaign Stats Calculator

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.

OpenSea Data Inside Sheets

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

Dylan Asks: How to Automatically Delete Rows If Cell Contains Value

Find out how to automatically delete rows based on a cell's value. We do this in Apps Script

Highlight Row as You Move Your Cell Selection

Checking data? This script changes bg color of entire row as you move your cell selection.

Create a Timer with Apps Script

Create a start time and end time and duration of that, with a little bit of Apps Script.

LinkTree in a Google Sheet

This tool will allows you to share multiple links on your social media.

Password Protecting Data In a Google Sheet

A funky way to password protect some data in a sheet, 3 ways to do it: with IF(), Apps Script, and Encoding

Automatic Weekly Backup of Google Sheets

Discover how to Save Your Sheets Every Week Automatically

Create a CPM Custom Function (Create Better Calculators!)

this is gonna be fun because we get to create a calculator with Apps Script.

Move Entire Row when a Cell is changed to "Yes" - The $75,000 Google Script

What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users

Learn about triggers, hourly, daily, weekly, etc.

Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.

FREE

Sync Two Tabs Without ImportRange()

Get this epic script that automatically edits two tabs and keeps them in sync.

Password Protecting Data In a Google Sheet Part 2 The Basics

Covering some of the basics I skipped over in the part 1 video.

Benoit Asks: How to Convert Case

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?

FREE

Learn to Code in Google Sheets, For Programmers

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".