| CARVIEW |
Select Language
HTTP/2 200
date: Wed, 30 Jul 2025 22:36:25 GMT
content-type: text/html; charset=utf-8
cf-ray: 967855b2caf1c1ce-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=2783d7dc-270c-4167-b038-cc04d0552b67; expires=Thu, 30 Jul 2026 22:36:25 GMT; domain=.stackoverflow.com; path=/; secure; httponly
strict-transport-security: max-age=31536000; includeSubDomains
vary: Accept-Encoding
content-security-policy: upgrade-insecure-requests; frame-ancestors 'self' https://stackexchange.com
feature-policy: microphone 'none'; speaker 'none'
x-clacks-overhead: GNU Terry Pratchett
x-frame-options: SAMEORIGIN
x-request-guid: 14d1a332-46f6-4f80-bea1-bf060002fc68
x-worker-origin-response-time: 352000000
x-dns-prefetch-control: off
set-cookie: __cflb=02DiuFA7zZL3enAQJD3AX8ZzvyzLcaG7vzEeW5Z6qZyPA; SameSite=Lax; path=/; expires=Thu, 31-Jul-25 21:36:25 GMT; HttpOnly
set-cookie: prov=2783d7dc-270c-4167-b038-cc04d0552b67; Path=/; HttpOnly; Domain=stackoverflow.com
set-cookie: __cf_bm=Pcfiuatx51C0lADK1Cz9jEwjRqV0w83DPVTL8YkgXQ4-1753914985-1.0.1.1-PcqRe847UgCIMuCPJQqikPA5xicKyT0XocFhiCYdUV1mXIyESfbgr6199okndE6xduKP6tFZ8y_4eh9WDYzbGNjmxrxNDc6SF7.ZUebuwns; path=/; expires=Wed, 30-Jul-25 23:06:25 GMT; domain=.stackoverflow.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=q2MYBHIEVJlq5rYSQoOZJd1nOkzitwEgQAiQwojpJ6w-1753914985779-0.0.1.1-604800000; path=/; domain=.stackoverflow.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'google-apps-script' Questions - Stack Overflow
Skip to main content
Stack Overflow
- Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers
- Advertising Reach devs & technologists worldwide about your product, service or employer brand
- Knowledge Solutions Data licensing offering for businesses to build and improve AI tools and models
- Labs The future of collective knowledge sharing
- About the company Visit the blog
The 2025 Developer Survey results are in. Explore insights into technology and tools, careers, community and more.
View results.
Collectives™ on Stack Overflow
Find centralized, trusted content and collaborate around the technologies you use most.
Learn more about CollectivesTeams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about Teams
55,608 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
18
views
How to retrieve triggers?
Google Sheets App Script v8: oauthScopes and ScriptApp.getProjectTriggers
My Google Sheet uses an App Script with an installed trigger to extend some functionalities.
Since enabling Chrome V8 runtime ...
2
votes
2
answers
87
views
How do I update the font color of a key value of a Scorecard chart?
I've tried several ways to change the font color of the key value of a scorecard chart in Google Sheets, but I'm unable to do so. option titleTextStyle.color changes the Title color only. I've tried ...
0
votes
1
answer
57
views
How can I prevent my script from timing out when writing formulas to a large file?
I’m trying to automate some changes in a file that has two versions: one with about 5,000 rows and another with around 80,000 rows.
When I run my script on the smaller file, it works fine. But when I ...
-1
votes
2
answers
94
views
Autosorting 2 columns function with negative number to be shown at the top
This is my demo sheet:
https://docs.google.com/spreadsheets/d/17OiBMhbeW35T50sSE9J-NQyvTAbirM4OSePEzW2iIiE/
And I have this script in Google App Script:
function autoSort() {
const ss = ...
1
vote
1
answer
58
views
Multiple Attendees for Automated Calendar Invite via Sheets
I hitting an error when I try to add multiple attendees via my spreadsheet. It works with one but when I try comma-separate to include multiple attendees it throws an error:
Error ...
1
vote
2
answers
123
views
How can I add an unchecked checkbox to sorted data in Google Sheets?
I have a Google Form that takes entered information and outputs it to a Google Sheet. The responses from this form are then sorted in a separate tab. I want this information to be sorted by most ...
0
votes
1
answer
82
views
Adding a list of variables to a spreadsheet [closed]
I have a Google Sheets Macro which under certain conditions generates an email with 3 variables in them.
I want it to also place these 3 values on a new line into the same spreadsheet, but on a ...
-1
votes
1
answer
60
views
How to make a Google Sheets apps script to hide rows based on colour to work on multiple sheets
I managed to locate a script to hide rows based on a background colour, which works for just 1 sheet, but I'd like it to work on all the sheets within that spreadsheet. I have sheets labelled MSQ1, ...
0
votes
1
answer
80
views
How to Programmatically Style the Google Sheets Sidebar Container with Apps Script
I'm trying to change the background color and font color of the main Google Sheets sidebar container—the frame that holds the title and close button—using server-side Google Apps Script.
I know how to ...
0
votes
0
answers
63
views
How do I handle query string with ajax to pass a Google Sheets ID parameter to my app script so it can show that Google Sheet's data on my website? [closed]
I’ve been working on a website built to show a table of sports teams and their stats. In order to do so I am utilizing datatables, ajax, google sheets, and google app script. I’m also using Hostinger ...
0
votes
2
answers
55
views
How can I return a Filter Formula reference range?
I'm trying to return a range I've gotten results with via cell formula with the app script equivalent so I can in turn overwrite the array with different values.
This is the formula I'm using which ...
0
votes
0
answers
71
views
"The state token is invalid or has expired. Please try again." error
Subject: Persistent "State Token Invalid" Error in Google Apps Script Web App for Test Users (OAuth2 Library)
I'm encountering a highly persistent and perplexing "The state token is ...
0
votes
1
answer
59
views
Trouble passing dynamic variable/scriptlet into HTML in Google Apps Script
I'm having difficulty when trying to pass a dynamic variable into an HTML file from my GAS code. The GAS code is able to recognize the scriptlet in the HTML file, but for some reason it will only pass ...
-3
votes
1
answer
64
views
Apps Script keeps reading “WAIT” even though the cell shows “OK” in the sheet UI [closed]
function queryPnLData() {
/* 0️⃣ Execution timer */
const startTime = new Date();
Logger.log('⏱️ START queryPnLData at %s', startTime);
/* ----------------------------------------------------...
0
votes
0
answers
33
views
AppsScript ERROR: We're sorry, a server error occurred while reading from storage. Error code PERMISSION_DENIED [duplicate]
As we AppsScript add-on devs know, Apps Scripts which are using the Rhino engine have to be migrated to the new V8 engine until January 31, 2026. We tried this migration few years ago, but we were ...
- The Overflow Blog
-
-
- Featured on Meta
-
-
-
-
-
-
Hot Network Questions
- "One can" in technical writing--good, bad, indifferent?
- Is the six million dollar hut challenge real?
- I applied for a postdoc and the position was left unfilled because no candidate was found to be a good match. Should I follow up?
- Should I regularly reapply thermal paste?
- Is it commonplace/acceptable for university professors to not teach Evolutionary Biology based on their religious beliefs?
- How safe is it to send an ID photo to a host via Booking.com chat?
- How quickly can you solve the Change Change game?
- Is it ethical to hire a graphic designer for a job talk?
- Golden-section optimization with complication
- Finite projective plane with trivial automorphism group
- Has the similarity between diagrams of the expanding universe and of vapour pressure in mixtures been noted by others? Is this just coincidence?
- Novel with fog on an alien world and a labyrinth
- How should I talk about definitional uncertainty in seemingly well-defined measurands, arising at high resolutions?
- Middleschool student shows unusual level of insight. How to take the next step?
- QuantLib `RangeAccrualFloatersCoupon` instanciation fails
- What happens if a witness is required to travel to the US to make a deposition but is refused entry?
- How to create a Face Group from selected faces, similar to a Vertex Group
- What is the difference between Render Distance and Simulation Distance?
- Visa Free Transit Facility (VFTF): Indian passport but resident in Saudi Arabia
- Identify Last-Layer Perm of a Rubik's Cube
- What is known about the third time derivative of the expansion of the Universe?
- Is a normality test always performed on errors and not on raw data?
- Puzzlin’ Puzzle
- What does Paul’s mention of 'they that are of Caesar’s household' in Philippians 4:22 reveal about the spread of the gospel within the Roman Empire?