Stack Overflow
Stack Overflow

Questions tagged [google-apps-script-api]

DO NOT USE THIS TAG ALONE. Use for questions regarding programmatic manipulation of Google Apps Scripts through the REST-Google Apps Script API. Use in addition to the language tag (like [python], [java], [c#]) and the google-api library tag(like [google-api-java-client]) that is used to do the said manipulation.

The Apps Script API offers programmatic control of Google Apps Script projects to 3rd party applications via a REST API. It is an extension of the previous "Execution API," now enabling client applications to perform actions that were previously only available inside the Apps Script editor, such as create projects or manage deployments.

221 questions
1
vote
1 answer

Datetime seems to break Google Apps Script client-side deserialization

I've uncovered an odd bug with Google Apps Script's web interface that it can't seem to transport datetime values from the server side to the client. // Code.gs function fetchData(){ var spreadsheet = SpreadsheetApp.openByUrl(SHEET_URL) var…
NealJMD
  • 864
  • 8
  • 15
1
vote
1 answer

How can I use User/Pass authentication method for a third party service with Data Studio Community Connectors?

I'm trying to create a connector that fetch data from an API. The API authentication need username and password and return a token in the end. For now I'm using TextInput element of the getConfig() methode to get username and password from the…
bilalo
  • 129
  • 1
  • 1
  • 7
1
vote
3 answers

Google Service Accounts / API - I keep getting the Error: Access not granted or expired. (line 454, file "Service")

I've searched for hours for an answer to this, so please bear with me! I'm using Apps Script to connect to the Google Drive API. I have created a service account in Console, and collected the relevant credentials. I've got the following…
sitestem
  • 21
  • 4
1
vote
1 answer

Deploying Script as Webapp directly from Sheets

Is it, at all, possible to deploy a Google Scripts as web app directly from Google Sheets? I am trying to add a custom menu to Google Sheets where the user can programmatically deploy the file's script as a web app. And it looks like it is possible…
Byron
  • 63
  • 6
1
vote
0 answers

Google Scripts API, get "User has not enabled the Apps Script API" even though its enabled

I am trying to use the Google Scripts API. I run projects.create through the npm package and I get the following error: Error: User has not enabled the Apps Script API. Enable it by visiting https://script.google.com/home/usersettings then retry.…
Marcelo Mason
  • 6,750
  • 2
  • 34
  • 43
1
vote
2 answers

403 accessing programatically created sheets project endpoint through Apps Script

Used code to create a blank spreadsheet and obtain it's Id. Once the Id of the resource is available I want to attach a custom script to it programmatically. [...] var newSpreadsheet = SpreadsheetApp.create("Опис "+dateFormated); …
Petyo Zhechev
  • 13
  • 3
1
vote
0 answers

Can not deploy Google Apps Script API Executable using clasp

I am using clasp to operate Google Apps Script with CLI. Now I want to create a new version and deploy it as API executable. So I have tried to run the following command by referring to the link…
saito_ya
  • 11
  • 1
1
vote
1 answer

Google Drive API cannot handle large App Script project upload

I could not find any documentation on limits for App Script project file size, but it seems that is my problem. I have a large JS file that must be added to a App Script project - the resulting JSON for the project has 5.4 MB. I tried to use the web…
MarceloCosta
  • 11
  • 3
1
vote
1 answer

Google app script can not insert image to spreadsheet sometimes

My project has been written by Ruby on Rails, since google-api-client gem does not support inserting the image to spreadsheet through sheet apis, so I am using Google app script to handle this task. Most of times, the inserting has been success with…
Tiktac
  • 966
  • 1
  • 12
  • 32
1
vote
1 answer

REST API failure: Invoke-WebRequest : 404

The Powershell code bellow writes and reads values to Google Sheets (works fine) and should run the function myfunction in an Apps Script project using API, but Invoke-WebRequest returns the error bellow: Invoke-WebRequest : 404. That’s an error.…
Cleber Marques
  • 426
  • 5
  • 20
1
vote
0 answers

Assigning a macro to a cell instead of a drawing/text box

Is it possible to assign a macro/script to a cell in Google Sheets to cut out the need to have a drawing/text box to assign it to? I have a header in A1 which, when clicked, I would like to to take me to another sheet. The script I have works, it…
The_Train
  • 319
  • 3
  • 11
1
vote
1 answer

Issue with scopes when switching Google Apps Script projects to V8 runtime

Due to Google Apps Script forcefully pushing "Rhino" to "V8" engine, Applications are moving from Rhino to V8 automatically. So our applications are asking "scopes" that need to be specified manually in "appscript.json" file. Please check the below…
Ramachandra-Sah GANESH
  • 31
  • 3
1
vote
0 answers

programmatically enable a specific appscript for container bound sheets

I would like to programmatically enable a container bound appscript. i can able to create app script via an api and attach to a sheet. problem is if the sheet already have another app script enabled ,that script is working instead of my script…
user4206843
1
vote
1 answer

Get current script version in google app script

I have created a library and want to check if others are using the latest version or not. If not, one mail regarding the same should be sent?So, is there a way to get the current version of a Spreadsheet script using Google app script ?
John
  • 19
  • 1
1
vote
1 answer

How to refresh an OAuth token before calling the Execution API?

I am calling the app script execution API from my web app. I am getting ScriptApp.getOauthToken() and storing it inside sheet. When I open my web app I will get the stored access token and calling the execution API with the help of it. But the…
Mithun Walawakar
  • 13
  • 4
1 2 3
…
14 15