56,902 questions
1
vote
1
answer
83
views
Can't fetch data from Google Sheets in Google Apps Script [closed]
update
I've found the issue. GAS can only send Strings, Numbers, Booleans, Arrays, and simple Objects from server to client. But some lastModified values are Date instances, so the client receive null....
- 17
0
votes
0
answers
46
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
67
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
71
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
123
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
74
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
111
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
59
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
64
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
95
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
69
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
126
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 ...
