Questions tagged [google-apps-script]
Google Apps Script is a JavaScript cloud scripting language for automating tasks across Google products and third party services.
68 questions
4votes
0answers
75views
Google App Script to take form responses submitted by teachers on their students and produce formatted PDF student reports
I'm not a programmer but, with help, I managed to make a Google Apps Script which takes reports, submitted by teachers on their students, to the Form Responses Sheet, and then selects all responses ...
1vote
1answer
163views
Copy and Pasting Values from Spreadsheets
Background This code is apart of a library I'm developing for my company. It takes in anywhere from 3 to 5 arguments. All of the code functions properly. To be more specific, a user has data on a ...
6votes
2answers
453views
Sending Email Through App Script
Background This is a function that is part of a library written in GAS. A function inside a library I've written is supposed to send out an email to another user or users with accompanying details (...
1vote
1answer
92views
Pulling Data from an Email and Pasting it into a Google Spreadsheet
Background The reason why I'm doing this is because at my company, we get emails a lot from different locations that have relevant data we need for other processes. The problem is that this data is ...
2votes
2answers
2kviews
Slow performance of Google Apps Script that updates data
I have a Google Spreadsheet with a few hundreds of sheets there. Users update those sheets with new data under a strict and specific template. I created a Google Apps Script where once every while, I ...
- 159
1vote
1answer
56views
Grouping arrays with different lengths to make a single sentValues() for the spreadsheet
Currently I find out which is the biggest array and from it I generate a while loop and I go around errors with try catch: ...
1vote
1answer
161views
Replace/remove all diacritics and converting different letters to Latin alphabet in multiple spreadsheet columns (multidimensional array)
Attention: if you read the question and are going to use the defaultDiacriticsRemovalMap in the future → I analyzed the name of all professional football athletes ...
0votes
1answer
347views
Google App Script Automation for User Onboarding
Background I am a relatively new developer(> 2 years coding) working as an intern for a smaller company, as part of a now 4 person team. We had two other team members, one our system admin and the ...
0votes
3answers
121views
List with values not found in another list when each index has two objects
As the question already says, my code returns a list with the index's that don't exist inside another list. For this I currently create two lists joining the objects of each index, then filter the ...
2votes
0answers
34views
Pull pictures from folders on Google Drive and add them to a Sheet
I have code that I have been using for 2 years and it was working perfectly until recently. It started to give a timeout warning a couple of weeks ago and now it's not really running anymore. The code ...
3votes
2answers
102views
Calculate cumulative daily rainfall
It took me a while to compute this script, it works perfectly, but I think that it is very raw and long. The goal of the script is to produce a graph of cumulated rainfall with 3 lines: Cumulated ...
1vote
1answer
47views
Set Dates on Spreadsheet Rows
I'm trying to get this to run faster, even marginally so. Right now to update 470 rows it takes about 90 seconds. It works, but I know there are better ways. I understand calls to Spreadsheet API are ...
- 11
1vote
1answer
78views
New Spreadsheet Row to YouTube Playlist
I have the following code below that takes a new row added to my Google Spreadsheet (has a header row) and extracts the video ID. If the ID does not exist in the playlist, it adds the video to the ...
- 259
2votes
1answer
874views
JavaScript: proper user of SJCL encryption in Google Apps Script
I'm using the minified version of SJCL to encrypt the backup files requested by the users. It is in a Google Apps Script add-on for Google Sheets. I'm mostly concerned with correct use, exception ...
user235971
3votes
1answer
115views
Faster way to copy rows of data to different sheets by column value
I'm trying to find a faster way to copy specific rows of a sheet to different sheets. Iterating through them as done in code below takes too much time it leads to timeout. Some information about ...
