Top "Google-apps-script" questions

Use for questions about Google Apps Script, Google's JavaScript-based cloud scripting platform for automating tasks across Google products and third-party services.

Google Script to see if text contains a value

I have a google form that when the user submits it will trigger my function to run which is creating …

javascript google-apps-script
How to define global variable in Google Apps Script

I see most examples from Google is they use only functions in a single giant script. e.g. https://developers.…

google-apps-script google-sheets global-variables google-docs
Insert date time in google document

I would like to insert a timestamp (date and/or time) into Google Documents. The support documentation () says that there …

google-apps-script timestamp google-docs
How to use Utilities.sleep() function

What is the exact use of Utilities.sleep() function? Should we use it between function calls or API calls? I …

google-apps-script
Write an array of values to a range of cells in a spreadsheet

Using Google Apps Script, is there a way to write the values in a Google Spreadsheet array to a range …

arrays google-apps-script google-sheets
How to upload multiple files using one file input element

I'm trying to use one file input element to upload multiple files to Drive using html form. This seems to …

html google-apps-script
Delete a row in Google Spreadsheets if value of cell in said row is 0 or blank

I'd like to be able to delete an entire row in a Google Spreadsheets if the value entered for say …

google-apps-script google-sheets
How to union ranges in google spreadsheets

I want to union ranges from any Google spreadsheets. The example Sheet1!A:A {12, 131, 45} Sheet2!A:A {12, 131, 46} The unknown function =…

arrays google-apps-script google-sheets google-sheets-formula
Faster way to find the first empty row in a Google Sheet column

I've made a script that every few hours adds a new row to a Google Apps spreadsheet. This is the …

performance google-apps-script google-sheets
Refresh data retrieved by a custom function in Google Sheet

I've written a custom Google Apps Script that will receive an id and fetch information from a web service (a …

google-apps-script google-sheets custom-function