Transfer data from one spreadsheet to anotherone

[Guille]

I've been working on a script and I want it to get data to the active spreadsheet from a different spreadsheet when interacting with a menu in the active spreadsheet. When trying to do so with only the function that does that it executes correctly. But when I try to do it when I have many other functions doing different things in the same script it appears the following error:
Exception: You do not have permission to call SpreadsheetApp.openById. Required permissions: https://www.googleapis.com/auth/spreadsheets

I realized that when doing it with only the function that calls the SpreadsheetApp.openById and not many other functions it requests the permission "See, edit and manage all your Spreadsheets". However, when I try to execute it with many other functions this permission changes to "View and manage spreadsheets where this application is installed.".
I have the  https://www.googleapis.com/auth/spreadsheets  permission added in the Google Cloud Project that corresponds to the script.

How can I solve that?

[Jim Willeke]

I assume this is running locally?

You probably need to add the scopes to the appsscript.json" manifest file

https://developers.google.com/apps-script/concepts/scopes#setting_explicit_scopes

[Daniel Paes]

i have seen some error like that, try to see if these two spreadsheets its google sheet, if one of them its xlsx this permission can be shown (its a guess because last day i have seen something like that)

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/d10afe3f-a24a-40f5-ae15-2d1d6a0c3cc4n%40googlegroups.com.

--

Daniel Paes Ti, GS Cred +55 (46) 9918-2513  |  www.gscrd.com.br  |  dan...@gscrd.com.br Rua Itacolomi 939, Centro, Pato Branco - Paraná, 85501-240, Brazil

Create your own email signature