Skip to main content

Questions tagged [google-apps-script]

For questions about using Google Apps Script to extend Google applications

Filter by
Sorted by
Tagged with
0 votes
1 answer
26 views

How do I display an alternative charchter in a Doc that is pulling data from a sheet?

I have created an HTML form (not a Google Form) that populates a Google Sheet. The form has both text inpt and checkboxes (multiples of each.) On the Google Sheet, if a checkbox is checked on the ...
1 vote
1 answer
36 views

Get exactly data to put on email message?

I got a function to email notice like this code below: function approvedby() { var approvedrange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Responses 1").getRange("E2:E500&...
1 vote
1 answer
697 views

SpreadsheetApp.openById gives unauthorised error

I am trying to trigger a function in Google Apps Scripts, and am using openById("Sheet_Id); But on using it, I am getting this error: Exception: You do not have permission to call SpreadsheetApp....
0 votes
1 answer
157 views

Change tab color based on cell vaule

I am trying to change the tab color based on a cell value on an individual sheet. I have multiple tabs. The cell value that will determine whether or not it gets a color is a cell containing a date. ...
1 vote
3 answers
508 views

How can I sort multiple ranges by one reference cell that is outside the second range?

I have a roster that has (on sheet 1 ('Roster')): Name, 1st Week of Attendance, 2nd Week of Attendance, and then other non-relevant data. On the second sheet ('Contact Info' it has Name, a cell that ...
2 votes
1 answer
1k views

Email notification if cell value goes below set amount

I'm having trouble finding a Google sheet script that does what I need so I figured I would ask if someone could help me. Basically I have a simple sheet setup to track inventory of one item. There is ...
2 votes
1 answer
1k views

How to use Google Scripts w/ spreadsheet and jotform to auto sort so the newest entry is always listed on the top row?

I'm trying to setup a form and spreadsheet database to track inventory on a daily basis at a remote location. The idea is that the person at the remote location can update our stock via a simple ...
1 vote
0 answers
36 views

How to update my Change Log script to show how it affected other cells in the spreadsheet [closed]

I was able to use the following script to create a change log so I can now see where and when a change occurred across multiple tabs on my spreadsheet: function onEdit(e) { var sName = e.source....
0 votes
1 answer
368 views

Clear cells based on checkbox repeated Google Sheets

I have checkboxes in columns A, E, H, L, O, S, V, and Z I have a script that is working which allows me to check the box in a2 and it deletes data in e2 and f2. I then am able to reverse the script so ...
1 vote
1 answer
249 views

Add a new row and move data to that row when box is checked

I currently have a Google spreadsheet that keeps track of all orders and the progress: Column 1: Order Form Sent Column 2: Order Form Received Column 3: Delivered to Pick Up Site Column 4: Picked Up ...
1 vote
1 answer
123 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 ...
-1 votes
0 answers
9 views

Send custom automatic email to Google Form respondents on a specific date [duplicate]

I have a Google Form that collects bookings for a number of events. The responses sheet (Sheet 1) contains, amongst other data: a column with the event being booked for The name of the person Email ...
-1 votes
0 answers
12 views

Send partial contents of Google Sheets to email on a specific date

I have a Google Form that collects bookings for a number of events. The responses sheet (Sheet 1) contains, amongst other data, a column with the event being booked for. I have added another sheet (...
0 votes
1 answer
3k views

Create a custom DateTimePicker in Google Sheets

In a sheet I have a column to enter a datetime value that would later be checked by a script to create a trigger. I would like to set a picker in that column to ease selection and avoid errors. I ...
2 votes
1 answer
1k views

Put the timestamp of last edit on master sheet, next to edited sheet's name

I'm trying to come up with a script that will print a timestamp of the last edit made to a specific tab within a google sheet. Imagine you have 17 retail stores, each one having its own tab with a set ...
0 votes
1 answer
46 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 votes
0 answers
16 views

How can I add "settings" or custom properties to Google Sheets? [closed]

Is there a way for me to add custom key-value properties to a Google Sheet without resorting to creating a different "settings" sheet? I'm using Apps Script and prefer not creating custom ...
1 vote
1 answer
184 views

Automate auto-reply based on specific Google Calendar Events

I'm currently trying to automate an auto-reply with Google Apps Script for whenever I am out of office based on my Google calendar events named 'OOF'. Even if everytime I'm getting closer, there's ...
1 vote
1 answer
15 views

Will Google Transfer for Education Save my Container-bound Apps Script Files?

I am a teacher and am leaving my school district soon. I have created a large number of container-bound scripts in Google Sheets, Docs and Slides files. I want to take these with me, but when I tried ...
0 votes
1 answer
3k views

How to include VLOOKUP with a loop for a list of data on Google Scripts?

I have a list of data on Sheet1 columns A-N, and a list of updates on Sheet2, columns A-N. I have a code that imports data to Sheet2, and I would like to add to my code a similar function to VLOOKUP. ...
1 vote
2 answers
32 views

Sorting Google sheet based on two columns as if they were one

This question is an evolution of this other question. I have a Google sheet (Form responses) with the following structure: | Timestamp | Field 1 | Field 2 | Field 3 | Field 4 | Field 5 | | ...
1 vote
1 answer
4k views

How to automatically set date in a cell when a different cell value is changed by a formula from data on another sheet?

I currently have a column, e.g. ColB, containing SUMIF functions with its data range from other sheets and a column, e.g. ColC, with dates that I want to automatically update to the last date ColB's ...
2 votes
1 answer
2k views

How to automatically forward Gmail messages when a label is applied?

I have found this question that is answered: How can I automatically forward Gmail emails when a label is applied? However I'm using that exact script and have replaced the label and recipient with ...
1 vote
1 answer
2k views

Auto hide row based on cell text (formula based)

My plan is to hide an entire row if a specific cell in the row showed specific value. I already found the script and the script work amazing. But the problem now, since the script use onEdit function, ...
0 votes
1 answer
670 views

Grant permissions on a shared google drive with script

I have google drive folder with subfolders, each subfolder has several google sheets and each sheet has a set of functions that run when users click on buttons, the issue is that for every time user ...
0 votes
1 answer
2k views

Getting error while using inlineImages

I am always getting error while using inlineImages. Error Exception: Invalid argument: inlineImages" Below is my code: var blob = Charts.newTableChart() .setDataTable(table.build()) ....
0 votes
0 answers
21 views

Duplicate and rename a sheet in one spreadsheet from a different spreadsheet [closed]

Having a hard time find info on this specific situation. To be clear, when I say I have two spreadsheets, I mean two separate spreadsheet files, each with it's own unique set of sheets (tabs). From ...
0 votes
0 answers
17 views

Need help formatting date column as "yyyy-mm-dd" using Apps Script [closed]

I have a due date column in Google Sheets which I would like to format as yyyy-mm-dd. I tried using the code below but it displays the date as Wed Jan 10 2024 00:00:00 GMT+0800 (China Standard Time). ...
2 votes
1 answer
4k views

Need to get a list of Drive files several subfolders deep

I need to get a list of all the files in my Drive with all of the nested folder names where the files reside. I found this very helpful answer which is almost exactly what I need: Get a list of Drive ...
0 votes
1 answer
29 views

Sorting Google sheet in a particular way

I have a Google sheet (Form responses) with the following structure: | Timestamp | Field 1 | Field 2 | Field 3 | Field 4 | | | | | | 4 | | | | ...
1 vote
1 answer
160 views

Duplicate row values to next row, based off specific column

I'm trying to set up a button that will copy information from the last row and paste it into the row right underneath (based on where column D last has a value). Almost like a "duplicate" ...
2 votes
1 answer
593 views

function no longer working on mobile

I have a function that uses the onEdit trigger. It was working great both on PC and mobile yesterday, but today it no longer works on mobile but still functions on my PC. Not sure what is going on. ...
0 votes
1 answer
125 views

Script to Copy multiple sheets from an Excel file and convert it to a Google Sheets file

I have an Excel file with 3 tabs (Sheet1, Sheet2, Sheet3) attached to a Gmail message and I would like these to copy to a Google Sheet file with 3 tabs (SheetA, SheetB, SheetC). The problem I am ...
1 vote
1 answer
25 views

Script successfully copies sheet contents to Gmail but doesn't include formatting

I've set up a Google spreadsheet so that it creates a new draft message in Gmail and copies the contents of a sheet into it. However, when the sheet contents are copied over, it only copies the ...
0 votes
1 answer
300 views

Macro to move down and separate data

I wish to use a macro in Google Sheets to find the number 1 in column A then move that corresponding row and all following rows down to start at A9 row then find the number 2 in column A then move ...
-1 votes
1 answer
547 views

Can I use responses of a previous google form in a new google form?

I have a Google form that is collecting the Event date, event name, employee name, and his/her assistance in that event(Yes/No). After collecting those answers, we want to use the data to create ...
0 votes
1 answer
114 views

Protecting and unprotecting identical ranges across multiple sheets

I teach a middle school robotics class and we do an inventory check every six weeks to make sure that all the pieces are there. I would like to track over different class periods how the inventory is ...
1 vote
1 answer
4k views

Google Sheet jump to current date on Open (very large sheet)

I understand that this question has been asked before but most users seem to only have the dates in one column or a limited number. The sheet I am trying to work with has the schedule for one entire ...
1 vote
1 answer
1k views

Script to duplicate template sheet into new workbook, then rename

I am looking for a script that will create a menu item that will allow me to copy a template sheet that I have created (multiple times) into a new workbook, and rename the copies at the same time. ...
0 votes
1 answer
2k views

Move Google Sheet with a script to Excel

I have a Google Sheet that I would like to access and modify also when I'm offline. The problem is that I have a script attached to it so I can't use the "make available offline" option; the script ...
1 vote
1 answer
554 views

How to Add RTL Tables to a Google Document

As I'm trying to format google doc tables and in reference to this thread I was able to add some formatting to the header row, to the table data and was able to create a doc in a landscape layout. ...
2 votes
1 answer
281 views

Send email notification when a data in column matches a certain value

I am trying to make Google Sheets send a notification to a particular person/s when one of the fields on column Q is equal to the word "High". I want the email to be sent when it is high ...
3 votes
1 answer
416 views

Apply custom formula across all columns using Array Formula

I have trouble applying my custom formula across all columns using Array Formula. My custom formula is named getCountry where it could get the country based on an address. The address components e.g. ...
2 votes
2 answers
276 views

copying the Data to the next available Row in Another Sheet

I have run into a small issue with this script, it does copy the values in the range but pastes them under the 1500 cell in column A on the destination Sheet. I can't seem to get it to paste to the ...
0 votes
1 answer
226 views

How to update multiple google sheet files on google drive from a template without changing the current values of certain cells

I created a google sheet template and then we created almost 200 sheets from that template, now we updated the original template, and I am trying to figure out a way to updated the 200 files without ...
-1 votes
0 answers
8 views

How to preview a webpage in Google Sheets when the URL has parameters

I would like to preview webpages in Google Sheets using Apps Script. However, the URLs that I want to preview have parameters. For example, my URL is like this: example.com/?elementor_library=thing-i-...
2 votes
1 answer
168 views

Google Sheet Script for automatically entering date/time stamp when the adjacent column

I've found a script on here for entering a timestamp in a column based on edits to the adjacent column: Date and time stamp automatically added in column if(e.source.getActiveSheet().getName() == &...
0 votes
1 answer
433 views

Google App Scrips onEdit function timeout

I have an onEdit function running fine into googlesheets, it is basically a countdown timer and displays the countdown into a cell. However after around 30 seconds of running, the display no longer ...
0 votes
1 answer
97 views

How to apply formatting on specific Google Sheets and columns?

I have a Google Spreadsheet with many sheets. I want to apply (through code) formatting to specific columns to the sheets I specify. I have tried this but my code applies the formatting to every sheet ...
2 votes
1 answer
692 views

How can you use a Gmail script to attach more than one image at a time?

I'm trying to set up a Google Sheet with some data to email images. I have the code I found online working below to send a single image attachment but I would like to send more than one image at a ...

1
2 3 4 5
37