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.

Set cell format with google apps script

It is possible to set number format to a cell with google apps script like cell.setNumberFormat("0.000"); I need to …

google-apps-script google-sheets
Use a Google Docs Spreadsheet as a datasource for a dynamic Google Sites webpage

I have a Google Form that feeds a Google Docs Spreadsheet. I'd like to--in turn--have that Google Docs Spreadsheet feed …

google-apps-script google-docs
Custom function throws a "You do not have the permission required to setValue" error

I am trying to set some value to a cell in a Google Spreadsheet: function exampleFunction() { var ss = SpreadsheetApp.getActiveSpreadsheet(); …

google-apps-script google-sheets permissions authorization google-sheets-custom-function
How to delete a File in Google Drive?

How do I write a Google Apps Script that deletes files? This finds files: var ExistingFiles = DocsList.find(fileName); But …

file google-apps-script google-drive-api delete-file
Is it possible to automate Google Spreadsheets Scripts (e.g. without an event to trigger them)?

Does anyone know if it's possible to use Google Apps Scripts to run without needed a manual event? Meaning - …

google-sheets google-apps-script
Converting a string timestamp to Date results in reset to UNIX epoch

I'm having some problems converting a string to a date object in google apps script. My dates are in the …

date google-apps-script datetime-format
Validating email addresses in Google Forms

I want to use a Google Form to populate a Google Spreadsheet. One of the fields is email address, and …

google-apps-script google-forms
How to add "Edit Response" link to Google Forms emails?

I have a simple Google Form that collects data, and, using AppScript, sends confirmation emails to users who fill it …

google-apps-script google-forms
"function not found" error when making both GET and POST requests to a Web App

I'm getting a Script function not found: doGet OR Script function not found: doPost when I GET/POST to my …

google-apps-script web-applications
Dynamically update Google Form 'Choose from list' options from column in Spreadsheet

I am trying to setup a Google Form that will create a 'choose from list' question, with each option being …

google-apps-script google-sheets google-forms