Questions tagged [google-apps-script]

For questions about using Google Apps Script to extend Google applications

Filter by
Sorted by
Tagged with
0 votes
0 answers
5 views

How create a script for Google Docs with some Docs specific paragraphs configs? [closed]

I'm trying to create a script for Google Docs with some specific paragraphs configs. Docs only have a few number of paragraphs styles (Title, Headings, etc.). I need a script with this configs: 4 cm ...
  • 1
0 votes
0 answers
9 views

Too delayed execution of Googld Apps Script Trigger [closed]

I'm trying to clear a sheet of my total spreadsheet every 1 hour. It is obviously very simple script, just find corresponding sheet name (SkullKing), and clear certain sections. function ...
-1 votes
0 answers
17 views

Cell to Row then Cell to column

There's a way to add column and add data after we split from cell to column using Apps Script? Currently I split my cell to a new row from this to this using this code function result(range) { ...
  • 1
0 votes
0 answers
32 views

Google Sheets / IMPORTjson(): How to Resolve "Invalid Argument" Error [closed]

Using the Google Sheets IMPORTjson AppScript function, I'm try to pass this long URL and keep getting the error "Exception: Invalid argument:" as a response. The formula I'm using is =...
  • 225
0 votes
0 answers
19 views

How to Automatically Format a Google Sheet from Google Form data?

I have a Google Form which is linked to a Google Sheet that is submitting data for warranty exchanges for a client. At the end of each month they download the sheet as an Excel file to enter into ...
0 votes
1 answer
6 views

Exception: The parameters (String) don't match the method signature for SpreadsheetApp.Spreadsheet.getSheetNam [closed]

I am trying to create a google sheets form that would automatically populate the entered data from one sheet to another within the same document. However, I am getting this error when running them. ...
1 vote
1 answer
39 views

Cannot find active sheet: TypeError: read properties of undefined (reading 'source')

I'm trying to add the current date to a cell in column K when any cell in that respective row is changed. I found this script and altered it for my situation so I can deploy it as a trigger: function ...
  • 427
0 votes
1 answer
14 views

Insert formula, process and replace by raw value

What is the best approach to achieve the following: If a cell in column A has content, then place a formula into the cell in column B in the same row, referencing the cell in column A. Once the ...
  • 5,266
-1 votes
1 answer
18 views

App Script code is so slow [closed]

I have created a script for my sheet to do the following when a certain cell is edited: Get the timestamp Get the user E-mail Add the text "New" in another spreadsheet. function ...
  • 25
-1 votes
1 answer
6 views

How can I get the same format of cells in my script?

I've made a script, but I need the numbers off 3 rows to be on percentage and I also want to use only 2 decimals and format the date (one of my table colums) as "yyyy-MM-dd". this is my ...
  • 1
0 votes
0 answers
18 views

Custom conditional in Google Sheets: How to integrate in Apps Script?

My goal is to have Google Sheets detect when a cell's contents has a strikethrough added, and to change the font color of that cell in response. I learned that this is not possible without an Apps ...
0 votes
0 answers
19 views

Is it possible to make clickable links using Logger.log?

Is it possible to make clickable links using Logger.log? I have this code that log url Logger.log(url); that logs text in console. I wonder if this is possible to make that url clickable by using ...
0 votes
2 answers
19 views

CLEAR DROPDOWN IF ANOTHER CELL IS UPDATED

I am trying to figure out why my script is not working: I have a sheet called "active unentered invoices" where my master data is housed, I am using a true/ false statement is used in column ...
0 votes
1 answer
16 views

How to copy an existing google form filled survey (with answers) to a new google form survey (to create a different link than the original survey)?

I am using google forms to survey the same patient each month. Is there a way for me to create a different link to the patient's previous survey (and maintaining his/her answers) or to quickly copy ...
0 votes
1 answer
50 views

Writing an Array from Apps Script to Google Sheets

I have been out of coding for a while and have forgotten much. I am attempting to read data from a selection of cells from one page and then write it to another section if it meets the criteria. Both ...
0 votes
1 answer
10 views

I can not remove data validation with 2 criterias - Function onEdit(e)

I would like to run function onEdit(e) to remove Data validation with these 2 criterias as below: Remove for columns G,H,I,K if L is "no need". Remove for columns M,N,O,Q if R is "no ...
1 vote
0 answers
9 views

Using an android add (Http Shortcut) to start a google app script [closed]

I am totally a noob to coding and have no background in programming, hence have tried my best to understand things but am unable to. I am trying to get use an android app (HTTP Shortcut) to do a POST ...
0 votes
1 answer
17 views

Add Timestamp to Update Tab onEdit of Main Tab

I would like to have it that when a row is edited that it only copies the name, phone and adds a timestamp of the edit on another tab in Google Sheets. Each row on Update sheet should be a new row ...
0 votes
1 answer
51 views

OnEdit Not firing

[This Script]1 seems to be exactly what I want. Yet, it doesn't "Fire" when the reference cell is edited. That is, the target cell is not cleared. Just nothing happens upon editing the ...
0 votes
0 answers
24 views

How do you import cell fill color from another spreadsheet? [duplicate]

I am currently working on a spreadsheet with 100+ conditional formatting rules on columns, and the formatting rules significantly reduce initial page load speed. I already implemented IMPORTRANGE(), ...
0 votes
1 answer
22 views

Pulling all data from a column

tl:dr - I have a code that can work but want to make it better by pulling everything from column E into 1 message (including header) I am trying to get the output of a singular column to post to ...
0 votes
1 answer
31 views

Google Sheets - merge text in Apps script

i am looking for solution to merge text fragements in Apps script to automate a process. I have 3 sheets (sheet_1, sheet_2,sheet_3). In each of the sheets i have 10 cells (A1:A10) to be filled by the ...
2 votes
2 answers
119 views

Creating a custom menu in google sheets

I'm currently using the below code to create a custom menu called 'Team Admin' in Google sheets which allows a user to activate the function 'newSheet' when the menu item 'Add Agents' is clicked. ...
0 votes
1 answer
377 views

How to integrate the real OpenAI ChatGPT with Google Sheets?

Nowadays there are a lot of posts using the word ChatGPT but many of them use it as a common noun to refer to GPT-3 and some chatbots, not to specically make refence to https://chat.openai.com/chat / ...
  • 43.2k
1 vote
1 answer
27 views

Automatically record daily values from a column in a new row

I currently have a project tracker in a google sheet which records a project name, status character column and three progress columns as below: I would like to record a daily log of each progress ...
0 votes
1 answer
21 views

IMPORTRANGE to refer the function but not the value/result

Thanks for the help Here is my situation There are 5 different spreadsheets, i.e. Master, 1, 2, 3, 4) All cell A1 in 5 different spreadsheet has the same function e.g. =count(B1:B5), they count the ...
  • 1
0 votes
1 answer
14 views

Copying Google sheets data to newly inserted rows (which have been inserted by a script)

We would like to extend an (amazing) script for Google Sheets that inserts multiple new rows in Google Sheets based on a cell value (original question and answer: https://webapps.stackexchange.com/a/...
0 votes
1 answer
28 views

Apps Script to combine multiple sheets to a Master and have the Master automatically update if any of the child sheets are edited

I have multiple sheets that I want to combine to a master sheet. I want to have it that if the individual sheets are updated the corresponding value in the master sheet will also update. I can do this ...
0 votes
1 answer
25 views

Slow Script when duplicating tabs Google Sheets

I'm currently using the below script which essentially pulls a list of agents from a list then creates new tabs using a template sheet as the basis for the new ones and renames them all as per the ...
1 vote
1 answer
115 views

Adding multiple new rows in Google Sheets based on a cell value

I need to try and find a formula or script that can insert new rows in a Google Sheet between other rows of data, based on cell values. In the below example, cell X2 is showing "3", so we ...
0 votes
0 answers
80 views

Data Validation using Named range from Apps Script

In Dec22 Google changed how data validation is maintained [Release note].1 I have thousands of cells using different ranges for validation, and it's now impossible to maintain. I want to change them ...
0 votes
1 answer
22 views

Create a countdown timer from 2 different date and time

I have created a google sheet which consist of dates & time. What I want to do is to create a countdown timer from those 2 data. Here's my spreadsheet setup. Column A:1 11/01/2023 15:10:00 PM ...
  • 3
0 votes
0 answers
21 views

Onedit non contiguous range problem

I have an OnEdit function, when it is trigger I need to make some operations on the modified cells. Currently my code is going well when I have one modified cell or a contiguous range of modified ...
0 votes
2 answers
45 views

APP Script list Google Drive files in Sheet

I've been on a hunt to find a script that will return file names and hyperlinks into a Google Sheet. I found the following script that works perfectly, but is limited to PDFs. How do I modify this ...
  • 3
0 votes
1 answer
23 views

How to automatically update one google sheet based on the data available in other sheet

I have two different google sheets; one with the leads data and the other with unsubscribe data. Is there a way to automatically update the lead's data whenever a new unsubscribe email is added to the ...
0 votes
2 answers
48 views

How to create pop up and add link to a cell

I have a sheets file that requires users to inserts links in the cells of a specific column when they add the information required. However, to make sure this step is done accordingly, I would like to ...
0 votes
1 answer
14 views

When my function is called from onEdit it does not perform the same as calling directly

Per code below, a direct call to getWeather in the editor executes successfully to completion. But when triggered via onEdit in the spreadsheet, it properly displays my debug line "In ...
  • 3
0 votes
1 answer
40 views

Google Script to only search specific worksheet name not whole spreadsheet

This current script works but searches column 14 in all sheets on the spreadsheet. I only want it to search column 14 on sheet name "Master Crime Spreadsheet". Thanks in advance for your ...
1 vote
1 answer
31 views

Stop running script on last row with content

I have a script that sends emails to a list of recipients per row. For every row it checks certain conditions and sends an email with different information taken from different columns of that row. ...
3 votes
1 answer
168 views

How to parse RFC3339 with TZ to field so that Google Sheets recognizes it as valid datetime stamp

I have a Google Apps Script which receives a date/time value formatted in rfc3339, with Timezone info, for example: 2022-12-29T06:34:07.442788Z However, Google Sheets doesn't recognize this as a date (...
  • 33
0 votes
1 answer
24 views

Is there a function where if you modify a certain cell, the contents of another cell in the same column will be cleared?

E.g. If the range of cells is A1:A20 and the independent variable is A5. If A5 is modified then the content of A1 to A20 except for A5 will be cleared.
0 votes
1 answer
39 views

Automatically create new Sheets like 1st 2nd 3rd 4th and so on

I am using google Sheets I want to do the following but I cant figure out how: We do have like a daily Report sheet. We need it for every day, so I create 31 new Sheettabs 1 for each day and give the ...
  • 9
2 votes
1 answer
43 views

automatically generate new dataset from two data sheets // merge google sheets

I have two data sets: first data set: list of clients who bought a sertain product package: second data set: list of products for every product package: what I need is to generate (automatically) a ...
2 votes
1 answer
33 views

Exempting a cell containing a specific character

First, let me clarify that this is my first time doing anything with Google Apps Script or javascript in general. I'm trying to create a function that adds checkboxes to all cells in a column which is ...
  • 23
0 votes
1 answer
102 views

Defining variable type for google sheets script

I'm building an arduino project to measure environmental conditions in a salami conditioning cabinet. I've "stolen" some code from another project. https://iotdesignpro.com/articles/esp32-...
  • 1
1 vote
1 answer
25 views

How do I add multiple cellvalue in a IF function?

I'm trying to add more values with "Select a name" to the script so when any of these values pop up it'll clearcontent function onEdit(e) { let range=e.range; let activeRow = range....
  • 15
0 votes
1 answer
24 views

How do I Apply a simple script to a specific tab in a Google Sheet? I know zero code

I'm trying to apply this script to a specific tab to not ruin all the other tabs. function onEdit(e) { let range=e.range; let activeRow = range.getRow(); let activeColumn = range.getColumn(); ...
  • 15
-1 votes
1 answer
41 views

Borders in conditonal formatting

I am looking to remove borders in cells AG64:BE68 on the below spreadsheet based on whether Cell AG64 is blank or populated. I am aware its not possible to do just using conditonal formatting but ...
1 vote
1 answer
440 views

service spreadsheets timed out while accessing document with id, after copy some data between spreadsheets

I need to copy data from one spreadsheet to another every day. There is 13 columns and about 50k rows (counts of rows is growing with time). But from time to time, after copy some data, function is ...
0 votes
1 answer
441 views

Apps script wont let me use (row, column) notation with sheet.getRange

var range = sheet.getRange(i, 1); It only lets me use var range = sheet.getRange('A1'); otherwise it gives me error message Exception: The parameters (String,number) don't match the method signature ...

1
2 3 4 5
36