I have this google script for google sheets that moves rows of data from "Sheet1" to "Sheet2" when column 15 says "tracking", and it works perfectly fine when I type in "tracking" but I would like ...

Each user on the domain initiates a simple script we run for leave entitlements but we want the welcome message to be "Hi First Name," however the script doesn't seem to be able to fetch ...

I am trying to evaluate Google Apps Script (GAS) as one of the component in my overall SaaS. But, I see there is quota limits. https://developers.google.com/apps-script/guides/services/quotas#curre...

Whats the difference between these two methods from class SpreadSheetApp in Google Apps Script? Both return "currently active spreadsheet, or null if there is none". Whats the difference between t...

I am creating a workflow process in Apps Script where a Doc is generated from a template and shared with various users for approval. The Script sends a customised email notifying a user that the do...

SPECIFIC FOR: "NEW" google sheets only. This is a known issue as highlighted by google in the new sheets. Issues: If you write complex* custom functions in google-apps-script for google sheets, y...

I am trying to typehint a bunch of javascript in Google Script, and I have gotten as far as trying this: /** * Get (named) range given by name * * @param {String} name * @return {Range} * */...

I created a google apps script for Google Sheets with some simple custom functions. But when I Test the Deployment as an Add-on to a test Sheet. The custom functions don't work in the test sheet. H...

I'm trying to send an automatic response from code to a form of mine. I can open it and send empty responses (I create a FormResponse and submit it empty). Now I want to fill the itemResponses pri...

I'm trying to get multiple filters on the same row that filter different tables. So users can sort data from table 1, 2 or 3 individually as they wish. Is it possible to do that in Google sheets? Q...

I've got a Google apps script project running on a Google site. The site requires users to sign in, and it only open to users on this G-suite domain. The scripts I have are for allowing users to d...

I'm trying to create a script to capture data via HTTP POST from Ejunkie. When someone makes a purchase on ejunkie, they can transmit all the order data via HTTP POST to a common notification url (...

I'm having a nightmare doing a lot of scenarios using Apps Script, but nothing works! I have a function that makes a GET request returns an array of cards. Now, sometimes I need this card refreshes...

I added a new menu item to my spreadsheet using google apps script. This menu item creates a file, but I'd like for it to initiate the download of the file after creating it. Is this possible? Reme...

I am appending rows from one sheet to another, and the source sheet has date format like: Sat, Apr 29, 2017 When appended to the target sheet, it changes to 4/29/2017 format. Since I am appending...

I would like to write a google apps script to trash every empty folder into my google drive, which method / property should I use to examine the current folder (I can write a cycle) is really empty...

I have been looking for a way of automating at work the google forms we need to create for Gsuite but in this documentation for the life of me I can't find how to add questions that allow me to hav...

I have string variable with HTML entities: var str = 'Some text & text'; I want to convert (decode) it to original characters: Some text & text. JavaScript doesn't have built-in fu...

I'm facing a problem since this morning with webapps deployed with Apps Script that used to works fine previously. Of course no changes has been made to justify this problem. External scripts are n...

I have a spreadsheet with some values in column G. Some cells are empty in between, and I need to get the last value from that column into another cell. Something like: =LAST(G2:G9999) except t...

Hi I was trying to extract PlainBody contents of my emails and was on the point of finishing extracting my emails until at some point I encountered an error saying Your input contains more than the...

I will have hundreds of cells which will use a webservice call to obtain stock data. However, the data is only returned in JSON or CSV format. Using one example, how can I obtain only the "uHigh" v...

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 rows, 16 columns into an array before I...

Is there a way to get the value of a cell note and display it in the cell next to it? I have a column C where some of the cells contain notes. I would like to get these note values and write each c...

I have an add-on for Google Sheets that's currently being tested within my domain. For this post, let's call it My First Add On. When users install the add-on they're prompted for permissions, but ...