Questions tagged as 'google-apps-script'

Tagged questions
1
answer

Capture mail data Gmail

I'm starting with GAS, and I'm trying to create a script that captures the data of an email sent from Gmail. I can not find any GmailApps property that collects this information, and the methods it implements, I do not see any of them referri...
asked by 12.04.2017 / 15:57
1
answer

Script in Google Sheets to perform actions on DRIVE

Is it possible with a script in a Gsheet to create a folder with a specific name and create a set of file copies within it? These lists of files would be listed with their IDs in the Gsheet.     
asked by 10.05.2017 / 15:43
1
answer

Run Google Sheets script without being the owner [closed]

I have a sheet in which you must enter dates in column A. These must be entered by running a script that is in the menu bar. Column A is protected for all users except for my who created it . I do not want the dates to be entered by hand but...
asked by 21.03.2017 / 21:54
1
answer

TypeError: Can not call method "getThreads" of null

I need to implement the following code for the massive deletion of emails in a Gmail account (the code is not mine), but I can not get it to work. The code I use is the following: function cleanUp() { var delayDays = 365 // Enter # of d...
asked by 11.06.2016 / 19:03
1
answer

problems with array in apps script

I have problems to pass the information from spreadsheet to an html with apps script. I explain to you; I have a spreadsheet that contains 5 columns and 5 lines, but they are formulas, concatenation and others. from an appscript html templ...
asked by 28.09.2016 / 20:39
1
answer

HTML form to search and edit data in Google Sheets

I have a form in html to edit or search data in a sheet, everything works but after clicking the edit button or when I try to do two searches in a row the page disappears and I have to manually reload. I would like to know how to do that after c...
asked by 06.06.2018 / 18:18
1
answer

How to apply a filter to a spreadsheet from script

Greetings I am trying to generate a filtered view according to the user that accesses my spreadsheet, so far I have only managed to make this work: function onOpen(){ var currentUser = Session.getActiveUser().getEmail(); SpreadsheetApp.getUi...
asked by 24.04.2018 / 07:33
0
answers

Copy Phone complete with country code with extension intl-tel-input [closed]

I have a problem using the extension intl-tel-input ( link ) Start the CDN: <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/intl-tel-input/12.1.5/css/intlTelInput.css"> <script src="https://cdnjs.cloudflare.c...
asked by 06.12.2017 / 16:44
1
answer

help on arrays in Google Apps Script

I need to send a reminder message to certain email recipients, I have the following structure function recordatorio () { var asunto = "Recordatorio de felicitación"; var nombrebuzon = "Comunicación Global Engineering Mexico";...
asked by 09.11.2017 / 19:03
0
answers

Trigger, or edit file without permission (no form) Google script

I created a panel using doGet (HTML panel), linked to a spreadsheet. It will be used by supervisors of the company where I work. Depending on which supervisor opens the page, only employees in your sector will appear in a drop-down list. (getEff...
asked by 22.08.2017 / 21:30