Members-only tutorial

Watch the video and get the practice sheet with membership.

See membership options

OAuth Scopes

About this Tutorial

A little bit about how to write scopes and where to write them. For your own add-on these might change. 

Video Transcript

<div>0:00 Okay, so honestly this process of OAuth scopes might seem intimidating and it might seem actually really hard. I will show you how to get through this.<br>0:09 In particular my spin tax custom function Learn about functions in Apps Script and how they can enhance your projects. Opens in new tab had these two OAuth scopes. They will have spreadsheets.current only and then script.container UI.<br>0:20 So I just will copy paste this into, just to keep a record Understand how to keep track of your OAuth scopes and other important data. Opens in new tab of it, into my editor Explore the Apps Script editor and its features for better coding. Opens in new tab , into my Apps Script Get insights into Apps Script and its role in automating tasks. Opens in new tab manifest file.<br>0:31 I will add a comma at the end of here and add these OAuth scopes.

I just want to have this in my Apps Script Get insights into Apps Script and its role in automating tasks. Opens in new tab .<br>0:36 I want this as well because this particular part of the OAuth consent screen. I need these OAuth scopes. I'll show you sort Discover sorting techniques to organize your data effectively. Opens in new tab of a trick to do.<br>0:47 If you go and add scopes, you're going to have to go through these and figure out what to do. Don't not worry about it.<br>0:56 Do your research beforehand. Make sure you have the right scopes. And then come down here to manually add scopes. That URL that you have in your OAuth scopes, again, I'm just making a custom function Learn about functions in Apps Script and how they can enhance your projects. Opens in new tab .<br>1:09 I need only spreadsheets.

Currently and I need script.container to have that alert. This script container is the problematic one and we'll get through that.<br>1:20 You'll see how I will just add to table Find out how to manage tables in your Apps Script projects. Opens in new tab and there it is. It just shows up. Sort Discover sorting techniques to organize your data effectively. Opens in new tab of like magic.<br>1:27 I sort Discover sorting techniques to organize your data effectively. Opens in new tab of don't even like this process because I keep thinking that I'm doing it wrong. Like, do I really just add to the table Find out how to manage tables in your Apps Script projects. Opens in new tab or I always try to like search for one.<br>1:36 Let's see. I always try to search for it and it just doesn't come up. So just manually adding to the table Find out how to manage tables in your Apps Script projects. Opens in new tab .<br>1:42 Here they magically show up checked. Great.. And that's it.

Click update for the scopes. That is all you have to do.<br>1:53 You think you have to like fill in information here, but you don't yet. You might have to give some reason test users skip it.<br>2:01 They even continue and here's OAuth consent screen all done. We have not provided any of this. We will come back to it.<br>2:09 I think we can come back to it. I think that's it. It is done. So now we should be able to go to our project settings, change project and get out.<br>2:23 Or number Learn how to work with numbers in your scripts and calculations. Opens in new tab . Where Understand how to use query where clauses for data filtering. Opens in new tab is it? Let's just click on APIs and services. Nope. Gotta go to cloud overview.

Here's our project number Learn how to work with numbers in your scripts and calculations. Opens in new tab .<br>2:35 Let's go to our GCP project number Learn how to work with numbers in your scripts and calculations. Opens in new tab . Set project. And it is done. We have set our cloud, Google Cloud Platform project.<br>2:48 Again, Apps Script Get insights into Apps Script and its role in automating tasks. Opens in new tab projects need to use us to manage authorizations. We will come back and later on in the course.<br>2:55 We have, we have to make all the logos, all the banners, screenshots and all that. And we'll make a website.<br>3:00 It's super easy. At least the way that I've done it.

With card and I have a template Explore templates for creating consistent and efficient Apps Script projects. Opens in new tab that I just copy each time and I add a privacy policy, terms of service and all that stuff.<br>3:09 You will see how I do that in the next section called Make it Findable.</div>