236 questions
0
votes
1
answer
58
views
Getting 404 when trying to execute GCP scripts().run using service account
I'm trying to access an Apps Script I have created, via Python using a service account that I have which is linked to my GCP project.
I've created an API executable deployment, and set the project ...
- 1
1
vote
2
answers
140
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
57
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
120
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 ...
- 33
3
votes
1
answer
305
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: ...
- 891
0
votes
0
answers
94
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,099
-1
votes
1
answer
244
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
63
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
1
answer
159
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
122
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
68
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
63
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.3k
0
votes
0
answers
134
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(&...
- 131
0
votes
0
answers
349
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 ...
- 551
0
votes
0
answers
148
views
User Access Ctrl for Google Script App with 'Execute as Me' option
I have a Google App Script based WebApp for basic CRUD operations with Google sheet as source of data.
This will app be used by multiple users in the team but with restricted access. i.e some users ...
- 303