All Questions
Tagged with google-apps-script-editor or google-apps-script
56,900 questions
Advice
0
votes
0
replies
27
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 ...
-2
votes
0
answers
39
views
I want to deliver financial market news and connect to MetaTrader 4 [closed]
How do I create a system that trades on my behalf in the financial markets using the MetaTrader 4 platform, employing indicators,
1
vote
1
answer
92
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
50
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
70
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
73
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
130
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
76
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
60
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
65
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
99
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
129
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 ...
