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.

Import google spreadsheet data into google forms with app script

I searched the internet and I can't find a response to this nor the documentation for it. I need to …

javascript google-apps-script google-sheets google-sheets-api google-forms
Google Apps Script formatDate using user's time zone instead of GMT

I have a line that sets the current date and time in a cell: sheet.getRange(1,1).setValue(new Date()); Then …

javascript time google-apps-script timezone timezone-offset
For-each loop in google apps script

How do you create a for-each loop in Google Apps Script? I'm writing an email script with GAS, and I'd …

javascript google-apps-script
Easiest way to get file ID from URL on Google Apps Script

Here is what I'm trying to do: given a Google document URL, I want to get the document ID to …

google-apps-script google-drive-api
"MMMM yy"-date in google spreadsheet

I have a google spreadsheet in which I want a date with only the name of the month and the …

google-apps-script google-sheets
getRange with named range google spreadsheet using scripts

Can the getRange be used to have a named range instead of an area? When I seem to do it, …

google-apps-script google-sheets named-ranges
Display custom message after submitting a Google Form

I have a Google Form that allows user to enter their information. After they submit the form, the data is …

google-apps-script customization google-forms
Google Spreadsheet - Insert cut/copied cells/rows

Google Spreadsheet doesn't have the functionality to "insert cut cells" like in Excel. Let's say I selected A4 to B5, …

google-apps-script google-spreadsheet-api
Google Forms onsubmit

How does one reference the default 'Submit' Forms button to link the 'onsubmit' trigger with another action? Thank you. For …

google-apps-script google-forms
Google app script timeout ~ 5 minutes?

My google app script is iterating through the user's google drive files and copying and sometimes moving files to other …

google-apps-script google-drive-api