Questions tagged as 'google-apps-script'

Tagged questions
1
answer

How to generate PDFs with Javascript

I have a program in Python that reads a text file (.txt) and with a series of data from the file, generates a PDF with certain information. To read the .txt, use regular expressions. In Javascript there is no problem, I can do it in a similar wa...
asked by 18.12.2015 / 08:55
3
answers

How to make this google script work in several ranges?

I have done a script of google sheet that writes me the modification date of a specific range of cells and now I want to make it detect the cell that I am modifying and detect if it is within a few ranges concrete. This is the scrip...
asked by 30.11.2018 / 07:24
1
answer

Remove null or empty values from a JSON Object in Google AppScript

I am analyzing information within a Google Sheet through Google App Script, through the active total range of the Google Sheet I obtain a javascript object of type multidimensional I transform this into a JSON object with the function JSON....
asked by 28.08.2017 / 18:22
1
answer

Delete files with google-apps-script

There is a google spreadsheet and a script that generates PDF files with the information of the spreadsheet, the PDF files are automatically saved in a folder of google drive. How could you erase the PDF files in that folder? Attachment code....
asked by 05.08.2017 / 05:53
1
answer

Help with Google spreadsheet script

I'm trying to make a script for the Google spreadsheet but I'm stuck and it does not work for me. My intention is to make a script that detects the cell that I am modifying, to later, see if it is within specific ranges and depending on the r...
asked by 10.12.2018 / 08:52
2
answers

How to determine if the cell that has changed from a google sheet is in a list and how to put a trigger?

I am new to google scripts and event handling and I do not clarify with the API. I'm looking to create a script that monitors certain cells in a specific sheet of a google sheet book. These cells contain a formula that depends on the content...
asked by 20.08.2018 / 12:01
2
answers

Activators in Apps Scripts [closed]

I know that using Google Apps Script you can configure an activator, so that it runs every so often, but I would like to be able to configure it from the code. They will ask themselves why, well, I made an application for my work that has a p...
asked by 20.06.2016 / 22:40
3
answers

Error 401 when sending email with JavaScript and AJAX

I was looking for methods to send emails without PHP or as little as possible by AJAX, and I found a method on the Formspree page. It's very simple, but browsing I found this on GitHub that works perfectly to a certain extent. At the time...
asked by 14.06.2017 / 12:59
1
answer

Copy document sheet Google Docs in another document

I am trying to copy a sheet of a Google Doc document into another document, but I am unable to do so. Can someone help me? I'm trying with the object Document and Body but I can not get it, the maximum I've achieved is copying t...
asked by 20.01.2017 / 09:11
1
answer

Error: Time has run out while waiting for the user's response

Trying to send several Mails triggers this error. How can I start fixing the error that says: "Time has run out while waiting for the user's response". Sometimes it works and sometimes the bug does not come out. This is my code: function...
asked by 16.05.2018 / 05:24