Category "google-apps-script"

Google apps script URL changes and does not open

I have an issue where other uses of my Google apps script's url is getting changed. Due to this issue they are not able to open the html page. Original url "htt

Modify a Google Slides presentation while presenting?

I'm afraid I already know the answer, but maybe someone else has found a way to do this. I've been perusing the Slide Apps Script reference, and I'm excited a

How do I use LockService properly every time in Google Apps Script?

I am trying to avoid concurrent process with LockService on my project. In test runs, LockService works for me without any problems. But when I roll my projec

Put a CSV file in a specific Sheet by Name

With this script I would to put the CSV in a specific Sheet named "TEST". I have tried with getSheetByName but without result. How could I proceed? function imp

Google Sheets appendRow with formula values

My goal is to write a script in Google Sheets that will copy two (or more) values from specific cells on a single row on a worksheet to the bottom of the list o

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)