Questions tagged [google-sheets]

Google Sheets is an online spreadsheet app for creating and formatting spreadsheets.

Filter by
Sorted by
Tagged with
4 votes
0 answers
62 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 ...
StreetSavvypub's user avatar
2 votes
2 answers
2k 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 ...
Tasos's user avatar
  • 159
1 vote
1 answer
48 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: ...
Digital Farmer's user avatar
1 vote
1 answer
147 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 ...
Digital Farmer's user avatar
1 vote
0 answers
103 views

Embedded Google Apps Script to search for and collect a copy of files in Google Drive

Embedded Google Apps Script I've written an embedded Google Apps script to advanced search Google drive for files matching search parameters supplied in the hosting spreadsheet. Link to Google sheets ...
MrMills's user avatar
  • 11
1 vote
1 answer
68 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 ...
Bogdan Mind's user avatar
1 vote
1 answer
89 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 ...
JoshJohnson's user avatar
3 votes
1 answer
112 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 ...
Adam Poznar's user avatar
4 votes
0 answers
37 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 ...
MRuba's user avatar
  • 41
2 votes
1 answer
267 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 ...
TC76's user avatar
  • 115
4 votes
1 answer
137 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 ...
Mohammed Ziara's user avatar
1 vote
0 answers
38 views

Faster Google Spreadsheet access and direct use of Named Ranges for code readability

This object structure, that I think might be useful for a number of projects, attempts to: learn the use objects (classes are not available in Google Apps Script) and inheritance minimize calls to ...
Dave in Ohio's user avatar
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 ...
Linu's user avatar
  • 219
6 votes
0 answers
65 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 ...
Kerry's user avatar
  • 61
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 ...
Geza Kerecsenyi's user avatar
1 vote
0 answers
32 views

Adjust entries in Google Sheet for short orders

I am relatively new to scripting. My programming experience stems from a QBASIC course when I was 11, and teaching myself HTML when I was a teenager (a while ago). This script resides on what is ...
Aaron's user avatar
  • 11
3 votes
0 answers
30 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 ...
R Borland's user avatar
3 votes
1 answer
512 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 ...
Tommy's user avatar
  • 143
0 votes
1 answer
329 views

Google Apps Script shifting columns containing specified substring - using array functions

The link is to the example sheet of what I have done This code solves the problem of shifting large amounts of specific data in a google spreadsheet. The data is shifted to the right by one column, ...
Nikki Luzader's user avatar
3 votes
1 answer
577 views

Modal displayed in Google Spreadsheet from Gscript

First: I'm not really a programmer. Thus, this application may be started in a bad way, but here is my question. It's not a specific one because I have no real clue about how to improve my code. Let ...
LMS's user avatar
  • 31
1 vote
1 answer
268 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 ...
Jim's user avatar
  • 21
5 votes
0 answers
87 views

"Backend" of custom app made for editing Google Spreadsheet file

I've been learning some basics of python for few moths now. My friend, who works as salesman at company which sells hookahs, asked me if a could write a simple app which would help him maintain a ...
Michal Vöröš's user avatar
2 votes
1 answer
143 views

Returns Google Sheet cells from a named range

I've got this function that's called in several places in some of my Google Spreadsheets. It accepts a Range object, a string to ...
tariqk's user avatar
  • 121
1 vote
1 answer
28 views

Copying contents of cells in a vehicle-tracking Google Sheet

This is really my first shot at scripting anything. What I have below works, it does exactly what I need it to, but this is only a quarter of the total function. Clearly, I need to cut down the length ...
user avatar
2 votes
1 answer
65 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"...
Shinobe's user avatar
  • 51
3 votes
1 answer
103 views

Structure the MaxCPC automation code

When doing a search in Google, it is possible to have an ad in first position, at the top of the page or only on the first page. To do this, it is possible to pay for specific keywords for certain ...
Dave's user avatar
  • 33
3 votes
1 answer
1k views

Automatically Sending an Email based on a Google Sheet's cell value

Would love some feedback on how to improve my code. It might not be as readable as I'd like in places, but it currently works. Note that this code will be adapted to work on a different spreadsheet, ...
cody.codes's user avatar
  • 1,935
4 votes
0 answers
705 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 ...
Jon Bourne's user avatar
1 vote
1 answer
853 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 ...
Eight17's user avatar
  • 11
3 votes
1 answer
83 views

Email finding bot

I'm working on a lead generation bot that helps you find the emails of people you want to reach out to. The bot grabs your spreadsheet from gdrive, logs into several email finding tools, and collect ...
Tommy Adey's user avatar
0 votes
1 answer
107 views

Setting values in a spreadsheet

I have put together the following script to automate a process I have to perform at my work. The script solves some basic math functions and then inputs text values in certain cells. I have several of ...
jnohl's user avatar
  • 9
5 votes
1 answer
944 views

Small Python script using Google and Slack APIs

I've recently been working on a small Python script that I was tasked to do at my new job. It will basically handle the rotation and notification of the on call engineer by populating a Google ...
AJwr's user avatar
  • 153
3 votes
1 answer
542 views

Spreadsheet generated through Google Drive file iteration

I put together a script which goes through all of the files in Google Drive, and writes a spreadsheet with all of the files with their name, containing folder, URL, and date last updated. ...
STowslee's user avatar
  • 133
2 votes
0 answers
225 views

Retrieving Google Spreadsheet

I've made a JavaScript library that retrieves a Google Spreadsheet. It's something like Sheetrock.js, while mine is just a less powerful prototype. I've uploaded the source code and example in GitHub....
Jeon's user avatar
  • 121
4 votes
1 answer
391 views

Exporting unread mail details for further processing

As the result of some expert procrastination I have over 4000 unread mail in my gmail box. While that does not hold a candle to what some people likely have I wanted to try and do something about it. ...
Matt's user avatar
  • 2,568
4 votes
0 answers
92 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 ...
Mr. M. Perzan's user avatar
4 votes
1 answer
228 views

Summer camp cost calculation using Google Sheets

I am making a sheet that adds up the total cost for a summer camp after registration. Each parent can register up to five children. I have already made my code and it works, but there must be a ...
Nicholas Chauvin nxchauvin's user avatar
1 vote
1 answer
756 views

Google App Script to calculate score card for a certain person, create PDF file, store to drive and email to person

I'd appreciate if someone could cast an eye over my dodgey coding and give me some feedback. The use / purpose of the sheet/script is to quality grade calls, emails and chats with customers. A form ...
Munkey's user avatar
  • 177
8 votes
1 answer
118 views

Google Sheet with a column of names merged with Google Doc

I wrote my first script for google apps, but I am just learning how this all works. The script works fine, but I am sure there are things that are not done properly. Any advice is appreciated. The ...
Ognar's user avatar
  • 111
2 votes
1 answer
99 views

Combining 3 forms into 1, then writting data to 3 different sheets, with different layouts

Where I work, we have 3 forms for leavers: HR, IT and rota. Lots of questions are duplicated across all 3 forms. So I thought, why not fill ONE form out, remove all duplicate questions, and simply ...
Munkey's user avatar
  • 177
4 votes
2 answers
2k views

Parse and format data on Google Sheets

This is a script that I use on a Google sheet for parsing data that has been pasted from various other software and getting it into the correct format and columns on another sheet. Data is pasted into ...
CalPal's user avatar
  • 41
3 votes
1 answer
112 views

Catching API changes for a service that doesn't version its API

I'm using the old Google Data API to access several spreadsheets and put their contents in a database using Flask and SQLAlchemy. Each run deletes the contents of the database tables and repopulates ...
drs's user avatar
  • 131
5 votes
1 answer
4k views

Exporting a table from Google Sheets and sending it via email

Basically is a script to export a table from Google Sheets and send it via email. But it's not a clean script, although it works. If there is any way of making it more simple, or instead of get all ...
user3817505's user avatar
10 votes
1 answer
3k views

Managing Google Calendar from Spreadsheet

Overview: I have a need to manage a Google Calendar from a spreadsheet, so I developed a Calendar Manager program with Google Apps Script. I found some inspiration over on Stack Overflow, but my ...
RubberDuck's user avatar
  • 30.8k
12 votes
2 answers
604 views

Averaging a set of percentages between certain important levels

I have a spreadsheet, called "To Do", with set of percentages in column E and importance levels in column A: On another ...
Ky -'s user avatar
  • 407
3 votes
2 answers
1k views

Looping through selected cells to indent text

I have written the following Google Spreadsheet script that attempts to loop through all selected cells and then update the value so that it adds an indent, by adding ...
shwashbuckle's user avatar
4 votes
1 answer
124 views

Script for generating a report in Google-Spreadsheets. Looks for various values to check and count

It all works exactly as it should. It finds data from today, finds unique emails and puts them in an array. I then check the data again from today, against the emails to total up different values. ...
Munkey's user avatar
  • 177
5 votes
1 answer
576 views

Google Spreadsheet form script for employee work hours

The form updates a spreadsheet with agents (employees) hours worked for a specific date. The form has 4 pages, a first page where the date and office is picked. After which the form continues to one ...
Mantar's user avatar
  • 153
0 votes
1 answer
219 views

Country data archiving script using Google Spreadsheet

I've just created a script in Google Spreadsheet in order to archive some things. I have data from four countries. If something is marked done, then that line could be archived into that country's ...
molnardenes's user avatar
5 votes
2 answers
879 views

Spreadsheet function that gives the number of Google indexed pages

I've developed this spreadsheet in order to scrape a website's number of indexed pages through Google and Google Spreadsheets. I'm not a developer, so how can I improve this code in order to have ...
Kuhm Cyril's user avatar