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 do I pass an access token to a Google apps script rest API call from the browser?

I have a function that calls an apps script that has been deployed as an executable script. I setup oAuth with the correct necessary scopes in a react app and then I call my API request to get data from the app script. const connectToDrive = async…
Josh Pittman
  • 7,024
  • 7
  • 38
  • 66
0
votes
2 answers

404 error when deploying a Google Apps script via the REST API

I'm trying to deploy a Google Apps script via the Google REST API, and I'm using the API Explorer to perform that. This is the method I am testing: https://developers.google.com/apps-script/api/reference/rest/v1/projects.deployments/create Executing…
Ohm
  • 3
  • 3
0
votes
2 answers

Apps Script API not pasting data into Google Sheets

I'm trying to execute the function by calling it from my Chrome Extension. I can see in my "My Executions" that the chrome extension called the function, but it's not pasting data into Google Sheets. When I try to run that function from the Script…
Tanveer Jan
  • 61
  • 2
  • 2
  • 11
0
votes
1 answer

AppsScript - How to import output from Project (Error Rate, Executions, Users) to Googlesheet

Hi everyone and thanks for your help. I try to figure it out an APpsScript code/function that allows me to pull the stats (Error rate, Executions, Users) from the "Project Dashboard" and store it into a Google sheet in three different columns. I…
Angel A
  • 11
  • 2
0
votes
1 answer

Remotely update Sheets on client-side with new Library version

I've an question about libraries usage within Google Sheets. I developed a standalone Apps Script published as Library. This library is used by 150 Google Sheets files (I did that to centralize and hide some code from users). Today, I need to update…
Luis Esteves
  • 3
  • 1
0
votes
0 answers

UrlFetchApp.fetch returns "Timeout" after 1min

I got a timeout error after 1 min. from the below code. Can I set a timeout value? function apiPost(token, url, body) { var response = UrlFetchApp.fetch(url, { method: 'post', contentType: 'application/json', headers: { …
seonghwa.park
  • 1
  • 2
0
votes
0 answers

Google Execution API does not work with non-"script owner" user

I call a Google Apps Script project from my website with the Apps Script API, but when I am logged in with another account instead of the owner, the Apps Script function receives no parameter values. When logged in my website with the account that…
DZtech
  • 23
  • 4
0
votes
2 answers

Trying to set permissions for "anyone with link can view" on file uploaded via form "file upload" section

A "File upload" section is used in a form: I need the form user (not owner) to be able to share the file with someone other than the owner of the form. It appears the results of the file-upload in the form puts the file into the current form user's…
Chris Worley
  • 15
  • 4
0
votes
1 answer

403 The caller does not have permission & Request entity was not found

If you're getting errors for Google App Script API: 403 The caller does not have permission. Permission_Denied Forbidden Request entity was not found The answer below should remedy the issue. If you find this helpful, please remember to contribute…
sojim2
  • 1,245
  • 2
  • 15
  • 38
0
votes
1 answer

How do I create and push new files client side?

Simply making files in the directory does not add them to the project. Is there a way to make sure they get pushed with the rest of the project, or am I doomed to creating them in the web editor and then pulling?
J. G.
  • 1,922
  • 1
  • 11
  • 21
0
votes
1 answer

Google Execution API can't find shared function

I stepped through this example to create a Google Apps Script. I've wired up the OAuth2 credentials from a 3rd party javascript application and tried to execute my google apps script via that app. Every time I attempt to it fails with "error":…
plamb
  • 5,636
  • 1
  • 18
  • 31
0
votes
1 answer

How to update spreadsheet bound script using AppScript API?

I intend to update my bound script (destination) with contents from another script (source). I am trying the following code. It does not give any error, but do not modify the destination script either. function getScriptSourceCode() { var…
Partha S. Pal
  • 169
  • 1
  • 2
  • 14
0
votes
1 answer

404, while trying to deploy apps script through App Script API

I am trying to deploy an App Script through the App Script API but keep getting a 404 error - both in the script and the OAuth playground. Script: function createNewFile() { var options,payload,response,theAccessTkn,url, thisID; thisID =…
Alistair Ian Dgb Brownlee
  • 27
  • 5
0
votes
0 answers

403 with `scripts.run` with Google Python API Client

In trying to test the Execution API with the Python Google API client, in which we currently just have a single function that outputs a string, we seem to be getting a 403 with the message "The caller does not have permission". We were able to get…
coltonoscopy
  • 321
  • 4
  • 16
0
votes
0 answers

Executing Google App Script for a remote machine

I'm working on a script based on the documentation given here. My idea here is to trigger a google app script which does some updating work in the google spreadsheets. I've all the details (listed below) required to trigger the app…
sdgd
  • 723
  • 1
  • 17
  • 38
1 2 3
…
14 15