Skip to content

Tag: google-sheets

Google App Script randomly stop executing

I have a script that basically take info from a website for multiple users, and put these info in a google spreadsheet, with one sheet per users. I have a function that remove values of the firstline, resize every columns, and put back the setValues: my problem is that the script stop executing in the middle of the function. I

Set a range to uppercase in sheets APP SCRIPT

I want to create a script that I will have in a menu that gets the range “A1:C” and uppercases it. The problem is that throws an error “TypeError: values.toUpperCase is not a function” trying to use toUpperCase(). Got the following code: Im pretty new to JS and sheets api. I feel dumb because it looks like something simple. EDIT