All Questions
Tagged with google-apps-script performance
18 questions
4
votes
0
answers
78
views
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 ...
2
votes
2
answers
3k
views
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
0
votes
1
answer
355
views
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 ...
- 3
1
vote
1
answer
64
views
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
4
votes
0
answers
51
views
Rearranging data from one table to another in spreadsheets using apps script
I need some help with making my code run faster. It currently works by going through all cells in a 201x151 table. If the value in a cell is not equal to zero, then it will return the row number, the ...
- 41
4
votes
1
answer
155
views
Google apps script Exceeded maximum execution time issue or 29k rows
I built some code to update dates from a Dump file.
I am commonly running into an "Exceeded maximum execution time" message. Otherwise the code works fine. It imports & updates statuses for 16.5 ...
3
votes
0
answers
35
views
Google Scripts (Add, Remove & Moving Record) stop timeout
What is it?
The google sheet that the macros are on acts as a sort of "back-end" for the records of a behaviour system at a school. I build multiple google sheets that link to this one that pull the ...
- 31
2
votes
1
answer
593
views
Google Apps Script to create an invoice
I am using Google Execution API to create an invoice and it's a small part of a bigger system. However, my boss is pretty displeased at the total execution time before an invoice is generated. It ...
1
vote
1
answer
302
views
Hide rows where column F is not empty
I'm not a scripting expert by any means, but I put together some code that I needed for Google Sheets. The good news is that it actually works!
However, it's noticeably slow to run (about 15 ...
- 21
2
votes
1
answer
83
views
Extract a number from a consecutive range in a Google Sheet
I'm new in coding and I use google script in my spreadsheet to add a list of consecutive numbers automatically by giving the first number to add and the last one (with an arrival date and an option "A"...
- 51
4
votes
0
answers
713
views
Generating Bitly links in a Google Sheet
I have this set of functions in my Google Sheet to create a Bitly bitlink whenever data in a row is changed. While this does work, it seems really slow to me. Looking at the Execution transcript, it ...
- 41
1
vote
1
answer
886
views
Lock-range code for Google Scripts/Sheets
This code locks a range and adds a timestamp. More details below. I'd like to learn how to make this code more efficient (minimize code/variables and reduce redundancy). Any thoughts on the areas I ...
- 11
4
votes
0
answers
100
views
Protection for cells in Google Sheets
Is there some way to speed this up, since it keeps timing out while running?
The spreadsheet is shared with a Google Group with editing permissions. I've loaded what I can into memory but each ...
2
votes
1
answer
105
views
Google Drive folders properties caching to file
I have the recursive function below to cache all the folders of my company Drive into a file. It works like a charm but takes too long, specifically >30 secs to read and save the 300 folders.
What I ...
- 131
7
votes
1
answer
7k
views
A1Notation conversion to row & column index
This set of Google Apps Script helper functions are published in this gist, along with a bunch of other utilities. Background info is in this SO question. Since no Google services are used, this is ...
- 276