<div>0:00 At this stage we have already completed our custom
function
Learn about custom functions in Google Sheets and how to use them effectively.
Opens in new tab
, and that
function
Learn about custom functions in Google Sheets and how to use them effectively.
Opens in new tab
we should not have to touch again. What we're going to be adding to the
app script
Discover the power of Apps Script for enhancing your Google Sheets experience.
Opens in new tab
is extra stuff that really makes it usable as an
add-on
Understand what add-ons are and how they can improve your Google Sheets functionality.
Opens in new tab
.<br>0:16 This is going to be a little tricky, I have to admit. It took me a while to get through all of this, but it should be just a few minutes for each of these videos as we add it.<br>0:27 I'm opening up now Sheet Styles to show you.
This is actually the real code that I used to ship my first
add-on
Understand what add-ons are and how they can improve your Google Sheets functionality.
Opens in new tab
.<br>0:35 This has some
comments
Explore how comments can help you document your code and collaborate with others.
Opens in new tab
here of code that I didn't want to delete yet. What I have been doing is, It is so tricky because if you are familiar with
Apps Script
Discover the power of Apps Script for enhancing your Google Sheets experience.
Opens in new tab
, you have this
function
Learn about custom functions in Google Sheets and how to use them effectively.
Opens in new tab
onOpen, which is a common
function
Learn about custom functions in Google Sheets and how to use them effectively.
Opens in new tab
.<br>0:46 I have it in a lot of other videos. I had to change this to create
add-on
Understand what add-ons are and how they can improve your Google Sheets functionality.
Opens in new tab
menu. That was a little tricky, and I had to add this onInstall as well, which we will get into in this set of videos.<br>0:59 We are also going to go through, with this
Apps Script
Discover the power of Apps Script for enhancing your Google Sheets experience.
Opens in new tab
.json, which I will show you
where
Get insights on using the QUERY function with WHERE clauses in Google Sheets.
Opens in new tab
to go.
We will do some auth scopes a little bit with a custom
function
Learn about custom functions in Google Sheets and how to use them effectively.
Opens in new tab
.<br>1:11 You don't need anything. Oh, and I can also show you, one second. We will also be adding this alert as well.<br>1:20 This, I need to do, in Spintax one. In Sheets Styles, I had, I did not have that. I had a
sidebar
Find out how to create and use sidebars in your Google Sheets add-ons.
Opens in new tab
.<br>1:28 But as a custom
function
Learn about custom functions in Google Sheets and how to use them effectively.
Opens in new tab
, it
sort
Learn sorting techniques to organize your data effectively in Google Sheets.
Opens in new tab
of has a lack of menu items because you just use the
function
Learn about custom functions in Google Sheets and how to use them effectively.
Opens in new tab
. But this alert was important.<br>1:36 I had to add this.
So it adds a little bit of extra stuff, but you'll see, in our Oethscopes, we will literally just copy and paste this.<br>1:46 And anything in this next section of videos that you'll see me doing, I'm copy and pasting from the ones that worked.<br>1:54 You're going to be able to access this sheet, or at least a copy of the sheet with all of this stuff, if you just want to copy paste and then, it as you go.<br>2:03 You're more than welcome to do that.
But you will have to, you'll see in the
Apps Script
Discover the power of Apps Script for enhancing your Google Sheets experience.
Opens in new tab
Manifest one, you have to do a couple things.<br>2:09 And the Google Cloud Project one, it's going to be a little tricky because you have to use your own console.<br>2:14 But we'll walk through that. Let's go make it useful or usable.</div>