Questions Tagged [Google-Apps-Script]
Ask Question Use for Questions About Google Apps Script, Google's Server Side Javascript-Based Cloud Scripting Platform for Automating Tasks Across Google...
![Questions Tagged [Google-Apps-Script]](https://www.alledaags.nl/uploads/questions-tagged-google-apps-script_1200.jpg)
Use for questions about Google Apps Script, Google's server side Javascript-based cloud scripting platform for automating tasks across Google products and third-party services. Use in addition to relevant product-specific (e.g. [google-sheets], [google-docs]) or API-specific (e.g. [google-drive-api]) tags where applicable
Must Read
48,006
questions
0
votes
0
answers
11
views
Looping through every starred file in my Drive folder and running a macro. No bugs but script not working...why?
I wrote the following script that looks through every starred file in Google Drive and executes two functions. The problem is, the functions are not actually doing their thing in the files. I'm new to ...
0
votes
0
answers
4
views
Google Apps Script Finding Email by Not Writing to File
I have written a script to search a designated gmail inbox against specified parameters and append the data to a sheet. The script appears to be working as intended except that if it finds more over a ...
0
votes
0
answers
6
views
Is there a way to update a Slide on Google Slides via Sheets?
I have been trying to find a way to update a diagram on a Google Slide via a script in Sheets. I know that there are plenty of ways to do that via a drop down menu in Google Slides, but since my ...
-1
votes
0
answers
7
views
Importing csv's containing Multiline cells from drive to Google Sheet using AppScript
I need to automate a script for importing CSV from DRIVE to Google Sheets. The csv contains 3 columns and 2nd column contains multiline cells, which can be converted to single line if importing ...
-1
votes
0
answers
12
views
Google Forms, Apps Script, Google Sheets, ArrayFormula Help for a Time Off app
so I needed to find a way to use Google Forms as a time-off requesting app for employees. I found this link:
0
votes
0
answers
14
views
Redirect to URL After Posting to Google Sheet - Google Apps Script
I am trying to redirect to a webpage after posting to a google sheet instead of outputing the text from the return ContentService.createTextOutput command. Any help would be greatly appreciated.
Code....
0
votes
3
answers
45
views
I need prevent and alert users whenever their entry is a duplicate in google sheets
I'm managing a tracker in google sheets, where users should enter new IDs in column A.
I need to prevent them, as well as alert them, whenever their entry is a duplicate (so the ID already exists in ...
-1
votes
0
answers
22
views
Google standalone appscript
I have written a standalone google app script for a google web app. when I open a new window on the click of the submit button i get the following error.
userCodeAppPanel:23 Unsafe attempt to ...
0
votes
1
answer
22
views
Google Sheet Lock Data On closure of Sheet
I want to design an app script for Google Sheets which protects the data upto last row when the sheet is closed.
E.g. If I am working on the sheet and data is till Row No. 100 then, when I close the ...
0
votes
2
answers
46
views
Get Unique Value Based on Multiple Columns from Spreadsheet using Google Apps Script and JavaScript
So, Basically what I want is to get unique data from a 2d array where I can pass multiple column values which I have stored in an array. Like I want to get unique based on column 1 and 2 so, I can ...
-1
votes
0
answers
23
views
How to create Google Workspace menufunctions from an array? [duplicate]
Getting a lists of organisational units from AdminDirectory, I would like to create a menu in Google Sheets.
This is do-able with the code below.
But since I cannot pass parameters when I create ...
0
votes
0
answers
20
views
Is there a better way to email a range on Sheets?
Here's what I have so far and it functions perfectly. The thing I'm having trouble with is that this is the only way to have the range email to Outlook with each cell in the column on a new line. If I ...
1
vote
1
answer
22
views
How we can change the permissions for editors/writers for not sharing the google docs using google docs API?
I am working on google docs API and google drive API. I am facing one issue while setting the permissions for editors/writers for not able to share the google docs to anyone except for the owner using ...
-1
votes
0
answers
18
views
Export users and permissions of all google analytics properties with Apps script
I would like to be able to automate with script apps to extract from each property that I have the users and the permissions they have regarding the property, administrator, editor, reader, etc...
I ...
0
votes
2
answers
15
views
How to Automatically End Triggers in Google App Script
Is there a way to end a trigger after a month or two in Google App Script?
Like for example, I want the trigger to occur on a daily basis just for one month and discontinue after the end of the month.
James Sterling reports on renewable energy developments, climate policy, ecological conservation, and green tech innovations around the globe.
