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

Google Apps Script Importation of a CSV file into Google Sheets from Gmail Sub-Label

I am very new to google apps script and I am trying to automated some daily reports. I receive updated reports to my inbox daily and I am trying to use a code to grab this updated CSV report daily from my inbox and import into the appropriate sheet.…
avaf
  • 31
  • 2
3
votes
0 answers

Wait for input from dialog before proceeding in server code

I have a function in my server code(.gs) which pops up a dialog for input from user. I should wait for user input before proceeding with the function. To do this, I am using a while loop with sleep and checking for value of a key in…
Ekalavya
  • 39
  • 2
3
votes
1 answer

How do I execute Google app script function from Python script via API? Not able to locate credentials.json for download in order to execute appscript

I'm trying to run a google app script function remotely from a python flask app. This function creates google calendar events with inputs from a google sheet. I referred to this documentation from Google in order to set up the python script to run…
arjunhd
  • 57
  • 6
3
votes
1 answer

UrlFetchApp.fetch(URL).getContentText() all of a sudden not working despite no changes

I have a very simple Google Script that grabs a CSV file from the internet and puts it into a Google Doc. There is more to it before and after, but here is where the issue arises: var csvUrl =…
user7577616
  • 31
  • 2
3
votes
0 answers

Access Google AppScript API from Chrome Extension leads to 403 error

I would like to edit my Google Doc using a Google AppScript function externally via a Google Chrome extension. To achieve this I have performed the following steps: setup the script via Google Docs Tools > Script Editor implementation of the dummy…
Druux
  • 143
  • 1
  • 2
  • 7
3
votes
1 answer

How can I pass an argument to Google App Script API from Python script?

I have an argument SalesID I'd like to pass through to the Google App Script. How can I pass it through with this python script? (Script is from https://developers.google.com/apps-script/api/how-tos/execute) from __future__ import…
sojim2
  • 1,245
  • 2
  • 15
  • 38
3
votes
1 answer

Creating a Google App Script programmatically with the API

Is it possible to create a brand new google app script programmatically and attach him to a specific google doc? Or in any other way, to make 1 bound script and make several google docs to share him as the same bound script?
Jumpa
  • 878
  • 1
  • 8
  • 12
3
votes
2 answers

Using Google Apps Script and the Pastebin.com API to post a paste

I am trying to make a Pastebin.com paste using Google Apps Script from the spreadsheet script editor. Can anyone tell me what I'm doing wrong? function postPastebinPost() { var options, url, apiKey, payload, response; apiKey =
Mio Winter
  • 33
  • 5
3
votes
1 answer

Apps Script Execution API showing error with devMode: true

Trying to use Execution API for one of my project with devMode: true, but getting the following error. But it works flawlessly when I make devMode: false. NOTE: I am owner and using the API from same account (so it should work ideally) I have…
Hari Das
  • 10,145
  • 7
  • 62
  • 59
3
votes
1 answer

How to Publish/Deploy Google Sheet script as API executable programmatically?

I have a google sheet containing script, I want to perform following operations programmatically. Make this Google spreadsheet public programmatically. I want to execute the script associated with the above spreadsheet programmatically for any user…
Asad Khan
  • 347
  • 4
  • 10
2
votes
3 answers

Updating multiple appscript projects from one appscript

I have scenario where I have more than 60 sheet, and all have appscript project behind them running and managing those sheet. I want to updat/control those appscript projects all at once, from one different project. So that I don't have to manually…
vector
  • 1,032
  • 1
  • 4
  • 16
2
votes
1 answer

Why all fields appear as dimensions in data studio?

I'm working on the npm Downloads Counter connecter using this Google Data Studio codelabs. In the getFields() function i created two dimensions( 'day' and 'packageName') and one metric(downloads). But in Data Studio, all fields appear as dimensions,…
bilalo
  • 129
  • 1
  • 1
  • 7
2
votes
1 answer

Google Sheets API - creating app scripts or attaching them to a Spreadsheet that was created with API

I am using the Google Sheets API to create a spreadsheet. I want to add an onEdit function to this sheet that calls out and does an ajax request. Using either the app script api or the spreadsheet API I want to create the onEdit function, something…
amlwwalker
  • 3,161
  • 4
  • 26
  • 47
2
votes
3 answers

Google form Multiple Choice Other option not visible when submitted from app script

I have a google form where I have a multiple choice question "Territory field". This field is having two valid answer United States and Others (When you choose other option you can write down any Country name in text area) Now I am trying to submit…
roshan kumar
  • 21
  • 3
2
votes
0 answers

Apps Script Execution API 404 error with devMode: true

When requesting POST https://script.googleapis.com/v1/scripts/{script_id}:run with devMode: true I get a 404 error. I can run the script successfully with devMode: false. Although other people (1, 2) have raised this issue, none of the other…
Yuval
  • 3,207
  • 32
  • 45
1
2
3
…
14 15