Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [google-apps-script]

For questions about using Google Apps Script to extend Google applications

1
vote
0answers
14 views

Copy formula every other row and every column

I have been playing with scripts to try and figure out this tedious task as there are 600ish rows in my sheet, times 4 sheets. So far I have come up with this function myFunction() { var ss =...
0
votes
1answer
24 views

VLOOKUP vs IMPORTHTML

I am having a Google Apps Script issue using VLOOKUP on some data generated by the IMPORTHTML function. For normal user interactions this does not seem to be an issue but scripts accessing the ...
0
votes
0answers
31 views

How do I find the value in the first column according to the edited cell? (Google Sheets)

I'm trying to create a sheet in the same workbook that will log changes that are made on the master sheet. Here is the 'Master List' where changes will be made: This following information needs to ...
0
votes
1answer
197 views

Google Sheets script down or moved to a new address

I was using a localization Google sheet that has this script. Everything worked fine until I suddenly got this error message: UiApp has been deprecated. Please use HtmlService Instead. So I made ...
2
votes
2answers
61 views

ARRAYFORMULA with IF, DETECTLANGUAGE and LEN

I'm trying to make an array formula to detect the number of English characters in a range. When I use the following for individual cells: =IF(DETECTLANGUAGE(ARRAYFORMULA(A5:A))="en",LEN(ARRAYFORMULA(...
1
vote
1answer
61 views

Please tell me about how to implement privacy policy site for my Google Apps Script project (mail from Google Apps Developers)

I have three questions, tell me please. 【As a premise】 I have a Google Apps Script project to do these. Tweet automatically on my Twitter bot Send mail from the my Gmail address Read and write ...
0
votes
2answers
23 views

Conditional formatting by using the note in Google Sheets

How can I use conditional formatting by using the note on a specific or many cells in Google Sheets? For example, I would like to set up conditional formatting to a specific cell and when I use a note ...
1
vote
1answer
39 views

Pass cell value into Google script

I'm facing a problem, hope anyone can help me. I have 3 sheets with different functions, data_sheet contains a thousand data with date in descending order in Col A, input_sheet is only for input data ...
2
votes
0answers
30 views

Script to transfer data from invoice sheet to database

This is my first post and I'm new to scripts. Upon searching through multiple questions similar to mine, I couldn't find exactly what I was looking for. I want to create a macro that pulls specific ...
0
votes
0answers
81 views

Pulling specific data from Firebase/firestore with google app scripts to Google Sheets

I'm trying to capture data (mainly the integer, double, string and time values) that is sent from a website periodically with firestore as its source. Examples of the data source and structure are ...
0
votes
1answer
43 views

Translate UrlFetchApp Response HTML To Google Sheet

I'm new to working with APIs/CURL and trying to figure out how to get a response (not response code) into a sheet. Here's my code: function myFunction() { var url = "https://platform.quip.com/1/...
1
vote
2answers
57 views

Jump to today's date when opened

I have found a similar question here: How to make Google Sheet jump to today's column when opened? I want to do a similar thing, but I have the dates in row 5 not in the column. I tried several ...
0
votes
1answer
25 views

Google Script Range Error - Owner Range?

I've been playing around with Google Scripts and I'm trying to pull some data into a sheet. It all seems to check out except one line where I get a range error, I know (or I think I do) that it has ...
0
votes
1answer
31 views

How to upload a photo from mobile phone to Google Forms as an answer?

One can choose file upload to Google Forms, but when answering in form option only opens Google Drive upload dialog. Is there any way to upload photo from mobile phone as an answer? E.g. is it ...
0
votes
1answer
39 views

How to print the first modified date of a cell

I would like to make a script that works like this script to print a timestamp when a cell was last updated but in this case I want to return when it was first updated, not last. Here is one attempt:...
0
votes
1answer
23 views

Move ROW upon selecting a specific option from drop down menu

I am looking to use Google Sheets to keep track of my jobs. I have a spreadsheet set up so the status of a job is indicated by a dropdown menu. When a job is completed I would select "Closed" from the ...
0
votes
1answer
28 views

A Google script to disable keys in a keyboard

I have a project in which the "Delete" key needs to be disabled in keyboard when working on the sheet. Is there a script to do this?
1
vote
2answers
74 views

Move cursor to cell in all sheets

I have the following script: function setActiveCells() { var wb = SpreadsheetApp.getActiveSpreadsheet(); var ws_names = wb.getRangeByName('an_sheets').getValues(); var ws_cells = wb....
0
votes
0answers
15 views

Auto-Sort script which excludes formula if ascending False

I am looking to exclude formulas or blank cells when I am running my auto sort. I used the following... It sorts fine, but I wanted the numbers to be ascending: False. When I change this, it takes ...
0
votes
0answers
13 views

Google Sheets [Script]: Add new row to the top when previous one is filled up [duplicate]

I have a spreadsheet where I record info by rows and it's troublesome to scroll down to type out in a new row. I'm looking for a script to help me add new rows. What happens is that row 2 is blank (...
0
votes
1answer
19 views

How to apply scripting only to rows with data in them?

I have a Google Sheet that adds multiples rows per day as forms get entered. What's the best, most hands-off way to apply formulae to rows as they get added? I've built a script, but it applies the ...
2
votes
1answer
31 views

Timestamping purchase entries

I’ve created myself a budget tracker where I can track what I bought and how much I spent across a few categories. I specified column B (purchase entries are rows) to be the date and time at which I ...
0
votes
1answer
24 views

Calculations which won't recalculate

I'm trying to make a simple calculator in Google Sheets with checkboxes for certain values. For simplicity I'll refer to these Checkboxes as A and B. What I would like to have is the user selects A, B,...
0
votes
1answer
38 views

Making Google Sheets script work on multiple tabs

Below is my script or code: function myFunction() { } function onEdit() { var s = SpreadsheetApp.getActive().getSheetByName('Sheet1'); s.showRows(1, s.getMaxRows()); s.getRange('H:H') ....
0
votes
1answer
37 views

Running formatting script across multiple Google Sheets tabs

I have an onEdit script I'm using to protect/force formatting on a single tab within a google sheets document - and it works perfectly. The issue I have is that I'd like the same script to work on ...
0
votes
1answer
135 views

Split multi-line (comma-separated) cell into new rows + duplicate surrounding row entries

Based on: Google sheets split multi-line cell into new rows (+ duplicate surrounding row entries) How can I rewrite this for use of a comma as separator and remove blank spaces? Input sheet: ...
0
votes
2answers
100 views

How to merge Google documents with PDF files automatically?

I am trying to merge different file sources into one Google doc, in a programmatic way. That means I should use Google scripting. So far I do not have problems inserting text files, images, MS Word or ...
0
votes
0answers
19 views

Classic Google Sites page throws error on the web browser console

I just noticed that it’s not even my code that causes the error — classic Google Sites page on load is throwing that error. I tried in incognito mode and I still get an error on any page load. I am ...
1
vote
1answer
42 views

Dynamic protection based on cell value

In my Google spreadsheet, I want to protect all cells below a checkbox if it's value is true and unprotect if it's value is false. Every cell in row 3 is a checkbox that this has to work for. Example ...
0
votes
1answer
230 views

Making select columns UPPERCASE

In relation to the post linked below, is there a similar script out there that will apply this same functionality to only certain columns in a Google Sheet? Convert all text to UPPERCASE in a Google ...
1
vote
1answer
415 views

Is there a way to emulate Vlookup in Google Script?

I did some looking around and I'm struggling quite a bit in finding the answer. I'm working on a Google Script for Google Sheets that works like a Vlookup, where you define a cell for it to look at, ...
1
vote
1answer
29 views

Cell format protection + forced capitalisation [duplicate]

I've created a Google Sheets document intended for daily use by more than a dozen people. Text inputted in two of the columns is set up, via conditional formatting, to change colour based on the name ...
1
vote
1answer
23 views

Can I record the users within a Google sheet?

I'd like to have an auto-generated list of users with timestamps within a spreadsheet, tabs, or if possible specific cells. Ideally, once a cell has been altered, I'd like another cell to record the ...
0
votes
0answers
31 views

Have script code itself dynamically update based on value of cell in sheet?

I'd like to have the script coding itself change as I change the data in a sheet. For example, I have a script set to list the all the files in a particular folder as well as their ids. It spits them ...
0
votes
0answers
9 views

sheet date copy

When you run a macro from the "A" sheet, you need a script that pastes the data from "A1:C1" to the "B" sheet "A:C". We want data to be stacked in a blank space every time we run a macro, whether it's ...
-3
votes
1answer
39 views

Possible scam using Google Drive

Is there any possibility of someone harvesting email address and/or Google profile info by sharing a link to a file on Google drive and collecting info on the people who view the file? I suspect a ...
0
votes
2answers
219 views

Having Google Sheets not recalculate a formula on page load

I have a Google Sheet with a list of addresses, and a column that geocodes the addresses with mapquest via Google App Script. This works great, except it "recalculates" the addresses on page load. ...
0
votes
1answer
35 views

What is the difference between Google Apps Script add-on and web app?

The issue is mainly that I don't understand what is meant by the web app. I understood that it must support HTTP requests, but otherwise is it the same? Or is the difference in publishing? I looked ...
1
vote
0answers
185 views

Internal Error when trying to share Google Apps Script

I'm the owner of a Google Apps Script project that contains several scripts. When I try to give Edit permissions to people in my organization, it throws an error: Error Sorry, an internal ...
1
vote
0answers
62 views

How to pass a parameter allow= “geolocation” when embedding Google Apps Script in a Google site?

The target is to embed a Google Apps Script gadget into my Google site. The function of this script is to show a google map, determin the location of the client and center the map to the found ...
0
votes
1answer
26 views

Is it possible to reverse engineer a Google Doc into Google Apps Script File?

I'm trying to figure out if it is it possible to reverse engineer a Google Doc into Google Apps Script File? I'd like to be able to evaluate a Google Doc (GD#1) by its URL and convert that doc into a ...
0
votes
1answer
26 views

Google spreadsheet mail as Excel attachment

I want to mail Google Spreadsheet as excel attachment, and also I want to write 4 to 5 lines in the body of a mail, and also I want to send this mail to many peoples some in "To", and some in "Cc" can ...
0
votes
1answer
41 views

Im trying to make a automated script, that auto sends emails with an pdf attachment

This is my script function sendEmails() { var sheet = SpreadsheetApp.getActiveSheet(); var startRow = 2; // First row of data to process var numRows = 8; // Number of rows to process // ...
-1
votes
1answer
35 views

Google Script Editor apply to all sheets except 1st, 2nd and 3rd sheet [duplicate]

Currently this code is only applied to the sheet called "Name" I wanted applied to all except for 3 sheets (Template,Summary and Count): function EqualValue() { var ss = SpreadsheetApp....
0
votes
0answers
99 views

Get final redirected link from Google's “I'm feeling lucky” function

I need to write a Google App Script function that takes the redirected link from Google's "I feeling lucky" button. The function should take: http://www.google.com/search?q="stackoverflow"&btnI ...
0
votes
0answers
18 views

How to make Google sheets editable only for a few days a month

I have a spreadsheet in which users fill in their names for their shifts for next month, and they should do it only during 20th to 25th in a month but they keep breaking this rule. So I would like to ...
0
votes
1answer
160 views

Conditional formatting with color scale for many rows independently once

I create reports with different cohort tables. Each row of a table must have conditional formatting with color scale (depending only on current row values, i.e. regardless of other rows min/max values)...
0
votes
0answers
30 views

Dialogue Box Input w/o click (just enter) in Google Sheets

I want to be able to use a barcode scanner to enter data in a dialogue box in Google Sheets. The barcode scanner inserts "enter" after the numbers. How can I make the enter trigger the data entry (...
0
votes
0answers
13 views

Recalculation of references after Copy in Google SpreadSheet

I have the problem of the lost references after a copy in Google Spreadsheet that has been solved in that post with the "Find and Replace" of "=". But is there anyway to do that trick in recalculation ...
0
votes
1answer
77 views

How to use 3 separate sheet specific onEdit formulas?

So I have 3 separate sheets in on Google Sheet Doc, I have a script running on the first sheet that hides a row when a drop down is ammended: var SHEET = "Tweaks Needed"; var VALUE = "All Tweaks Made"...