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

Adding Google Classroom ID based on user enrollment code

I have a spreadsheet where a user can list classes and Google Classroom enrollment codes, represented by the array userClassCodes. This array is allowed to contain blank values when the range contains blank cells. This array is represented in the…
MeesterZee
  • 99
  • 7
1
vote
1 answer

Automate running several projects at once in google script

I have multiple spreadsheet bound projects, and I want once in a while run all of them together. Is there a possibility to automate this, as I do not want open each project and run it manually. And as I understand I cannot create installable timed…
Alina
  • 33
  • 4
1
vote
1 answer

Is there way to Pre-Fill name from the signed in Google Account in Google Forms?

I need to pull the name off of the GSuite Business account name and have it automatically be filled in the form when opened along with the email address. Is this possible using Apps Script?
Shoaib Alam
  • 11
  • 1
1
vote
1 answer

Using GS to Import data from GA4 runRealtimeReport into Google Sheets

On Google AppsScript, I have been trying to pull real-time user data from a GA4 property into a google sheet. However, I keep getting the following error message: "API keys are not supported by this API. Expected OAuth2 access token or other…
Arvind
  • 13
  • 2
1
vote
1 answer

Apps Script projects.deployments.create throwing GaxiosError: Requested entity was not found

I am trying to set up a onEdit trigger for Google SHeets using the Apps Script API. I have managed to create and update a script project by the code given below (this is working fine) const createScriptRes = await this.script.projects.create({ …
Rajkumar Gaur
  • 95
  • 6
1
vote
1 answer

How to pass creativeId into CampaignCreativeAssociations.insert() method using Google CM360 API

I'm using Google Apps Script and using the DoubleClickCampaigns services v3.5, which allows me to use CM360 APIs v3.5 I'm trying to associate a creative to a campaign using campaignCreativeAssociations.insert() const profileId = '1234' //fake …
kevhol
  • 35
  • 6
1
vote
1 answer

How to batch the calls in google app script

I was trying to optimize runtime some code that ran really slowly, when searching it up google came up with this:…
Black sky
  • 11
  • 1
1
vote
1 answer

Hyperlinks of multiple filtered views in google sheets using apps script part2

This is an extension of question: I have sheet a sheet of names(sheet 1 in Columns A, B and C). I want Have sales information of people in Sheet 2 , sheet 3 and Sheet 4. I want an apps script for filter view hyperlinks on sheet 1. So Column A on…
user17243359
  • 55
  • 6
1
vote
2 answers

Delete filtered Views and hyperlinks from google sheets

This is an extension of question I have sheet a sheet of names(sheet 1 in Columns A, B and C). I want Have sales information of people in Sheet 2 , sheet 3 and Sheet 4. if possible, please add a function to delete the filter views and hyperlinks of…
user17243359
  • 55
  • 6
1
vote
1 answer

Google Script with Python example - GET Request - HTML result error

I'm trying to connect a Google spreadsheet via API GET request to receive some information from snov.io, but I am getting a HTML result instead of a JSON. The below Python code works, but the Google Appscript not. Any suggestions? Thank you…
SKuan
  • 37
  • 7
1
vote
1 answer

How to add libraries via Google Script API (Node.js)?

I m developing an app that automates creating google spreadsheets that have a container-bound script. To make the maintenance of the script easy, the script doesn't have business logic but have delegation codes instead as below. container-bound…
liberrace
  • 23
  • 3
1
vote
0 answers

Adding googleapis to analytics call from Apps script

I'm trying to call Ganalytics from app-script, but I get an error about missing scopes. I couldn't find documentation about where I should put the "scope" property (it just says under request options). Is this the right syntax? function…
Elad Benda
  • 35,076
  • 87
  • 265
  • 471
1
vote
2 answers

How to get image inside a form item in google apps scripts

I have multiple multiple choice questions and checkboxes with images inside them. I am trying to compile all the questions into a doc file. How do I get the images inside the questions? They are not in a separate Image…
MAHESH ARAVIND V
  • 33
  • 8
1
vote
1 answer

Get quote price from CoinMarketCap API in EUR instead of USD - GAS

the following code works ok for me in GAS (Google Apps Script) for CoinMarketCap API function cmcQuotes2() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheetByName('base'); var lastRow = sheet.getLastRow(); …
John Galassi
  • 309
  • 2
  • 16
1
vote
1 answer

Add array as parameter in Google Apps Script function using cURL

I have created a function in Google Apps Script to create and manage several items in Google Drive (e.g. create a folder, a new Doc or Xls file, etc.). The important thing is that I have 4 DOC documents (or templates): MainDoc + 3 additional Doc…
Wardiam
  • 127
  • 7
1 2 3
…
14 15