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

Executing Functions using the Apps Script API

I am trying to execute Apps Script function using Apps Script API. For this I set up a target script and calling script (JavaScript code) using instructions from Google here. I followed exactly how it is described but I am getting the following…
Partha S. Pal
  • 169
  • 1
  • 2
  • 14
0
votes
1 answer

Updating the default broadcast's stream title via YouTube API

Using the link below, the title can be easily updated: https://developers.google.com/youtube/v3/live/docs/liveStreams/update?apix=true. I wish to implement the same using the YouTube API in Google Apps Script. The code below works successfully, but…
Ratan Nahn
  • 90
  • 7
0
votes
1 answer

Google Chat bot linked to a google sheet

The final idea of the bot that I am building will be to send out messages on the chat when a google sheet is edited. But first I am trying just to create a Google Chat bot linked to a google sheet with the hangouts chat template given by google. For…
user14491665
  • 35
  • 11
0
votes
1 answer

Google Apps Script API Authorizations for DriveApp.getFileById

I have a Google Cloud Platform Project (GCP) that runs almost all scripts/functions directly, but a couple through an API. Everything is only accessible internally to the G Suite domain, and the OAuth consent screen Application Type is…
Chris
  • 473
  • 5
  • 18
0
votes
1 answer

How do you pass parameters to a Deployed Google Apps Script API function?

I created a test function (doPost) in a Google Apps Script API using Google Cloud Platform (GCP). I am now trying to call that function from another script in the same project. I know I am almost there, because this code works: var token =…
Chris
  • 473
  • 5
  • 18
0
votes
0 answers

Event on sheet activate

I want to update my sidebar whenever user clicks on different sheets. Basically, whenever a sheet is activated. I have explored onChange and onEdit events but they don't help my cause. I didn't come across any apps-script event which will help me…
Putta
  • 67
  • 7
0
votes
0 answers

How can my Slack Bot that uses Google APIs to generate a Google Sheet with data for users using a Service account add a Script to that sheet

I have a private Slack Bot that uses Google APIs to generate a Google Sheet with data for our users. I am using a Service account as the bot creates those sheets under it's own Google account. Now I want to add a script to that sheet (so that…
Marcelo Mason
  • 6,750
  • 2
  • 34
  • 43
0
votes
1 answer

Why does "ReferenceError: Drive is not defined" keep occuring frequently?

const file = Drive.Files.insert({ title: 'Temp.pdf' }, blob, { ocr: true, ocrLanguage: "en" }); I have enabled Drive API(v2) from Resources->Advanced Google Services and also enabled Drive API in Google Cloud Platform API Dashboard for that…
Ekalavya
  • 31
  • 4
0
votes
1 answer

Google Apps Script API - Permissions for my Python script to execute an Apps Script function

this is my first contribution here. I'm trying to access Gmail through a python script. To do so, I've created a Google Apps Script function and used the Apps Script API between the 2. (This doc displays what I'm trying to do) So the python script…
Cannelier
  • 33
  • 5
0
votes
0 answers

Google Apps Script Execution API not running script or returning error?

I'm trying to catch a SQLAlchemy error and on error execute a Google Apps Script, which is deployed as an API executable. Example error to catch: [SQL: INSERT INTO mytbl (id, attr) VALUES (%(id)s, %(attr)s)] [parameters: ({'id': 177, 'attr':…
user8121557
  • 149
  • 2
  • 9
0
votes
1 answer

Custom Apps Script function not executing on some certain rows on Google Sheet

I have written some Apps Script code to fetch stock data from Yahoo and Fizviz, and for a while it worked fine. Ever since I reached a certain number of rows in my table (around 20 tickers), some specific rows stop executing, the cells say "Loading"…
hoangbv15
  • 360
  • 2
  • 4
  • 14
0
votes
1 answer

How to create and execute a function using the Apps Script API

I created a script following "Ruby Quickstart" but I can't run it with the API. I know that I should publish it as API executable. To do that I need to switch the script project to use a "standard GCP project" and I couldn't find how to do it…
Nicolas Ferrari
  • 11
  • 1
0
votes
1 answer

Google Apps Script Time based trigger at custom date and time based on value in spreadsheet

I am trying to create a Google apps script with the ability to schedule mails at specific times based on the value in the spreadsheet. There will be multiple date-time cells based on which the trigger would be made. I have tried adding the trigger…
Fateh AK
  • 386
  • 5
  • 20
0
votes
1 answer

Some posts inserted using Blogger API not displayed on main page

I am using Blogger API to insert posts. Go through the following blog to understand the problem: Link: https://post-testing123.blogspot.com/ In this blog I have 7 posts: 5 posts with title of format 'Title #no'- are created with API request. 2 posts…
Ranveer Singh
  • 131
  • 1
  • 1
  • 9
0
votes
0 answers

Can't call App Script function thru the REST api

I'm using Java API for calling the AppScript function on the spreadsheet When I list deployments List deployments = projects.deployments().list("XXX").execute().getDeployments(); I can see my deployments but the…
user658408
1 2 3
…
14 15