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

Formatting removed for google docs embed in gmail via app script

I have a scenario where I need to schedule an email at particular time every-day but the content of an email is present in some google doc and update on timely bases. So currently I am manually sending email and paste those content into my email but…
Chintan
  • 59
  • 1
  • 8
0
votes
1 answer

Cannot run remote Google Apps Script app via node.js

I am having a problem running the following node.js to remotely execute a Google Apps script. the Google Apps script in itself is very simple, it is just: function addText(){ …
Jason Jurotich
  • 441
  • 4
  • 24
0
votes
1 answer

Google Apps Script How to Create First Run Tutorial

I am creating a Google Spreadsheet tool (with Google Apps Script) for a client to help them streamline their processes. I would like to create an interactive tutorial to show them how to use this new tool. I envision callouts that pop up pointing to…
Hurston
  • 48
  • 7
0
votes
0 answers

How can I trigger a Google Apps Script function from the Google API PHP Client with the authentication I have set already?

I'm struggling to trigger a Google Apps Script Function which builds many dropdowns of a Google Spreadsheet. I need this data to be updated daily on this Google Spreadsheet so I must call the function. Seems like I'm required to have a client-side…
Bruno FG
  • 125
  • 6
0
votes
1 answer

Google Apps Script error: You do not have permission to call createEvent (line 57, file "Code")

I'm trying to create an event in Google Calendar from Google Apps Script. When I run the following line var event = CalendarApp.getDefaultCalendar().createEvent('Apollo 11 Landing', new Date('February 22, 2017 13:00:00 UTC'), new Date('February…
Pitchiah Natarajan
  • 179
  • 10
0
votes
1 answer

Google Apps Script PUT requests failing

I'm having issues with calling the Streak API with Google Apps Script. Any of the GET or POST requests I make are working, but I can't get a single PUT request to work. Since the matching CURL requests work I'm thinking it's something I'm doing…
Tristan
  • 3
  • 2
0
votes
1 answer

Javascript google API quickstart error

I'm working through the tutorial from here : https://developers.google.com/apps-script/api/quickstart/js. When i try to run the quickstart.html locally on window platform with client ID and API key insert, it throws an error at line 144…
Tung Pham
  • 537
  • 4
  • 10
0
votes
1 answer

Creating sheet via execution API

I'm trying to create a google sheets document via script, and I'm using the execution API example google provides here: https://developers.google.com/apps-script/guides/rest/quickstart/android The only change I've made was a line on the…
Arthur Cezar
  • 1
0
votes
1 answer

How to copy google drive folder into another google drive account by using App Script?

I want to copy google drive folder to another google Drive by using App Script. Right now I am sharing folder to target account and try to copy folder to target google drive.Here is my App Script Code: // Make copy in Google Drive function…
chris
  • 1
  • 1
0
votes
1 answer

How to send List of objects to google execution api and handle it in google apps script

In general I want to export data from asp.net mvc application to Google Sheets for example list of people. I've already set up connection and authenticated app with my Google account (trough OAuth2) but now I'm trying to send my list of objects to…
Piotr Smyda
  • 177
  • 1
  • 15
0
votes
1 answer

404 error when posting request to google execution api from chrome extension

I'm getting 404 error when I post request to google execution api from chrome extension. I'm sure my client id is correct and scopes are correct. Also, my script id and function name to call are correct as well. I also published the script as api…
user5809117
0
votes
2 answers

ScriptError using Google Apps Script Execution API

Following these guides https://developers.google.com/apps-script/guides/rest/quickstart/target-script and https://developers.google.com/apps-script/guides/rest/quickstart/nodejs, I am trying to use the Execution API in node to return some data that…
Tri Nguyen
  • 9,950
  • 8
  • 40
  • 72
0
votes
0 answers

Is it possible to call the Apps Script Execution API via a jQuery `ajax` method?

Is it possible to call the Apps Script Execution API via a jQuery ajax method? I am getting request failures using: $.ajax({ type: "POST", url : "https://script.googleapis.com/v1/scripts/{script_id}:run", data : { 'function' :…
Ian Hudson
  • 21
  • 3
0
votes
5 answers

Google apps script in HTML

Is it possible to use google apps script in my HTML? I want to be able to write to a spreadsheet from a form in purely Javascript from an external framework such as Node.js. https://developers.google.com/apps-script/
goodcow
  • 4,495
  • 6
  • 33
  • 52
-1
votes
1 answer

How do you run the same API multiple times on Google Apps Script?

So I'm totally new at using Google Apps Script, basically just started a few hours ago. Also new to stackoverflow so excuse my formatting. For the life of me, I cant seem to find how to run Bored API to get 20 unique suggested activities. I am also…
Ginasimran Kaur
  • 1
  • 1
1 2 3
…
14
15