How to request or get the permission of google spread sheet access in the apps script of other sheet?

c-an Published at Dev

c-an

I am writing apps script of A spread sheet for my custom functions and trying to get values in B spread sheet from there using openUrl()

However, I got ERROR in A spreadsheet when I use the custom function..

in Google Document, it says

If your custom function throws the error message You do not have permission to call X service., the service requires user authorization and thus cannot be used in a custom function.

ref: https://developers.google.com/apps-script/guides/sheets/functions

However, it doesn't say anything how to get the permission..

I tried with sharable link to everyone but it didn't work.
I tried with url&scope=https://www.googleapis.com/auth/spreadsheets

Both way didn't work. How can I solve this problem?

Sourabh Choraria

Unfortunately, what you're asking for cannot be done directly. In the same documentation, please scroll all the way down to sharing; that's -

Custom Functions in Google Sheets > Advanced > Sharing.

Here, you'll see the following -

Custom functions start out bound to the spreadsheet they were created in. This means that a custom function written in one spreadsheet can't be used in other spreadsheets unless...

If it suits you, you can make use of the 3 methods that they've listed there to overcome this problem.

Hope this helps!

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2020-12-12

Comments

0 comments

How to request or get the permission of google spread sheet access in the apps script of other sheet?

How to request or get the permission of google spread sheet access in the apps script of other sheet?

pump.io port in URL

Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)

Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

How to import an asset in swift using Bundle.main.path() in a react-native native module

Failed to listen on localhost:8000 (reason: Cannot assign requested address)

Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3

Using Response.Redirect with Friendly URLS in ASP.NET

Can a 32-bit antivirus program protect you from 64-bit threats

Double spacing in rmarkdown pdf

How to fix "pickle_module.load(f, **pickle_load_args) _pickle.UnpicklingError: invalid load key, '<'" using YOLOv3?

3D Touch Peek Swipe Like Mail

Bootstrap 5 Static Modal Still Closes when I Click Outside

Assembly definition can't resolve namespaces from external packages

Vector input in shiny R and then use it

Emulator wrong screen resolution in Android Studio 1.3

Svchost high CPU from Microsoft.BingWeather app errors

Graphics Context misaligned on first paint

Python connect to firebird docker database

Is this docker-for-mac password dialog legit?

How to save models trained locally in Amazon SageMaker?