Category "google-apps-script"

Enable Google API OAuth Scope

For one of the application created using Google Apps Script, some scopes are automatically added as follows in my app: https://www.googleapis.com/auth/drive

How do you create a "reverse pivot" in Google Sheets?

I am trying to produce a "reverse pivot" function. I have searched long and hard for such a function, but cannot find one that is already out there. I have a su

How to Publish/Deploy Google Sheet script as API executable programmatically?

I have a google sheet containing script, I want to perform following operations programmatically. Make this Google spreadsheet public programmatically. I want

document.getElementById "not defined" in Google Apps Script [duplicate]

I am currently working on a Google forms addon. The addon has a sidebar with an input field and a button. The ID of the input field is "emaili

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