Questions tagged [google-apps-script]
For questions about using Google Apps Script to extend Google applications
1,799
questions
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 ...
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) {
...
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 =...
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 ...
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 ...
-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 ...
-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 ...
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 / ...
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 ...
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
...
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 ...
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 ...
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 (...
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 ...
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 ...
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
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....
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();
...
-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 ...