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

Speed up adding Items to Forms with Apps Script

I'm wondering if there is a more efficient way to add Items to Google Forms with App Script. My script is taking a long time and I'm wondering if there's anyway to add items more efficiently using an array or something rather than one by one. Here's…
Sherif
  • 13
  • 3
0
votes
0 answers

NodeJS Request is missing required authentication credential. Expected OAuth 2 access token, login cookie or other valid authentication credential

I am trying Google Apps Script API. I receive this Request is missing required authentication credential" error by trying service.scripts.run({ // params }). Can somebody help me figure out, how to authenticate credentials? I am using…
jnewbie
  • 1
  • 1
0
votes
1 answer

How to allow other user to execute script on Google Apps Script

I have script that works fine on my account but I want other user to be able to use that script over API Executable. var serviceScript = new ScriptService(new BaseClientService.Initializer() { …
wedo
  • 129
  • 1
  • 11
0
votes
1 answer

Enable other users to run Google App Script Function on protected sheet

I'm new to Google App Script and have created this function that allows members to submit data through a form. I want to protect the sheet where form records the data in so that the other users can't modify them post-submission. Problem is, when I…
din2345
  • 33
  • 5
0
votes
0 answers

How to specify standard GCP when using Apps Script API to create project?

I would like to mimic the functionality under "Switch to a different standard Cloud project" here using the Apps Script API in Python. When I create a Script Project using the API it gets created such that it uses a Default Cloud Project and from…
alec
  • 1
0
votes
1 answer

Running Google Apps Script for a Google Doc from inside a Google Chrome extension

I am trying to make a chrome extension that adds an extra custom menu to google docs. I have already figured out how to make an extension, and I also have figured out how to make an extra menu in apps script. I just can't figure out how to run the…
Gibson DeGroot
  • 1
  • 2
0
votes
1 answer

Is there branching functionality on a Google Apps Script Project?

I am new to Google Apps Script projects, and have a Google Calendar add-on that I have been working on. My users recently came across some bugs, and I realized that I had no idea how to go back to the version they were on, and save the current…
Andrew
  • 9
  • 1
0
votes
1 answer

Use base64 encoded image in Google Chat card image widget

I am using the Google Chat card api to send a card back to a user to answer their questions. I wish to include an image within the results, however a direct URL cannot be provided since it is only exposed to the company network. Instead I have…
Michael Pulis
  • 35
  • 4
0
votes
1 answer

403 The caller does not have permission when calling Apps Script API from a Cloud Function

I'm building a Workspace addon that you launch from Google Drive and that will be executed as a background task. To do so my apps script addon calls a Google Cloud Function that calls the Apps Script back using the Apps Script API. I do see because…
ValLeNain
  • 2,232
  • 1
  • 18
  • 37
0
votes
0 answers

How to insert text in google docs through function execution script API

I opened a google doc. In that document created a app script function (attached function code img) in this function i am trying to insert some text(document cursor location) in current active document. So calling this function through script run…
Rajat Kulhari
  • 1
  • 1
0
votes
0 answers

Want to change Google slides element location based on sheets value

I have a Google slides presentation that I've set up to get populated by values in a Google spreadsheet via an Apps Script below function fillTemplate() { var Presentation_ID= "###"; var Presentation=SlidesApp.openById(Presentation_ID) var…
Phill In the Blanks
  • 1
0
votes
2 answers

"The script completed but the returned value is not a supported return type."

I created a very simple app script that returns ContentService.createTextOutput("Hello"), associated it with a Google Cloud project, and created a JavaScript program to get the return value. I can successfully execute, deploy, and use the link from…
Ethan Strominger
  • 173
  • 1
  • 5
0
votes
1 answer

Google Apps Script API give entire organization read access for a Script

I am developing an add-on for Google Docs. The add-on is being constantly updated and therefore I have created an auto-update mechanism which works by saving the last script version used to a Document Property for each document, and then I check if…
Yuval.R
  • 1,182
  • 4
  • 15
0
votes
0 answers

Iterating API parameter in google app script

I'm trying to use this API to fetch data directly in my google spreadsheet, I'm using Google AppScript. Below is my API =ImportJSON("https://rest.yyy.com/v2/matches?date=2022-06-01(Date start - yyyy-mm-dd)_2022-07-02(Date end -…
Yogesh
  • 13
  • 6
0
votes
0 answers

Google Calendar trigger - Script function not found

I implemented a Google Calendar AddOn for hundreds of users which also installs a calendar trigger for each user to run some business logic whenever something changes in the user's calendar. The trigger code is located in a different AppScript and…
zlZimon
  • 2,334
  • 4
  • 21
  • 51
1 2 3
…
14 15