236 questions
1
vote
2
answers
91
views
Google Apps Script 403: The caller does not have permission
Task
I'm creating a Apps Script that adds new Feedback row to the containing Google Sheet whenever the API is invoked.
Setup.
I have a Google Sheet named Feedback
Created the Apps Script (Code.gs - ...
2
votes
0
answers
41
views
Is it possible to mass replace scripts in the Google spreadsheet (extensions -> apps script) with a given name?
I need to create a script in python/google scripts that will replace the script in the sheet. The source script that will be used for the replacement will be saved as Google Script and will have a ...
- 21
1
vote
1
answer
103
views
How can we run a function from Standalone Script A to create a time-based trigger in Script B or any copy of Script B using Google Apps Script?
I have tried everything, including enabling the Google Apps Script API in console.cloud.google.com, setting the project number of that project in Script A, and ensuring that the Script ID of Script B ...
- 43
0
votes
0
answers
38
views
Is it possible to update (add/edit/delete) named functions using apps script [duplicate]
Context
We have a master template and many users using copies of it in their accounts.
I'm using apps script to update users sheets to new version, once we make changes to master template spreadsheet.
...
- 1,580
2
votes
1
answer
120
views
How to clasp list, clasp clone, clasp pull and/or clasp push a Google Apps Script project bound to a Google Doc container (eg. Google Sheet)
How can clasp access Google Apps Script projects bound to their Google Doc container using clasp list, clasp clone, clasp push, clasp pull? Without proper use they fail with errors like:
clasp list: ...
- 871
0
votes
0
answers
80
views
Google Apps script exceeds execution time without really triggering
Here's a rephrased version:
I have a script that runs every minute, but occasionally, about once a day, it fails with an "Exceeded maximum execution time" error.
To investigate the cause of ...
- 6,059
-1
votes
1
answer
111
views
Running multiple Google Apps scripts sequentially (one after another)
I am working on a sheet that pulls data from an API, then runs calculations on it. Because of timeouts and limitations, I need to run one script, wait for the calculations to finish, then run another ...
- 95
0
votes
2
answers
56
views
Appscript REST Api slowness
I am calling the following appscript function using google.script.run from my mobile application.
Code
function addOrUpdateEntry(response) {
let sheetName = "X";
var lock = ...
- 3,158
0
votes
0
answers
22
views
Google App Script How to use projects.deployments.delete [duplicate]
I developed a Google Sheets extension and deployed the JavaScript code.
Unfortunately, I unintentionally ended up creating multiple deployments.
Despite my efforts to find a solution for deleting the ...
- 3,057
0
votes
1
answer
119
views
Error 500 on POST https://script.googleapis.com/v1/scripts/{scriptId}:run
I have a dummy function inside the Apps Script that I want to execute with Postman.
Apps Script simple dummy function
Every seems to be OK in my postman request, but I always recieve an error 500.
...
0
votes
1
answer
101
views
Why does running Apps Script function from Apps Script API returns 500?
Keep in mind the difference between Apps Script(AS for short) projects (code.gs) and the Apps Script API.
The general idea is to be able to create AS projects, write functions inside and execute them, ...
- 49
-1
votes
1
answer
58
views
Is there a way to run Apps Script web applications in a "queue", respecting the completion of one execution to start the next?
I have a web application that is started by my CRM, but sometimes it runs twice in a very short period of time and this is affecting the proper functioning of the code, causing 2 simultaneous ...
- 3
0
votes
1
answer
53
views
Permission issues deleting files with Google Drive API in ruby
I have a Google Apps Script that creates json files from spreadsheet tabs:
function makeJSON() {
var spreadsheetId = 'someId';
var spreadsheet = SpreadsheetApp.openById(spreadsheetId);
var ...
- 13.2k
0
votes
0
answers
118
views
POST request to Google Apps script from Spring Boot controller
I am trying to do a post request to google apps script function through a spring boot application and I am getting unauthorized exception.
My spring Boot controller function is as below
@PostMapping(&...
- 121
0
votes
0
answers
276
views
Call Google Apps Script from a Google Cloud Function
I am attempting to write a Google Cloud Function that will call an Apps Script function that is deployed as an API Executable.
I have confirmed:
the Apps Script is deployed as an API Executable and ...
- 541