Members-only tutorial

Watch the video and get the practice sheet with membership.

See membership options

Apps Script Manifest

About this Tutorial

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.

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>