Category "google-apps-script"

Can't deploy new version of published Google apps script app with Rest API

When trying to use https://developers.google.com/apps-script/api/reference/rest/v1/projects.deployments/update to update an existing deployment with a new versi

How do I connect to the Admanager API with Javascript? [closed]

I would like to connect to the Admanager and bring my reports but I have not been successful. An example of how to do it would be helpful.

How to change the pixel quality and size of Image using Google Apps Script?

I have a list of image URLs and I want to get all those images which are more than 14Mb in size or 14 Megapixel in quality and resize them to under 5Mb in size

In AppScript, for Workspace Published Add-On Sheet Extensions, how do I switch to Head version and stop Deploying every bug fix?

Each time I fix a bug I have to Deploy and update the Version in theconsole.cloud.google.comI'm 17 Versions in and I don't think this is how it's supposed to wo

Unwanted Output In Console

I've started to get some strange output in my developer console. I was wondering if there was a way to turn it off. Net state changed from IDLE to BUSY T

How to sort files according to date created with google apps script?

I'm looking to sort the files in a folder by the date they were created or last modified. I'm loading the contents of a folder in google drive with the followin

Find and replace duplicate rows with the newest data in a defined range using Google Apps Script

Google sheet using columns A:M. Each day a new set of raw data (around 30 rows) is pasted on the next available row in column B manually. This raw data contains

Unexpected error while getting the method or property create on object ScriptApp.CalendarTriggerBuilder

I have code that has always worked but today it is giving me an error. I'm not sure if this is a bug or something else. function myFunction() { ScriptApp.newT

Merge PDF documents in different versions

I'm using Google App Scripts to manipulate some PDFs. I have two PDFs and want to merge them into one - im trying to use Merge Multiple PDF's into one PDF O

How to make a google apps script that takes a random value from a column when out separate sheet

I'm sorry for the question, but I am not really a software developer and not familiar with java. I've been struggling with this problem for days, and the deadl

Show images inside a pdf created with Gloogle Apps Script Blob

I am creating PDF files using blobs in Google Apps Script from a HTML code, but the problem is that HTML code has an image (referenced by "http") but the create

How to forward a Gmail email and add to the message body using GmailApp in Google Apps Script?

The GmailMessage.forward only has an htmlBody option. But if you use that, then the forwarded email does not include the original email's body/content. It only

Google Apps Script basic authentication

I'm an absolute beginner when it comes to programming. I've been trying to import data table from "http://www.rotowire.com/daily/nba/value-report.htm" into goog

google.script.run is not triggering the next function

I have a function that checks if the user fills out the form correctly and checks the user's questions and answers in the Google Form that was created. I create

e.source returns Spreadsheet instead of Form object?

I create google form 'on the fly' using data in spreadsheet. Also I install trigger on submit form event. ScriptApp.newTrigger('onSubmit') .forForm(form)

Make VSCode syntax highlighting accept Google Apps Script Scriptlets

I'm using VS Code in combination with clasp to develop in Google Apps Script. Using scriptlets inside a <script> or <style> tag is messing with VS

Sytax error: Missing ), but I don't see it. My quotation marks don't seem to be the problem either

I've been working on this app script trying to automate data from a Google sheet to create events on Google Calendar. I've tried changing the Quotation marks fr

List names of sheets in Google Sheets and skip the first two

I found code to list the names of all the sheets in Google Sheets (from here): function SheetNames() { // Usage as custom function: =SheetNames( GoogleClock() )

Trouble accessing Footnotes class Google Scripts

I'm trying to write up a simple script which will take a footnote added to a Google Document and copy it into an endnotes section. So, the user would use footno

How to resolve "This app is blocked" error for shared Google Apps Script library?

I'm trying to create a Google Apps Script (GAS) library that I can reuse across my Google Sheets spreadsheets. Following these instructions, here's what I've do