Top "Google-sheets-custom-function" questions

Use for questions about Google Apps Script, Google's JavaScript-based cloud scripting platform for automating tasks across Google products and third-party services.

Custom function throws a "You do not have the permission required to setValue" error

I am trying to set some value to a cell in a Google Spreadsheet: function exampleFunction() { var ss = SpreadsheetApp.getActiveSpreadsheet(); …

Read More
google-apps-script google-sheets permissions authorization google-sheets-custom-function
New Google Sheets custom functions sometimes display "Loading..." indefinitely

SPECIFIC FOR: "NEW" google sheets only. This is a known issue as highlighted by google in the new sheets. Issues: …

Read More
google-apps-script google-sheets google-sheets-custom-function
You do not have permission to call openById

Problem: When I run the script, Google tells me, You do not have permission to call openById I had copied …

Read More
google-apps-script google-sheets google-apps-script-addon google-sheets-custom-function
Debugging a custom function in Google Apps Script

I am trying to create my first custom function for a Google Spreadsheet in Apps Script and I am having …

Read More
debugging google-apps-script google-sheets google-docs google-sheets-custom-function
How to generate an uuid in google sheet?

How to generate an uuid in google sheet (for exemple ccb8a660-91c9-a556-58e0-4fa7-229516872004). …

Read More
google-apps-script google-sheets uuid google-sheets-custom-function