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

GoogleJsonResponseException: API call to dfareporting.ads.insert failed with error: Invalid value at 'profile_id' (TYPE_INT64)

I try to call this API with the following ad object. var ad = DoubleClickCampaigns.Ads.insert(6485800, { "campaignId": parseInt(singlePlacementArray[0]), "advertiserId": parseInt(inputSheet.getRange("J9").getValue()), …
Elad Benda
  • 35,076
  • 87
  • 265
  • 471
0
votes
1 answer

How to know the progress status of a Google Apps script

I have created an Apps Script to perform several tasks automatically: Function 1. - Create a new folder and retrieve the ID. Function 2. - Create a copy of a doc file in the folder. Function 3. - Replace the text of several tags of type {{TEXT}} in…
Wardiam
  • 127
  • 7
0
votes
1 answer

Noob user, run into an error on prototyping attempt

I'm making my first attempt at creating a Service and API prototype. I've been following this guide https://medium.com/madhash/prototype-your-app-with-firebase-api-7a51325de6f2 I've reached the step of "Run > Run Function > Initialize" but i'm…
bobtastic
  • 169
  • 8
0
votes
1 answer

How to model the rows in getData() since i have nested JSON data?

I want to display these fields :name, age, addresses_id, addresses_city, addresses_primary for each person into data studio. My JSON data { "data": [ { "name": "Lio", "age": 30, "addresses": [ …
bilalo
  • 129
  • 1
  • 1
  • 7
0
votes
1 answer

How to provide the getData() response with nested JSON data?

I'm not able to model a nested JSON data in Google Data Studio. I have the problem exactly in the "addresses" field. The JSON Data: { "data": [ { "id": 37314, "first_name": "Lio", "last_name":…
bilalo
  • 129
  • 1
  • 1
  • 7
0
votes
1 answer

Error while calling freshchat APIs from google apps script

I am trying to call FreshChat API from google apps script. GET request of outbound-messages is working fine but POST request is failing with error Exception: Request failed for http://api.in.freshchat.com returned code 400. Truncated server…
Krishna Kanth Vuppalapati
  • 31
  • 1
  • 5
0
votes
1 answer

How to programmatically deploy a Google Apps Script as a standard GCP project

Using the Node.js client for Google Apps Script API, I am able to deploy a script. However, according to Google's documentation and my own trial-and-error with the run method, in order to trigger that script to run from the Node.js client, the…
Education Automation
  • 13
  • 2
0
votes
1 answer

How can I call Google CM360 API from Apps-script editor?

I see the Apps Script API doc for calling Google CM360 API is much slimmer than the gapi REST API API doc. Is there a way to call gapi/Google CM360 API from Apps Script Editor?
Elad Benda
  • 35,076
  • 87
  • 265
  • 471
0
votes
1 answer

App Script - Creating an installable onEdit trigger to call a function that makes an API request - not working

So I'm relatively new to app-script and have succeeded in making an API request using urlFetchApp and pulling data onto my google sheet. Now what I am interested in doing is having this API request code run whenever I edit the contents of a specific…
Amos Turin
  • 43
  • 4
0
votes
1 answer

How to use clasp run with properties - the valid JSON format

Why does this clasp command no longer work for me? clasp run setProperty -p ['domain' 'mydomain.com'] which runs this function function setProperty(key,value) { let scriptProperties = PropertiesService.getScriptProperties() …
Chadd
  • 636
  • 7
  • 30
0
votes
0 answers

Access questions programmatically?

Is there a way to access Google Form questions and response options programmatically from a web app? I would like to use my web app to retrieve this information. I've tried creating a script using Google Apps Script but don't see how I can use that…
AKang123.
  • 405
  • 6
  • 15
0
votes
1 answer

Can i use an external program to run custom scripts in google sheets?

TLDR; Can a .py script run a Google Apps Script? Hi! By using Google APIs I've managed to create a .py script that can access and edit a google sheet. I then want the program to be able to select a custom UI tab in the sheet and run the function…
Ole Gunnar
  • 11
  • 1
0
votes
1 answer

How to use Advanced Drive Services properly to replace an existing spreadsheet instead of making a new one every time the function gets called?

I have been taking a bunch of source spreadsheets from a shared corporate drive, normalizing them, and combining them into a master sheet for my uses. Some of the sheets get uploaded as excel docs. Its impractical to expect the typical employee to…
FiddlerOfAnyBytes
  • 3
  • 1
0
votes
0 answers

Exception: You have been creating or deleting too many calendars or calendar events in a short time. Please try again later

Issue: Receiving error when running google app script in google sheets: "Exception: You have been creating or deleting too many calendars or calendar events in a short time. Please try again later." I have a google apps script that integrates with…
whydah
  • 1
0
votes
1 answer

How to render a Google Slides presentation via API and control / move slides?

I'm trying to render a Google Slides presentation in my web app and control it (move slides) using buttons on my web app. If I embed it using iframe, then I can't send key/mouse events to that iframe since it's not the same origin, and I don't want…
amiregelz
  • 1,833
  • 7
  • 25
  • 46
1 2 3
…
14 15