Questions tagged [google-sheets]
Google Sheets is an online spreadsheet app for creating and formatting spreadsheets.
47 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
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 ...
1
vote
1
answer
63
views
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:
...
1
vote
1
answer
165
views
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
...
1
vote
1
answer
86
views
Check Google Sheet for emails, verify delivery by api and Subscribe via api Benchmark
The main objective of this bot to make fast and reliable automatic subscriptions to email newsletter for people, who filled the website form(submissions go to google sheet)
I had too many requests to ...
1
vote
1
answer
111
views
Updating Google Sheets table efficiently
Program description:
A program accepts a list (uTable). The list consists of at least 4 different lists (rows), each with 7 elements (cells). Check whether the ...
3
votes
1
answer
122
views
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 ...
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 ...
2
votes
1
answer
281
views
Nesting for loops to find matches in different tables
I'm not sure if I'm even approaching this correctly (still very much learning), but this is what I'm attempting to accomplish:
My script gets an array from a column (tab names of the sheet) and then ...
4
votes
1
answer
157
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
1
answer
3k
views
Update Google Sheet with Python
Below is a code to update a google sheet using the database values. The script is working fine but it is rather slow because of the sleep function which I have to put because of the "Quota exceeding ...
6
votes
0
answers
77
views
HR Data Entry Form allows addition of new employees and update of existing employees
Business Process: Data entry form allows HR employees to input data for new employees, update data for existing employees, or terminate employees. Three data storage sheets exist for existing ...
3
votes
0
answers
1k
views
Eliminate all empty cells via vertical merging: Google Sheets
I am working with a spreadsheet containing a bunch of 'sections', e.g where the 'URL' column is set to 'google.com/search' in A1, and left empty while a bunch of things related to that URL are done in ...
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 ...
3
votes
1
answer
531
views
Tracking stock prices using Python and Google Sheets
The purpose of this program is to keep track of some stocks that we bought in a game and every week we must list the closing prices of each stock in a Google Sheet. I thought since I had a lot of ...