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
20 views

Run Google Apps Scripts locally to process spreadsheet data

I have a spreadsheet that needs to make many hundreds of calls to functions I've written in JavaScript in the Google script editor, to fill many hundreds of cells. The problem is I get the error that ...
2
votes
1answer
18 views

How to apply autoformatting in Google Apps Script?

Neither shortcuts e.g. CTRL + Shift + f nor options provided by the taskbar: seem to be able to apply autoformatting in Google Apps Script.
0
votes
0answers
14 views

How can I create a search, return and replace app for a Google sheet [on hold]

Would it be possible to create a search, return and replace app for my Google sheet? When a customer submits a Google Form, the data is placed in the responses sheet. I would like to then create an ...
0
votes
1answer
9 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
22 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 ...
2
votes
1answer
114 views

Using Google Apps to handle customized after hours auto responses to support based email inbox

THE SETUP: Our company has a primary support email that all of our clients use to generate helpdesk tickets. It is a google apps inbox using helpdesk@%our primary domain% Our ticketing support auto ...
2
votes
1answer
192 views

Auto Sort data in Google sheet, but by sheet not range

I have found this script from this question to auto sort a column: How can I apply a script to only one specific sheet within a spreadsheet function onEdit(){ var sh0 = SpreadsheetApp....
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 ...
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
18 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
14 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
17 views

ParseError on spreadsheets [on hold]

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
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
223 views

Dropdown list based on the result of another cell's dropdown

I want to populate a dropdown list based on a selection of another cell's dropdown list. Here is my spreadsheet. E.g., if user does not make a choice from D20 dropdown menu, therefore F20 dropdown is ...
2
votes
1answer
50 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 ...
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 ...
2
votes
1answer
39 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()....
1
vote
2answers
240 views

Sort randomly in a Google Script

I found this script to sort a Google Spreadsheet but I need to sort everything randomly instead of alphabetically, is there a way to sort it randomly every time this script runs? > // LinkBack to ...
1
vote
1answer
107 views

Google Sheets - Keep multiple sheets synced (both ways)

I need to have multiple Google Sheets be synced both ways. For example: I have a "master" sheet that has all of my information. And then I have multiple "filtered" sheets. Each filtered sheet only ...
-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]]&...
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
vote
1answer
233 views

Download list of contact information and check if Google Account

I'm looking for a way I could: retrieve a list of all my contacts and their email's and In order to retrieve a list of all of my contacts into a Google spreadsheet, I exported them as a Google CSV ...
5
votes
2answers
4k views

Google Spreadsheet Sort Two Columns

So I've found the following answer in regards to auto-sorting by one column, which works great How can I make some data on a Google Spreadsheet auto-sorting? However, my use case requires the sorting ...
9
votes
2answers
5k views

In Google Spreadsheet, finding what formulas reference a given value

I would like to find out which cells have formula dependencies in a large spreadsheet. I am looking for a way to do something like OpenOffice Tools>Detective>Trace dependents and Edit>Find &...
-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
87 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 = '...
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
15 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 ...
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 ...
3
votes
1answer
152 views

Problem: Script does not trigger on FormSubmit: Removing Duplicates in Google Sheet of Form Responses based on a column

I am trying to remove older duplicate form responses based on a column using the following code. The credit for the code goes to: http://www.jacorre.com/tutorial/remove-duplicate-rows-google-...
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 ...
1
vote
1answer
48 views

How can I automatically set “sheets last updated” in a cell on Google Docs Spreadsheets?

Simple task!.. output a date and time every time something in the sheet is edited! function onEdit() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheets("Data"); var ...
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
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 ...
18
votes
8answers
20k views

How to pass a range into a custom function in Google Spreadsheets?

I want to create a function which takes in a range... something like: function myFunction(range) { var firstColumn = range.getColumn(); // loop over the range } A cell would reference it using: ...
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 ...
3
votes
1answer
59 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
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,...
7
votes
4answers
27k views

How to automatically insert a new row and retain functions/formulas from last row?

I have a table with cells that have functions/formulas, like this one: I need a script that creates a new row, copying with it the functions/formulas of the last used row. I find this script which ...
2
votes
1answer
36 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 ...
2
votes
2answers
38 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(); ...
-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
2answers
730 views

Make a counter, that counts cell change

I have a cell, let us call it A1, that contains an IF function. Cell A1 changes between two types of text: Healthy Injured What I want is a counter in for example B1 that counts how many times A1 ...
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
1answer
68 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
85 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 ...
0
votes
3answers
5k views

Parse HTML through Google Spreadsheet using scripting

I'm trying to speed up the process of getting values from an HTML page to a Google Docs Spreadsheet through scripting. I remember Microsoft Excel had the import data function, but I don't own a copy ...