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
0
votes
0 answers

How to know which Google Apps Script API is the reason for a scope?

Background: I'm the creator of PlantUML Gizmo, one of the first Google Docs add-ons. As such, it's a kind of legacy add-on, and I began the development long before there were today's processes of managing OAuth 2.0 scopes and consent (which are…
Fuhrmanator
  • 11,459
  • 6
  • 62
  • 111
0
votes
1 answer

Call function in add-on with user authorisation using Execution API

We are looking for a way to trigger a function in the add-on in the user's context (authorization) from our web app. We tried using Apps Script Execution API to trigger that. The flow is add-on (apps script) registers the access token in our web app…
Michaes
  • 73
  • 6
0
votes
1 answer

How to use scope "https://www.googleapis.com/auth/script.webapp.deploy"

When you add this scope inside oauthScopes section in your appscript.json file: "oauthScopes": [ "https://www.googleapis.com/auth/script.webapp.deploy", ] you will see something like this when you attempt to use the addon: As I…
0xh8h
  • 3,271
  • 4
  • 34
  • 55
0
votes
0 answers

How to fix 'error TS2345: argument of type' ' is not assignable to parameter of type 'Params$Resources$Scripts$Run'

I am trying to utilize the google apps-script API to run a premade google apps script. Unfortunately all of the sample documentation is not made for Angular, but node.js is similar and I have been trying to redo it in angular. I keep getting this…
Shamison
  • 11
  • 2
0
votes
1 answer

Is this setup of using a webapp and api executable secure and reasonable?

The problem We (me and a colleague) have some code that fits the use case of a webapp nicely, except for authentication of users outside of our domain. If not for this problem, we would have liked to use the following configuration (at the top level…
jano
  • 59
  • 1
  • 5
0
votes
2 answers

UrlFetchapp response error {"success":false,"error":"org.json.simple.JSONArray cannot be cast to org.json.simple.JSONObject"}

When I am calling API in Google appscript using method UrlFetchapp getting error as org.json.simple.JSONArray cannot be cast to org.json.simple.JSONObject Google appscript using method UrlFetchapp getting error as org.json.simple.JSONArray cannot be…
Mukundha CHar
  • 11
  • 3
0
votes
0 answers

Deploying Apps Script as API Executable with a given version throws error when making requests to Apps Script API?

Before I get into the details, the basic error is that a json response from postman for making requests to the Apps Script API Either returns a success or failure solely depending on the version of the script I have selected as an API executable.…
Jaden Ranzenberger
  • 69
  • 10
0
votes
1 answer

Identifying the spreadsheet to use in Google Script Editor

I am trying to automate a google spreadsheet on google script editor. However, when I try to identify the spreadsheet and select as the one that we are working on, it is written in the documentation cited below (openById) that scripts that use this…
Sabrina Chow
  • 1
  • 1
0
votes
1 answer

GCP project created by an app authorized by me, but I do not have access to it?

I'm developing some automation/integration between a CRM software and my google account. I am attempting to use the Google Apps Script API so I can remotely execute functions in Google Apps Script through the integration I'm building from within the…
Jaden Ranzenberger
  • 69
  • 10
0
votes
1 answer

Export Single sheet and save as sheet name

I have a workbook with multiple sheets in it. I have set it up so that on the main page you can click export next to the sheet name and it exports that sheet to xls. Is there a way to export the sheet and save it as that sheet name rather than the…
user9499643
0
votes
1 answer

How to programatically copy script permissions for a file bound script in Google Apps Script?

I'm trying to implement a performance evaluation system using google sheets + forms. Overall, what I need to do is generate a form for each user, according to a template. After the user has submitted an answer, I need to edit the form, in order to…
Lucas Lima
  • 832
  • 11
  • 23
0
votes
1 answer

App Script Execution API with Service account - HTTP 400 Invalid arguments

I am running the Google App script executable API from a Python script. I am doing this using a service account so that it can be scheduled for unattended run. I have tried to do this using my own account and OAuth works by opening up a browser page…
umesh shetty
  • 5
  • 3
0
votes
0 answers

Execute Google Apps Script via ruby script ( `check_status': notFound: Requested entity was not found. (Google::Apis::ClientError)

I have a google apps script that runs a macro to do things on my google sheet. I want my ruby script to execute the macro in the google sheet. I am getting authentication issues when trying to execute. the script. I have used the ruby quick-start…
plgelso
  • 107
  • 2
  • 15
0
votes
1 answer

Google Apps Script script.run -- getting unexpected 401, even while sending Oauth token

I am trying to run a Google Apps script using the Google Apps Script API method scripts.run. However, I get a 403 error with the following error message: { "error": { "code": 401, "message": "Request is missing required authentication…
chiragzq
  • 388
  • 1
  • 14
0
votes
0 answers

apps-script contacts api synchronus issue

I am trying to add/create/get contactGroup based on each contact info by Google Apps Script. But I have faced asynchronous error while I am using app-script/contacts API. I can't get latest contactGroup list(it doesn't include contactGroup just…
Sandokan
  • 667
  • 5
  • 14
1 2 3
…
14 15