56,846 questions
Score of 2
0 answers
63 views
URLFetchApp Post Request Troubleshooting Next Steps
I am trying to create a script that scrapes local ice rink sites and adds public skating times to my calendar. I'm new to scraping and am not sure how to move forward in troubleshooting the errors I'm ...
Score of 0
1 answer
101 views
Fix emailing the wrong event name for people who have booked for another event
I have a Google Apps Script that works on the Responses sheet from Google Forms used to receive bookings for events. The form permits people to book for more than one event, but frequently, people ...
Score of -7
0 answers
97 views
Music in apps script pages [duplicate]
In my apps script pages I want to put in the background a music with mp3 files no copyright. I already have the file but I can't add it plus I would like a button that allows the user to deactivate ...
Score of -1
0 answers
62 views
google.script.run success/failure callback never fires intermittently (server executes fine, client hangs) [closed]
I have an HTML Service web app that calls a server-side function via google.script.run to read data from a Google Sheet:
javascript
google.script.run
.withSuccessHandler(function (p) { /* render ...
Score of 1
2 answers
99 views
Gmail Filter Export xml file schema not supported?
I exported a set of Gmail Filters to xml file.
I am trying to parse this XML file in Google Apps Script. Primary goal is to retrieve the rule text in the apps:property name="hasTheWord" ...
Score of 0
1 answer
127 views
Limit Google Sheet to Only Be Viewed on a Tuesday (preferably between certain hours)
Each week we have students view a Google Sheet to find out where they have been assigned for that day's "flex" time.
The problem is that we draft the students and fill out their assigned ...
Score of 1
0 answers
95 views
Google Chat API + Apps Script "Can't handle the app's response" error when clicking a card button (Web App / OAuth2)
I'm building a Google Chat Bot integration using Google Apps Script and GCP Service Account (OAuth2).
The Flow:
Form submitted -> Apps Script sends a Card message to a Google Chat space using ...
Score of 0
1 answer
117 views
Google Sheets does not recalculate cell dependent on sheet name
I use a formula which is based on sheet name. I name sheets by year and month in a form like this "YYYY-MM" (e.g. "2026-08"). In that way, I would duplicate sheets and cell name ...
Score of 0
2 answers
192 views
Automatic Static Date Stamp
I'm trying to add an automatic static timestamp in this ticketing process:
Sheet A column B is labeled "Data Received". The user manually inputs the date when they receive a ticket.
When ...
Score of 1
1 answer
271 views
429 Error on Google Sheets script pulling from Google Books API
I've created a Google Sheet where I enter a book ISBN in cell A2 and want the book title returned in cell B2 upon the click of a button that I've associated with function getBookData(). However, my ...
Score of 0
1 answer
165 views
Google Sheets doesn't catch the user email via event [duplicate]
The task is: several users edit Google Sheets table. All of them have Editor's role. Some of the users are masterusers - they can edit everything. Some are clients - they can edit only empty time-...
Score of 0
1 answer
118 views
Timed Email Notifications for multiple tabs, specific emails, based on dates in spreadsheet
I have a task manager spreadsheet for my company's project managers. Each person has their own tab that they add in their projects, due dates, etc. They get email notifications sent when an upcoming ...
Score of 0
1 answer
267 views
Error in fetching pdf file from a website using google apps script UrlFetchApp
I have a Google Apps Script that downloads a daily PDF rate sheet from a public financial website. This script ran perfectly for months but suddenly stopped working around April 9th.
Instead of ...
Score of 0
1 answer
202 views
Static URL for Google Apps script? [duplicate]
Although each project has a name, Google Apps scripts use an automatically generated URL to make them available via the internet. This URL changes with each iteration of the code. Meanwhile a schedule ...
Score of 0
1 answer
169 views
Exception: API call to sheets.spreadsheets.batchUpdate failed with error: Empty response
I would like to know if there is someone intimately familiar with the Google sheets API who knows precisely what this error means:
Exception: API call to sheets.spreadsheets.batchUpdate failed with ...