56,896 questions
0
votes
0
answers
19
views
GScript command for ‘Who can modify group details?’
How can I use GScript to change the parameter for ‘Who can modify group details?’
According to ChatGPT, this should be possible using the command ‘whoCanModifyGroupMetadata’, but this command isn’t ...
- 273
0
votes
0
answers
49
views
Why does "You do not have permission to access the requested document" script error happen AFTER all code in function has executed?
I have several Apps Script functions bound to a Google Slides file that is owned by a managed Workspace account. The account is the owner of the slide file and also owns the triggers in the script ...
-3
votes
0
answers
38
views
Script "name" experienced an error, console log shows nothing just says failed [closed]
Script "name" experienced an error, console log shows nothing just says failed. Then they re run it a couple times and it runs fine
1
vote
2
answers
103
views
Technical Issue: Pie Chart Slice "Distance from Center" and "Color" not updating via Apps Script
I am seeking help regarding a consistent technical issue with Pie Charts in Google Sheets when using Apps Script.
The Problem: When I try to programmatically update a Pie Chart, some visual elements ...
- 13
Tooling
0
votes
4
replies
101
views
Google Drive Folder File Counting Script
I need a reliable Google Sheets script that counts files in multiple Google Drive folders.
Requirements:
Handle all types of links or folder IDs in column E (plain URLs, rich-text links, or raw IDs).
...
Advice
0
votes
1
replies
41
views
Retain value of a cell
I have created a google form linked to a google sheet which captures users' request for a limited resource
It may be that the request fails because there were no resources left
However, the form also ...
0
votes
0
answers
52
views
Issue using .addRange to modify chart
I'm having issues using .addRange to modify an existing line chart. When I run the following code the range does not get added, but the title does change. I've copied this almost exactly from the ...
- 1
Advice
0
votes
2
replies
83
views
daily request limit for incoming HTTP requests
I'm deploying a Google Apps Script as a Web App (doGet/doPost) to serve as a webhook relay. The script uses only CacheService for storage — no UrlFetchApp, no Sheets, no Gmail, no other Google ...
- 1
Advice
0
votes
0
replies
84
views
How to optimize slow initial load in Google Apps Script (HtmlService) with 1MB bundle
I am developing a Web App on Google Apps Script (GAS) using React and Ant Design. I use Vite with vite-plugin-singlefile to bundle everything into a single index.html for deployment.
The Problem:
The ...
- 1
-1
votes
1
answer
155
views
Drive API v3 rejects OAuth token when Gmail scopes are included in manifest
Problem Summary
I have a Google Apps Script that needs to:
Generate sharing links using Drive API v3 Advanced Service
Send emails with alias using Gmail API via REST
These work independently, but ...
-1
votes
1
answer
85
views
Google Sheets API PivotFilter.getFilterCriteria yields "Service error: Spreadsheets" when the filter contains a formula
PivotFilter.getFilterCriteria returns the expected result when the filter references values directly as in: 'Text contains A'. However, when the filter references formulas as in: 'Text contains =&...
- 25
-1
votes
2
answers
116
views
need code for this: when a cell is selected, highlight that row and all rows with the same value in column B
Need code for this: when a cell is selected, highlight that row and all rows with the same value in column B (table only, if possible).
I tried an even simpler code suggested by google, and it didn't ...
Best practices
0
votes
2
replies
62
views
Suggestions to keep my appscript live so it becomes easy for AI models to find solution
I am working as developer and want to ensure that chatgpt is always aware of structure of my appscript.
Because posting appscript everytime in chatgpt looks so laborious. any shortcuts pls. Have been ...
- 1
Advice
0
votes
2
replies
68
views
Using Batch Request API to export up to 100 Slides to PNG
How do I convert exporting slides into png into a Batch Request?
Is there other ways I can speed up the processing of this coding
section?
I am running into an issue with the google execution time ...
Advice
0
votes
2
replies
88
views
Scripts to add column A from data sheet to destination sheets
In Google Sheets I have a Data Sheet with alphabetical names in Column A (and row 1 being a header). There is data in Columns B onwards that is specific to this sheet only (the Data Sheet)
When I add ...
user32447676
