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
14
votes
3 answers

Can the Google Apps Script Execution API be called by a service account?

I'd like to use a service account to access a Google Sheet via the Apps Script Execution API, but it's not clear from the documentation whether this is supported. The steps I've tried (which result in a 403 status from the Execution API)…
Stephen L
  • 181
  • 1
  • 4
14
votes
6 answers

Why does my apps script deployed as API executable return Permission Denied?

I created a script in the script editor, published it as a "Deploy as API executable". Inside this script, I provided a doc_id to my sheet and defined a function to get data from that sheet. I then went to…
Bellave Jayaram
  • 366
  • 1
  • 2
  • 11
9
votes
1 answer

How to create application type "Other" in OAuth Client ID in Google

I want to execute Google Apps Script from external Node.js App. And I tried the following manual, Step3. https://developers.google.com/apps-script/api/how-tos/execute#step_3_configure_the_calling_application According to 1-c "Choose Other when…
Sesame
  • 111
  • 1
  • 3
5
votes
3 answers

Google apps script execution API service authorization fails once per hour

I'm executing a Google apps script with my C# app about once every 1.5 minutes. The apps script moves content between spreadsheets, and edits sheets. I also use the Drive API. My script runs fine over long periods, except for the fact that I get an…
Coert Grobbelaar
  • 627
  • 4
  • 14
4
votes
2 answers

Apps script that shares a google sheet to a specific group of people

I have an apps script that creates a new Google worksheet each time a new entry is made in Column A of sheet1 of a Master Sheet and renames that new worksheet to the last entered data in column A of sheet1 of the Master Sheet. It also pastes the URL…
Damilola Ogundun
  • 59
  • 6
4
votes
1 answer

GCP App Script API Auth not working (code: 403, "PERMISSION_DENIED") for just two users

I have Google Apps Script-based software deployed to multiple users via Google Cloud Platform. Most of it works via triggers running every x minutes. However, currently there is one script that runs by being called through Apps Script API. I made…
Chris
  • 473
  • 5
  • 18
4
votes
1 answer

How to get Google Apps Script project ID linked/bound to a Google Spreadsheet

I have a task to update Apps Scripts linked to some Spreadsheets using Google REST APIs. I know how to update script if I have script Id, but the problem is that I have only spreadsheet Id, and I need to updated linked/bound script. I didn't find…
Rustem Zinnatullin
  • 386
  • 3
  • 12
4
votes
2 answers

Error 429 Resource has been exhausted (e.g. check quota) when creating new Apps Script projects

It appears an unidentifiable Apps Script project creation via Apps Script API usage quota exists and has been reached on my end (i.e. the IAM & admin console indicates all API usage is well below its limits). The resource limit appears unspecified…
user10194781
4
votes
2 answers

Google App Script API cannot authenticate "Request contains an invalid argument"

I am pretty much using the sample from google's own site https://developers.google.com/apps-script/api/how-tos/execute The relevant part of the sample python script is replicated below from __future__ import print_function from googleapiclient…
Parit Sripakdeevong
  • 51
  • 1
  • 4
4
votes
1 answer

How to run Google App Script function from Google OAuth 2.0 Playground | The caller does not have permission

I have created a new script which creates "Google Form" on my google account. Following is the sample code: function myFunction() { var form = FormApp.create('New Form'); var item = form.addCheckboxItem(); item.setTitle('What condiments would you…
Kamaldeep Singh
  • 765
  • 2
  • 8
  • 28
4
votes
1 answer

Running Apps Script on Android?

I am currently developing an Android app that requires the user to log into Google, and then get verified by running an Apps Script to figure out whether the user is part of a Google Group (I haven't been able to figure out how to do this outside…
PabloJ
  • 199
  • 1
  • 9
4
votes
1 answer

Get Bounded Script ID from another project

Is there a way to get the id of a script embedded in a spreadsheet (not the id of the spreadsheet) from another script (in other file)? I have a main standalone script that copies a spreadsheet that contains a script (web app code). I need to get…
Luis
  • 51
  • 1
4
votes
0 answers

How can I publish a Google App Script using a domain-wide-delegation service account?

I'm trying to use the what Google terms a 'Domain-wide delegation' service account: https://developers.google.com/admin-sdk/directory/v1/guides/delegation The specific API I'm trying to access with this delegation is:…
Marcos Scriven
  • 581
  • 1
  • 5
  • 15
4
votes
1 answer

Programmatically access Execution Transcripts

I need to access the Execution Transcripts like accessing the Logger logs. For example, I could set Logger.log data to a spreadsheet cell or email using getLogs(). How to access Execution Transcripts in a similar way?
TheMaster
  • 45,448
  • 6
  • 62
  • 85
4
votes
1 answer

404 error when using Apps Script Execution API in Python

I keep getting a 404 error when trying to use the Apps Script Execution API. I've made sure that the project ID is correctly linked, and that the correct API is turned on. This is the traceback I'm getting: Traceback (most recent call last): File…
JStew
  • 437
  • 3
  • 7
  • 19
1
2 3
…
14 15