56,902 questions
0
votes
0
answers
45
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
65
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
-5
votes
0
answers
106
views
Finding the shortest path through a variety of types of information (represented on a graphic organizer) [closed]
My question is mainly regarding that: I don't even know where to start when it comes to looking up solutions to an issue.
I'm aware I need something like an algorithm, but I'm unaware of any and where ...
Advice
0
votes
0
replies
57
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
0
votes
1
answer
114
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
70
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
109
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
56
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
60
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
86
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
0
votes
1
answer
90
views
API Handling on Google Apps Script is not using API key
I am a beginner, trying my hand at realtime API data handling for a small project.
I am trying to create an HTML page (for an iframe later) that gives me the realtime data for one specific metro stop ...
- 1
1
vote
0
answers
66
views
possible to scan a QR code with html5 qrcode google app script? [duplicate]
https://unpkg.com/html5-qrcode
html5 qrcode used in google app script web app
<button class="btn btn-light fw-bold" style="position:absolute;right:2%;" onclick="...
- 11
Advice
1
vote
2
replies
117
views
Is google app script web app proper for production environment?
I'm wondering if google app script web app deployment is proper for production environment? Because I noticed these things:
The deployment link is random generated.
Accessing web app on another ...
-1
votes
2
answers
122
views
Create copy of sheet and rename with todays date +4 days
The following code correctly creates a copy of my template sheet and renames to "Week of [Todays Date]".
How can I add 4 days to the date value? Eg. Todays Date = Feb 23 ; Need it to return ...
- 11
1
vote
1
answer
77
views
Activate cell working on Chrome on a Windows laptop, but not Android Google Sheets app
The following code activates the correct cell when viewing/editing a Google Sheet on a Windows laptop through Chrome.
However, the cell will NOT activate with viewing/editing the same spreadsheet on ...
