current community

your communities

more stack exchange communities

Stack Exchange
tour help
stack overflow careers

Tagged Questions

Google Apps Script is a JavaScript cloud scripting language for automating tasks across Google products and third party services.

learn more… | top users | synonyms

0
votes
0answers
3 views

oAuth2 code for replacement for of oAuth1 in Google Docs

Following is function call and function which helps in oAuth1 in Google Apps Script for Authorization from google Docs but as oAuth1 is getting discontinue from 20 April 15, replacement code for ...
0
votes
0answers
9 views

How to get JS variable from Google Script?

Hello guys im new on Google Script, im making an app that read the input from the box, and then send it to the mysql. I have this: - Codigo.gs function doGet(e) { return ...
1
vote
2answers
15 views

google not defined in google script

Alright I've looked through the google documentation and a bunch of posts here with no success (maybe I missed one). I'm writing a google script that creates a table using google.visualization but I ...
1
vote
2answers
9 views

Set signature for Google user: change code oAuth1.0 with oAuth2.0 (Google Apps Script)

I use a Google Apps Script (found here: http://blog.knoldus.com/2013/01/11/google-apps-script-to-create-signature-block-for-user/) that set a user signature. Each my user have a signature with same ...
0
votes
0answers
14 views

Returning/Opening a Document upon completion

I am trying to get my script to open a document on success of the run of the script. However, the return statement seem not to be doing what I expect from it. I'd really appreciate any help with ...
0
votes
0answers
18 views

How do I include form data in email to SUBMITTER?

I am trying to include in the email notification to the submitter/user (person filling out the form) the form the data from the form that the put into the form. I found this tutorial on including it ...
0
votes
1answer
20 views

Trigger an email notification if cell is changed

I need help creating a script for Google Apps! I want to be able to send email notifications if a specific cell has been changed (eg: E10). Can someone please help me with this? Thanks in advnace!
1
vote
1answer
50 views

How do I output a 2D array to a Google Sheet?

I have a list of teams that have been ranked, and I want to put them up in groups of three. Here is an example: Team Name Rank Example Team #1 1 Example Team #2 2 Example Team #3 ...
0
votes
1answer
13 views

How to update/ overwrite input in the same row not in lastrow google app script

I have a search tool like this: https://sites.google.com/site/appsscriptexperiments/home/a-simple-search-tool-ui But put it in a panel, add an edit button to enable textboxes and an update button ...
1
vote
1answer
17 views

How to update row return in the same row not in lastrow google app script

I have a search tool like this: https://sites.google.com/site/appsscriptexperiments/home/a-simple-search-tool-ui BUT put it in a panel, add an edit button to enable txtboxes and an update button ...
0
votes
0answers
18 views

UrlFetchApp doGet not called and return html with “Meet Google Drive”

I must be loosing my mind as suddenly I can'y get a simple webapp to work. When I use the url generated in the browser everything works fine. When I run the script the result is an html content with ...
0
votes
1answer
26 views

Extract two words from a cell in to another cell in google spreadsheet

I am new to google spreadsheets & want to copy class names mentioned in range c10 in to b3. I am trying to use following formula which I know is wrong: =query(C3:C52, "copy class name where C ...
0
votes
1answer
7 views

Set spreadsheet cell formatting using Google Apps Script

When editing spreadsheet we can specify cell formatting using this button: I would like to do same thing using Apps Script, but I cannot find that in API. There is a method called copyFormatToRange ...
-1
votes
0answers
13 views

Fusion table to be updated from google spreadsheet but not sync. and should avoid duplicates

Have a Google spreadsheet which is regularly updated with daily sales data we need only current two months data maximum at any give point of time in spread sheet rest needs to be backed up in fusion ...
0
votes
1answer
18 views

Extract class names from cells in google spreadsheet

I am new to google spreadsheets & want to copy all class names mentioned in range c3:c51 in to b3. I have tried with filter formula but could not succeed, can you please provide formula for the ...
0
votes
0answers
28 views

APP script times out after 6 mins

I am running a long app script which times out after 6 mins. What is the best way to restart the script from the same place? Like some trigger?
0
votes
1answer
19 views

How to run a Google Apps Script on a hidden sheet

I have a sheet that is hidden that determines who will be emailed. The script that I have now will not run without having the sheet opened. Is it possible to run that GAS without having to unhide the ...
0
votes
0answers
8 views

Set GmailLabel color using Google apps script

I think it is not possible yet, but maybe someone created a workaround? Thats my problem: I want to create Gmail labels and specify a color to them by using Google Apps Script. Manually I can do ...
1
vote
0answers
12 views

Google Form App Script Automatic URL Redirect

My problem is that I have Link on all my business cards that leads to a Google form. I no longer am using that form and have moved on to Sharepoint. I need to redirect users to the new site. I already ...
0
votes
1answer
24 views

Security risk of whitelisting google apps script ip addresses

perhaps this isn't the best place to ask this, but I wanted to be educated. I would like to have a Google sheet interact with data on an oracle server. I have been reading the Google Apps Script ...
1
vote
2answers
21 views

Google Form Response Sheet script that triggers copy of a template spreadsheet to a new filename

I have created: Google Sheet as a Master Template ("QC_MasterTemplate") in my root drive that has all formatting as I want for a Checklist to be completed for every new sales order taken. Google ...
0
votes
0answers
22 views

Format TextOutput object in UTF-16 with Byte order mark (BOM)

I'm using the doGet() to download an xml file using: var output = ContentService.createTextOutput(); var doc = XmlService.createDocument( root ); //... fill in doc here ... var format = ...
0
votes
1answer
29 views

Script not Clearing cells

I'm sorry for asking this I've been doing so much reading. The script does finish but its not clearing selected cells. What did I do wrong? Please help? // Display a dialog box with a message ...
0
votes
1answer
18 views

my Current /downloadis not showing on google developer account

i have created my account two days ago but total download is not showing, but the number of people that rated the app is both showing on google play and the developer account
0
votes
1answer
18 views

Filter range by selecting any single word from a cell

I am new to google spreadsheets and trying to implement function in following way: =FILTER(C3:C7,D3:D7=E3) E3 contain words: "Where India Love Cannot" Range D3:D7 : Each cell of range contain many ...
0
votes
0answers
43 views

Authentication in google App Script

I am beginner in google app script so think of creating one small project, in my project i am trying to fetch data from CSV by using UrlFetchApp.fetch(URL) and write into google app script, I am ...
0
votes
2answers
29 views

Google Apps Script Inner Join Ranges

I would like to "inner join" 2 data-ranges (SHEET 1 & 2) by "ID" and output its result in SHEET 3 (as shown below) For all sheets the first row is only the header, the actual values start from ...
0
votes
1answer
28 views

Google Apps Script Example - How to change value of listbox dependent value of radio button

I have a question about Google Apps Script. I want to create a basic form where the form contain a textbox, radio button, listbox and fileupload. My issues here, I want to change value of listbox ...
1
vote
1answer
27 views

how to return a project's 'project key' programmatically

I can easily get the project key by going to File --> Project Properties --> Project key (on the info tab) but is there any way to return the 'project key' from the script itself?
0
votes
2answers
24 views

Google Apps Script returning wrong minute from Date object

In Google Apps Script I am directly inputting the arguments into a Date object constructor and the returned date is incorrect for the minutes and seconds. The returned minutes and seconds are ...
0
votes
1answer
34 views

GAS not working on windows machine

I created an application using GAS and HTML service. It works on Safari and Chrome on mac, using different logins for a google apps account, but for the same accounts, it does not run on any of the ...
0
votes
1answer
46 views

Is it possible to launch the Google Drive image viewer?

Basically, I want to exactly reproduce the behaviour of when you double-click on an image in a Google Drive folder and you are presented with a image viewer with all the images and videos contained in ...
0
votes
1answer
32 views

Trying to remove Google Groups members gives Not Authorized exception

I have a google apps script attached to a Google Sheets document. I have the following code. function addGroupMember() { var userEmail = '[email protected]'; var groupEmail = '[email protected]'; ...
0
votes
1answer
47 views

Google Apps Script - deleting a row if today's date is past input date

I'd like to make a script that compares the date within a row to today's date and delete that row if today's date is paste the date row. This is my current script: function deleteRow1() { var ...
0
votes
0answers
21 views

Published Apps script as both a web app and an sheet add on

I have a container bound script (G Sheets) I wish to have an HTTP API available with it. I want to publish the script as an Add-on. The problem I have is that the doGet and doPost features will only ...
0
votes
0answers
15 views

I am trying to figure out a way to send emails to multiple addresses entered in a same cell in Google Sheets and I am stuck

The part of my code that sends the email: I enter the email address of the concerned person in ROW 6, what i need to do is update the program to be able to send an email if I enter two email ...
-1
votes
0answers
29 views

Working with Google forms and spreadsheets

I take online classes on a couple of courses and will form a batch after 10-15 days from the start date of a batch. My assistant helps me in filling the batch details through a Google form and the ...
0
votes
0answers
19 views

Running code as one user by another user via the use web app or installed trigger?

I currently have a spreadsheet that has fields that must only be edited by scripts. If I understand correctly, both of these would provide the required function of allowing User X to run a script to ...
0
votes
1answer
26 views

Multiple File Upload Google Apps Script

Put together this script that will upload a file to my google drive. I need it to be able to handle either a big .zip file, OR multiple image files. Currently it times out if you upload a big .zip ...
0
votes
2answers
43 views

Show a list of Drive files and allow the user to select one

I want to create a web app to use in a Google Site. The app would allow the user to select a Spreadsheet in Google Drive and pass the file ID to a script to then use the getByID functions to complete ...
0
votes
1answer
14 views

Google Apps script: make the radio field required

It may be a simple one for the expert. But I'm not able to figure it out. I have a google apps script that shows two radio buttons. var txtGender = ...
-2
votes
0answers
13 views

Regular data backup from one google spreadsheet to another using google script

I would like to backup data from one google spreadsheet to another spreadsheet via google script whenever data is updated. Scenario: Spreadsheet-1: Data present in Spreadsheet-1, Name apple ...
0
votes
1answer
19 views

insertColumn() and update getLastColumn()

quick question concerning Google Spreadsheet. When I use insertColumn() and sometimes later getLastColumn from the sheet, it gives me the last column of the old, un-appended sheet. Even if I store the ...
0
votes
0answers
42 views

Google script table - file.makeCopy

File name when saving should be "firstName secondName thirdname" and saves as " copy copy copy". What is the problem? function myFunction() { var spreadsheet = ...
0
votes
1answer
24 views

Filling in School reports (v from a spreadsheet file in which all grades are kept

I'm trying to migrate my excel files to the google spreadsheets but I have trouble with the following. In my excel design what I did was keep grades in a single file. From this file I made a ...
-1
votes
0answers
35 views

Google Apps Script: Can't find method createFile((class))

I have problem in Google Apps Script. I created a basic form that takes user input via textbox, radio button, checkbox and file upload but i got stuck in file upload. I've read a solution in this post ...
0
votes
0answers
37 views

how to save 2 tables in google big query using google app script?

I have to make 2 tables where the second table created uses the first table. It looks like this: function saveQueryToTable() { var projectId = 'your project'; var datasetId = 'your ...
-2
votes
1answer
35 views

Google script to split comma separated values into rows

I am looking for a google script to create a row for each comma separated value and also create all possible permutations if there is more than one column that contains comma separated values. For ...
0
votes
1answer
25 views

Google Sheets custom function conditional formatting

I need to make a cell text turn red if the value of the cell is equal to the value of the cell two rows above it. I have these two functions in my script editor: /** * Compares cell value to another ...
0
votes
1answer
41 views

How to set default drop down list value from another drop down list in sheets?

Here is what I am trying to do. I have a list that populates a drop down list created by data validation. I then query the data to populate a second list based on the first drop down value. ...

1 2 3 4 5 … 183