Questions tagged [google-apps-script]

For questions about using Google Apps Script to extend Google applications

Filter by
Sorted by
Tagged with
2
votes
1answer
72 views

How do you dynamically add multiple URLs into rich text for Google Sheets using Google Apps Script?

I have multiple links to Google Drive files in an array. I need to get the links into this format in the cell: File 1, File 2, File 3 The links should be "File 1", "File 2" and &...
2
votes
1answer
40 views

How to automate find and replace link in Google Sheets from form photo submission

Trying to automate find and replace function on form submission within sheets. Principal/Teacher submits a photo through a Google Form and I want to change from the file link to a search to link ...
0
votes
1answer
56 views

Google Script: Changing date format from Typeform Response in Sheets

I'm using Google Script to add a function where once the response from Typeform is sent to the sheet, a button called "create document" is added to fill up the Google Doc template using the ...
1
vote
0answers
37 views

Google Sheets split into new rows while duplicating surrounding row entries

I am creating a spreadsheet for a service drive my non-profit is doing. As people sign up through a Google Form, the information comes in like this: However, to make it easier on our volunteers, it ...
0
votes
0answers
10 views

Google Sheet script will not run on a tab linked to a Google Form

I wrote a script to move a row of data from one sheet (Sheet1) to another (Sheet2) when I type the word Yes in column one. I can get the script to work perfectly when the sheet is not collecting Form ...
1
vote
0answers
26 views

Google Form to sheet to Doc, with calculations after pushing to sheet

NOTE! I am not a programmer I'm just fumbling through this! I've gotten as far as I can with searches, getting lost on multiple steps as most responses don't integrate on thing to the next. Background ...
2
votes
1answer
78 views

Run script through multiple Google sheet tabs

I have a script which deletes columns of information that is now rendered obsolete. However, I have multiple tabs which means going through them all manually, how can I edit my script to do this ...
2
votes
1answer
31 views

Script in Google Sheets which deletes every column that doesn't have a header

I'm trying to take an existing script but change it so that every column that is without a header is deleted. function deleteColumns() { var required = ["Name", "Position", "...
0
votes
1answer
70 views

Sum values across multiple Sheets IDs automatically by creating a formula?

I used this post to have all Google Sheets IDs in a folder Getting all files' file-id from a folder in Google Drive I would like to make a formula or script to sum values in table across all these ...
0
votes
0answers
22 views

Script to replace a row if it starts with the same value

I have a source document that contains mandates. Each mandate has its number and is assign to 1 of 5 teams. I have 6 sheets on my document (source + one for each team) I already have some scripts to ...
0
votes
0answers
53 views

Scroll to first blank cell Google Sheets on top

I am trying to create a, only on Open, function to go to the first blank cell of a specific sheets column in Google Sheets Update I currently have a script that works - but it's quite slow onOpen. ...
0
votes
0answers
24 views

How on Google sheets can I auto sort multiple Columns on multiple sheets?

So I work in a secondary school, as such we're trying to make a temporary register that will auto sort. We therefore have a sheet for each year group. So I need multiple sheets to auto sort based on ...
0
votes
1answer
33 views

How do I update Google worksheet with data from separate worksheet based on dates

I have a worksheet of "Loads" that contains a growing list of loads done by drivers. This worksheet grows with new rows daily. I am wanting to have a seperate worksheet called "New ...
2
votes
1answer
45 views

Google Script Sort Column Ascending Order with Blank Cells at Bottom

I have the below script running to sort column E in an ascending order. Each row is a different task and column E is the deadline. I have another piece of script running which deletes the deadline in ...
1
vote
1answer
39 views

Inserting an image into a Google Sheet using Google Scripts?

Does anyone know if it is possible to insert an image from a URL into a Google Sheet using Google Scripts?
0
votes
2answers
45 views

Duplicate and rename vs make a blank sheet and name

I want to duplicate and name multiple copies of a sheet that already has data. The rename would be based on a list from another sheet in the same workbook. This script does that, but only generates ...
1
vote
0answers
21 views

Capturing events on embedded charts within Google Sheets

I am trying to embedded column chart in Google sheets and would like to capture events like which column was clicked, then use the info to highlight certain cells. Is that even possible in embedded ...
0
votes
0answers
17 views

Trying to streamline button navigation in google sheets. It works but it's tedious and clunky. Anyway to automate this?

I am building a VFX shot tracking database, based off of an existing paid software platform. I only use about 10% of the functionality of the paid app, so I'm trying to replicate that 10% in google ...
-1
votes
1answer
40 views

Script setValue in column based on the values of two columns with a case/switch and for-loop

I'm working on a Google Sheets document in which I calculate profits based on two columns: Price and payment method. I'd like help with a script that checks the values of said columns in each row, and ...
0
votes
1answer
43 views

Double Timestamp with checkbox

I'm absolutely new in programming and I found this solution which helps me stamping the date in a cell depending on a checkbox value. The problem is that I tried to copy the exact same code and ...
0
votes
0answers
45 views

Find and Replace Script for Google Sheets

I am trying to write a script for find and replace from one column to another. I don't want to see the initial URL in Column B but then find and replace the data into Column C for a spreadsheet. ...
0
votes
1answer
91 views

How to add row to Google Sheet daily with two columns?

I would like to add a row every day at midnight to my Google Sheet containing two columns: 1st the current date, 2nd the cell value from another sheet (portfolio value). I.e.: I want to make a graph ...
0
votes
1answer
26 views

Reorganizing data submission on Google Sheets [duplicate]

I currently work at a college and we working to make the process of asking student clubs for information easier. We have created a google form for them to submit their member information, but each ...
0
votes
1answer
28 views

Automatic date in Google Sheet data entry. I can apply the scenario I have found to 6 windows in the same worksheet

I have prepared such a scenario, but I want to use it in 6 pages like the question asked above. function onEdit() { var s = SpreadsheetApp.getActiveSheet(); if( s.getName() == "Sheet1" ) { ...
-1
votes
1answer
38 views

Gmail to Google Sheets Script Help [closed]

I'm new to Google Scripts and struggling to optimize a code I've found. I used this base to extract the emails from Gmail and feed them into a Google Sheet, and that's working fine. However, I would ...
1
vote
1answer
76 views

Exporting huge Google Sheet to a PDF

I have a google sheet having 110,000 rows and 10 columns. If I try to export using the normal File > Download > As PDF, it takes forever to make the Save button work (The ~4800 pages of the PDF ...
0
votes
1answer
495 views

Google Sheets script- Copy and paste data from fixed cell to a row corresponding to a cell with current week date

I have a Google Sheets document where I track status of a project as red/yellow green. the live count of Red/Yellow/Green are in Cells BU1 BV1 and BW1 of my summary Sheet. Now I have a table below in ...
0
votes
1answer
26 views

Setting values in a range of cells using for loop

I am playing around with scraping stock fundamentals from a website.The spreadsheet has two sheets : Portfolilo and Backend.I am calling Vlookup() from within the script to look up 'company name' for ...
0
votes
2answers
50 views

Add a date stamp when a new row is added from another tab

I have been trying this for a few hours. I would like a date stamp inserted on column K when a new row is added (my data is on another sheet). I currently have the script below, however, it only works ...
0
votes
1answer
190 views

Email notification when any cell in specific column is changed

I have a Google Sheet in which I would like to get an email notification when any cell changes in a specific column. I am new to scripting so it is mind blowing, I have no idea on how to do this and ...
0
votes
1answer
30 views

Is there a variable I can use to call a senders name?

I built a script for auto replying... function autoReply() { var interval = 5; // if the script runs every 5 minutes; change otherwise var daysOff = [6,0]; // 1=Mo, 2=Tu, 3=We, 4=Th, 5=...
0
votes
1answer
37 views

How to skip 2 rows every time the cell's content gets > 5 character?

I'm trying to make google sheet skip 2 rows every time any active cell from column A gets > 5 characters in length. Here's the process I thought of: The user types up to 5 characters in cell A1. ...
2
votes
1answer
96 views

How do I extract specific value from a single cell on Google Sheets

I'd like to get respective data into each cell without the key and punctuations. Each cell must display only the value extracted from the properties column. I've tried to go to Data>split text to ...
0
votes
2answers
37 views

Can anyone suggest how to also include work hours (9-5) in this out-of-office script?

The below script successfully auto-replies to sender on selected non-working-days. Can anyone suggest how I might add the after-hours of working-days, say 5pm-7am, to trigger the reply also? function ...
0
votes
1answer
14 views

How to make a script with IF work separately in more than one row?

The script bellow works perfectly for the row in C5. However, I need it to work for the rows below it, separately. An IF check for each row, let's say. Any thoughts on how to do that? I tried changing ...
0
votes
1answer
20 views

TypeError - Move row from one sheet to another

I am experiencing the following issue and was wondering if anyone with more experience can shed some light. I have very little experience with code. Row is transferring correctly, but I am getting the ...
0
votes
1answer
21 views

Changing the fontColor of cells when editing

I'm trying to write an Apps Script that change the font color of a cell when it value changes. I found a way to to change de fontColor of a range, and add to trigger 'onEdit', but the all range is ...
1
vote
1answer
36 views

How to modify this existing post of script and/or steps so it functions to automatically empty Gmail Trash?

I found this post on how to do the above but it doesn't appear to work? Here is the error message Nov 25, 2020, 3:52:51 PM Error GoogleJsonResponseException: API call to gmail.users.threads....
-1
votes
1answer
87 views

Generate programmatically hyperlinks to sheets in Google Sheets

I know that is possible to generate hyperlinks programmatically with a script or a formula to a website taking a cell value as a reference. But in this case I need to generate a hyperlink to another ...
1
vote
1answer
43 views

Find and replace Google Script

I've read a lot of questions and I tried several Script for Google Sheets but nothing works for a very simple case: I would love to replace all the points "." with the commas "," ...
0
votes
1answer
88 views

Is there a way to track used and remaining execution time quota of the day in G Suite account for Apps Script?

Is there a way to query used and remaining execution time quota of the day in G Suite account for Apps Script? I am hoping to understand the above and thus be able to tell whether a different G Suite ...
0
votes
1answer
246 views

Google form script “form.getItemById(710215182).getResponse” returns undefined

I have created a Google form and I am trying to retrieve a response after the user submits the form. As some of my questions are grids and may be left blank by the user, the indexes of the responses ...
0
votes
1answer
70 views

Trying to search(from sheet1 ) for a value on in any row of sheet2

I have 2 sheets "Main" and "Data Storage" Main: should allow me to search "Data Storage" and locate information form any column(let say Column B') and provide me with ...
1
vote
1answer
148 views

In Google Apps Script how do I check if a reference is out of range?

I have some Google Apps Script code which works with Google Sheets. In one segment of code there are some instances where it throws an exception. Here is the exception: Exception: Cell reference out ...
0
votes
2answers
83 views

How to insert a webp image into a document?

I am trying to insert a webp format image into a table in a document - however it's giving me an error. When I try with a jpg file, I am able to insert the image at the top of the file (I don't know ...
0
votes
2answers
113 views

How to define the column/row/range where the script should start

In column Q start at row 15 is dynamic cell which goes down the column and contains a %-Nr. Next to it in column R i want to show the recorded max value per row. During my research i found here this ...
0
votes
1answer
30 views

Clear DropDown when Cell is cleared

with the help of a tutorial i made a script with dependent drop downs. I tried to modify it that when a cell in Column A is cleared/modified the first level of the drop down too. var mainWsName = &...
1
vote
1answer
47 views

How do you perform a bulk find & replace using a list of search phrases and their replacements?

This is not my wheelhouse and I'm realizing I'm in a bit over my head. Any help would be greatly appreciated. What I'm trying to accomplish https://docs.google.com/spreadsheets/d/...
1
vote
1answer
39 views

Google Sheets data formatting and extractions into more workable, easier to read format

I have a set of data representing visitors and times of their visits. Each entry is in its own row in the sheet. Example; Time of the visit in A1 and Name in A2. The single digit numbers represent ...
0
votes
1answer
16 views

How do I write a script that exits a cell that is being edited

If I enter a value in cell A1 without exiting the cell . Before I exit editing A1 I run a script that at some point selects another cell B1 , while A1 is still being edited. When I then click C1, the ...

1 2
3
4 5
30