Google Sheets Tutorials · Better Sheets

From Sheet to Script And Back Again - Learn to Code In Google Sheets Part 3

In this video, I'm going to share with you how to go basically from sheet to script and then back to the sheet again.

Beginner

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

Intermediate

IMAGE()

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our Add-on we'll be publishing to the Google Workspace Marketplace.

Why Code in Google Sheets? - Learn to Code in Google Sheets Part 1

welcome to part one of Learn to Code in Google Sheets. In this video, we're gonna get started to code.

Beginner

Now Do It Every Damn Day - Learn to Code in Google Sheets Part 5

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

Advanced

How to Write a Function - Learn to Code in Google Sheets Part 2

Continuing to show you how to write a function in Apps Script.

Beginner

Troubleshooting Bitly in a Google Sheet Script

Exclusive video only for Better Sheets members. This is, uh, troubleshooting your click tracking web app or slash sheet.

Advanced

Create a Radio Button From Checkboxes Using Google Apps Script

Let's code a Radio button that turns off all checkboxes except the one clicked.

Data validation Advanced

IFS() NOT() OR()

Copy That, From One Sheet to Another - Learn to Code in Google Sheets Part 4

Learn to code in sheets. Automate Your Daily Sales Report with Google Sheets: Learn how to create a script that copies data from one sheet to another, including timestamps. Boost your productivity with this easy guide!

Advanced

NOW()

Wrap Your Mind Around This - Learn to Code in Google Sheets Part 6

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.

Advanced

Getting Started Coding in Apps Script

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

Beginner

How To Set Up Stripe Webhook to Google Sheets with Google Script

Learn how to set up a Stripe web hook in a Google sheet and Stripe to track new customers, payments, and cancellations with ease! Get the script and code on GitHub, available for everyone. No need to be a Better Sheets member.

Advanced

Generate Coupon Codes from a Google Sheet - Announcing Coupon Code Maker

You can now generate 100% off unique 1 time use Gumroad Coupon codes from a Google Sheet.
It's $30, available now.
Lifetime members get it for free
https://bettersheets.co/tools/coupon-code-maker

What does Coupon Code Maker do?
Coupon Code Maker is designed for generating coupon codes, particularly useful for sellers on Gumroad. The tool, simplifies the process of creating large quantities of unique, single-use coupon codes.

The tool leverages Google Apps Script for its functionality, indicating a strong reliance on automation and API interactions. It's particularly noted for its ability to generate a high volume of codes quickly and efficiently, which can be exported as CSV files for use on platforms like AppSumo and others. This is important for marketing and selling products effectively on various online marketplaces.

There will be continuous updates to Coupon Code Maker. Get it now for a 1-time payment and you'll get all future upgrades for free.

If you're wondering how to build something like this check out Spreadsheet Automation 101 and Supercharge Your Sheets, two courses available for monthly members and lifetime members alike.

Intermediate

Twitter App Clone in a Google Sheet

I built a twitter clone in Google Sheets

Beginner

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

Advanced

Tag Emails From A List of Members in Google Sheets

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.

Advanced

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!

Spreadsheet Automation 101 Lesson 4: OmdbAPI get data in Apps Script

Use getData and UrlFetchApp functions, as well as Logger to get OMDb API data in our Google Sheet. Learn how to access an API outside of Google Sheets.

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

SUBSTITUTE()

5 Ways To Use Google Sheets for Advanced Project Management

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

Intermediate

COUNTIF() FILTER() IF() INDEX() ISBLANK() +3 more

Displaying items 1-20 of 351 in total

TAGS

FORMULAS

TOPICS

351 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

From Sheet to Script And Back Again - Learn to Code In Google Sheets Part 3

Learn to Code in Google Sheets, For Programmers

Write Apps Script to Create a New Google Sheets Formula

Why Code in Google Sheets? - Learn to Code in Google Sheets Part 1

Now Do It Every Damn Day - Learn to Code in Google Sheets Part 5

How to Write a Function - Learn to Code in Google Sheets Part 2

Troubleshooting Bitly in a Google Sheet Script

Create a Radio Button From Checkboxes Using Google Apps Script

Copy That, From One Sheet to Another - Learn to Code in Google Sheets Part 4

Wrap Your Mind Around This - Learn to Code in Google Sheets Part 6

Getting Started Coding in Apps Script

How To Set Up Stripe Webhook to Google Sheets with Google Script

Generate Coupon Codes from a Google Sheet - Announcing Coupon Code Maker

Twitter App Clone in a Google Sheet

Seek Errors When Coding Apps Script

Tag Emails From A List of Members in Google Sheets

Quickstart Tutorial OpenAI API in Google Sheets

Spreadsheet Automation 101 Lesson 4: OmdbAPI get data in Apps Script

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

5 Ways To Use Google Sheets for Advanced Project Management