We need to take screenshots of the add-on in action. These will be available for users to see how the ad-on works with in the Google Workspace Marketplace. We'll also use these same screenshots later on for launching and on our website.
In this section of our Add-on course we'll get out of sheets for a bit and create marketing materials. I'll show you the templates I use to make websites very quickly. hint: It's CARRD!I'll also show you how quickly I make the banner and logo. You might be as quick if you have your own company logo or you already have something made.
A little bit about how to write scopes and where to write them. For your own add-on these might change.
We need to fill out our Apps Script manifest. In this video I show you how to get that to show up in our Apps Script.
We need to bridge the gap between an add-on not being installed to actually being installed. We add a simple apps script.
Instead of just adding a custom menu to a sheet, we're going to turn this apps script into an add-on menu operable add-on.
In this section we're going to turn our apps script into an add-on. complete with add-on menu. (Yes it's different than a custom menu, slightly).The things I go over in this section took a lot of trial and error. The first time I created a Google Sheets Add-on I was flabbergasted that it just didn't work like a Google Sheets Add-on. Until I did all the things I go over in this section.
The most important part of the whole add-on creating process is naming it correctly. Avoid any and all existing names, as well as avoid any names that might conflict with Google Sheets itself.
We'll make sure our additional custom formula acts like a native formula with autocomplete in a cell.
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.
Discover what an Add-on is, what it could possibly do and what kind of problems an add-on can solve. There are much more in depth idea driven videos later in the course. For those who might want to know exactly what an add-on is, this video help you out!
In this course we'll go step by excruciating step how to take a simple apps script from a bound script to your spreadsheet and turn it into a published Google Sheets add-on available to the public on the Google Workspace Marketplace.
This is a review and improvement of Emmett Shear's Life to Date Sheet. Originally he tweeted about it and shared a sheet. I thought I could make it a bit better looking.
Two things I would teach every beginner to immediately improve your skillset in Google Sheets: 1. How to Combine Formulas2. How to Copy/Paste Apps Script Code to Your SheetLearn these two things in this quick video going over why I think these are important. And how unintuitive they are to beginners!→ Learn more about Formula Combinations→ Learn more Apps Script in Spreadsheet Automation 101
If you type the letters of PRIDE in the first 5 columns in the first row of your sheets they'll turn the color of the pride flag. If you want to create your own easter egg in sheets then follow along this step-by-step tutorial as I show you how.This might be better than Conditional Formatting! We're using the onEdit() simple trigger in Apps Script..