Google Apps Script (GAS) is a JavaScript cloud scripting language that lets you extend Google Apps and build web applications.

learn more… | top users | synonyms (1)

0
votes
1answer
8 views

Make cell “flash” onOpen rather than onEdit

I need a Google sheets script which will make the background color of a cell flash. Currently I have a script which works fine, but onEdit. It would be far better in this case if the script could work ...
1
vote
0answers
20 views

How can I programmatically (using Apps Script) import lots of contacts into Google Contacts?

I want to regularly import a changing list of ~500 contacts. I wrote an Apps Script that does this, but it takes longer than 6 minutes because it has to import each contact individually. I can ...
0
votes
0answers
15 views

Google Sheets: Script to add protection and remove the user running it?

We've been trying random solutions for the past couple of weeks that we have found on here and other sites.. came close a couple of times but still no bueno. Scenario: We have a worksheet that will ...
1
vote
1answer
16 views

Automatically “split text to colum” using Google App Script

I'm trying to figure out "if" I can automatically "split text to column" using Google App Script and the trigger of "on Form Submit". If yes, can someone help me figure out the solution to following ...
2
votes
1answer
17 views

autoincrement in Google Sheets based on Google Form submission

I'm trying to create an auto-generated unique ID# for each meetings being submitted via a Google Form. The unique ID# solution must also meet the following requirements. The ID# must be static (...
2
votes
1answer
13 views

Copy a column with mixed currencies using Google Apps Script

I have a google spreadsheet tab that needs to be copied to another sheet. In most columns I can set the formatting to the proper currency formatting, so when copying the column, the format is kept and ...
0
votes
0answers
5 views

Removing “Sent Via…” Text from Emails generated from a Google Spreadsheet Mail Merge Script

I found a spreadsheet script http://www.labnol.org/internet/personalized-mail-merge-in-gmail/20981/ that I use with Google Sheets that allows me to send out emails, pulling personalized elements from ...
-3
votes
1answer
16 views

ParseError on spreadsheets

I am receiving a "Parse Error" on this function: =loadBlueprints("corp",4324234,"7okqZ1gOyG43243243242342qb2wkyd21C",90926985) this turns out to be a parse Error though i do not see where it may be....
0
votes
1answer
19 views

Convert the data from comma-separated cells into repeated rows

I have a Google Spreadsheet where the first column is multi-valued (not all rows though) and also a few other columns. Not all columns are multi-valued. The values are separated by ',' Here is an ...
-1
votes
0answers
7 views

Parsing XML on Google apps script [migrated]

Here's my XML: <?xml version="1.0" encoding="UTF-8" ?> <response> <records> <record id='1'> <column name="Name"><value><![CDATA[John]]&...
1
vote
1answer
34 views

Process all files in Google Drives into Google Docs

I realised that I can convert all my images (and pdf files and such) in Google Drive to Google Docs and I won't be eating up any of my usage. Unfortunately, I have a crazy amount of images. How can ...
3
votes
1answer
10 views

Comparing values in two different columns, detecting those that are also present in the second

I have two columns I'd like to compare data in. The first column has about 50 rows, whereas the second column has 200 rows. I would like to be able to tell if any cell in the first column matches up ...
-1
votes
0answers
26 views

Problem with script to keep daily record in Google sheets

I'm turning to these forums after a long search on my problem but have not been able to find any solutions. I am trying to create a sheet on google sheets that keeps a record of data from another ...
1
vote
1answer
29 views

Auto insert column with today's date every day

I would like Google Sheets to insert a new column between columns A and B at the start of each new day with that day's date in cell B1. Is there a function or script that would make this possible?
1
vote
1answer
14 views

Importrange All Sheets

Is there anyway to call an IMPORTRANGE() and have it include all sheets? Here is my current function that combines the current data with the first archive, I'd like to set it up as a failsafe for the ...
1
vote
1answer
25 views

Transposing Column to Row

I am trying to write a script that will transpose a column from one sheet into a row on another sheet. I have already figured out how to do the copy, but I need to figure out how to change the data ...
0
votes
0answers
36 views

OnSubmit function, Google Forms and Google Apps script

If the number of rows increases, does retrieving a particular value using the below getValue function performs slower? Is there a better and more efficient way instead of retrieving a single Value ...
0
votes
1answer
23 views

Restrict the range of a script that replaces input data to a certain range

There is this question regarding adding checkbox functionality to Google Drive: Checkbox function to automatically add to total. And a great answer is: In the Google Sheets spreadsheet go to Tools ...
0
votes
0answers
31 views

How to stop Google Apps Script responding to noreply

I have a script that I have adapted to suit my needs. function autoReply() { var interval = 5; // if the script runs every 5 minutes; change otherwise var wkend = [6,0]; // 1=Mo, 2=Tu, 3=We,...
2
votes
1answer
38 views

Copy submitted form data to new automatically generated Google sheet

I have created a new sheet for every new name entered in the form using the following code. function formSheet(e) { var sheetName = e.namedValues['Name'][0]; SpreadsheetApp.getActiveSpreadsheet()....
2
votes
1answer
35 views

Auto-create and name new sheet in Google sheets from names being filled from a google form

How can I automatically create and name new sheets in a google spreadsheet from a list of name which are being input in the sheet from a google form.I would like each new sheet to be created when a ...
-1
votes
1answer
49 views

Getting e-mail adresses using a filter in Google Sheets /w scripts

I am trying to extra email replies from gmail. I already found some code that is supposed to work. My question is: how can one expand it to support a filter as a variable? (in this case so a filter ...
1
vote
1answer
55 views

Any way to send Gmail Out of Office/Auto-reply at the same times every week?

Because my clients bother me out of hours I would like to have my Out of Office respond out of hours without having to set it manually every day. To comlicate matters further I want to send one ...
2
votes
2answers
37 views

Run onEdit script in one sheet only

I have this Script so far, function onEdit() { var s = SpreadsheetApp.getActiveSheet(); var r = s.getActiveCell(); if( r.getColumn() != 2 ) { //checks the column var row = r.getRow(); ...
0
votes
1answer
37 views

Is there a script to draw a list of variables from a table to Google Forms?

I would like to have a field in Google Forms that allows the user to select a value from a "List" of values. The options in the list being drawn from a list in the sheet itself. This allows me to add ...
2
votes
1answer
66 views

Sending emails onSubmit using Google Apps Script Web Forms

Is it possible to send emails onSubmit() with Google Apps Script Custom Web Forms just like we can do using mailApp with Google Forms? I am currently transferring google forms code into html forms ...
0
votes
3answers
84 views

How do I compare the values of two columns and return the result in new columns?

EX. https://docs.google.com/spreadsheets/d/1CwFXSwIgnPdMocbrhTFZbEPRyXZUiovvWNy9MtOagxE/edit#gid=0 I wanted to compare two column "fix version" and "Affected version" and return the result bases on ...
3
votes
1answer
43 views

Can I host custom forms using Google Apps Script?

Is it possible to have custom forms created using Google Apps Script to have their own URL just like Google Forms do and be publicly available? Can I host these custom forms somewhere without using ...
2
votes
1answer
49 views

Google Forms - Show unique ID on the form (before submitting)

I need an anonymous form (no names, emails etc) that shows unique ID so that if a person decided to reveal that ID to me I will be able to find his/her answers in the spreadsheet. The ID can show on ...
1
vote
1answer
13 views

How to use user-defined functions for custom formatting?

I’m writing a simple Google spreadsheet to list every account number which could come in handy to our non-profit in the future. Of course, one can expect some typo will get in some point in the future....
1
vote
2answers
35 views

JavaScript To Dynamically & Daily Select The Next Worksheet In An Open Google Sheets File

At work using Chrome, I have a Google Sheets file saved on my Google Drive folder that's shared with me with edit privileges that I keep open on my MacBook Pro. After I've originally opened the file ...
2
votes
2answers
35 views

Organize employee time log into a table with a row for each employee

I want to get all the Timestamp of an employee (EmpID) from one sheet to another using Google apps script or otherwise. Explanation In Google Sheets, Sheet1 has the following items in 3 columns | ...
3
votes
1answer
57 views

How to know when the contents of a PDF in Google Drive are indexed for searching

I wrote a nice routine that allows me to get file Ids of 200 PDF files (uploaded some minutes ago onto my Google Drive) and setValue of a Google Sheet with those Ids. In order to get the correct file ...
0
votes
0answers
11 views

Google Spreadsheets: add hours to date problem

I've encountered some kind of strange problem with Google spreadsheets. I've 2 cells, in one I've date, lets say its 10/10/2010, in 2nd one is hour, 12:00:00. I get those from input cells, but when I ...
0
votes
2answers
50 views

How to sum cells in Google sheets that contain numbers and text

This has already been addressed in Excel but I was wondering how to do the same in Google Sheets. So suppose the B cell has this formula: ="frontend (days) total: "&sum(B2,B10,B14,B20) and the ...
0
votes
1answer
30 views

Sync multiple cells so that if any one of them is changed, the others change as well

I have 4 hard coded cells on 4 different sheets (within a google sheet file) that I'd like to keep synced. If any of those four cells have been changed, I'd like the other three cells to be updated to ...
0
votes
0answers
28 views

Loop through columns in different sheets, comparing the values

I have three sheets. One is for the item senders, one is for the receiving of the items, and the other times compares the sent and received. For the comparison to work I need to loop through columns a ...
0
votes
1answer
47 views

Google apps script to check availability

I'm using google form+calendar to create a reservation system for my makers lab. The user fills out the form and an event is created on the calendar so the TA knows when to goto the lab to help the ...
1
vote
1answer
36 views

Script to delete a dynamic range of rows

I'm looking for a script that allows me to delete a dynamic range of rows. Basically I have a script that adds rows to the bottom of a list but I want another script that will delete all rows in the ...
0
votes
1answer
94 views

Using Google URL Shortener API in Google Sheets for bulk URL shortening

Recently come across similar issue to this question, where I want to add use the Google URL shortener API in Google Sheets for bulk URL shortening. However, I keep running into this error: Rate ...
0
votes
1answer
23 views

Is there a way to print the source code of Google App Scripts?

I am an old fashioned programmer and like to print the source code of Google App Scripts. Is there a way to do that?
-1
votes
2answers
72 views

Fetching JSON in Google Sheets (ImportJSONAdvanced not defined?)

Currently working on fetching data from an API with Basic Authentication. Through this script: https://gist.github.com/anemitz/8cc6ef6c41ea4cefe51a13fbd6d8676a function ImportJSONBasicAuthentication(...
1
vote
1answer
85 views

How to embed Google Sheet into Google Document and keep the Google Sheet format

How do I embed a Google Sheet into a google document and keep the Google Sheet format in the document? I have got this far with the script but it's not working function updateData() { var ssUrl = '...
3
votes
1answer
44 views

Sum the totals for each product over all sheets in a spreadsheet

I'm trying to make a spreadsheet to take online orders from clients. I send them a price list, which they complete with their order and every time a client sends an order, it automatically adds a new ...
2
votes
1answer
51 views

Can I set a trigger to run every second?

While searching for answer to How can I trigger a function when switching sheets within a spreadsheet? I noticed that the Triggers for current project dialog has an option for specifying a trigger ...
3
votes
2answers
94 views

How can I trigger a function when switching sheets within a spreadsheet?

How can I trigger a function when switching sheets? Let's say I'm viewing a multi-sheet spreadsheet. Now I want a function to run whenever I switch from one sheet (tab) to another. Is that possible? ...
0
votes
0answers
28 views

Set a send email account in Google spreadsheet

I have 3 email accounts, two gmail (a "corporate account" and a work account) and one personal account not via gmail. We collect requests in a google spreadsheet, where I want to add a hot mailto ...
3
votes
0answers
23 views

google docs, make summary sheet based on tags

I have a document in google docs. It is very long and I want to tag and extract only certain paragraphs into a second document that is a summary of the first document. I want to be able to dynamically ...
0
votes
2answers
64 views

“Select Users from organization” field with Google Forms?

So here is my scenerio, I have a Google form that allows users to send a co-worker a digital greeting card, but they have to manually enter the email address of the person they are sending it to. The ...
1
vote
1answer
27 views

Timestamp code for Google Sheets

I am using this script in order to put a time stamp in column B when someone edits in a row. However, I need it to place the time stamp if someone edits a row in column A. I don't need it to place a ...