Members-only tutorial
Watch the video and get the practice sheet with membership.
About this Tutorial
Video Transcript
<div>0:00 Alright, so we have finished our OAuth consent screen unlisted YouTube video. I've already uploaded it is less than a minute long.<br>0:07 It is me just saying, here is the client ID. You will see where Learn how to filter data effectively using the WHERE clause in your queries. Opens in new tab I put that. I have this link here and we have some material as well.<br>0:16 We are back in console.cloud.google.com and we are in the. Project that we already called CPM custom function Discover the different types of functions you can use in your spreadsheets. Opens in new tab . We are now going to go to OAuth consent screen.<br>0:29 We have to find it first.
It is so hard to navigate this series of things, of windows and things that we are going to go to API services.<br>0:40 We are now going to go to OAuth consent screen. We have not yet filled this out yet. We are going to click up here edit app.<br>0:47 So we are on the OAuth consent screen form. We already have our app name. We already have our user support email.<br>0:55 Our app logo, remember we have created that since we have been here before. We will click browse. We are now going to go to OAuth consent screen.<br>1:00 We are now going to go to OAuth consent screen. We will add our logo.
App domain, this is CPM.betasheets.co. We are going to add that here.<br>1:11 Our privacy policy link is the same URL plus privacy-policy. We will double check that. That is a totally fine URL.<br>1:23 It's fine. We are going to copy-paste this here and instead of privacy policy it's terms of service. Just double check that it's correct.<br>1:34 Yep, there's our terms of service. Authorized domains are fine. See you again soon. Our scopes should be the same. Scopes are fine.<br>1:47 Save and continue. Test users. We don't have any. And now we are at the place. Okay, back to dashboard Understand how to create and manage dashboards for better data visualization. Opens in new tab .
Now what we want to do is publish Find out the steps to publish your app and make it available to users. Opens in new tab app.<br>1:58 Push to person. Your app will be available to any user with an ink. Google account. You've configured your app in a way that requires verification.<br>2:05 To complete verification, you need an official link to your app's privacy policy. We have that. A YouTube video showing how you plan to use the Google user data Explore how to manage and manipulate data within your sheets. Opens in new tab you get from scopes.<br>2:14 We have that. Oh, I think when I first made this, like the very first time, I actually literally explained. How I'm using the data Explore how to manage and manipulate data within your sheets. Opens in new tab .<br>2:24 And you only need to explain that. You don't need to go very deep.
You have to say, I get user data Explore how to manage and manipulate data within your sheets. Opens in new tab in this way, and this is what it is used for the user.<br>2:33 Written explanation telling Google why you need access to sensitive or restricted Get insights on restricted data access and how to handle it. Opens in new tab user data Explore how to manage and manipulate data within your sheets. Opens in new tab . This is, I think I will show you in this video.<br>2:41 And all your domains. And you can see that I'm not sure how I did that. I don't remember. To be honest.<br>2:51 We're gonna hit confirm. And then now we have prepare for verification. And so we should have some more things to fill out.<br>3:00 We have a privacy policy. Authorize domain. Save and continue. Where Learn how to filter data effectively using the WHERE clause in your queries. Opens in new tab is it? Here it is.
How will the scopes be used?<br>3:09 Interjustification here. And here we have our YouTube link. So let's get our YouTube link first. Put that there. Okay, this is what I wrote.<br>3:19 Just a couple of sentences. You can make this a little bit bigger. Can we make this a bit bigger? I'm using Script Container UI Scope to show the user a prompt screen with more information about the Google Sheet add-on Learn about add-ons and how they can enhance your spreadsheet functionality. Opens in new tab and custom function Discover the different types of functions you can use in your spreadsheets. Opens in new tab they're using.<br>3:32 That is it. That's all I'm saying. Don't need to go too much. It's only a thousand characters here.
Save and continue.<br>3:40 This is all optional information. Aang! Filling it out. Save and continue. Done. Now my usage of OAuth Scope complies. Submit for verification.<br>3:52 Ver-ver-verification. Your app has been submitted. We will get an email, I think. We'll get an email in a couple days, or a few days or within a week or- up to two weeks or something.<br>4:05 Depends, this- this is very weird.
Obviously I'm doing this on a Friday, so maybe it'll be a couple more extra days.<br>4:14 The email you'll get will say either accepted or rejected, probably will say rejected for some reason, or they'll ask additional information.<br>4:20 So look out for that.</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