I need to detect if changes made to a spreadsheet are being made within a certain range of data and if so, set the current update time. The issue is, I have a spreadsheet that I edit headers and t...

In my Google Apps Script App I am seeing the following error: The script completed but the returned value is not a supported return type How can I find out the type of the value which I am ret...

Is there a FORMULA that will display the name of the file in a cell? I've found scripts that will do it, formulas that will display the sheet name, but no luck finding a formula that will show the...

I'm wondering how to add custom headers or footers to a PDF that is exported using Google Apps Script from a Google Sheet. I would like to add a footer that says "My Company Proprietary and Co...

I have a neural network script that requires training data from a JSON file, is it possible to save a JSON file to Google Drive using Google Apps Script?

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 f...

I have a sheet where for each row in column Z there is a JSON string recovered from Twitter via TAGS. The JSON strings in column Z all have a similar structure: { "hashtags": [ { &quo...

In an onOpen method, how can the document type be determined? From the Quickstart: Add-on for Google Docs the following code is suggested: function onOpen(e) { DocumentApp.getUi().createAddonMen...

When developing Google Apps Scripts (specifically for Sheets in my case), you can use the Debug button to step through code and inspect variables, or you can use the Logger to output debug info. Wh...

I am trying to get the list of Twitter followers of a specific Twitter user using Google Apps Script. I found many sources: Source 1 Source 2 Source 3 but unable to create a link with my requirem...

In Google apps script documentation, there is a page about Private functions on server side. That should explain that without private functions, the server code is visible from the user browser. Ca...

I have created this form: https://docs.google.com/forms/d/e/1FAIpQLSepL1NX2ZVNFBDtbvFZqWrHlXVRUznljb6GkJBv2XJ5XCTBpg/viewform there is a way to force aligment to RTL no matter what?

a recent feature in Google Calendar allows users to select a working location (home, office, other) for every working day. Do you know if there is a way to retrieve this info using Apps Script ? Th...

I have a google sheet with a google apps script project bound to it. Using copy() and makeCopy() copy the gsheet with the bound script. How can I programmatically, make copies of this spreadsheet w...

I have a range of cells selected in a Google Sheets (activerange). I want to iterate over every cell in that range, and add a string to the end. The string is always the same, and can be hard coded...

I'm just starting tinkering with scripts for Google Spreadsheet and I have a problem : How to test if the type of a function's parameter is a range of cells ? I'd like to do something like this :...

I have this function to get the font color of a cell. The test function works fine (as a result I get hex code #ff0000), but when I call the get_color() function from a Google Spreadsheet, it retur...

I have an excel formula that is very simple and it works because I can restrict the recursive iterations. I am not very script savvy, but this is what it is and it works. =IF(D24="P",IF(E24="",Dat...

I want to use the cell address (of the cell the formula is in) in a custom formula. e.g. In my sheet I have a formula in cell C7: =fSomeFormula() In my code I need something like function fSomeFor...

I am getting this error: "The parameters (number[]) don't match the method signature for SpreadsheetApp.Range.setValues." in my Google Apps Script when I try to write an array of values to a ...

I wrote a google scripts editor addon, and published it to the google marketplace with private visibility (it is only visible to the users in my organization). I tested the addon with all types of ...

I am new to Google Calendar API. I created function to add events to the Google calendar using Google Apps Script. This works well. But I want to execute the Google Apps Script from C# application....

I want to execute a google apps script whenever a new file is added to a specific folder. Currently I'm using a run-every-x-minutes clock trigger, but I only need to run the script whenever I add a...

How do I add an item to an existing menu (in Google Docs) in Google Apps Script? I can create a new menu and add an item to that: DocumentApp.getUi().createMenu('MyMenu') .addItem('Insert My Thi...

I am working to link an image in my Google Sheet document to a specific cell in another tab. I'm doing this by building a simple function that will do this. However, when I assign the function and ...