Category "google-apps-script"

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

TypeError: Cannot read property 'getRange' of null [duplicate]

I have a spreadsheet with data in columns A:Z. In column AA is the name of a sheet in the workbook. I'm trying to copy the data in A:Z to th

Saving as CSV through google script handling newline characters

So I'm attempting to take a sheet from a Google Spreadsheet and save it as a .CSV file just like you can manually do. It is working fairly well, but I've ran in

Protect Sheet when condition is met by change (Google Sheet)

There is a case where test is given to a certain student. The student can only work with the answer for the test before a given period. Here is the sample case:

Google Tables (Area120) How to update Checklist field type?

This is for an Area 120 Tables There are simple checkbox fields and Checklist field types. I cannot find in the Documentation how to update the children items i

Google Apps Script JDBC ResultSet to Array

Is there a better way of retrieving the results from a ResultSet? Calling getString() on each value is very slow. It takes up to 2.5 seconds to put about 400 r

TypeError: Cannot read property 'getRange' of undefined

Why AppScript in google sheets doesn't find the range in the sheet?The SpreadsheetApp finds the sheet but shows error in line 6. I tried ActiveRange and just ge