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 Apps Script to open a URL

Is there a way to write a google apps script so when ran, a second browser window opens to www.…

html redirect google-apps-script hyperlink
Trying to read cell 1,1 in spreadsheet using Google Script API

I'm a mildly experienced programmer ... I have an OK understanding of OOP concepts, I've been using PHP and MySQL lately. …

google-apps-script
How to get the current time in Google spreadsheet using script editor?

There is an option to write a script and bind it to a trigger. The question is, how to get …

google-apps-script google-sheets
Is it possible to 'prefill' a google form using data from a google spreadsheet?

I'm looking for a way to 'pre fill' a google form with specific data from a google spreadsheet. The form …

google-apps-script google-sheets google-forms
How to convert a string to number

I can't figure it out how to convert this string 82144251 to a number. Code: var num = "82144251"; If I try the …

google-apps-script
Get today date in google appScript

How do I get the Today date on google appscript? I need to write a code to input today´s …

google-apps-script
How to automatically import data from uploaded CSV or XLS file into Google Sheets

I have a legacy database system (not web accessible) on a server which generates CSV or XLS reports to a …

google-apps-script google-sheets google-drive-api google-spreadsheet-api
How do you do dynamic / dependent drop downs in Google Sheets?

How do you get a sub-category column to populate a drop down based on the value selected in the main …

validation google-apps-script google-sheets
Selecting the last value of a column

I have a spreadsheet with some values in column G. Some cells are empty in between, and I need to …

google-apps-script google-sheets google-sheets-formula array-formulas custom-function
How to make google spreadsheet refresh itself every 1 minute?

My google spreadsheet is using GOOGLEFINANCE('symbol','price) function to retrieve stock prices of my portfolio. Unfortunately, I have to …

google-apps-script google-sheets google-finance