Questions tagged [google-apps-script]

0 votes
0 replies
How to prompt Authorize required script on Open Google Apps Script
I am trying to set up a template file with a script that needs to be authorized every time the file is duplicated. I would like the authorizatio...
asked 1 month ago
0 votes
2 replies
Uploading to another sheet with conditions
I need assistance with my project. The endgame goal is to have a user select cells in a row and then be able to use a button to upload that data...
1 votes
1 replies
Can validation drop down text be different from resulting value in cell?
I'm trying to concoct a creative way for a Google Sheets cell to provide a drop down menu which contains more text than the resulting cell value...
0 votes
0 replies
Update value in second sheet
I'm setting up a budgeting spreadsheet using google sheets. I have written code so that when my budget is updated on the dashboard sheet, the his...
asked 1 month ago
0 votes
1 replies
How to copy spreadsheet's URL reference to a tracking sheet in a different google spreadsheet after its been automatically created
My code automatically creates a user-specific google sheet when a new entry on a row is added. I want it to then copy and paste the URL of this n...
asked 1 month ago
0 votes
0 replies
On edit trigger for send email function
I am trying to create a script and/or trigger that will send an email to a small group of users anytime a value is entered into cells within a sp...
0 votes
0 replies
Changing the colour of a template Slide using app script
I have a created a slide template in which multiple teams will use to use to create an information sheet about their respective Process. This con...
0 votes
0 replies
google sheets UiApi to htmlservice script file upload
I got the problem since google isnt supporting UIapi anymore i cant use the code below. Could someone help me with it and re-edit to html service...
asked 1 month ago
0 votes
0 replies
How to add an icon into custom menu element?
When I add a custom menu element, it appears with empty space and it looks like I can add an icon there but I have no idea how to do this. funct...
asked 1 month ago
0 votes
1 replies
Why doesn't this script collect all gmails?
I have a google app script that collects information about Gmail messages and then pastes it into a google sheet. Trouble is it doesn't get ALL...
asked 1 month ago
0 votes
0 replies
What input data is used by Activity Recognition API by Google in a mobile device?
I want to use Google Activity Recognition API to detect the activity of my users but I am concerned about the privacy and the data I would transm...
asked 1 month ago
0 votes
1 replies
Google Script IF Statement for text
I need to write a Google Scripts IF Statement but for TEXT not Numeric values. If cell x contains "Yes" then y else z. Small syntax issue in lin...
0 votes
2 replies
Objects with and without quotation marks
Edit: using google apps script, these are objects that are passed back from their functions. When I say logged I mean the result of the return fu...
asked 1 month ago
0 votes
0 replies
Set sheet protection to view only for person running the script
I want certain Google sheets within a spreadsheet to become view-only after a user runs a script. Is this possible? I've tried several variation...
asked 1 month ago
0 votes
0 replies
How to set it to run async so every line will get a randomized time when it should be executed will be even better [closed]
function updateList(){ var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheetByName("Request"); var responseSheet = ss.getSheetB...
asked 1 month ago
0 votes
2 replies
Google Sheets - Script to move rows to different tab depending on a key word
I have been working on a google sheet that that receives a form submission. Once the submission comes in I need a script to move the rows of data...
asked 1 month ago
0 votes
0 replies
Forward email message with MailApp instead of GmailApp
Forward emails with MailApp instead of GmailApp to preserve emojis. We have a filter to tag emails we want to forward. And then a google-apps-sc...
asked 1 month ago
0 votes
0 replies
Uploading to another sheet matching specific cell
I need additional assistance with my project. The endgame goal is to have a user select cells in a row and then be able to use a button to upload...
asked 1 month ago
0 votes
1 replies
Looping through rows, get values, and add to total on another sheet
So I'm stumped on this in Google Sheets. Sheet 'Price Calculator' Qty has a of items bought and sold in Column A, separated into 2 named ranges...
asked 1 month ago
0 votes
1 replies
Function script on Google Spreadsheets is too slow
I've gotten this code to add one to a number in a cell from Google's Spreadsheet but it's taking too long to execute, like 5~15 seconds on averag...
asked 1 month ago
0 votes
0 replies
Setting width and height of tables with Google Slides Apps Script
I'm using Google Apps Script to manipulate a Slides file. I want to create a table on a slide and set the height/width of a row/column, of a part...
asked 1 month ago
0 votes
1 replies
Gmail script for creating and deleting labels not working
I have had a script running on a daily trigger for several years which manipulates Gmail labels in order to provide snooze functionality. I have...
asked 1 month ago
0 votes
0 replies
Cannot call SpreadsheetApp.getUi() from this context, but not using getUi on time-based trigger
I am trying to run a function every night that checks a list of dates and does work if it finds that a date has passed and all the checkboxes on...
-2 votes
1 replies
how to break all external links in google sheets and save values only backup with date as name of file automatically?
How to break all external links in google sheets and save/archive values only backup with date as name of file automatically? -2 Welcome t...
asked 1 month ago
0 votes
1 replies
Google apps script drive service download as function?
Does google apps script have a function to 'download as' (.docx, plain text, .pdf, etc.)? I can't find any reference to one but wanted to check....
asked 1 month ago