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

Google Apps Script function not found : function_name

I'm trying to run a script using google-apps-script RESTful API. When the script is being executed, I always get an error saying Script function not found: function_name. Where is it that I'm going wrong? This is for a new project where there is a…
Yadavalli Santosh
  • 79
  • 5
1
vote
1 answer

How to deploy Google Sheet as Web-app using Google API

I have a little proble with Google Sheets API I have a Google Sheet Document on my GDrive. And I can work with it using Google Sheets API and Google Drive API. So I can move it, update it or make copies. My task is: 1. make a copy of this document…
GhostKU
  • 1,898
  • 6
  • 23
  • 32
1
vote
0 answers

ScriptApp.getService().getUrl() is returning null, after publishing the App

my return type of the following code is returning null even when my code is deployed as web app, ScriptApp.getService().getUrl(); I was trying to link multiple HTML in my google script based application, and I followed this link for doing this,…
Sanat
  • 267
  • 1
  • 5
  • 16
1
vote
1 answer

Apps Script API returning 404 error for existing project. Error returned as HTML rather than JSON

I was attempting to run an Apps Script function using the Apps Script API. I set up the script in the console, and created an oauth client ID for the script. I configured the authorisation screen and deployed the script as API executable. I tested…
Tommy McGuire
  • 11
  • 4
1
vote
1 answer

Apps Script execution API returns unauthenticated

My application uses multiple API's all succesful under the same auth init - except for Apps Script execution API which throws error code 401 with the following message: "Request is missing required authentication credential. Expected OAuth 2 access…
Alejandro Jurado
  • 137
  • 1
  • 3
  • 15
1
vote
1 answer

Deploy new version of Apps Script using Google Apps Script java API

I am using the Google App Script java API to deploy the code. I am performing the following steps: 1. Update the latest code Content content = new Content(); content.setFiles(files); Content updatedContent =…
Mithun
  • 7,747
  • 6
  • 52
  • 68
1
vote
0 answers

Permission denied to execute function

I am trying to run the code given below, where "myApp" is function Name in the Script which one I am trying to run. ExecutionRequest request = new ExecutionRequest().setFunction("myApp").setDevMode(true); try { Operation op =…
Vipin Pokhriyal
  • 13
  • 5
1
vote
0 answers

Receive 403 Forbidden error when calling ProjectResource.Create, but project still created

When I use the Debug Console to execute C#/.NET code to create a new project (ProjectResource.Create(...)), I receive a "403 Forbidden" error. However, I still receive a Project response and the API correctly creates a file in my Drive. Because…
Ryan Toner
  • 91
  • 1
  • 6
1
vote
1 answer

Set an IP restriction on service account

At first, I'm using service account with delegated credentials executing Apps Script API to run a function on Google Apps Script from a Python script via Google's Python client library, and it just works fine. I'd like to add some IP restriction for…
rueyjye
  • 11
  • 2
1
vote
1 answer

How to rename project with Google Apps Script API

Is there any way to rename Google Apps Script project using API? I can't find any appropriate method for this. UPD: I want to change Project's name like
GhostKU
  • 1,898
  • 6
  • 23
  • 32
1
vote
0 answers

Google Apps Script - Deploy as web app - now requires me to "Share" the the code

I recently made a simple change to an google app script - once I re-deployed, you can access whichever page is in the: var t = HtmlService.createTemplateFromFile('my1'); But any subsequent attempts to open a different html page by clicking a button…
JBruce
  • 309
  • 1
  • 4
  • 15
1
vote
0 answers

Google Apps Script API - 4 minute Timeout?

The Google documentation states that "Google App Scripts have a 6 minute runtime limit". I've confirmed this limit by running a sleep function which waits for 355 seconds and then returns a value in a browser. However, running the same function for…
FreeZey
  • 2,382
  • 3
  • 11
  • 23
1
vote
0 answers

Google app script import CSVs

Okay. Multiple people use the scanpet app to create csv files of 3 columns [uniformly structured, no headers in csv]. I'd like them to email the created file to a gmail account, then go to a google form. I realize for this to work it's have to be…
Eddie Freeman
  • 11
  • 2
1
vote
2 answers

Can I deploy bound scripts using Google Script API

Google recently made available its new Google Script API, and I think it is a good opportunity to make a long awaited project happen. The context is as follows: A few users, all in a corporate GSuite domain share ~100 sheets, that have the same…
Maxime
  • 1,245
  • 2
  • 14
  • 24
1
vote
0 answers

Standalone Script to Add Bound Script to Google Sheet by Sheet ID

I need to add the same container-bound script to hundreds of google sheets in order to automate a process. I have a separate spreadsheet that catalogues the URLs of all the sheets in need of updates. Does anyone know how to write a script that will…
MellyCopter
  • 51
  • 2
  • 6
1 2 3
…
14 15