How to allow others to access a web app made from a Google Apps Script?

I deployed a web app from a Google Apps Script, but others don't seem to be able to run it. (It runs fine for me when logged-in to Google) I keep getting "Request to share" email, even though I...

Convert column index into corresponding column letter

I need to convert a Google Spreadsheet column index into its corresponding letter value, for example, given a spreadsheet: I need to do this (this function obviously does not exist, it's an...

What is the size of the cache provided by CacheService using GAS

What is the maximum size of the CacheService ? I know the maximum time something can be stored in cache is 21600 seconds, but I can't find how large the sizes of the publicCache and the...

Google Apps Script JDBC ResultSet to Array

Is there a better way of retrieving the results from a ResultSet? Calling getString() on each value is very slow. It takes up to 2.5 seconds to put about 400 rows, 16 columns into an array before...

Create a new folder in Drive using Google App Script

Is there a way to create a google app script to create a new folder in Google Drive that is NOT IN THE ROOT FOLDER? A script to move a folder in the root to a particular folder will also do.

google.script.run does not work from HTML template

Hi all and thank you for your help in advance. Here is my problem: I am developing spreadsheet tools from a library, through an HTML template, but the server functions do not work. gs simplified...

How multiple developers can collaborate to maintain a solution based on Google Apps Script, Google Forms & Google spreadsheet?

Using a shared Google account a few developers in our company had developed a solution based on Google Apps Script, Google Forms & Google spreadsheet. We have setup many time-based & event based...

ArrayFormula is breaking the getLastRow() funtion. Possible workarounds?

In my spreadsheet, I have a running script, which is using the getLastRow() function as an essential part of its logic. Ever since I applied the array formula in one of my columns, the...

"The coordinates of the range are outside the dimensions of the sheet" error when sorting

I am trying to create a script to sort a table on the current active sheet/tab but I am getting an error that I could not identify. I keep getting The coordinates of the range are outside the...

"Invalid Host header" in a React app deployed to IBM Cloud

I have developed a very simple demo Todo List app (Express + React), according to Brad Traversy's YT tutorial and successfully deployed this app to Heroku, where it is up and running. However,...

How to determine when all Loading Data operations are finished?

I have a Sheets spreadsheet that has many cells that use a custom function which calls IMPORTHTML and parses the results. Other calculations in the sheet use the returned values from these custom...

Is there a way to get the current slide the user is on? Google Slides, and Apps Script

I'm trying to create a game in Google Slides and need to have a system where if the user is on a certain slide, a variable is changed. How is this possible? I have already tried to use...

Limit the number of row in Google Sheets

I have a google sheets document that keeps adding rows to the sheet. It slows down my document tremendously because of scripts I run against the document. I only need around 100 rows, but it...

getBlob() causing "Invalid image data." Error. Google Apps Script

My objective is to. fetch a base64 image string from a google doc save it to the drive as an image getblob from image and insert the new image into the same doc as a real image. function...

Open cell for editing in Google Sheets

What I wanted to achieve was to create a button that adds a new row and sets focus so typing can be done without additional clicks. But now I only set focus, but to start typing it is necessary to...

How to modify Google Form Response with File Upload

I have successfully generated an edit link for my Google Form response (with File Upload). When I open this link, I can edit my answer to all questions except the File Upload item. I cannot delete...

Apps Script - Remove a Protection

I want to restrict cell editing in a Google Sheet by only allowing a user to edit empty cells or cells filled by him, but not cells filled by other editors. Put simply : If a cell is blank, any...

Get gmail address using Google Apps Script, Error: redirect_uri_mismatch

I try to get gmail address of user use my app script. I have consulted several places...

Apps Script Refused to Connect

I am trying to learn Apps Script and some fron-end web dev. I wrote some some code in Apps Script and I am trying to render it in a Google Site. Here is the doGet function that I use in my Apps...

Importing CSV from URL that has line breaks within one of the fields

I created a script that imports a CSV file from a URL into a Google Sheet. I have used Utilities.parseCsv(csv) in the past with no problems. However, this particular CSV file contains a field that...

Extract Custom Metadata (XMP) From Google Drive Image using Advanced Drive Service

I'm attempting to get some extra metadata added by a camera that does not seem to be available in the ImageMediaMetaData resource for Google Drive. Here is the way I am currently retrieving...

Kraken API private request authentication {"error":["EAPI:Invalid key"]} - Google Script

I have been trying to communicate with the private API on kraken. The error I get suggests {"error":["EAPI:Invalid key"]} that the encryption/decryption steps are correct. I have tried creating...

Find and format all words that start with a set string in Google Docs

I made a function in Google Apps Script that searches for all words in a Google Docs and changes their colors to a desired color. It takes as inputs: the doc ID, the color desired and the word to...

Google App Script, .getValue returns ERROR

I have quite a big problem. If I read columns cells with for loop and range(r,c.).getValue() (same for reading with range(r,c,m,1).getValues() ) the values are not read. I got #ERROR!. I am...

How to get the current price of a cryptocurrency on google sheets from coinmarketcap?

On a google sheets cell I want to get only the current cryptocurrency price with this formula: =ValueCrypto(A1) I tried this function for coinmarketcap: function ValueCrypto(crypto) { var url...

Allow Anyone to Upload Files Directly to my Google Drive

I would like to allow my students to send me one or more files directly to my google drive via a form where they would just enter their name and choose the file(s) to send (drag and drop would be...

How to place QR code that generated by formula as image in google doc (Export to PDF)?

I've generated QRcode by using image function (=image("https://chart.googleapis.com/....) and want to place in google doc, after the export to PDF, but it's show nothing, How do i place QRcode...

How to integrate p5.js with Python Flask

So I'm trying to run a python flask app which should render a html template which will record audio and send it to my flask server. I'm new to p5.js and I'm not able to run/get audio input on my...

TypeScript project failing to deploy to App Engine targeting Node 12 or 14, but works with Node 10

I have a TypeScript project that has been deployed several times without any problems to Google App Engine, Standard environment, running Node 10. However, when I try to update the App Engine...

How to query graphql issuing post requests with json parameters using google apps script?

I've been trying to scrape the first column from the table of this webpage using google apps script. When I observe network activity in dev tools, I could notice that I have to send post http...