Members-only tutorial
Watch the video and get the practice sheet with membership.
About this Tutorial
Video Transcript
<div>0:00 Alright, for this next few videos we are going to need the AppScript.json file here. If you are not familiar with AppScript, I will walk you through how to show that and get it.<br>0:11 Super easy. In my CPM custom function Learn about functions in Google Sheets and how they can enhance your spreadsheets. Opens in new tab , again, this was just a sheet done here just a few minutes ago. And so you will not see this AppScript.<br>0:21 Manifest.
What we need to do is go over to the left side of the screen and we will see some project settings.<br>0:28 We will actually come back to this when we need to add our Google Cloud Platform, but I don't want to get too ahead of myself.<br>0:36 Before we do that, if you see these three check boxes, one says log uncautic. So. And then the last one says show app script Discover what Apps Script is and how it can automate tasks in Google Sheets. Opens in new tab .json manifest file in editor Get familiar with the Google Sheets editor and its features for better productivity. Opens in new tab .<br>0:48 So this whole time app script Discover what Apps Script is and how it can automate tasks in Google Sheets. Opens in new tab .json has been here. We just haven't seen it. So we just click that box and we don't have to save.<br>0:57 We don't have to do anything.
We literally just go back to overview. No, not overview. So sorry, editor Get familiar with the Google Sheets editor and its features for better productivity. Opens in new tab . That's what we're in.<br>1:03 And there it is. That is all. You just click once on that check box and you get your app script Discover what Apps Script is and how it can automate tasks in Google Sheets. Opens in new tab .json.<br>1:09 And how it will look is wherever your time zone Understand how time zones work in Google Sheets and how to manage them effectively. Opens in new tab is. It will be here. You'll have some dependencies if you need them.<br>1:16 I don't use them. But there's some other things we're going to have. Do add here. We're going to do that in multiple videos.<br>1:25 We'll go over the auth, the auth scopes.
But the next thing in the next video I want to go over is the Google cloud project, which will take a little bit of time to do.<br>1:34 But if you're looking for your app script Discover what Apps Script is and how it can automate tasks in Google Sheets. Opens in new tab that Jason, that's where Explore the Query function's WHERE clause to filter data in Google Sheets. Opens in new tab you go. You go to project settings, check off this box show app script Discover what Apps Script is and how it can automate tasks in Google Sheets. Opens in new tab .<br>1:42 And now we have our app script Discover what Apps Script is and how it can automate tasks in Google Sheets. Opens in new tab . We can't. App script Discover what Apps Script is and how it can automate tasks in Google Sheets. Opens in new tab Jason manifest. So oh, did I, did I uncheck it?<br>1:53 Might've, there. Yeah, I did uncheck it. So it disappeared on me, but I just can show it here. There you go.<br>1:58 Go back to editor Get familiar with the Google Sheets editor and its features for better productivity. Opens in new tab . And there it is. It's there. It's there the whole time. All right.
Thanks for watching. Go on.<br>2:05 Watch the next one.</div>
Courses
Introduction to Google Sheets™ Add-on Course
What is an add on? What problems can it solve?
MAKE Your Google Sheets Add-on WORK
Write Apps Script to Create a New Google Sheets Formula
Add Autocomplete with Custom Function
How to Name Your Add-on
MAKE Your Google Sheets Add-on USABLE
Add-on menu on open
OnInstall to onOpen
Apps Script Manifest
Connect to a Google Cloud Project
OAuth Consent Screen
OAuth Scopes
MAKE Your Google Sheets Add-on DISCOVERABLE
Add-on Logo Design
Add-on Banner Design
Add-on Screenshots
Add-on Web Site
MAKE Your Google Sheets Add-on MARKETABLE
Check Your Google Sheets Add On Works
OAuth Consent Screen Video
Complete the OAuth Consent Screen
OAuth - Action Needed
OAuth Approval Request Granted
Marketplace SDK Install and App Configuration
Marketplace Store Listing
Submit Store Listing for Approval
Rejection!
Marketplace Approval
Marketplace Opportunities
Create an Internal Google Sheets Add-on
How To Update Your Add-on
Upgrade Your Add-on to V8 Runtime Explained