Ask Question

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

48,006 questions 1

0votes0answers11views

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 ... user avatar mackerley

  • 1
0votes0answers4views

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 ... user avatar Josh

  • 1
0votes0answers6views

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 ... user avatar Nick Parchman

  • 1
-1votes0answers7views

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 ... user avatar Anmol Jaiswal

  • 1
-1votes0answers12views

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: user avatar QAA

  • 1
0votes0answers14views

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.... user avatar Barroni Tomlinson

  • 1
0votes3answers45views

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 ... user avatar Franco

  • 1
-1votes0answers22views

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 ... user avatar Shyamala R

  • 9
0votes1answer22views

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 ... user avatar Edyphant

  • 55
0votes2answers46views

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 ... user avatar Mohd Imran

  • 13
-1votes0answers23views

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 ... user avatar Bendt Campus 10

  • 9
0votes0answers20views

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 ... user avatar Spencer Chou

  • 15
1vote1answer22views

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 ... user avatar Taniya Halder

  • 137
-1votes0answers18views

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 ... user avatar Rebellion

  • 1
0votes2answers15views

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. user avatar Hannah Hernalin

  • 1

153050per page

1 2 3 4 5 … 3201