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
votes
1 answer

How do I connect a script application to the Google Cloud Platform?

How do I connect a script application to the Google Cloud Platform? I found how to do it manually. But how to do it programmatically? File file3 = new File() .setName("appsscript") .setType("JSON") .setSource("{\n" …
Александр Хворостенко
  • 59
  • 5
-1
votes
1 answer

How to get data from specific cells in a sheet and send them to another sheet into different columns?

How do I make something that sends values from specific cells in a google sheet (say SHEET 1) to another sheet (say SHEET 2)? Can I make a menu button or something that would help me do that? Also, if possible, can I give the PDF link of SHEET 1…
gg0wwrr1
  • 21
  • 6
-1
votes
1 answer

How do I get the subject and body of every mail that I click to my add on that I created?

I want to create an add-on similar to Trello. Every time you open a mail, Trello automatically fills in the "Name" and "Description" fields for you. The name here is the "subject" of the mail and the description is the "body" of the mail. I want to…
2ach
  • 1
  • 1
-1
votes
1 answer

How can I Update Spreadsheet cell value directly from Html Page using appscript

I have a Planning sheet with huge data. For every row will have 200+ columns (cells). I wanted to change the cell value from html page using appscript. How can we change the cell value directly from Html Table view. Please help. Regards RS
R S Kumar Yellapu
  • 13
  • 3
-1
votes
1 answer

how to parse json data in appsscript

I am trying to extract the number of goals from the retrieved json data shown in my appsscript log below: Info {copyright=NHL and the NHL Shield are registered trademarks of the National Hockey League. NHL and NHL team marks are the property of…
Jeff Jones
  • 11
  • 3
-1
votes
2 answers

Can a local script directly produce a message box in Google Sheets?

I know that I can use the Google API executable to have a local script trigger a Google Apps Script. I'm wondering if I can optimize this by eliminating the Apps Script. Are there means by which I can make a message box appear in a Sheet with just a…
Helen K.
  • 69
  • 7
-1
votes
1 answer

Executing function via Apps Script API raises ScriptError

I need to create a trigger when the user clicks a button in the extension. I set everything up, connected to the extension, and wrote this Google Apps Script code: function CreateTriger() { ScriptApp.newTrigger('MoveToInbox') .timeBased() …
Mariana Mariana
  • 7
  • 1
-2
votes
1 answer

Is app script long running in the background?

clicking the run button. Will the script continue to run in the background after I close the browser tab? if not, any way to let it keep running?
Luk Aron
  • 1,235
  • 11
  • 34
-3
votes
1 answer

Cannot get to Google Execution API and receiving 500 Internal error

I have created a script in APPS script and deployed it as API Executable. I started to get 500 error when connecting to it. I decided to create a script from tutorial to localize the issue with this error. To my surprise i received the same results.…
Paulus
  • 138
  • 1
  • 11
1 2 3
…
14
15